public ActionResult Index() { TodayBillReportModel model = new TodayBillReportModel(); return(View(model)); }
public ActionResult Index(TodayBillReportModel model1) { int OutletId = getOutletId(); DateTime dd = Convert.ToDateTime(model1.Date); DateTime datefrom = Convert.ToDateTime(model1.DateFrom); DateTime dateto = Convert.ToDateTime(model1.DateTo); //DateTime dd = Convert.ToDateTime(model1.Date); // var dd = Convert.ToDateTime(Date); TodayBillReportModel model = new TodayBillReportModel(); model.getAllRestroBill = getallRestroBill(datefrom, dateto); model.getAllRestroVat = getAllVatAmount(datefrom, dateto); var restroBill = entites.tblBillMasters.Where(a => System.Data.Entity.DbFunctions.TruncateTime(a.BillDate) >= datefrom.Date && System.Data.Entity.DbFunctions.TruncateTime(a.BillDate) <= dateto.Date && a.OutletId == OutletId).ToList(); var today = restroBill.Where(a => ((a.BillingType == "Ac Hall" || a.BillingType == "Dine In Hall"))).ToList(); //var demo=entites.tblBillMasters.Where(a=>a.BillDate.Day==dd.Day) model.RestroTotalAmount = today.Sum(a => a.TotalAmount); model.RestroTotalDiscountAmount = today.Sum(a => a.DiscountAmount); model.RestroTotalServiceTaxAmount = today.Sum(a => a.ServiceTax.Value); model.RestroTotalServiceChargeAmount = today.Sum(a => a.ServicChargesAmount); model.RestroTotalVatAmount = today.Sum(a => a.VatAmount); model.TotalRestroNetAmount = today.Sum(a => a.NetAmount); // Home Delivery Today Report var Home = restroBill.Where(a => a.BillingType.Equals("Door Delivery Hall")).ToList(); model.HomeTotalAmount = Home.Sum(a => a.TotalAmount); model.HomeTotalDiscountAmount = Home.Sum(a => a.DiscountAmount); model.HomeTotalServiceTaxAmount = Home.Sum(a => a.ServiceTax.Value); model.HomeTotalServiceChargeAmount = Home.Sum(a => a.ServicChargesAmount); model.HomeTotalVatAmount = Home.Sum(a => a.VatAmount); model.TotalHomeNetAmount = Home.Sum(a => a.NetAmount); model.getAllHomeBill = getallHomeBill(datefrom, dateto); model.getAllHomeVat = getAllVatHomeAmount(datefrom, dateto); // Takeaway Today Report var Take = restroBill.Where(a => a.BillingType.Equals("Take Away Hall")).ToList(); model.TakeTotalAmount = Take.Sum(a => a.TotalAmount); model.TakeTotalDiscountAmount = Take.Sum(a => a.DiscountAmount); model.TakeTotalServiceTaxAmount = Take.Sum(a => a.ServiceTax.Value); model.TakeTotalServiceChargeAmount = Take.Sum(a => a.ServicChargesAmount); model.TakeTotalVatAmount = Take.Sum(a => a.VatAmount); model.TotalTakeNetAmount = Take.Sum(a => a.NetAmount); model.getAllTakeBill = getallTakeBill(datefrom, dateto); model.getAllTakeVat = getAllVatTakeAmount(datefrom, dateto); // Calculate Total model.TotalAmount = model.RestroTotalAmount + model.HomeTotalAmount + model.TakeTotalAmount; model.TotalServiceTax = model.RestroTotalServiceTaxAmount + model.HomeTotalServiceTaxAmount + model.TakeTotalServiceTaxAmount; model.TotalServiceCharge = model.RestroTotalServiceChargeAmount + model.HomeTotalServiceChargeAmount + model.TakeTotalServiceChargeAmount; model.TotalVatAmount = model.RestroTotalVatAmount + model.HomeTotalVatAmount + model.TakeTotalVatAmount; model.TotalDiscount = model.RestroTotalDiscountAmount + model.HomeTotalDiscountAmount + model.TakeTotalDiscountAmount; model.NetAmount = model.TotalRestroNetAmount + model.TotalHomeNetAmount + model.TotalTakeNetAmount; // total cash and card amount var totalcash = entites.tblBillMasters.Where(a => a.PaymentType.Equals("Cash") && a.BillDate.Day == dd.Day && a.BillDate.Month == dd.Month && a.BillDate.Year == dd.Year && a.OutletId == OutletId).ToList(); if (totalcash.Count > 0) { model.TotalCashAmount = Math.Round(totalcash.Sum(a => a.NetAmount), 2); } var totalCard = entites.tblBillMasters.Where(a => a.PaymentType.Equals("Card") && a.BillDate.Day == dd.Day && a.BillDate.Month == dd.Month && a.BillDate.Year == dd.Year && a.OutletId == OutletId).ToList(); if (totalCard.Count > 0) { model.TotalCardAmount = Math.Round(totalCard.Sum(a => a.NetAmount), 2); } model.DateFrom = datefrom; model.DateTo = dateto; return(View(model)); }
public ActionResult Index() { int OutletId = getOutletId(); DateTime dd = DateTime.Now.Date; // var dd = Convert.ToDateTime(Date); TodayBillReportModel model = new TodayBillReportModel(); model.getAllRestroBill = getallRestroBill(); model.getAllRestroVat = getAllVatAmount(); var today = (from p in entites.tblBillMasters where p.BillDate.Day == dd.Day && p.BillDate.Month == dd.Month && p.BillDate.Year == dd.Year && p.OutletId == OutletId && (p.BillingType == "Ac Hall" || p.BillingType == "Dine In Hall") select p).ToList(); //var demo=entites.tblBillMasters.Where(a=>a.BillDate.Day==dd.Day) model.RestroTotalAmount = today.Sum(a => a.TotalAmount); model.RestroTotalServiceChargeAmount = today.Sum(a => a.ServicChargesAmount); model.RestroTotalDiscountAmount = today.Sum(a => a.DiscountAmount); model.RestroTotalServiceTaxAmount = today.Sum(a => a.ServiceTax.Value); model.RestroTotalVatAmount = today.Sum(a => a.VatAmount); model.TotalRestroNetAmount = today.Sum(a => a.NetAmount); // Home Delivery Today Report var Home = entites.tblBillMasters.Where(a => a.BillDate.Day == dd.Day && a.BillDate.Month == dd.Month && a.BillDate.Year == dd.Year && a.OutletId == OutletId && a.BillingType.Equals("Door Delivery Hall")).ToList(); model.HomeTotalAmount = Home.Sum(a => a.TotalAmount); model.HomeTotalDiscountAmount = Home.Sum(a => a.DiscountAmount); model.HomeTotalServiceTaxAmount = Home.Sum(a => a.ServiceTax.Value); model.HomeTotalServiceChargeAmount = Home.Sum(a => a.ServicChargesAmount); model.HomeTotalVatAmount = Home.Sum(a => a.VatAmount); model.TotalHomeNetAmount = Home.Sum(a => a.NetAmount); model.getAllHomeBill = getallHomeBill(); model.getAllHomeVat = getAllVatHomeAmount(); // Takeaway Today Report var Take = entites.tblBillMasters.Where(a => a.BillDate.Day == dd.Day && a.BillDate.Month == dd.Month && a.BillDate.Year == dd.Year && a.OutletId == OutletId && a.BillingType.Equals("Take Away Hall")).ToList(); model.TakeTotalAmount = Take.Sum(a => a.TotalAmount); model.TakeTotalDiscountAmount = Take.Sum(a => a.DiscountAmount); model.TakeTotalServiceTaxAmount = Take.Sum(a => a.ServiceTax.Value); model.TakeTotalServiceChargeAmount = Take.Sum(a => a.ServicChargesAmount); model.TakeTotalVatAmount = Take.Sum(a => a.VatAmount); model.TotalTakeNetAmount = Take.Sum(a => a.NetAmount); model.getAllTakeBill = getallTakeBill(); model.getAllTakeVat = getAllVatTakeAmount(); // Calculate Total model.TotalAmount = model.RestroTotalAmount + model.HomeTotalAmount + model.TakeTotalAmount; model.TotalServiceTax = model.RestroTotalServiceTaxAmount + model.HomeTotalServiceTaxAmount + model.TakeTotalServiceTaxAmount; model.TotalServiceCharge = model.RestroTotalServiceChargeAmount + model.HomeTotalServiceChargeAmount + model.TakeTotalServiceChargeAmount; model.TotalVatAmount = model.RestroTotalVatAmount + model.HomeTotalVatAmount + model.TakeTotalVatAmount; model.TotalDiscount = model.RestroTotalDiscountAmount + model.HomeTotalDiscountAmount + model.TakeTotalDiscountAmount; model.NetAmount = model.TotalRestroNetAmount + model.TotalHomeNetAmount + model.TotalTakeNetAmount; // total cash and card amount var totalcash = entites.tblBillMasters.Where(a => a.PaymentType.Equals("Cash") && a.BillDate.Day == dd.Day && a.BillDate.Month == dd.Month && a.BillDate.Year == dd.Year && a.OutletId == OutletId).ToList(); if (totalcash.Count > 0) { model.TotalCashAmount = Math.Round(totalcash.Sum(a => a.NetAmount), 2); } var totalCard = entites.tblBillMasters.Where(a => a.PaymentType.Equals("Card") && a.BillDate.Day == dd.Day && a.BillDate.Month == dd.Month && a.BillDate.Year == dd.Year && a.OutletId == OutletId).ToList(); if (totalCard.Count > 0) { model.TotalCardAmount = Math.Round(totalCard.Sum(a => a.NetAmount), 2); } return(View(model)); }