private void RefreshData()
{
ITopCustomersRepository pandsRepository = new TopCustomersRepository();
String sDate = DateTime.Now.ToString();
DateTime dateTime = DateTime.UtcNow.Date;
var quarter = (dateTime.Month + 2) / 3;
var lastQuarter = quarter - 1;
if (lastQuarter == 0)
{
lastQuarter = 1;
}
DateTime datevalue = (Convert.ToDateTime(sDate.ToString()));
this.JsonData = pandsRepository.GetLastSelectionData(Convert.ToInt32(ScreenId.TopCustomers));
//this.TopCustomersList = pandsRepository.GetPandSList(null).OrderByDescending(x => x.Sales).ToList();
this.TopCustomersList = pandsRepository.GetPandSList(this.JsonData).ToList();
this.ShowAllCount = this.TopCustomersList.Count();
//this.ShowSelectedCount = 0;
FullList = this.TopCustomersList.ToList();
//DefaultList = this.TopCustomersList.ToList();
this.TopCustomersListcmb = this.TopCustomersList.OrderBy(x => x.CustomerName).ToList();
//this.TopCustomersListcmbCode = this.TopCustomersList.OrderBy(x => x.PandSCode).ToList();
//this.TopCustomersListcmbCat1 = this.TopCustomersList.GroupBy(x => x.Category1).Select(e => e.First()).OrderBy(x => x.Category1).ToList();
//this.TopCustomersListcmbCat2 = this.TopCustomersList.GroupBy(x => x.Category2).Select(e => e.First()).OrderBy(x => x.Category2).ToList();
//allPosition.Category1 = "All";
//allPosition.Category2 = "All";
//this.TopCustomersListcmbCat1.Insert(0, allPosition);
//this.TopCustomersListcmbCat2.Insert(0, allPosition);
GetOptionsandTaxValues();
this.ShowAllTrue = true;
//this.ShowSelectedTrue = false;
this.YearRange = pandsRepository.GetYearRange().ToList();
TotalSalesAmountStr = Convert.ToString(TopCustomersList.Sum(e => e.Sales));
TotalPaymentAmountStr = Convert.ToString(TopCustomersList.Sum(e => e.Payment));
SetDefaultSearchSelection();
}
