public void GetSummaryDetails() { try { this.JsonData = gstAndVatReportsRepository.GetLastSelectionData(Convert.ToInt32(ScreenId.GstVatSummary)); GstAndVatSummaryEntityList = gstAndVatReportsRepository.getGstAndVAtSummaryDetails(this.JsonData); FullListOFSummary = GstAndVatSummaryEntityList; TotalTaxInvoiceCNAmountSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxInvoiceCNAmountSummaryDec)); TotalTaxCollectedSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxCollectedSummaryDec)); TotalInvoiceDNAmountSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxInvoiceDNAmountSummaryDec)); TotalPaidSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxPaidSummaryDec)); } catch (Exception e) { throw e; } }
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) { GstAndVatSummaryEntityList = gstAndVatReportsRepository.getGstAndVAtSummaryDetails(jsonSearch); TotalTaxInvoiceCNAmountSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxInvoiceCNAmountSummaryDec)); TotalTaxCollectedSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxCollectedSummaryDec)); TotalInvoiceDNAmountSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxInvoiceDNAmountSummaryDec)); TotalPaidSummary = Convert.ToString(GstAndVatSummaryEntityList.Where(x => x.TaxDescriptionSummary != "Total").Sum(x => x.TaxPaidSummaryDec)); } } }