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)); }