public GroupManager saveGroupManager(int groupID, int managerID, int directorID) { MainFactory.getLogSvc().logAction("Save new GroupManager - " + managerID + " into console."); GROUP_MANAGER gm = new GROUP_MANAGER { GROUP_ID = (short)groupID, MANAGER_ID = managerID, DIRECTOR_ID = directorID, START_DATE = DateTime.Today }; UserMgr userMgr = new UserMgr(MainFactory.getUserSvc()); GroupManager groupManager; try { using (ConsoleDataContext db = (ConsoleDataContext)MainFactory.getDb("Console", false)) { db.GROUP_MANAGERs.InsertOnSubmit(gm); db.SubmitChanges(); groupManager = new GroupManager(userMgr.getUser(managerID), gm.DIRECTOR_ID, gm.START_DATE, gm.END_DATE, gm.GROUP_ID, gm.GROUP_MANAGER_START, getGroupName(gm.GROUP_ID)); } } catch (SqlException se) { MainFactory.getLogSvc().logError(this.GetType().Name, MainFactory.getCurrentMethod(), "esid-sgm-01", se.Message + "\n" + se.StackTrace); throw new Exception("Unable to create Group Manager. Please see error log for further details."); } return groupManager; }
private IEmployee saveManager(GROUP_MANAGER manager) { try { using (ConsoleDataContext db = (ConsoleDataContext)MainFactory.getDb("Console", false)) { db.GROUP_MANAGERs.InsertOnSubmit(manager); db.SubmitChanges(); return new GroupManager(manager.MANAGER_ID, manager.DIRECTOR_ID, manager.START_DATE, manager.END_DATE, manager.GROUP_ID); } } catch (SqlException se) { if (se.Number == 2627) // if exception is due to primary key violation. throw new ArgumentException("The manager already has a new record for today. Please update that record."); MainFactory.getLogSvc().logError(this.GetType().Name, MainFactory.getCurrentMethod(), "esid-sm-01", se.Message + "\n" + se.StackTrace); } throw new ArgumentException("Unable to insert manager. Please validate information and try again."); }
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); } }
private void detach_GROUP_MANAGERs(GROUP_MANAGER entity) { this.SendPropertyChanging(); entity.GROUP_lkp = null; }
partial void DeleteGROUP_MANAGER(GROUP_MANAGER instance);
partial void UpdateGROUP_MANAGER(GROUP_MANAGER instance);
partial void InsertGROUP_MANAGER(GROUP_MANAGER instance);
private void attach_GROUP_MANAGERs(GROUP_MANAGER entity) { this.SendPropertyChanging(); entity.DIRECTOR = this; }