public DataTable GetPurchaseRecordById(string purchaseRecordId)
{
PurchaseToWHDAL purchaseRecord = new PurchaseToWHDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRecord.GetPurchaseRecordById(purchaseRecordId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}
public DataTable GetPurchaseRecordsListByWarehouseDateRangeAndStatus(string warehouseId, string fromDate, string toDate, string status)
{
PurchaseToWHDAL purchaseRecord = new PurchaseToWHDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRecord.GetPurchaseRecordsListByWarehouseDateRangeAndStatus(warehouseId, fromDate, toDate, status, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}
public string SavePurchaseRecord(DataTable dtPrdList)
{
PurchaseToWHDAL purchaseRecord = new PurchaseToWHDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start(true);
string Id = purchaseRecord.SavePurchaseRecord(this, dtPrdList, db);
db.Stop();
return Id;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
dtPrdList = null;
}
}
public bool rejectPurchaseRecord(string warehouseId, string purchaseRecordId)
{
PurchaseToWHDAL purchaseRecord = new PurchaseToWHDAL();
bool st = false;
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
st= purchaseRecord.rejectPurchaseRecord(warehouseId, purchaseRecordId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
return st;
}
public void ApprovePurchaseRecord(string warehouseId, string purchaseRecordId)
{
PurchaseToWHDAL purchaseRecord = new PurchaseToWHDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
purchaseRecord.ApprovePurchaseRecord(warehouseId, purchaseRecordId, db);
db.Stop();
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}
public DataTable GetPurchaseRecordsApprovalListByWarehouse(string warehouseId)
{
PurchaseToWHDAL purchaseRecord = new PurchaseToWHDAL();
try
{
LumexDBPlayer db = LumexDBPlayer.Start();
DataTable dt = purchaseRecord.GetPurchaseRecordsApprovalListByWarehouse(warehouseId, db);
db.Stop();
return dt;
}
catch (Exception)
{
throw;
}
finally
{
purchaseRecord = null;
}
}
