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