private void RefreshData() { IRefundFromSuppliersListRepository purchaseRepository = new RefundFromSuppliersListRepository(); this.DateFormat = purchaseRepository.GetDateFormat(); this.ShowAllCount = purchaseRepository.GetAllPurInvoice().Count(); GetOptionsandTaxValues(); this.JsonData = purchaseRepository.GetLastSelectionData(); this.RefundFromSuppliersList = purchaseRepository.GetAllPurInvoiceJson(this.JsonData).ToList(); this.RefundFromSuppliersListcmb = purchaseRepository.GetAllPurInvoice().OrderBy(e => e.SupplierName).ToList(); this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); this.RefundFromSuppliersListcmbDebit = this.RefundFromSuppliersListcmb.GroupBy(x => x.CashChequeNo).Select(g => g.First()).Where(y => y.CashChequeNo != null).OrderBy(e => e.CashChequeNo).ToList(); this.RefundFromSuppliersListcmbSup = this.RefundFromSuppliersList.GroupBy(x => x.SupplierName).Select(y => y.First()).Distinct().OrderBy(e => e.SupplierName).ToList(); this.RefundFromSuppliersListcmbInv = this.RefundFromSuppliersList.GroupBy(x => x.InvoiceNo).Select(y => y.First()).Distinct().OrderBy(e => e.InvoiceNo).ToList(); this.YearRange = purchaseRepository.GetYearRange().ToList(); //changedateformat(this.RefundFromSuppliersList); //changedateformat(this.RefundFromSuppliersListcmb); changeNumberformat(this.RefundFromSuppliersList); changeNumberformat(this.RefundFromSuppliersListcmb); DefaultList = this.RefundFromSuppliersList; FullPQList = this.RefundFromSuppliersListcmb; //this.ShowAllCount = this.PurchaseInvoiceListcmb.Count(); SetDefaultSearchSelection(); var Updateddate = this.RefundFromSuppliersListcmb.Max(x => x.CreatedDate); string date = this.DateFormat as string; this.LastUpdateDate = Convert.ToDateTime(Updateddate).ToString(date); TotalCashChequeAmount = Convert.ToString(RefundFromSuppliersList.Sum(e => e.CashChequeAmount)); TotalPOPIAmount = Convert.ToString(RefundFromSuppliersList.Sum(e => e.InvoiceAmountValue)); //this.GetData(this.SelectedSearchSupplier); }
void Search(object param) { if (Count != 0) { SearchValues = new List <SearchEntity>(); this.ShowSelectedTrue = true; //this.ShowAllTrue = false; 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); DefaultList = FullPQList.Where(x => x.CreatedDate.Value.Year == year).ToList(); //if (this.IncludingGSTTrue == true) // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == true).ToList(); //else // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == false).ToList(); this.RefundFromSuppliersList = DefaultList; } 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; } DefaultList = FullPQList.Where(x => x.CreatedDate.Value.Month == month1 || x.CreatedDate.Value.Month == month2 || x.CreatedDate.Value.Month == month3).ToList(); //if (this.IncludingGSTTrue == true) // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == true).ToList(); //else // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == false).ToList(); this.RefundFromSuppliersList = DefaultList; 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); DefaultList = FullPQList.Where(x => x.CreatedDate.Value.Month == month).ToList(); //if (this.IncludingGSTTrue == true) // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == true).ToList(); //else // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == false).ToList(); this.RefundFromSuppliersList = DefaultList; } if (this.SelectedSearchStartDate != null && this.SelectedSearchEndDate != null) { SearchEntity value = new SearchEntity(); value.FieldName = "StartDate"; //value.FieldValue = this.SelectedSearchStartDate.ToString(); value.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchStartDate); //SearchValues.Add(value); //string[] value = new string[2]; SearchEntity value1 = new SearchEntity(); value1.FieldName = "EndDate"; //value1.FieldValue = this.SelectedSearchEndDate.ToString(); value1.FieldValue = string.Format("{0:MMM/dd/yyyy}", this.SelectedSearchEndDate); DefaultList = FullPQList.Where(x => x.CashChequeDateDate > this.SelectedSearchStartDate && x.CashChequeDateDate < this.SelectedSearchEndDate).ToList(); //if (this.IncludingGSTTrue == true) // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == true).ToList(); //else // this.PurchaseInvoiceListInternal = DefaultList.Where(x => x.ExcIncGST == false).ToList(); this.RefundFromSuppliersList = DefaultList; SearchValues.Add(value); SearchValues.Add(value1); } //if (this.SelectedSearchEndDate != null || this.SelectedSearchEndDate == string.Empty) //{ // string[] value = new string[2]; // value[0] = "EndDate"; // value[1] = this.SelectedSearchEndDate; // SearchValues.Add(value); //} //this.PurchaseInvoiceList = this.PurchaseInvoiceListInternal; jsonSearch = JsonConvert.SerializeObject(SearchValues); this.JsonData = jsonSearch; IRefundFromSuppliersListRepository purchaseRepository = new RefundFromSuppliersListRepository(); var results = purchaseRepository.SaveSearchJson(jsonSearch, Convert.ToInt32(ScreenId.RefundFromSuppliersList), "RefundFromSuppliers_List"); if (Count != 0) { this.RefundFromSuppliersList = purchaseRepository.GetAllPurInvoiceJson(jsonSearch); //changedateformat(this.RefundFromSuppliersList); //changedateformat(this.RefundFromSuppliersListcmb); //changeNumberformat(this.RefundFromSuppliersList); changeNumberformat(this.RefundFromSuppliersList); } this.RefundFromSuppliersListcmb = this.RefundFromSuppliersList; this.RefundFromSuppliersListcmbDebit = this.RefundFromSuppliersListcmb.GroupBy(x => x.CashChequeNo).Select(g => g.First()).Where(y => y.CashChequeNo != null).ToList(); this.RefundFromSuppliersListcmbSup = this.RefundFromSuppliersList.GroupBy(x => x.SupplierName).Select(y => y.First()).Distinct().ToList(); this.RefundFromSuppliersListcmbInv = this.RefundFromSuppliersList.GroupBy(x => x.InvoiceNo).Select(y => y.First()).Distinct().ToList(); if (this.ShowAllTrue == true) { this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); } else { this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); } DefaultList = this.RefundFromSuppliersListcmb; } TotalCashChequeAmount = Convert.ToString(RefundFromSuppliersList.Sum(e => e.CashChequeAmount)); TotalPOPIAmount = Convert.ToString(RefundFromSuppliersList.Sum(e => e.InvoiceAmountValue)); }
public void GetData(string SearchFilter, string parameter) { //IPurchaseInvoiceListRepository purchaseRepository = new PurchaseInvoiceListRepository(); //var result = purchaseRepository.GetAllPurInvoice().ToList(); if (SearchFilter != null || SearchFilter == string.Empty) { if (parameter == "Supplier") { this.ShowAllCount = this.ShowAllCount; //var searchname = SearchFilter.Split('#')[0]; if (this.ShowAllTrue == true) { this.RefundFromSuppliersList = FullPQList.Where(x => (x.SupplierName == SearchFilter)).ToList(); } else { this.RefundFromSuppliersList = DefaultList.Where(x => (x.SupplierName == SearchFilter)).ToList(); } //DefaultList = DefaultList.Where(x => x.SupplierName == SearchFilter).ToList(); } //DefaultList = DefaultList.Where(x => x.SupplierName == SearchFilter).ToList(); if (parameter == "CashChequeNo") { this.ShowAllCount = this.ShowAllCount; //var searchname = SearchFilter.Split('#')[0]; if (this.ShowAllTrue == true) { this.RefundFromSuppliersList = FullPQList.Where(x => x.CashChequeNo == SearchFilter).ToList(); this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); } else { this.RefundFromSuppliersList = DefaultList.Where(x => x.CashChequeNo == SearchFilter).ToList(); this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); } //DefaultList = DefaultList.Where(x => x.SupplierName == SearchFilter).ToList(); } if (parameter == "InvoiceNo") { this.ShowAllCount = this.ShowAllCount; //var searchname = SearchFilter.Split('#')[0]; if (this.ShowAllTrue == true) { this.RefundFromSuppliersList = FullPQList.Where(x => x.InvoiceNo == SearchFilter).ToList(); this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); } else { this.RefundFromSuppliersList = DefaultList.Where(x => x.InvoiceNo == SearchFilter).ToList(); this.ShowSelectedCount = this.RefundFromSuppliersList.Count(); } //DefaultList = DefaultList.Where(x => x.SupplierName == SearchFilter).ToList(); } } else { if (this.ShowAllTrue == true) { this.RefundFromSuppliersList = FullPQList.ToList(); } else { this.RefundFromSuppliersList = DefaultList.ToList(); } } TotalCashChequeAmount = Convert.ToString(RefundFromSuppliersList.Sum(e => e.CashChequeAmount)); TotalPOPIAmount = Convert.ToString(RefundFromSuppliersList.Sum(e => e.InvoiceAmountValue)); }