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