public DataTable GetPendingPurchaseOrdersListByWarehouse(string warehouseId)
{
PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseOrder.GetPendingPurchaseOrdersListByWarehouse(warehouseId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseOrder = null;
}
}
public DataTable GetPurchaseOrdersListByWarehouseDateRangeAndStatus(string warehouseId, string fromDate, string toDate, string status)
{
PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseOrder.GetPurchaseOrdersListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseOrder = null;
}
}
public string SavePurchaseOrder(List<PurchaseOrderBLL> purchaseOrders, string warehouseId, string narration)
{
PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
string purchaseOrderId = "";// purchaseOrder.SavePurchaseOrder(purchaseOrders, warehouseId, narration, db);
db.Stop();
return purchaseOrderId;
}
catch (Exception)
{
throw;
}
finally
{
purchaseOrder = null;
}
}
public void UpdatePurchaseOrderCancelPendingStatusById(string purchaseOrderId, string status)
{
PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseOrder.UpdatePurchaseOrderCancelPendingStatusById(purchaseOrderId, status, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
purchaseOrder = null;
}
}
public DataTable GetPurchaseOrderProductListById(string purchaseOrderId, string purchaseRequisitionId)
{
PurchaseOrderDAL purchaseOrder = new PurchaseOrderDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseOrder.GetPurchaseOrderProductListById(purchaseOrderId, purchaseRequisitionId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseOrder = null;
}
}