public IEnumerable <Sales> Get(
string StartDT = null,
string EndDT = null,
DateGroupType group = DateGroupType.Day)
{
if (StartDT == null)
{
StartDateTime = DateTime.MinValue;
}
else
{
DateTime.TryParseExact(StartDT, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out StartDateTime);
}
if (EndDT == null)
{
EndDateTime = DateTime.MaxValue;
}
else
{
DateTime.TryParseExact(EndDT, "yyyy-MM-dd", CultureInfo.InvariantCulture, DateTimeStyles.None, out EndDateTime);
}
return(MathGroup.GetSales(StartDateTime, EndDateTime, group, db));
}
public IEnumerable <Sales> Get(
DateTime?StartDateTime = null,
DateTime?EndDateTime = null,
DateGroupType group = DateGroupType.Quarter)
{
IEnumerable <Sales> Group;
if (StartDateTime == null)
{
StartDateTime = DateTime.MinValue;
}
if (EndDateTime == null)
{
EndDateTime = DateTime.MaxValue;
}
switch (group)
{
case DateGroupType.Week:
{
Group = MathGroup.GetHistorySalesWeek(db.HistorySales.Where(x => x.DateSale >= StartDateTime).Where(x => x.DateSale <= EndDateTime).OrderBy(x => x.DateSale).ToList());
break;
}
case DateGroupType.Month:
{
Group = MathGroup.GetHistorySalesMonth(db.HistorySales.Where(x => x.DateSale >= StartDateTime).Where(x => x.DateSale <= EndDateTime).OrderBy(x => x.DateSale).ToList());
break;
}
case DateGroupType.Quarter:
{
Group = MathGroup.GetHistorySalesQuarter(db.HistorySales.Where(x => x.DateSale >= StartDateTime).Where(x => x.DateSale <= EndDateTime).OrderBy(x => x.DateSale).ToList());
break;
}
default:
{
Group = MathGroup.GetHistorySalesDay(db.HistorySales.Where(x => x.DateSale >= StartDateTime).Where(x => x.DateSale <= EndDateTime).OrderBy(x => x.DateSale).ToList());
break;
}
}
return(Group);
}
