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