public ActionResult DeleteConfirmed(int id)
        {
            Crops crops = db.Crops.Find(id);

            db.Crops.Remove(crops);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "Id,CropName,Variety,SownDate,PlantedDate,GerminationDate,HarvestDate,LocationIdRef,yield,satisfaction,notes")] Crops crops)
 {
     if (ModelState.IsValid)
     {
         db.Entry(crops).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.LocationIdRef = new SelectList(db.locations, "LocationId", "LocationName", crops.LocationIdRef);
     return(View(crops));
 }
        // GET: Crops/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Crops crops = db.Crops.Find(id);

            if (crops == null)
            {
                return(HttpNotFound());
            }
            return(View(crops));
        }
        // GET: Crops/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Crops crops = db.Crops.Find(id);

            if (crops == null)
            {
                return(HttpNotFound());
            }
            ViewBag.LocationIdRef = new SelectList(db.locations, "LocationId", "LocationName", crops.LocationIdRef);
            return(View(crops));
        }