public void SimulateMRP(ProcessDTO dtoProcess, GenerateMRPDTO dtoGen) { Database db = null; try { db = Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); ProcessDAO dao = new ProcessDAO(db); dao.SimulateMRP(null, dtoProcess.PROCESS_NO, dtoGen); db.Commit(); } catch (Exception) { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
public void UpdateFinishTime(ProcessDTO dto) { Database db = null; try { CheckBeforeSave(); db = Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(IsolationLevel.Serializable); ProcessDAO dao = new ProcessDAO(db); dao.UpdateFinishProcess(null, dto); db.Commit(); } catch (Exception) { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
private void LoadProcessesIntoCmb() { var processDAO = new ProcessDAO(); var processes = processDAO.Processes(); foreach (var process in processes) { cmbProcesses.Items.Add(process.Name); } }
public bool CheckNameNotBeingUsed(string name) { var processDAO = new ProcessDAO(); var process = processDAO.Processes().FirstOrDefault(x => x.Name == name); if (process == null) { return(true); } throw new NameBeingUsedException(); }
private void btnRegister_Click(object sender, EventArgs e) { try { var process = new Process(txtName.Text, dtpStartDate.Value, dtpEndDate.Value); var processDAO = new ProcessDAO(); processDAO.Add(process); MessageBox.Show("Process saved"); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public ProcessDTO LoadLastProcess(string strPROCESS_TYPE) { ProcessDAO dao = new ProcessDAO(Common.CurrentDatabase); return(dao.LoadLastProcess(null, strPROCESS_TYPE)); }