public List <TotalHomeVatModel> getAllVatHomeAmount(DateTime datefrom, DateTime dateto)
{
int OutletId = getOutletId();
List <TotalHomeVatModel> lst = new List <TotalHomeVatModel>();
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.Equals("Door Delivery 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))
{
TotalHomeVatModel model = new TotalHomeVatModel();
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 <TotalHomeVatModel> getAllVatHomeAmount()
{
int OutletId = getOutletId();
List <TotalHomeVatModel> lst = new List <TotalHomeVatModel>();
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 == "Door Delivery Hall" && p.OutletId == OutletId
select new
{
Vat = q.Vat,
Amount = q.Amount,
ItemId = q.ItemId,
VatAmount = p.VatAmount,
Discount = p.Discount
}).ToList();
foreach (var item in result.GroupBy(a => a.Vat))
{
TotalHomeVatModel model = new TotalHomeVatModel();
model.Vat = item.Key.Value;
decimal sum = item.Sum(a => a.VatAmount);
model.Amount = Math.Round(sum, 2);
lst.Add(model);
}
return(lst);
}
