public List <TodayRestroBillModel> getallRestroBill(DateTime datefrom, DateTime dateto)
{
int OutletId = getOutletId();
List <TodayRestroBillModel> lst = new List <TodayRestroBillModel>();
var dd = 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
{
ItemName = p.tblItem.Name,
Quantity = p.FullQty,
Amount = p.Amount,
BillId = p.BillId,
}).ToList();
foreach (var item in result.GroupBy(a => a.ItemName))
{
if (item.FirstOrDefault().Quantity > 0)
{
TodayRestroBillModel model = new TodayRestroBillModel();
decimal amount = item.Sum(a => a.Amount);
model.Amount = amount;
model.TotalAmount = item.Sum(a => a.Amount);
model.Name = item.FirstOrDefault().ItemName;
model.Price = Convert.ToDecimal(item.FirstOrDefault().Amount / item.FirstOrDefault().Quantity);
model.Qty = item.Sum(a => a.Quantity).Value;
lst.Add(model);
}
}
return(lst);
}
public List <TodayRestroBillModel> getallRestroBill()
{
int OutletId = getOutletId();
List <TodayRestroBillModel> lst = new List <TodayRestroBillModel>();
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
join t in entites.tblItems on q.ItemId equals t.ItemId
join b in entites.tblBasePriceItems on t.ItemId equals b.ItemId
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
{
ItemName = t.Name,
Quantity = q.FullQty,
Price = b.FullPrice,
Amount = q.Amount,
BillId = p.BillId,
}).ToList();
foreach (var item in result.GroupBy(a => a.ItemName))
{
TodayRestroBillModel model = new TodayRestroBillModel();
decimal amount = item.Sum(a => a.Amount);
model.Amount = Math.Round(amount, 2);
model.TotalAmount = item.Sum(a => a.Amount);
model.Name = item.FirstOrDefault().ItemName;
model.Price = Math.Round(item.FirstOrDefault().Price, 2);
model.Qty = item.Sum(a => a.Quantity).Value;
lst.Add(model);
}
return(lst);
}
