public IDataResult <List <OrderDetail> > GetOrderDetails(int orderId)
{
try
{
return(new SuccessDataResult <List <OrderDetail> >(_orderDetailDal.GetList(od => od.OrderId == orderId)));
}
catch (Exception)
{
return(new ErrorDataResult <List <OrderDetail> >(Messages.ErrorWhileGettingEntity));
}
}
public IEnumerable <CashierRevenueStatisticModel> GetCashierRevenueStatisticByProduct(DateTime fromCreatedDate, DateTime toCreatedDate)
{
try
{
var lstOrderDetail = _orderDetailDal.GetList((short)OrderStatusEnum.Success, fromCreatedDate, toCreatedDate);
if (lstOrderDetail.Any())
{
var result = new List <CashierRevenueStatisticModel>();
var lstProduct = lstOrderDetail.GroupBy(x => x.product_id).Select(c => c.First()).ToList();
foreach (var item in lstProduct)
{
var total = 0;
var cashierRevenueObj = new CashierRevenueStatisticModel {
CashierName = item.product_name
};
foreach (DateTime day in EachDay(fromCreatedDate, toCreatedDate))
{
var revenueByDay = new CashierRevenueStatisticByDayModel {
Day = day
};
var RevenueOfDishes = lstOrderDetail.Where(x => x.product_id == item.product_id &&
x.created_date.Date.CompareTo(day) == 0).Sum(x => x.price);
revenueByDay.Revenue = RevenueOfDishes;
cashierRevenueObj.lstDay.Add(revenueByDay);
total += revenueByDay.Revenue;
}
cashierRevenueObj.TotalStr = StringUtils.ConvertNumberToCurrency(total);
result.Add(cashierRevenueObj);
}
return(result);
}
}
catch (Exception ex)
{
Logger.WriteLog(Logger.LogType.Error, ex.ToString());
}
return(new List <CashierRevenueStatisticModel>());
}
public List <OrderDetails> GetByProduct(int productId)
{
return(_orderDetailDal.GetList(p => p.OrderId == productId));
}
public List <OrderDetail> GetDetails()
{
return(_orderDetailDal.GetList());
}
public List <OrderDetail> GetByOrderId(int id)
{
return(_orderDetailDal.GetList(filter: d => d.OrderId == id).ToList());
}
