public ActionResult AddOrEditFertilizer(AddOrEditFertilizer model, HttpPostedFileBase file) { SmartFarmingEntities db = new SmartFarmingEntities(); if (file != null) { var filename = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Images/"), filename); file.SaveAs(path); model.FertilizerImage = filename; } if (model.id != 0) { var fertilizerDetails = db.Fertilizers.Where(x => x.id == model.id).FirstOrDefault(); fertilizerDetails.crop_id = model.crop_id; fertilizerDetails.dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]); fertilizerDetails.FertilizerName = model.FertilizerName; fertilizerDetails.Material = model.Material; fertilizerDetails.FertilizerImage = model.FertilizerImage; fertilizerDetails.PackType = model.PackType; fertilizerDetails.PackSize = model.PackSize; fertilizerDetails.Features = model.Features; fertilizerDetails.Solubility = model.Solubility; fertilizerDetails.Doses = model.Doses; fertilizerDetails.PHvalue = model.PHvalue; fertilizerDetails.HowToUse = model.HowToUse; fertilizerDetails.Price = model.Price; db.SaveChanges(); } else { Fertilizer fertilizerDetails = new Fertilizer() { crop_id = model.crop_id, dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]), FertilizerName = model.FertilizerName, Material = model.Material, FertilizerImage = model.FertilizerImage, PackType = model.PackType, PackSize = model.PackSize, Features = model.Features, Solubility = model.Solubility, Doses = model.Doses, PHvalue = model.PHvalue, HowToUse = model.HowToUse, Price = model.Price }; db.Fertilizers.Add(fertilizerDetails); db.SaveChanges(); } return(RedirectToAction("ManageFertilizers")); }
public ActionResult AddOrEditFertilizer(int id) { SmartFarmingEntities db = new SmartFarmingEntities(); AddOrEditFertilizer model = new AddOrEditFertilizer(); if (id != 0) { var fertilizerDetails = (from s in db.Fertilizers where s.id == id select new AddOrEditFertilizer() { id = s.id, crop_id = s.crop_id, CropList = db.Crops.Select(m => new CropList { id = m.id, Name = m.CropName }).ToList(), FertilizerName = s.FertilizerName, FertilizerImage = s.FertilizerImage, Material = s.Material, PackType = s.PackType, PackSize = s.PackSize, Features = s.Features, Solubility = s.Solubility, Doses = s.Doses, PHvalue = s.PHvalue, HowToUse = s.HowToUse, Price = (decimal)s.Price }).FirstOrDefault(); return(View(fertilizerDetails)); } else { model.id = 0; model.CropList = db.Crops.Select(m => new CropList { id = m.id, Name = m.CropName }).ToList(); return(View(model)); } }