public void GetCustomerListByActivationStatus(string sortedBy, string sortingOrder, string isActive)
        {
            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                GeneralReportsDAL generalReports = new GeneralReportsDAL();

                if (LumexSessionManager.Get("ReportData") != null)
                {
                    LumexSessionManager.Remove("ReportData");
                }

                LumexSessionManager.Add("ReportData", generalReports.GetCustomerListByActivationStatus(sortedBy, sortingOrder, isActive, db));
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
        }
        public void GetSelectedCustomersDetails(string customersId)
        {
            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                GeneralReportsDAL generalReports = new GeneralReportsDAL();

                if (LumexSessionManager.Get("ReportData") != null)
                {
                    LumexSessionManager.Remove("ReportData");
                }

                LumexSessionManager.Add("ReportData", generalReports.GetSelectedCustomersDetails(customersId, db));
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
        }
        public void GetSalesCenterListByWarehouse(string sortedBy, string sortingOrder, string isActive, string warehouseId)
        {
            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                GeneralReportsDAL generalReports = new GeneralReportsDAL();

                if (LumexSessionManager.Get("ReportData") != null)
                {
                    LumexSessionManager.Remove("ReportData");
                }

                LumexSessionManager.Add("ReportData", generalReports.GetSalesCenterListByWarehouse(sortedBy, sortingOrder, isActive, warehouseId, db));
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
        }
        public void GetDeletedSalesCenterListByDateRangeAll(string sortedBy, string sortingOrder, string fromDate, string toDate, string search)
        {
            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                GeneralReportsDAL generalReports = new GeneralReportsDAL();

                if (LumexSessionManager.Get("ReportData") != null)
                {
                    LumexSessionManager.Remove("ReportData");
                }

                LumexSessionManager.Add("ReportData", generalReports.GetDeletedSalesCenterListByDateRangeAll(sortedBy, sortingOrder, fromDate, toDate, search, db));
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
        }
        public void GetVendorListByProduct(string sortedBy, string sortingOrder, string isActive, string productBarcodeIdName)
        {
            try
            {
                LumexDBPlayer db = LumexDBPlayer.Start();
                GeneralReportsDAL generalReports = new GeneralReportsDAL();

                if (LumexSessionManager.Get("ReportData") != null)
                {
                    LumexSessionManager.Remove("ReportData");
                }

                LumexSessionManager.Add("ReportData", generalReports.GetVendorListByProduct(sortedBy, sortingOrder, isActive, productBarcodeIdName, db));
                db.Stop();
            }
            catch (Exception)
            {
                throw;
            }
        }