public ViewResult ConsumptionReportHerdDay(DateTime day)
{
List<ConsumptionReportHerd> report = new List<ConsumptionReportHerd>();
Herd aux = new Herd();
Milker aux1 = new Milker();
Cow aux2 = new Cow();
List<Cow> cows = new List<Cow>();
Production production = new Production();
var Herd = from h in db.Herds.ToList() select h;
var Milker = from o in db.Milkers.ToList() select o;
//var Cow = from c in a.Cows.ToList() select c;
foreach (Herd h in Herd)
{
ConsumptionReportHerd item = new ConsumptionReportHerd();
Double hay = new Double();
Double Silage = new Double();
item.IdHerd = h.Id;
item.NameHerd = h.Name;
item.HowCows = h.Cows.Count();
foreach (Milker o in Milker)
{
aux1.Name = o.Name;
}
item.NameOpe = aux1.Name;
cows = h.Cows;
foreach (Cow c in cows)
{
var query = from co in db.Consumptions.ToList()
where co.Id == c.Id && co.Date == day && c.State.Equals('A')
select co;
foreach (Consumption co in query)
{
hay = hay + co.HayAmount;
Silage = Silage + co.SilageAmout;
}
item.HayAmount = hay;
item.SilageAmout = Silage;
}
report.Add(item);
}
return View(report);
}
public ActionResult Create(Milker milker)
{
milker.State = "A";
if (ModelState.IsValid)
{
db.Milkers.Add(milker);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(milker);
}
public ActionResult Create(Milker milker)
{
milker.State = "A";
if (ModelState.IsValidField("JoinDate") && DateTime.Now < milker.JoinDate)
ModelState.AddModelError("JoinDate", "Input a current or past date");
if (milker.Age > 60 || milker.Age < 18)
ModelState.AddModelError("Age", "The age of the milker is not appropiate for job");
if (ModelState.IsValid)
{
db.Milkers.Add(milker);
db.SaveChanges();
return RedirectToAction("Index");
}
return View(milker);
}
public ViewResult ProductionReportHerdMonth(DateTime Month)
{
List<ProductionReportHerd> report = new List<ProductionReportHerd>();
Herd aux = new Herd();
Milker aux1 = new Milker();
Cow aux2 = new Cow();
List<Cow> cows = new List<Cow>();
Production production = new Production();
var Herd = from h in db.Herds.ToList() select h;
var Milker = from o in db.Milkers.ToList() select o;
//var Cow = from c in a.Cows.ToList() select c;
foreach (Herd h in Herd)
{
ProductionReportHerd item = new ProductionReportHerd();
Double quant = new Double();
item.IdHerd = h.Id;
item.NameHerd = h.Name;
foreach (Milker o in Milker)
{
aux1.Name = o.Name;
}
item.NameOpe = aux1.Name;
cows = h.Cows;
foreach (Cow c in cows)
{
var query = from co in db.Productions.ToList()
where co.Id == c.Id && c.State.Equals('A') && co.Date.Month.Equals(Month.Month) && co.Date.Year.Equals(Month.Year) && c.State.Equals('A')
select co;
foreach (Production p in query)
{
quant = quant + p.Quant;
}
quant = quant / (query.ToList<Production>().Count);
}
report.Add(item);
}
return View(report);
}
public ActionResult Edit(Milker milker)
{
if (ModelState.IsValid)
{
db.Entry(milker).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
return View(milker);
}