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

            db.tbl_LK_Farmer.Remove(tbl_LK_Farmer);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        // GET: Farmer/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_LK_Farmer tbl_LK_Farmer = db.tbl_LK_Farmer.Find(id);

            if (tbl_LK_Farmer == null)
            {
                return(HttpNotFound());
            }
            return(View(tbl_LK_Farmer));
        }
 public ActionResult Edit([Bind(Include = "FarmerID,StateID,CIGID,ValueChainID,FarmActivityID,FarmProductID,FarmerName,MobileNo1,MobileNo2,Sex,BaseLine,FarmSizeID,FarmName,FarmListID")] tbl_LK_Farmer tbl_LK_Farmer)
 {
     if (ModelState.IsValid)
     {
         db.Entry(tbl_LK_Farmer).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.FarmActivityID = new SelectList(db.tbl_LK_FarmActivity, "FarmActivityID", "FarmerActivityName", tbl_LK_Farmer.FarmActivityID);
     ViewBag.CIGID          = new SelectList(db.tbl_LK_FarmerCIG, "CIGID", "CIGName", tbl_LK_Farmer.CIGID);
     ViewBag.FarmListID     = new SelectList(db.tbl_LK_FarmList, "FarmListID", "FarmName", tbl_LK_Farmer.FarmListID);
     ViewBag.FarmProductID  = new SelectList(db.tbl_LK_FarmProduct, "FarmProductID", "ProductName", tbl_LK_Farmer.FarmProductID);
     ViewBag.FarmSizeID     = new SelectList(db.tbl_LK_FarmSize, "FarmSizeID", "FarmSizeDescription", tbl_LK_Farmer.FarmSizeID);
     ViewBag.ValueChainID   = new SelectList(db.tbl_LK_FarmValueChain, "ValueChainID", "ValueChainName", tbl_LK_Farmer.ValueChainID);
     ViewBag.StateID        = new SelectList(db.tbl_LK_State, "StateID", "StateName", tbl_LK_Farmer.StateID);
     return(View(tbl_LK_Farmer));
 }
        // GET: Farmer/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            tbl_LK_Farmer tbl_LK_Farmer = db.tbl_LK_Farmer.Find(id);

            if (tbl_LK_Farmer == null)
            {
                return(HttpNotFound());
            }
            ViewBag.FarmActivityID = new SelectList(db.tbl_LK_FarmActivity, "FarmActivityID", "FarmerActivityName", tbl_LK_Farmer.FarmActivityID);
            ViewBag.CIGID          = new SelectList(db.tbl_LK_FarmerCIG, "CIGID", "CIGName", tbl_LK_Farmer.CIGID);
            ViewBag.FarmListID     = new SelectList(db.tbl_LK_FarmList, "FarmListID", "FarmName", tbl_LK_Farmer.FarmListID);
            ViewBag.FarmProductID  = new SelectList(db.tbl_LK_FarmProduct, "FarmProductID", "ProductName", tbl_LK_Farmer.FarmProductID);
            ViewBag.FarmSizeID     = new SelectList(db.tbl_LK_FarmSize, "FarmSizeID", "FarmSizeDescription", tbl_LK_Farmer.FarmSizeID);
            ViewBag.ValueChainID   = new SelectList(db.tbl_LK_FarmValueChain, "ValueChainID", "ValueChainName", tbl_LK_Farmer.ValueChainID);
            ViewBag.StateID        = new SelectList(db.tbl_LK_State, "StateID", "StateName", tbl_LK_Farmer.StateID);
            return(View(tbl_LK_Farmer));
        }