public ActionResult RegisterCrops(int cid, int quantity, int unit_price) { if (Session["UserData"] != null) { int id = int.Parse(Session["UserData"].ToString()); // bool status = BusinessManager.AddCrop(c); DateTime date = DateTime.Now; int totalquantity = 0; crops c = new crops(); List <CropFarmer> cf = BusinessManager.getcropfarmerByID(id); foreach (CropFarmer i in cf) { if (i.cid == cid) { c = BusinessManager.getcrop(cid); totalquantity = c.quantity + i.qty_left; i.qty_left = totalquantity; i.added_on = DateTime.Now; BusinessManager.updateCrop(i); BusinessManager.updateCropquantity(cid, totalquantity); } } BusinessManager.AddCrop_xref(id, cid, date, quantity); c = BusinessManager.getcrop(cid); CropFarmer cf1 = BusinessManager.getcropFarmer(cid); totalquantity = c.quantity + cf1.qty_left; BusinessManager.updateCropquantity(cid, totalquantity);//main crop table return(RedirectToAction("displayAllCrops", "crops")); } return(RedirectToAction("loginfarmer", "farmers")); }