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"));
}
