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"));
}
// GET: Home
public ActionResult Index()
{
SmartFarmingEntities db = new SmartFarmingEntities();
homeModel model = new homeModel();
var cropDetails = (from c in db.Crops
join ct in db.CropTypes on c.type_id equals ct.id
select new CropDetails
{
id = c.id,
CropName = c.CropName,
CropImage = c.CropImage,
CropType = ct.Croptype1
}).ToList();
var newsList = (from c in db.News
select new NewsView
{
id = c.id,
Headline = c.Headline,
Text = c.Headline,
Link = c.Link,
Date = c.Date
}).ToList();
model.Crops = cropDetails;
model.News = newsList;
return(View(model));
}
public JsonResult GetTractorModels(int id)
{
SmartFarmingEntities db = new SmartFarmingEntities();
var tractorModels = db.Tractors.Where(x => x.dealer_id == id).Select(x => new { x.id, x.ModelName }).ToList();
return(Json(tractorModels, JsonRequestBehavior.AllowGet));
}
public ActionResult TractorCompare()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var brandList = db.Users.Where(x => x.role_id == 3).Select(x => new { x.id, x.Name }).ToList();
ViewBag.brands = brandList;
return(View());
}
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 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 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 AddDealer()
{
SmartFarmingEntities db = new SmartFarmingEntities();
AddDealer model = new AddDealer()
{
Roles = db.Roles.ToList()
};
return(View(model));
}
public override string[] GetRolesForUser(string username)
{
using (SmartFarmingEntities db = new SmartFarmingEntities())
{
var userRoles = (from user in db.Users
join role in db.Roles
on user.role_id equals role.id
where user.Email == username
select role.Title).ToArray();
return(userRoles);
}
}
public ActionResult ManageFaqs()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var faqs = db.Faqs.Select(m => new ManageFaq
{
id = m.id,
Question = m.Question,
Answer = m.Answer
}).ToList();
return(View(faqs));
}
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 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 ManageDealer()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var usersdetails = (from x in db.Users
join y in db.Roles on x.role_id equals y.id
select new ManageDealer
{
Id = x.id,
Name = x.Name,
Email = x.Email,
Title = y.Title
}).ToList();
return(View(usersdetails));
}
public ActionResult Seeds()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var seedList = (from m in db.Seeds
select new ManageSeeds()
{
id = m.id,
SeedName = m.SeedName,
Image = db.SeedImages.Where(x => x.seed_id == m.id).FirstOrDefault().Image,
Price = (decimal)m.Price
}).ToList();
return(View(seedList));
}
public ActionResult Pesticides()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var pesticideList = db.Pesticides.Select(x => new ManagePesticides
{
id = x.id,
PesticideName = x.PesticideName,
Category = x.Category,
Image = x.PesticideImage,
Price = (decimal)x.Price
}).ToList();
return(View(pesticideList));
}
public ActionResult Fertilizers()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var fertilizerList = db.Fertilizers.Select(x => new ManageFertilizers
{
id = x.id,
FertilizerName = x.FertilizerName,
Material = x.Material,
Image = x.FertilizerImage,
Price = (decimal)x.Price
}).ToList();
return(View(fertilizerList));
}
public ActionResult News()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var newsList = (from c in db.News
select new NewsView
{
id = c.id,
Headline = c.Headline,
Text = c.Headline,
Link = c.Link,
Date = c.Date
}).ToList();
return(View(newsList));
}
public ActionResult AddFaq(int id)
{
SmartFarmingEntities db = new SmartFarmingEntities();
ManageFaq model = new ManageFaq();
if (id != 0)
{
model = db.Faqs.Where(m => m.id == id).Select(m => new ManageFaq
{
id = m.id,
Question = m.Question,
Answer = m.Answer
}).FirstOrDefault();
}
return(View(model));
}
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 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 NewsDetails(int id)
{
SmartFarmingEntities db = new SmartFarmingEntities();
var newsList = (from c in db.News
where c.id == id
select new NewsView
{
id = c.id,
Headline = c.Headline,
Text = c.Text,
Link = c.Link,
Date = c.Date
}).FirstOrDefault();
return(View(newsList));
}
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 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 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 ManageSeeds()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var dealerId = Convert.ToInt32(HttpContext.Session["UserId"]);
var seedList = (from m in db.Seeds
join c in db.Crops on m.crop_id equals c.id
where m.dealer_id == dealerId
select new ManageSeeds()
{
id = m.id,
SeedName = m.SeedName,
CropName = c.CropName,
Price = (decimal)m.Price
}).ToList();
return(View(seedList));
}
public ActionResult Quatation()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var dealerId = Convert.ToInt32(HttpContext.Session["UserId"]);
Quatation model = new Quatation();
var seedlist = (from m in db.Quotations
join s in db.Seeds on m.seed_id equals s.id
where m.dealer_id == dealerId
select new QuatationSeed()
{
id = m.id,
SeedName = s.SeedName,
Quantity = m.Quantity,
Unit = m.Unit,
ContactNo = m.ContactNo
}).ToList();
var pesticideList = (from m in db.Quotations
join p in db.Pesticides on m.pesticide_id equals p.id
where m.dealer_id == dealerId
select new QuatationPesticide()
{
id = m.id,
PesticideName = p.PesticideName,
Quantity = m.Quantity,
Unit = m.Unit,
ContactNo = m.ContactNo
}).ToList();
var fertilizerList = (from m in db.Quotations
join f in db.Fertilizers on m.fertilizer_id equals f.id
where m.dealer_id == dealerId
select new QuatationFertilizer()
{
id = m.id,
FertilizerName = f.FertilizerName,
Quantity = m.Quantity,
Unit = m.Unit,
ContactNo = m.ContactNo
}).ToList();
model.seedlist = seedlist;
model.pesticidelist = pesticideList;
model.fertilizerlist = fertilizerList;
return(View(model));
}
public ActionResult ManageTractors()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var dealerId = Convert.ToInt32(HttpContext.Session["UserId"]);
var tractorList = (from t in db.Tractors
where t.dealer_id == dealerId
select new ManageTractor()
{
id = t.id,
ModelName = t.ModelName,
Warrenty = (int)t.Warranty,
Price = (decimal)t.Price,
Status = t.Status
}).ToList();
return(View(tractorList));
}
public ActionResult ManageFertilizers()
{
SmartFarmingEntities db = new SmartFarmingEntities();
var dealerId = Convert.ToInt32(HttpContext.Session["UserId"]);
var fertilizerList = (from m in db.Fertilizers
join c in db.Crops on m.crop_id equals c.id
where m.dealer_id == dealerId
select new ManageFertilizers()
{
id = m.id,
FertilizerName = m.FertilizerName,
Material = m.Material,
CropName = c.CropName,
Price = (decimal)m.Price
}).ToList();
return(View(fertilizerList));
}
public ActionResult AddOrEditTractor(int id)
{
SmartFarmingEntities db = new SmartFarmingEntities();
AddOrEditTractor model = new AddOrEditTractor();
if (id != 0)
{
var tractorDetails = (from s in db.Tractors
where s.id == id
select new AddOrEditTractor()
{
id = s.id,
ModelName = s.ModelName,
TractorImage = s.TractorImage,
Capacity = (int)s.Capacity,
Clutch = s.Clutch,
Price = s.Price,
NoOfCylinder = (int)s.NoOfCylinder,
HpCategory = (int)s.HpCategory,
EngineRatedRPM = s.EngineRatedRPM,
Cooling = s.Cooling,
AirFilter = s.AirFilter,
Brake = s.Brake,
Battery = s.Battery,
GearBox = s.GearBox,
Steering = s.Steering,
FuelTank = s.FuelTank,
Features = s.Features,
Accessories = s.Accessories,
Warranty = (int)s.Warranty,
Status = s.Status,
TotalWeight = (int)s.TotalWeight,
GroundClearance = (int)s.GroundClearance,
TurningRadius = (int)s.TurningRadius
}).FirstOrDefault();
return(View(tractorDetails));
}
else
{
model.id = 0;
return(View(model));
}
}
