public List <TotalRestroVatModel> getAllVatAmount(DateTime datefrom, DateTime dateto)
{
int OutletId = getOutletId();
List <TotalRestroVatModel> lst = new List <TotalRestroVatModel>();
var dd = Convert.ToDateTime(dateto);
var result = (from p in entites.tblBillDetails
where System.Data.Entity.DbFunctions.TruncateTime(p.tblBillMaster.BillDate) >= datefrom.Date &&
System.Data.Entity.DbFunctions.TruncateTime(p.tblBillMaster.BillDate) >= dateto.Date &&
((p.tblBillMaster.BillingType == "Ac Hall" || p.tblBillMaster.BillingType == "Dine In Hall")) && p.tblBillMaster.OutletId == OutletId
select new
{
Vat = p.Vat,
VatAmount = p.VatAmount,
Amount = p.Amount,
BillId = p.BillId,
}).ToList();
foreach (var item in result.GroupBy(a => a.Vat))
{
TotalRestroVatModel model = new TotalRestroVatModel();
model.Vat = item.Key.Value;
decimal sum = item.Sum(a => a.VatAmount.Value);
model.Amount = Math.Round(sum, 2);
lst.Add(model);
}
return(lst);
}
public List <TotalRestroVatModel> getAllVatAmount()
{
int OutletId = getOutletId();
List <TotalRestroVatModel> lst = new List <TotalRestroVatModel>();
var Date = DateTime.Today.ToShortDateString();
var dd = Convert.ToDateTime(Date);
var result = (from p in entites.tblBillMasters
join q in entites.tblBillDetails on p.BillId equals q.BillId
where p.BillDate.Day == dd.Day && p.BillDate.Month == dd.Month && p.BillDate.Year == dd.Year && (p.BillingType == "Ac Hall" || p.BillingType == "Dine In Hall") && p.OutletId == OutletId
select new
{
Vat = q.Vat,
Amount = q.Amount,
ItemId = q.ItemId,
VatAmount = q.VatAmount,
Discount = p.Discount
}).ToList();
foreach (var item in result.GroupBy(a => a.Vat))
{
TotalRestroVatModel model = new TotalRestroVatModel();
model.Vat = item.Key.Value;
decimal sum = item.Sum(a => a.VatAmount.Value);
model.Amount = sum;
lst.Add(model);
}
return(lst);
}
