public ActionResult DeleteSeed(int id) { SmartFarmingEntities db = new SmartFarmingEntities(); var seedDetails = db.Seeds.Where(m => m.id == id).FirstOrDefault(); var seedImages = db.SeedImages.Where(m => m.seed_id == id).ToList(); var seedFaq = db.SeedFaqs.Where(m => m.seed_id == id).ToList(); var quatation = db.Quotations.Where(m => m.seed_id == id).ToList(); foreach (var item in quatation) { db.Quotations.Remove(item); db.SaveChanges(); } if (seedImages.Any()) { foreach (var item in seedImages) { db.SeedImages.Remove(item); } } if (seedFaq.Any()) { foreach (var item in seedFaq) { db.SeedFaqs.Remove(item); } } db.Seeds.Remove(seedDetails); db.SaveChanges(); return(RedirectToAction("ManageSeeds")); }
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 AddOrEditPesticide(AddOrEditPesticide 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.PesticideImage = filename; } if (model.id != 0) { var pesticideDetails = db.Pesticides.Where(x => x.id == model.id).FirstOrDefault(); pesticideDetails.crop_id = model.crop_id; pesticideDetails.dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]); pesticideDetails.PesticideName = model.PesticideName; pesticideDetails.Category = model.Category; pesticideDetails.PesticideImage = model.PesticideImage; pesticideDetails.State = model.State; pesticideDetails.PackingType = model.PackingType; pesticideDetails.Dosage = model.Dosage; pesticideDetails.Formulation = model.Formulation; pesticideDetails.PesticideDescription = model.PesticideDescription; pesticideDetails.Price = model.Price; db.SaveChanges(); } else { Pesticide pesticideDetails = new Pesticide() { crop_id = model.crop_id, dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]), PesticideName = model.PesticideName, Category = model.Category, PesticideImage = model.PesticideImage, State = model.State, PackingType = model.PackingType, Dosage = model.Dosage, Formulation = model.Formulation, PesticideDescription = model.PesticideDescription, Price = model.Price }; db.Pesticides.Add(pesticideDetails); db.SaveChanges(); } return(RedirectToAction("ManagePesticides")); }
public ActionResult DeletePesticide(int id) { SmartFarmingEntities db = new SmartFarmingEntities(); var pesticideDetails = db.Pesticides.Where(m => m.id == id).FirstOrDefault(); var quatation = db.Quotations.Where(m => m.pesticide_id == id).ToList(); foreach (var item in quatation) { db.Quotations.Remove(item); db.SaveChanges(); } db.Pesticides.Remove(pesticideDetails); db.SaveChanges(); return(RedirectToAction("ManagePesticides")); }
public ActionResult DeleteFertilizer(int id) { SmartFarmingEntities db = new SmartFarmingEntities(); var fertilizerDetails = db.Fertilizers.Where(m => m.id == id).FirstOrDefault(); var quatation = db.Quotations.Where(m => m.fertilizer_id == id).ToList(); foreach (var item in quatation) { db.Quotations.Remove(item); db.SaveChanges(); } db.Fertilizers.Remove(fertilizerDetails); db.SaveChanges(); return(RedirectToAction("ManageFertilizers")); }
public ActionResult DeleteFaq(int id) { SmartFarmingEntities db = new SmartFarmingEntities(); var faq = db.Faqs.Where(m => m.id == id).FirstOrDefault(); db.Faqs.Remove(faq); db.SaveChanges(); return(RedirectToAction("ManageFaqs")); }
public ActionResult DeleteTractor(int id) { SmartFarmingEntities db = new SmartFarmingEntities(); var tractorDetails = db.Tractors.Where(m => m.id == id).FirstOrDefault(); db.Tractors.Remove(tractorDetails); db.SaveChanges(); return(RedirectToAction("ManageTractors")); }
public ActionResult DeleteDealer(int id) { using (SmartFarmingEntities db = new SmartFarmingEntities()) { User model = db.Users.Where(x => x.id == id).FirstOrDefault(); List <Fertilizer> fertilizers = db.Fertilizers.Where(x => x.dealer_id == id).ToList(); List <Pesticide> pesticides = db.Pesticides.Where(x => x.dealer_id == id).ToList(); List <Quotation> quotations = db.Quotations.Where(x => x.dealer_id == id).ToList(); List <Seed> seedList = db.Seeds.Where(x => x.dealer_id == id).ToList(); List <Tractor> tractors = db.Tractors.Where(x => x.dealer_id == id).ToList(); db.Users.Remove(model); db.SaveChanges(); return(RedirectToAction("ManageDealer")); } }
public void AddQuatation(AddQuatation model) { SmartFarmingEntities db = new SmartFarmingEntities(); Quotation quatationModel = new Quotation() { seed_id = model.seed_id, dealer_id = model.dealer_id, Quantity = model.quantity, Unit = model.noOfSeed, ContactNo = model.contactNo }; db.Quotations.Add(quatationModel); db.SaveChanges(); }
public ActionResult ManageNews(NewsView model) { SmartFarmingEntities db = new SmartFarmingEntities(); News news = new News() { Headline = model.Headline, Text = model.Text, Link = model.Link, Date = model.Date }; db.News.Add(news); db.SaveChanges(); return(RedirectToAction("ManageNews")); }
public ActionResult ContactUs(ContactUs model) { SmartFarmingEntities db = new SmartFarmingEntities(); ContactU contactModel = new ContactU() { Name = model.Name, ContactNo = model.ContactNo, Email = model.Email, Subject = model.Subject, Text = model.Text }; db.ContactUs.Add(contactModel); db.SaveChanges(); TempData["Submit"] = "Your Response is Submitted!"; return(RedirectToAction("ContactUs", "Home")); }
public ActionResult AddDealer(AddDealer model) { User usermodel = new User() { Name = model.Name, Email = model.Email, role_id = model.role_id }; using (SmartFarmingEntities dbcrop = new SmartFarmingEntities()) { dbcrop.Users.Add(usermodel); dbcrop.SaveChanges(); } ModelState.Clear(); ViewBag.SucessMessage = "Item Added Sucessful."; return(RedirectToAction("ManageDealer")); }
public ActionResult DeleteCrop(int id) { using (SmartFarmingEntities db = new SmartFarmingEntities()) { Crop cropDetail = db.Crops.Where(m => m.id == id).FirstOrDefault(); MajorProducer states = db.MajorProducers.Where(m => m.crop_id == id).FirstOrDefault(); List <Seed> seedDetail = db.Seeds.Where(m => m.crop_id == id).ToList(); List <Pesticide> pesticideCropDetails = db.Pesticides.Where(m => m.crop_id == id).ToList(); List <Fertilizer> fertilizerCropDetails = db.Fertilizers.Where(m => m.crop_id == id).ToList(); if (states != null) { db.MajorProducers.Remove(states); } if (seedDetail != null) { foreach (var item in seedDetail) { db.Seeds.Remove(item); } } if (pesticideCropDetails != null) { foreach (var item in pesticideCropDetails) { db.Pesticides.Remove(item); } } if (fertilizerCropDetails != null) { foreach (var item in fertilizerCropDetails) { db.Fertilizers.Remove(item); } } db.Crops.Remove(cropDetail); db.SaveChanges(); return(RedirectToAction("ManageCrops")); } }
public ActionResult AddFaq(ManageFaq model) { SmartFarmingEntities db = new SmartFarmingEntities(); if (model.id != 0) { var faq = db.Faqs.Where(m => m.id == model.id).FirstOrDefault(); faq.Question = model.Question; faq.Answer = model.Answer; } else { Faq faq = new Faq() { Question = model.Question, Answer = model.Answer }; db.Faqs.Add(faq); } db.SaveChanges(); return(RedirectToAction("ManageFaqs")); }
public ActionResult AddCrop(AddCrop model, HttpPostedFileBase file) { SmartFarmingEntities db = new SmartFarmingEntities(); if (model.id != 0) { if (file != null) { var filename = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Images/"), filename); file.SaveAs(path); model.CropImage = filename; } var cropDetails = db.Crops.Where(x => x.id == model.id).FirstOrDefault(); cropDetails.CropName = model.CropName; cropDetails.CropDesc = model.CropDesc; cropDetails.Kharif = (bool)model.Kharif; cropDetails.Rabi = (bool)model.Rabi; cropDetails.Zaid = (bool)model.Zaid; cropDetails.type_id = model.type_id; cropDetails.CropImage = model.CropImage; cropDetails.Temp = model.Temp; cropDetails.RainFall = model.RainFall; cropDetails.SoilType = model.SoilType; cropDetails.HighestProducers = (int)model.HighestProducers; cropDetails.SowingMethod = model.SowingMethod; cropDetails.Harvesting = model.Harvesting; cropDetails.LandPreparation = model.LandPreparation; db.SaveChanges(); } else { var filename = Path.GetFileName(file.FileName); var path = Path.Combine(Server.MapPath("~/Images/"), filename); file.SaveAs(path); model.CropImage = filename; Crop cropDetails = new Crop() { CropName = model.CropName, CropDesc = model.CropDesc, Kharif = model.Kharif, Rabi = model.Rabi, Zaid = model.Zaid, type_id = model.type_id, CropImage = model.CropImage, Temp = model.Temp, RainFall = model.RainFall, SoilType = model.SoilType, HighestProducers = model.HighestProducers, LandPreparation = model.LandPreparation, Harvesting = model.Harvesting, SowingMethod = model.SowingMethod }; db.Crops.Add(cropDetails); db.SaveChanges(); } if (model.MajorProducers[0] != "") { MajorProducer stateList = new MajorProducer(); int cropId = db.Crops.Where(x => x.CropName == model.CropName).FirstOrDefault().id; var stateIds = model.MajorProducers[1].Split(',').ToList(); for (int item = 0; item < stateIds.Count(); item++) { stateList.crop_id = cropId; stateList.state_id = Convert.ToInt32(stateIds[item]); db.MajorProducers.Add(stateList); db.SaveChanges(); } } return(RedirectToAction("ManageCrops")); }
public ActionResult AddOrEditSeed(AddOrEditSeed model) { SmartFarmingEntities db = new SmartFarmingEntities(); if (model.id != 0) { var seedDetails = db.Seeds.Where(x => x.id == model.id).FirstOrDefault(); seedDetails.crop_id = model.crop_id; seedDetails.dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]); seedDetails.SeedName = model.SeedName; seedDetails.Season = model.Season; seedDetails.PestTolerance = model.PestTolerance; seedDetails.Price = model.Price; seedDetails.Duration = model.Duration; seedDetails.MinQuentity = model.MinQuentity; seedDetails.Description = model.Description; seedDetails.PacketSize = model.PacketSize; seedDetails.GrowthHabit = model.GrowthHabit; seedDetails.PositiveFactor = model.PositiveFactor; seedDetails.NegativeFactor = model.NegativeFactor; seedDetails.Temp = model.Temp; seedDetails.Fertilizer = model.Fertilizer; seedDetails.Height = model.Height; seedDetails.SeedsPerPacket = model.SeedsPerPacket; db.SaveChanges(); foreach (HttpPostedFileBase file in model.Images) { if (file != null) { var imageName = file.FileName; var path = Path.Combine(Server.MapPath("~/Images/"), imageName); file.SaveAs(path); SeedImage seedImages = new SeedImage() { seed_id = model.id, Image = imageName }; db.SeedImages.Add(seedImages); db.SaveChanges(); } } } else { Seed seedDetails = new Seed() { crop_id = model.crop_id, dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]), SeedName = model.SeedName, Season = model.Season, PestTolerance = model.PestTolerance, Price = model.Price, Duration = model.Duration, MinQuentity = model.MinQuentity, Description = model.Description, PacketSize = model.PacketSize, GrowthHabit = model.GrowthHabit, PositiveFactor = model.PositiveFactor, NegativeFactor = model.NegativeFactor, Temp = model.Temp, Fertilizer = model.Fertilizer, Height = model.Height, SeedsPerPacket = model.SeedsPerPacket }; db.Seeds.Add(seedDetails); db.SaveChanges(); foreach (HttpPostedFileBase file in model.Images) { var imageName = file.FileName; var path = Path.Combine(Server.MapPath("~/Images/"), imageName); file.SaveAs(path); SeedImage seedImages = new SeedImage() { seed_id = seedDetails.id, Image = imageName }; } } return(RedirectToAction("ManageSeeds")); }
public ActionResult AddOrEditTractor(AddOrEditTractor 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.TractorImage = filename; } if (model.id != 0) { var tractorDetails = db.Tractors.Where(x => x.id == model.id).FirstOrDefault(); tractorDetails.ModelName = model.ModelName; tractorDetails.TractorImage = model.TractorImage; tractorDetails.Capacity = model.Capacity; tractorDetails.Clutch = model.Clutch; tractorDetails.Price = model.Price; tractorDetails.NoOfCylinder = model.NoOfCylinder; tractorDetails.HpCategory = model.HpCategory; tractorDetails.EngineRatedRPM = model.EngineRatedRPM; tractorDetails.Cooling = model.Cooling; tractorDetails.AirFilter = model.AirFilter; tractorDetails.Brake = model.Brake; tractorDetails.Battery = model.Battery; tractorDetails.GearBox = model.GearBox; tractorDetails.Steering = model.Steering; tractorDetails.FuelTank = model.FuelTank; tractorDetails.Accessories = model.Accessories; tractorDetails.Features = model.Features; tractorDetails.Warranty = model.Warranty; tractorDetails.Status = model.Status; tractorDetails.TotalWeight = model.TotalWeight; tractorDetails.GroundClearance = model.GroundClearance; tractorDetails.TurningRadius = model.TurningRadius; db.SaveChanges(); } else { Tractor tractorDetails = new Tractor() { dealer_id = Convert.ToInt32(HttpContext.Session["UserId"]), ModelName = model.ModelName, TractorImage = model.TractorImage, Capacity = model.Capacity, Clutch = model.Clutch, Price = model.Price, NoOfCylinder = model.NoOfCylinder, HpCategory = model.HpCategory, EngineRatedRPM = model.EngineRatedRPM, Cooling = model.Cooling, AirFilter = model.AirFilter, Brake = model.Brake, Battery = model.Battery, GearBox = model.GearBox, Steering = model.Steering, FuelTank = model.FuelTank, Features = model.Features, Accessories = model.Accessories, Warranty = model.Warranty, Status = model.Status, TotalWeight = model.TotalWeight, GroundClearance = model.GroundClearance, TurningRadius = model.TurningRadius }; db.Tractors.Add(tractorDetails); db.SaveChanges(); } return(RedirectToAction("ManageTractors")); }