public void GetCustomerReceivableListById(string customersId, string SalesCenterId)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetCustomerReceivableListById(customersId, SalesCenterId, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetAvailableProductBySaclesCenterIdPRWise(string SalesCenterId)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetAvailableProductBySaclesCenterIdPRWise(SalesCenterId, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetPurchaseRecordbySC_Date_RANGE_STATUS(string SalesCenterId, string ToDate, string FromDate, string PrStatus)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetPurchaseRecordbySC_Date_RANGE_STATUS(SalesCenterId, ToDate, FromDate, PrStatus, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetSalesCenterVendorDueAmountList(string SalesCenterId)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetSalesCenterVendorDueAmountList(SalesCenterId, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetProductSalesRecordListByProductId(string ProductId, string FromDate,string ToDate)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetProductSalesRecordListByProductId(ProductId,FromDate,ToDate, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetReceivePaymentVaucharbyVendororCustomer(string JournalNo, string vendorId, string WHSCId)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetReceivePaymentVaucharbyVendororCustomer(JournalNo,vendorId, WHSCId, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetCreditOrDebitVoucherByVoucherId(string voucherId, string salesCenterId,string cmdarg)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetCreditOrDebitVoucherByVoucherId(voucherId, salesCenterId,cmdarg,db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetSalesInvoiceBySalesRecord(string salesRecordId, string salesCenterId)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetSalesInvoiceBySalesRecord(salesRecordId, salesCenterId, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetWarehouseVendorReceivePaymentList(string SalesCenterId, string VendorId, string FromDate, string ToDate, string status)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetWarehouseVendorReceivePaymentList(SalesCenterId, VendorId, FromDate, ToDate, status, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void Get_Trial_Balance_by_Date(string ReportType, string SCWHId, string FromDate)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.Get_Trial_Balance_by_Date(ReportType, SCWHId, FromDate, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetGeneral_ledger_Sheet_Report_by_Date(string ReportType, string SCWHId, string toDate, string FormDate)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetGeneral_ledger_Sheet_Report_by_Date(ReportType, SCWHId, toDate, FormDate, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}
public void GetFinancial_Ladger_Report_by_Date_and_AccountId(string ReportType, string SCWHId, string accountId, string toDate, string FromDate)
{
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
IPOSReportDAL iposReport = new IPOSReportDAL();
if (LumexSessionManager.Get("ReportData") != null)
{
LumexSessionManager.Remove("ReportData");
}
LumexSessionManager.Add("ReportData", iposReport.GetFinancial_Ladger_Report_by_Date_and_AccountId(ReportType, SCWHId, accountId, toDate, FromDate, db));
db.Stop();
}
catch (Exception)
{
throw;
}
}