public ActionResult AddOrEditSeed(int id)
{
SmartFarmingEntities db = new SmartFarmingEntities();
AddOrEditSeed model = new AddOrEditSeed();
if (id != 0)
{
var seedDetails = (from s in db.Seeds
where s.id == id
select new AddOrEditSeed()
{
id = s.id,
crop_id = s.crop_id,
CropList = db.Crops.Select(m => new CropList
{
id = m.id,
Name = m.CropName
}).ToList(),
SeedName = s.SeedName,
Season = s.Season,
PestTolerance = s.PestTolerance,
Price = (decimal)s.Price,
Duration = s.Duration,
MinQuentity = (int)s.MinQuentity,
Description = s.Description,
PacketSize = s.PacketSize,
GrowthHabit = s.GrowthHabit,
PositiveFactor = s.PositiveFactor,
NegativeFactor = s.NegativeFactor,
Temp = s.Temp,
Fertilizer = s.Fertilizer,
Height = s.Height,
SeedsPerPacket = (int)s.SeedsPerPacket
}).FirstOrDefault();
var SeedImages = db.SeedImages.Where(m => m.seed_id == id).Select(m => m.Image.ToString()).ToList();
if (SeedImages.Any())
{
seedDetails.SeedImages = SeedImages;
}
return(View(seedDetails));
}
else
{
model.id = 0;
model.CropList = db.Crops.Select(m => new CropList
{
id = m.id,
Name = m.CropName
}).ToList();
return(View(model));
}
}
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"));
}