public void RefreshData() { this.YearRange = purchaseRepository.GetYearRange().ToList(); this.ShowAllTrue = false; GetOptionsandTaxValues(); SetDefaultSearchSelection(); //GstAndCollectedDetails(); this.JsonData = gstAndVatReportsRepository.GetLastSelectionData(Convert.ToInt32(ScreenId.GstVatSummary)); GstAndVatCollectedEntityList = gstAndVatReportsRepository.getGstAndVAtCollectedDetails(this.JsonData).ToList(); FullListOFCollected = GstAndVatCollectedEntityList; TotalInvoiceAmountC = Convert.ToString(GstAndVatCollectedEntityList.Where(x => x.TaxDescriptionC != "Total").Sum(x => x.TaxInvoiceAmountC)); TotalTaxCollecetdC = Convert.ToString(GstAndVatCollectedEntityList.Where(x => x.TaxDescriptionC != "Total").Sum(x => x.TaxCollectedC)); this.ShowSelectedCount = GstAndVatCollectedEntityList.Where(x => x.TaxDescriptionC != "Total").Count(); }
void Search(object param) { //UIServices.SetBusyState(); //DoProcessing(); if (Count != 0) { 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); } 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 = this.ShowAllTrue.ToString(); SearchValues.Add(value); } jsonSearch = JsonConvert.SerializeObject(SearchValues); this.JsonData = jsonSearch; var results = gstAndVatReportsRepository.SaveSearchJson(jsonSearch, Convert.ToInt32(ScreenId.GstVatSummary), "GstVatSummaryReport"); if (Count != 0) { GstAndVatCollectedEntityList = gstAndVatReportsRepository.getGstAndVAtCollectedDetails(jsonSearch); TotalInvoiceAmountC = Convert.ToString(GstAndVatCollectedEntityList.Where(x => x.TaxDescriptionC != "Total").Sum(x => x.TaxInvoiceAmountC)); TotalTaxCollecetdC = Convert.ToString(GstAndVatCollectedEntityList.Where(x => x.TaxDescriptionC != "Total").Sum(x => x.TaxCollectedC)); this.ShowSelectedCount = GstAndVatCollectedEntityList.Where(x => x.TaxDescriptionC != "Total").Count(); } } }