public ActionResult TonnageByEquipment(DateTime?chosenDateFrom, DateTime?chosenDateTo)
{
if (Session["user"] == null)
{
Response.Redirect("Login", true);
}
List <TonnageByActivity> EquipmentDEURList = new List <TonnageByActivity>();
EquipmentDEURList = (List <TonnageByActivity>)Session["EquipmentDEURList"];
if (chosenDateFrom == null || chosenDateTo == null)
{
return(RedirectToAction("NoData", "Home"));
}
if (chosenDateFrom > chosenDateTo)
{
DateTime?temp = chosenDateFrom;
chosenDateFrom = chosenDateTo;
chosenDateTo = temp;
}
List <TonnageByActivity> tempDEURList = EquipmentDEURList.Where(s => s.MaterialDateOfEntry >= chosenDateFrom && s.MaterialDateOfEntry <= chosenDateTo).OrderByDescending(s => s.MaterialDateOfEntry).ToList();
if (tempDEURList.Count == 0)
{
return(RedirectToAction("NoData", "Home"));
}
TonnageByEquipment curTonnageByEquipment = ComputeTonnageByEquipment(tempDEURList);
if (curTonnageByEquipment == null)
{
return(RedirectToAction("NoData", "Home"));
}
ViewBag.EquipmentType = "DUMP TRUCK";
ViewBag.DumpTruck = curTonnageByEquipment.DumpTruckData.TotalWMT;
ViewBag.Excavator = curTonnageByEquipment.ExcavatorData.TotalWMT;
ViewBag.Auxiliary = curTonnageByEquipment.AuxiliaryData.TotalWMT;
ViewBag.Stationary = curTonnageByEquipment.StationaryData.TotalWMT;
ViewBag.Envi = curTonnageByEquipment.EnviData.TotalWMT;
ViewBag.SVST = curTonnageByEquipment.SVSTData.TotalWMT;
ViewBag.NonEquipment = curTonnageByEquipment.NonEquipmentData.TotalWMT;
ViewBag.Rainfall = curTonnageByEquipment.RainfallData.TotalWMT;
ViewBag.ReportDate = "Report for " + Convert.ToDateTime(chosenDateFrom).ToString("MM/dd/yyyy") + " - " + Convert.ToDateTime(chosenDateTo).ToString("MM/dd/yyyy");
Session["tonnageByEquipmentSession"] = curTonnageByEquipment;
return(View(curTonnageByEquipment.DumpTruckData));
}
public TonnageByEquipment ComputeTonnageByEquipment(List <TonnageByActivity> activityList)
{
TonnageByEquipment finalValues = new TonnageByEquipment();
finalValues.DumpTruckData = ComputeTonnageByType("EQUIPMENT", "1", activityList);
finalValues.ExcavatorData = ComputeTonnageByType("EQUIPMENT", "2", activityList);
finalValues.AuxiliaryData = ComputeTonnageByType("EQUIPMENT", "3", activityList);
finalValues.StationaryData = ComputeTonnageByType("EQUIPMENT", "4", activityList);
finalValues.EnviData = ComputeTonnageByType("EQUIPMENT", "5", activityList);
finalValues.SVSTData = ComputeTonnageByType("EQUIPMENT", "6", activityList);
finalValues.NonEquipmentData = ComputeTonnageByType("EQUIPMENT", "7", activityList);
finalValues.RainfallData = ComputeTonnageByType("EQUIPMENT", "8", activityList);
return(finalValues);
}
public JsonResult GetTonnageByEquipment(string equipmentType)
{
TonnageByEquipment curTonnageByEquipment = (TonnageByEquipment)Session["tonnageByEquipmentSession"];
MajorActivityDetails majorActivityDetails = new MajorActivityDetails();
if (equipmentType.Trim() == "Dump Truck")
{
majorActivityDetails = curTonnageByEquipment.DumpTruckData;
}
else if (equipmentType.Trim() == "Excavator")
{
majorActivityDetails = curTonnageByEquipment.ExcavatorData;
}
else if (equipmentType.Trim() == "Auxiliary")
{
majorActivityDetails = curTonnageByEquipment.AuxiliaryData;
}
else if (equipmentType.Trim() == "Stationary")
{
majorActivityDetails = curTonnageByEquipment.StationaryData;
}
else if (equipmentType.Trim() == "Envi")
{
majorActivityDetails = curTonnageByEquipment.EnviData;
}
else if (equipmentType.Trim() == "SVST")
{
majorActivityDetails = curTonnageByEquipment.SVSTData;
}
else if (equipmentType.Trim() == "Non Equipment")
{
majorActivityDetails = curTonnageByEquipment.NonEquipmentData;
}
else if (equipmentType.Trim() == "Rainfall")
{
majorActivityDetails = curTonnageByEquipment.RainfallData;
}
ViewBag.MajorActivity = equipmentType.ToUpper();
return(Json(majorActivityDetails, JsonRequestBehavior.AllowGet));
}
public ActionResult TonnageByEquipment()
{
if (Session["user"] == null)
{
Response.Redirect("Login", true);
}
List <TonnageByActivity> EquipmentDEURList = (List <TonnageByActivity>)Session["EquipmentDEURList"];
if (EquipmentDEURList == null)
{
EquipmentDEURList = GenerateDEURList(0);
}
TonnageByEquipment curTonnageByEquipment = ComputeTonnageByEquipment(EquipmentDEURList);
if (curTonnageByEquipment == null)
{
return(RedirectToAction("NoData", "Home"));
}
ViewBag.EquipmentType = "DUMP TRUCK";
ViewBag.DumpTruck = curTonnageByEquipment.DumpTruckData.TotalWMT;
ViewBag.Excavator = curTonnageByEquipment.ExcavatorData.TotalWMT;
ViewBag.Auxiliary = curTonnageByEquipment.AuxiliaryData.TotalWMT;
ViewBag.Stationary = curTonnageByEquipment.StationaryData.TotalWMT;
ViewBag.Envi = curTonnageByEquipment.EnviData.TotalWMT;
ViewBag.SVST = curTonnageByEquipment.SVSTData.TotalWMT;
ViewBag.NonEquipment = curTonnageByEquipment.NonEquipmentData.TotalWMT;
ViewBag.Rainfall = curTonnageByEquipment.RainfallData.TotalWMT;
string LatestReportDate = (string)Session["ReportDate"];
ViewBag.ReportDate = "Report for 1/1/" + LatestReportDate.Substring((LatestReportDate.Length - 4), 4) + " - " + LatestReportDate;
Session["tonnageByEquipmentSession"] = curTonnageByEquipment;
Session["EquipmentDEURList"] = EquipmentDEURList;
return(View(curTonnageByEquipment.DumpTruckData));
}
