public static DailySaleReport GetSaleRecord(AprajitaRetailsContext db)
{
DailySaleReport record = new DailySaleReport
{
DailySale = (decimal?)db.DailySales.Where(C => (C.SaleDate.Date) == (DateTime.Today.Date)).Sum(c => (decimal?)c.Amount) ?? 0,
MonthlySale = (decimal?)db.DailySales.Where(C => (C.SaleDate).Month == (DateTime.Today).Month).Sum(c => (decimal?)c.Amount) ?? 0,
YearlySale = (decimal?)db.DailySales.Where(C => (C.SaleDate).Year == (DateTime.Today).Year).Sum(c => (decimal?)c.Amount) ?? 0
};
return(record);
}
public static DailySaleReport GetSaleRecord()
{
using (AprajitaRetailsContext db = new AprajitaRetailsContext())
{
DailySaleReport record = new DailySaleReport();
record.DailySale = (decimal?)db.DailySales.Where(C => DbFunctions.TruncateTime(C.SaleDate) == DbFunctions.TruncateTime(DateTime.Today)).Sum(c => (decimal?)c.Amount) ?? 0;
record.MonthlySale = (decimal?)db.DailySales.Where(C => DbFunctions.TruncateTime(C.SaleDate).Value.Month == DbFunctions.TruncateTime(DateTime.Today).Value.Month).Sum(c => (decimal?)c.Amount) ?? 0;
record.YearlySale = (decimal?)db.DailySales.Where(C => DbFunctions.TruncateTime(C.SaleDate).Value.Year == DbFunctions.TruncateTime(DateTime.Today).Value.Year).Sum(c => (decimal?)c.Amount) ?? 0;
return(record);
}
}
