void LoadDealQuarter(int quarter)
{
//quarter = 1 => Quý 1: Tháng 1 -> 3
//quarter = 2 => Quý 1: Tháng 4 -> 6
//quarter = 3 => Quý 1: Tháng 7 -> 9
//quarter = 4 => Quý 1: Tháng 10 -> 12
ReportDataList.DealQuarter = new ObservableCollection <Revenue>();
ReportDataList2.DealQuarter = new ObservableCollection <Revenue>();
List <sumArray> SumArrayQuantity = new List <sumArray>();
List <sumArray> SumArrayPrice = new List <sumArray>();
var DealList = DataProvider.Ins.DB.DEALs.Where(x => x.IsDeleted == false && x.PayDate.Value.Year == DateTime.Now.Year && (x.PayDate.Value.Month + 2) / 3 == quarter);
foreach (var deal in DealList)
{
if (IsExistsDate(SumArrayPrice, deal.PayDate.Value.Month, deal.DisplayPrice) == false)
{
var element = new sumArray();
element.date = deal.PayDate.Value.Month;
element.sumPrice = deal.DisplayPrice;
SumArrayPrice.Add(element);
}
if (IsExistsProduct(SumArrayQuantity, deal.PRODUCT.DisplayName, deal.Quantity) == false)
{
var element = new sumArray();
element.productName = deal.PRODUCT.DisplayName;
element.sumQuantity = deal.Quantity;
SumArrayQuantity.Add(element);
}
}
foreach (var element in SumArrayQuantity)
{
var revenue = new Revenue();
revenue.ProductName = element.productName;
revenue.SumQuantity = element.sumQuantity;
ReportDataList.DealQuarter.Add(revenue); //Load vào biểu đố số lượng
}
foreach (var element in SumArrayPrice)
{
var revenue = new Revenue();
revenue.Time = element.date;
revenue.SumPrice = element.sumPrice;
ReportDataList2.DealQuarter.Add(revenue); //Load vào biểu đố doanh thu
}
}
void LoadDealPeriodTime(DateTime beginTime, DateTime endTime)
{
ReportDataList.DealPeriod = new ObservableCollection <Revenue>();
ReportDataList2.DealPeriod = new ObservableCollection <Revenue>();
List <sumArray> SumArrayQuantity = new List <sumArray>();
List <sumArray> SumArrayPrice = new List <sumArray>();
var DealList = DataProvider.Ins.DB.DEALs.Where(x => x.IsDeleted == false && x.PayDate >= beginTime && x.PayDate <= endTime);
foreach (var deal in DealList)
{
if (IsExistsDate(SumArrayPrice, deal.PayDate.Value.Day, deal.DisplayPrice) == false)
{
var element = new sumArray();
element.detailDate = (DateTime)deal.PayDate;
element.sumPrice = deal.DisplayPrice;
SumArrayPrice.Add(element);
}
if (IsExistsProduct(SumArrayQuantity, deal.PRODUCT.DisplayName, deal.Quantity) == false)
{
var element = new sumArray();
element.productName = deal.PRODUCT.DisplayName;
element.sumQuantity = deal.Quantity;
SumArrayQuantity.Add(element);
}
}
foreach (var element in SumArrayQuantity)
{
var revenue = new Revenue();
revenue.ProductName = element.productName;
revenue.SumQuantity = element.sumQuantity;
ReportDataList.DealPeriod.Add(revenue); //Load vào biểu đố số lượng
}
foreach (var element in SumArrayPrice)
{
var revenue = new Revenue();
revenue.PayDate = element.detailDate;
revenue.SumPrice = element.sumPrice;
ReportDataList2.DealPeriod.Add(revenue); //Load vào biểu đố doanh thu
}
}