public ActionResult AmountReport(int id)
{
string uname = HttpContext.Session["Uname"].ToString();
UserModel um = db.Umodel.Find(uname);
HomeController hc = new HomeController();
RoutingAlgoController ra = new RoutingAlgoController();
var custUsername = db.custPaymentModel.Where(o => o.TableID == id).Select(u => u.Username).FirstOrDefault();
var trashItemsList = db.trashItemModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var typeList = db.trashMeasurementModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var qtyList = db.customerTrashModel.Where(u => u.Username == custUsername).OrderByDescending(t => t.TableID).FirstOrDefault();
List <string> finalItemLNameist = hc.FindItemList(trashItemsList);
List <string> finalTypeList = hc.FindTrashTypeList(typeList);
List <int> finalQtyList = ra.FindTrashQtyList(qtyList);
List <string> finalUnitPriceList = FindUnitPriceList(typeList);
List <string> amountList = new List <string>();
var totAmount = 0.0;
for (int i = 0; i < finalItemLNameist.Count; i++)
{
var currentAmt = finalQtyList[i] * Convert.ToDouble(finalUnitPriceList[i]);
totAmount = totAmount + currentAmt;
amountList.Add(" = " + currentAmt.ToString());
}
var companyName = db.custPaymentModel.Where(i => i.TableID == id).FirstOrDefault().CompanyName + " - " + db.custPaymentModel.Where(i => i.TableID == id).FirstOrDefault().Branch;
var totAmt = db.custPaymentModel.Where(t => t.TableID == id).Select(a => a.TotalAmount).FirstOrDefault();
var amountSummary = "Total Amount (Rs.) : " + totAmount.ToString();
return(Json(new { amountList = amountList, amountSummary = amountSummary, companyName = companyName, typeList = finalTypeList, itemList = finalItemLNameist, qtyList = finalQtyList, unitPriceList = finalUnitPriceList }, JsonRequestBehavior.AllowGet));
}
public ActionResult TrashItemDetails(int id)
{
string uname = HttpContext.Session["Uname"].ToString();
UserModel um = db.Umodel.Find(uname);
HomeController hc = new HomeController();
RoutingAlgoController ra = new RoutingAlgoController();
var custUsername = db.customerModel.Where(o => o.TableID == id).Select(u => u.Username).FirstOrDefault();
var trashItemsList = db.trashItemModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var typeList = db.trashMeasurementModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var collectedLists = db.customerTrashModel.Where(u => u.Username == custUsername) /*.Where(s=>s.CollectingStatus!="Collected")*/;
List <string> finalItemLNameist = hc.FindItemList(trashItemsList);
List <string> finalTypeList = hc.FindTrashTypeList(typeList);
List <List <int> > collectedQtyLists = new List <List <int> >();
List <int> finalQtyList = new List <int>();
foreach (var item in collectedLists)
{
collectedQtyLists.Add(ra.FindTrashQtyList(item));
}
var sum = 0;
for (int i = 0; i < collectedQtyLists[0].Count; i++)
{
for (int j = 0; j < collectedQtyLists.Count; j++)
{
sum = sum + collectedQtyLists[j][i];
}
finalQtyList.Add(sum);
sum = 0;
}
//List<int> finalQtyList = ra.FindTrashQtyList(qtyList);
var companyName = db.customerModel.Where(i => i.TableID == id).FirstOrDefault().CompanyName + " - " + db.customerModel.Where(i => i.TableID == id).FirstOrDefault().Branch;
return(Json(new { companyName = companyName, typeList = finalTypeList, itemList = finalItemLNameist, qtyList = finalQtyList }, JsonRequestBehavior.AllowGet));
}
public ActionResult FindTrashItemDetails(int id)
{
string uname = HttpContext.Session["Uname"].ToString();
UserModel um = db.Umodel.Find(uname);
HomeController hc = new HomeController();
RoutingAlgoController ra = new RoutingAlgoController();
var custUsername = db.custPaymentModel.Where(o => o.TableID == id).Select(u => u.Username).FirstOrDefault();
var trashItemsList = db.trashItemModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var typeList = db.trashMeasurementModel.Where(c => c.CompanyName == um.CompanyName).FirstOrDefault();
var qtyList = db.customerTrashModel.Where(u => u.Username == custUsername).OrderByDescending(t => t.TableID).FirstOrDefault();
List <string> finalItemLNameist = hc.FindItemList(trashItemsList);
List <string> finalTypeList = hc.FindTrashTypeList(typeList);
List <int> finalQtyList = ra.FindTrashQtyList(qtyList);
var companyName = db.custPaymentModel.Where(i => i.TableID == id).FirstOrDefault().CompanyName + " - " + db.custPaymentModel.Where(i => i.TableID == id).FirstOrDefault().Branch;
var totQty = db.customerTrashModel.Where(u => u.Username == custUsername).OrderByDescending(t => t.TableID).Select(q => q.TotalQty).FirstOrDefault();
var qtySummary = "Total Latest Quantity : " + totQty.ToString();
return(Json(new { qtySummary = qtySummary, companyName = companyName, typeList = finalTypeList, itemList = finalItemLNameist, qtyList = finalQtyList }, JsonRequestBehavior.AllowGet));
}
