public int DeleteDemandOrder(DemandOrderDTO dto) { int iResult = -1; Database db = null; try { CheckBeforeDelete(dto); db = Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); DemandOrderDAO daoOrder = new DemandOrderDAO(db); iResult = daoOrder.DeleteOrder(null, dto); db.Commit(); } catch (Exception) { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } return(iResult); }
public void SaveData(DemandOrderDTO dtoOrder, List <TmpDemandOrderDTO> dtoItems) { Database db = null; try { db = Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); TmpDemandOrderDAO daoTmpOrder = new TmpDemandOrderDAO(db); DemandOrderDAO daoOrder = new DemandOrderDAO(db); //add all record to temp table daoTmpOrder.DeleteTempDemandOrder(null, dtoOrder); foreach (TmpDemandOrderDTO dto in dtoItems) { daoTmpOrder.InsertTempDemandOrder(null, dto); } //set all record to in-active and update data for item in table daoOrder.DeleteOrder(null, dtoOrder); daoOrder.UpdateOrder(null, dtoOrder); //delete data in tmp daoTmpOrder.DeleteTempDemandOrder(null, dtoOrder); db.Commit(); } catch (Exception) { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
public DataTable LoadSourceOrderSummaryEachMonth(GenerateMRPDTO dto) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadSourceOrderSummaryEachMonth(null, dto, Common.CurrentUserInfomation.DateFormat.ToString())); }
public DataTable LoadDemandOrderInRange(NZDateTime nZDateTimeBegin, NZDateTime nZDateTimeEnd) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadDemandOrderInRange(null, nZDateTimeBegin, nZDateTimeEnd)); }
public DataTable LoadDemandOrderSummary(DemandOrderDTO dto) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadDemandOrderSummary(null, dto.YEAR_MONTH, dto.CUSTOMER_CD)); }
public bool IsHoliday(DateTime dtmPERIOD, DateTime dtmDATE) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.IsHoliday(null, dtmPERIOD, dtmDATE)); }
public bool IsExists(DemandOrderDTO dto) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.ExistsByHeader(null, dto.YEAR_MONTH, dto.CUSTOMER_CD)); }
public List <DemandOrderDTO> LoadDemandOrder(DemandOrderDTO dto) { DemandOrderDAO dao = new DemandOrderDAO(CommonLib.Common.CurrentDatabase); return(dao.LoadDemandOrder(null, dto.YEAR_MONTH, dto.CUSTOMER_CD)); }