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; } }