public DataTable GetProductTransferRequisitionById(string transferRequisitionId) { ProductTransferRequisitionDAL productTransferRequisition = new ProductTransferRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = productTransferRequisition.GetProductTransferRequisitionById(transferRequisitionId, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { productTransferRequisition = null; } }
public DataTable GetProductTransferRequisitionsListByTransferTypeFromToDateRangeAndStatus(string transferType, string transferFrom, string transferTo, string fromDate, string toDate, string status) { ProductTransferRequisitionDAL productTransferRequisition = new ProductTransferRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = productTransferRequisition.GetProductTransferRequisitionsListByTransferTypeFromToDateRangeAndStatus(transferType, transferFrom, transferTo, fromDate, toDate, status, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { productTransferRequisition = null; } }
public string SaveProductTransferRequisition(List<ProductTransferRequisitionBLL> productTransferRequisitions, string transferType, string transferFrom, string transferTo, string narration) { ProductTransferRequisitionDAL productTransferRequisition = new ProductTransferRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); string productRequisitionId = productTransferRequisition.SaveProductTransferRequisition(productTransferRequisitions, transferType, transferFrom, transferTo, narration, db); db.Stop(); return productRequisitionId; } catch (Exception) { throw; } finally { productTransferRequisition = null; } }
public string ApproveTransferRequisitionAndCreateTransferOrder(DataTable dt) { ProductTransferRequisitionDAL productTransferRequisition = new ProductTransferRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); string msg = productTransferRequisition.ApproveTransferRequisitionAndCreateTransferOrder(dt, this, db); db.Stop(); return msg; } catch (Exception) { throw; } finally { productTransferRequisition = null; } }
public DataTable GetProductTransferRequisitionsApprovalListByTransferTypeFromAndTo(string transferType, string transferFrom, string transferTo) { ProductTransferRequisitionDAL productTransferRequisition = new ProductTransferRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = productTransferRequisition.GetProductTransferRequisitionsApprovalListByTransferTypeFromAndTo(transferType, transferFrom, transferTo, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { productTransferRequisition = null; } }