public function run()
 {
     DB::table('storagecontracts')->delete();
     Storagecontract::create(['loan_id' => 8, 'commodity' => 'cotton', 'contract_number' => '2431', 'contract_date' => '2015-07-31', 'delivery_date' => '2015-12-31', 'grain_buyer' => 'Lansing Louisiana', 'lien_holder' => 'Commercial Capital', 'contract_amount' => 50000, 'contract_price' => 7.0, 'owner_share' => 21.3, 'mkt_set' => true, 'revenue' => 275625, 'eligible_proceeds' => 206719, 'advance_percent' => 75]);
     Storagecontract::create(['loan_id' => 8, 'commodity' => 'soybeans', 'contract_number' => '2131', 'contract_date' => '2015-06-01', 'delivery_date' => '2015-12-31', 'grain_buyer' => 'Lansing Louisiana', 'lien_holder' => 'Commercial Capital', 'contract_amount' => 50000, 'contract_price' => 6.75, 'owner_share' => 21.3, 'revenue' => 265781, 'eligible_proceeds' => 199336, 'mkt_set' => false, 'advance_percent' => 90]);
     Storagecontract::create(['loan_id' => 8, 'commodity' => 'corn', 'contract_number' => '2697', 'contract_date' => '2015-11-25', 'delivery_date' => '2015-02-28', 'grain_buyer' => 'Lansing Louisiana', 'lien_holder' => 'Commercial Capital', 'contract_amount' => 75000, 'contract_price' => 7.1, 'owner_share' => 24.6, 'revenue' => 401505, 'eligible_proceeds' => 301129, 'mkt_set' => false, 'advance_percent' => 90]);
     Storagecontract::create(['loan_id' => 8, 'commodity' => 'sorghum', 'contract_number' => '2698', 'contract_date' => '2015-11-25', 'delivery_date' => '2016-01-31', 'grain_buyer' => 'Lansing Louisiana', 'lien_holder' => 'Commercial Capital', 'contract_amount' => 17000, 'contract_price' => 6.9, 'owner_share' => 21.3, 'revenue' => 94322, 'eligible_proceeds' => 70741, 'mkt_set' => true, 'advance_percent' => 75]);
 }
 public function update($id)
 {
     // save updated
     $record = $this->records->find($id);
     if (!$record) {
         Storagecontract::create(Input::all());
         return $this->respond($record);
     }
     $record->fill(Input::all())->save();
     return $this->respond($record);
 }
 public function run()
 {
     DB::table('storagecontracts')->delete();
     Storagecontract::create(['loan_id' => 7, 'contract_number' => 'Jazzman', 'contract_date' => '2015-09-01', 'delivery_date' => '2016-04-30', 'commodity' => 'rice', 'grain_buyer' => 'Holly Ridge Rice & Grain', 'lien_holder' => 'Ag Resource Management', 'contract_amount' => 11000, 'contract_price' => 17.9, 'owner_share' => 20.0, 'revenue' => 157520, 'eligible_proceeds' => 118140, 'amount_requested' => 200000]);
     Storagecontract::create(['loan_id' => 7, 'contract_number' => 'Hybrid', 'contract_date' => '2015-09-01', 'delivery_date' => '2016-04-30', 'commodity' => 'rice', 'grain_buyer' => 'Holly Ridge Rice & Grain', 'lien_holder' => 'Ag Resource Management', 'contract_amount' => 28000, 'contract_price' => 15.55, 'owner_share' => 20.0, 'revenue' => 348320, 'eligible_proceeds' => 261240, 'amount_requested' => 200000]);
 }