Exemplo n.º 1
0
        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;
            }
        }
Exemplo n.º 2
0
        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));
                }
            }
        }