public DataTable GetProductRequisitionById(string purchaseRequisitionId) { ProductRequisitionDAL productRequisition = new ProductRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = productRequisition.GetProductRequisitionById(purchaseRequisitionId, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { productRequisition = null; } }
public DataTable GetProductRequisitionsListBySalesCenterDateRangeAndStatus(string salesCenterId, string fromDate, string toDate, string status,string reqType) { ProductRequisitionDAL productRequisition = new ProductRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = productRequisition.GetProductRequisitionsListBySalesCenterDateRangeAndStatus(salesCenterId, fromDate, toDate, status,reqType, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { productRequisition = null; } }
public string SaveProductRequisition(List<ProductRequisitionBLL> productRequisitions, string salesCenterId, string warehouseid, string requisationType, string narration) { ProductRequisitionDAL productRequisition = new ProductRequisitionDAL(); WarehouseBLL salesCenter = new WarehouseBLL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); string productRequisitionId = productRequisition.SaveProductRequisition(productRequisitions, salesCenterId, warehouseid, requisationType, narration, db); db.Stop(); return productRequisitionId; } catch (Exception) { throw; } finally { productRequisition = null; } }
public string ApproveTransferRequisitionAndCreateTransferOrder(DataTable dt, string productRequisitionId, string transferFrom, string transferTo, string transferType) { ProductRequisitionDAL productRequisition = new ProductRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(true); string msg = productRequisition.ApproveTransferRequisitionAndCreateTransferOrder(dt, productRequisitionId, transferFrom, transferTo, transferType, db); db.Stop(); return msg; } catch (Exception) { throw; } finally { productRequisition = null; } }
public DataTable GetProductRequisitionsApprovalListBySalesCenter(string salesCenterId,string reqType) { ProductRequisitionDAL productRequisition = new ProductRequisitionDAL(); try { LumexDBPlayer db = LumexDBPlayer.Start(); DataTable dt = productRequisition.GetProductRequisitionsApprovalListBySalesCenter(salesCenterId,reqType, db); db.Stop(); return dt; } catch (Exception) { throw; } finally { productRequisition = null; } }