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