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; } }