private void RefreshData()
        {
            IPandSCodesAndRatesListRepository pandsRepository = new PandSCodesAndRatesListRepository();

            this.PandSCodesAndRatesList = pandsRepository.GetPandSList().OrderBy(x => x.PandSName).ToList();
            this.ShowAllCount           = this.PandSCodesAndRatesList.Count();
            this.ShowSelectedCount      = 0;
            FullList    = this.PandSCodesAndRatesList.ToList();
            DefaultList = this.PandSCodesAndRatesList.ToList();
            this.PandSCodesAndRatesListcmb      = this.PandSCodesAndRatesList.OrderBy(x => x.PandSName).ToList();
            this.PandSCodesAndRatesListcmbCode  = this.PandSCodesAndRatesList.OrderBy(x => x.PandSCode).ToList();
            this.PandSCodesAndRatesListcmbCat1  = this.PandSCodesAndRatesList.GroupBy(x => x.Category1).Select(e => e.First()).OrderBy(x => x.Category1).ToList();
            this.PandSCodesAndRatesListcmbCat2  = this.PandSCodesAndRatesList.GroupBy(x => x.Category2).Select(e => e.First()).OrderBy(x => x.Category2).ToList();
            this.PandSCodesAndRatesListcmbTCode = this.PandSCodesAndRatesList.GroupBy(x => x.PSTaxName).Select(e => e.First()).OrderBy(x => x.PSTaxName).ToList();
            this.PandSCodesAndRatesListcmbTRate = this.PandSCodesAndRatesList.GroupBy(x => x.PSTaxRate).Select(e => e.First()).OrderBy(x => x.PSTaxRate).ToList();

            allPosition.Category1 = "All";
            allPosition.Category2 = "All";
            this.PandSCodesAndRatesListcmbCat1.Insert(0, allPosition);
            this.PandSCodesAndRatesListcmbCat2.Insert(0, allPosition);
            GetOptionsandTaxValues();
            this.ShowAllTrue      = true;
            this.ShowBoth         = true;
            this.ShowSelectedTrue = false;
            this.ShowProducts     = false;
            this.ShowServices     = false;
        }
        void GetOptionsandTaxValues()
        {
            OptionsEntity oData = new OptionsEntity();
            IPandSCodesAndRatesListRepository pandsRepository = new PandSCodesAndRatesListRepository();

            oData = pandsRepository.GetOptionDetails();
            if (oData != null)
            {
                this.CurrencyName   = oData.CurrencyCode;   //there is no currency name field in database
                this.CurrencyCode   = oData.CurrencyCode;
                this.CurrencyFormat = oData.NumberFormat;
                this.DateFormat     = oData.DateFormat;
                this.DecimalPlaces  = oData.DecimalPlaces;
                if (oData.ShowAmountIncGST == true)
                {
                    this.ShowIncTaxTrue = true;
                    this.ShowExcTaxTrue = false;
                }
                else
                {
                    this.ShowIncTaxTrue = false;
                    this.ShowExcTaxTrue = true;
                    int decimalpoints = Convert.ToInt32(DecimalPlaces);
                }
            }
            else
            {
                this.CurrencyName   = "USD";
                this.CurrencyCode   = "USD";
                this.CurrencyFormat = "en-US";
                this.DateFormat     = "dd/MM/yyyy";
            }
            var objDefaultTax = pandsRepository.GetTaxes().FirstOrDefault();

            if (objDefaultTax != null)
            {
                this.TaxName = objDefaultTax.TaxName;
            }
            else
            {
                this.TaxName = "GST";
            }
        }