public DataTable GetPurchaseRequisitionById(string purchaseRequisitionId)
{
PurchaseRequisitionDAL purchaseRequisition = new PurchaseRequisitionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRequisition.GetPurchaseRequisitionById(purchaseRequisitionId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRequisition = null;
}
}
public DataTable GetPurchaseRequisitionsListByWarehouseDateRangeAndStatus(string warehouseId, string fromDate, string toDate, string status)
{
PurchaseRequisitionDAL purchaseRequisition = new PurchaseRequisitionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRequisition.GetPurchaseRequisitionsListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRequisition = null;
}
}
public string SavePurchaseRequisition(List<PurchaseRequisitionBLL> purchaseRequisitions, string warehouseId, string narration)
{
PurchaseRequisitionDAL purchaseRequisition = new PurchaseRequisitionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
string purchaseRequisitionId = purchaseRequisition.SavePurchaseRequisition(purchaseRequisitions, warehouseId, narration, db);
db.Stop();
return purchaseRequisitionId;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRequisition = null;
}
}
public string ApprovePurchaseRequisitionAndCreatePurchaseOrder(DataTable dt, string purchaseRequisitionId, string warehouseId)
{
PurchaseRequisitionDAL purchaseRequisition = new PurchaseRequisitionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
string msg = purchaseRequisition.ApprovePurchaseRequisitionAndCreatePurchaseOrder(dt, purchaseRequisitionId, warehouseId, db);
db.Stop();
return msg;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRequisition = null;
}
}
public DataTable GetPurchaseRequisitionsApprovalListByWarehouse(string warehouseId)
{
PurchaseRequisitionDAL purchaseRequisition = new PurchaseRequisitionDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRequisition.GetPurchaseRequisitionsApprovalListByWarehouse(warehouseId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRequisition = null;
}
}
