private void RefreshData()
{
ICreditNoteListRepository SalesRepository = new CreditNoteListRepository();
// this.DateFormat = SalesRepository.GetDateFormat();
this.ShowAllCount = SalesRepository.GetAllSalesCredit().Count();
GetOptionsandTaxValues();
this.JsonData = SalesRepository.GetLastSelectionData(Convert.ToInt32(ScreenId.CreditNoteList));
this.CreditNoteList = SalesRepository.GetAllSalesCreditJson(this.JsonData, this.IncludingGSTTrue).OrderBy(x => x.CustomerName).ToList();
this.CreditNoteListcmb = SalesRepository.GetAllSalesCredit().OrderBy(x => x.CustomerName).ToList();
this.ShowSelectedCount = this.CreditNoteList.Count();
this.CreditNoteListcmbCredit = this.CreditNoteList.GroupBy(x => x.InvoiceNoCashChequeNo).Select(g => g.First()).Where(y => !string.IsNullOrEmpty(y.InvoiceNoCashChequeNo) || !string.IsNullOrWhiteSpace(y.InvoiceNoCashChequeNo)).OrderBy(x => x.InvoiceNoCashChequeNo).ToList();
this.CreditNoteListcmbCus = this.CreditNoteList.GroupBy(x => x.CustomerName).Select(y => y.First()).Distinct().OrderBy(x => x.CustomerName).ToList();
this.CreditNoteListcmbCus = this.CreditNoteList.GroupBy(x => x.CustomerName).Select(y => y.First()).Distinct().OrderBy(x => x.CustomerName).ToList();
this.CreditNoteListcmbInv = this.CreditNoteList.GroupBy(x => x.CreditNo).Select(y => y.First()).Distinct().OrderBy(x => x.SortCreditNoteNo).ToList();
this.YearRange = SalesRepository.GetYearRange().ToList();
//changeNumberformat(this.CreditNoteList);
//changeNumberformat(this.CreditNoteListcmb);
DefaultList = this.CreditNoteList;
FullPQList = this.CreditNoteList;
this.ShowAllCount = this.CreditNoteListcmb.Count();
SetDefaultSearchSelection();
//var Updateddate = this.CreditNoteListcmb.Max(x => x.CreatedDate);
//string date = this.DateFormat as string;
//this.LastUpdateDate = Convert.ToDateTime(Updateddate).ToString(date);
this.TotalCreditAmount = Convert.ToString(CreditNoteList.Sum(e => e.CreditNoteAmount));
//this.GetData(this.SelectedSearchCustomer);
this.TotalInvoiceCashChequeAmount = Convert.ToString(CreditNoteListcmbCredit.Sum(e => e.InvoiceCashChequeAmount));
}
//void ShowSelected(object param)
//{
// Search(null);
//}
void Search(object param)
{
if (Count != 0)
{
//this.ShowAllTrue = false;
SearchValues = new List <SearchEntity>();
if (this.SelectedSearchYear != null || this.SelectedSearchYear == string.Empty)
{
SearchEntity value = new SearchEntity();
value.FieldName = "Year";
value.FieldValue = this.SelectedSearchYear;
SearchValues.Add(value);
var year = Convert.ToInt32(this.SelectedSearchYear);
}
else
{
SearchEntity value = new SearchEntity();
value.FieldName = "Year";
value.FieldValue = "0";
SearchValues.Add(value);
var year = Convert.ToInt32(this.SelectedSearchYear);
}
if (this.SelectedSearchQuarter != null || this.SelectedSearchQuarter == string.Empty)
{
SearchEntity value = new SearchEntity();
value.FieldName = "Quarter";
value.FieldValue = this.SelectedSearchQuarter;
int month1;
int month2;
int month3;
if (Convert.ToInt32(this.SelectedSearchQuarter) == 1)
{
month1 = 1;
month2 = 2;
month3 = 3;
}
else if (Convert.ToInt32(this.SelectedSearchQuarter) == 2)
{
month1 = 4;
month2 = 5;
month3 = 6;
}
else if (Convert.ToInt32(this.SelectedSearchQuarter) == 3)
{
month1 = 7;
month2 = 8;
month3 = 9;
}
else
{
month1 = 10;
month2 = 11;
month3 = 12;
}
SearchValues.Add(value);
}
else
{
SearchEntity value = new SearchEntity();
value.FieldName = "Quarter";
value.FieldValue = "0";
SearchValues.Add(value);
}
if (this.SelectedSearchMonth != null || this.SelectedSearchMonth == string.Empty)
{
SearchEntity value = new SearchEntity();
value.FieldName = "Month";
value.FieldValue = this.SelectedSearchMonth;
SearchValues.Add(value);
var month = Convert.ToInt32(this.SelectedSearchMonth);
}
else
{
SearchEntity value = new SearchEntity();
value.FieldName = "Month";
value.FieldValue = "0";
SearchValues.Add(value);
}
if (this.ShowAllTrue == true)
{
SearchEntity value = new SearchEntity();
value.FieldName = "ShowAll";
value.FieldValue = this.ShowAllTrue.ToString();
SearchValues.Add(value);
}
else
{
SearchEntity value = new SearchEntity();
value.FieldName = "ShowAll";
value.FieldValue = "false";
SearchValues.Add(value);
}
if (this.SelectedSearchStartDate != null && this.SelectedSearchEndDate != null)
{
SearchEntity value = new SearchEntity();
value.FieldName = "StartDate";
value.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchStartDate);
//SearchValues.Add(value);
SearchEntity value1 = new SearchEntity();
value1.FieldName = "EndDate";
value1.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchEndDate);
SearchValues.Add(value);
SearchValues.Add(value1);
}
else
{
SearchEntity value = new SearchEntity();
value.FieldName = "StartDate";
value.FieldValue = "0";
//SearchValues.Add(value);
SearchEntity value1 = new SearchEntity();
value1.FieldName = "EndDate";
value1.FieldValue = "0";
SearchValues.Add(value);
SearchValues.Add(value1);
}
jsonSearch = JsonConvert.SerializeObject(SearchValues);
this.JsonData = jsonSearch;
ICreditNoteListRepository SalesRepository = new CreditNoteListRepository();
var results = SalesRepository.SaveSearchJson(jsonSearch, Convert.ToInt32(ScreenId.CreditNoteList), "Credit_Note_List");
if (Count != 0)
{
this.CreditNoteList = SalesRepository.GetAllSalesCreditJson(jsonSearch, this.IncludingGSTTrue).OrderBy(x => x.CustomerName).ToList();
// changeNumberformat(this.CreditNoteList);
}
this.CreditNoteListcmb = this.CreditNoteList.OrderBy(x => x.CustomerName).ToList();
this.CreditNoteListcmbCredit = this.CreditNoteList.GroupBy(x => x.InvoiceNoCashChequeNo).Select(g => g.First()).Where(y => !string.IsNullOrEmpty(y.InvoiceNoCashChequeNo) || !string.IsNullOrWhiteSpace(y.InvoiceNoCashChequeNo)).OrderBy(x => x.InvoiceNoCashChequeNo).ToList();
this.CreditNoteListcmbCus = this.CreditNoteList.GroupBy(x => x.CustomerName).Select(y => y.First()).Distinct().OrderBy(x => x.CustomerName).ToList();
this.CreditNoteListcmbInv = this.CreditNoteList.GroupBy(x => x.CreditNo).Select(y => y.First()).Distinct().OrderBy(x => x.SortCreditNoteNo).ToList();
if (this.ShowAllTrue == true)
{
this.ShowSelectedCount = this.CreditNoteList.Count();
}
else
{
this.ShowSelectedCount = this.CreditNoteList.Count();
}
DefaultList = this.CreditNoteList;
this.TotalCreditAmount = Convert.ToString(CreditNoteList.Sum(e => e.CreditNoteAmount));
this.TotalInvoiceCashChequeAmount = Convert.ToString(CreditNoteListcmbCredit.Sum(e => e.InvoiceCashChequeAmount));
}
}
