public IEmployee saveEmployee(IEmployee employee)
{
if (!employee.isValid())
throw new ArgumentException("Please fill out all necessary information.");
if (employee.GetType() == typeof(Director)) {
Director d = (Director)employee;
DIRECTOR director = new DIRECTOR {
DIRECTOR_ID = d.ID,
START_DATE = d.StartDate,
END_DATE = null
};
return saveDirector(director);
}
if (employee.GetType() == typeof(GroupManager)) {
GroupManager m = (GroupManager)employee;
GROUP_MANAGER manager = new GROUP_MANAGER {
MANAGER_ID = m.ID,
GROUP_ID = (Int16)m.GroupID,
DIRECTOR_ID = m.DirectorID,
START_DATE = m.StartDate,
END_DATE = null
};
return saveManager(manager);
} else {
Employee e = (Employee)employee;
EMPLOYEE emp = new EMPLOYEE {
EMPLOYEE_ID = e.ID,
GROUP_MANAGER_START = e.GroupManagerID,
START_DATE = e.StartDate,
END_DATE = null
};
return saveUser(emp);
}
}
public Employee saveEmployee(Employee employee)
{
MainFactory.getLogSvc().logAction("Save new Employee - " + employee.ID + " into console.");
EMPLOYEE e = new EMPLOYEE {
EMPLOYEE_ID = employee.ID,
START_DATE = employee.StartDate,
GROUP_MANAGER_START = employee.GroupManagerID
};
try {
using (ConsoleDataContext db = (ConsoleDataContext)MainFactory.getDb("Consxole", false)) {
db.EMPLOYEEs.InsertOnSubmit(e);
db.SubmitChanges();
return employee;
}
} catch (SqlException se) {
MainFactory.getLogSvc().logError(this.GetType().Name,
MainFactory.getCurrentMethod(),
"rs-se-01",
se.Message + "\n" + se.StackTrace);
throw new Exception("Unable to create Employee. Please see error log for further details.");
}
}
private IEmployee saveUser(EMPLOYEE employee)
{
try {
using (ConsoleDataContext db = (ConsoleDataContext)MainFactory.getDb("Console", false)) {
db.EMPLOYEEs.InsertOnSubmit(employee);
db.SubmitChanges();
return new Employee(employee.EMPLOYEE_ID,
employee.START_DATE,
employee.END_DATE,
employee.GROUP_MANAGER_START);
}
} catch (SqlException se) {
if (se.Number == 2627) // if exception is due to primary key violation.
throw new ArgumentException("The employee already has a new record for today. Please update that record.");
MainFactory.getLogSvc().logError(this.GetType().Name,
MainFactory.getCurrentMethod(),
"esid-su-01",
se.Message + "\n" + se.StackTrace);
}
throw new ArgumentException("Unable to insert employee. Please validate information and try again.");
}
partial void DeleteEMPLOYEE(EMPLOYEE instance);
partial void UpdateEMPLOYEE(EMPLOYEE instance);
partial void InsertEMPLOYEE(EMPLOYEE instance);
private void detach_EMPLOYEEs(EMPLOYEE entity)
{
this.SendPropertyChanging();
entity.GROUP_MANAGER = null;
}
