public bool AddPrefixToDepartment(DepartmentPrefixItem entity) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { DepartmentPrefix misc = new DepartmentPrefix(); misc.DepartmentID = entity.DepartmentId; misc.Prefix = entity.PrefixText; ctx.DepartmentPrefixes.InsertOnSubmit(misc); try { ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to add prefix: " + ex.Message); } } return result; }
public bool EditDepartment(DepartmentAddEditModel entity) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { var dept = ctx.Departments.Where(d => d.DepartmentID == entity.DepartmentID).SingleOrDefault<Department>(); if (entity.Description == "" || entity.Description == null) { entity.Description = " "; } dept.Contact = entity.Contact; dept.Description = entity.Description; dept.EffectiveYearQuarterBegin = entity.EffectiveYearQuarterBegin; dept.EffectiveYearQuarterEnd = entity.EffectiveYearQuarterEnd; dept.Name = entity.Name; dept.UrlFriendlyName = entity.UrlName; try { ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to add Department: " + ex.Message); } } return result; }
public bool RemoveMiscSortCodeEntry(int id) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { DepartmentMiscSort item = ctx.DepartmentMiscSorts.Where(m => m.DepartmentMiscSortId == id).SingleOrDefault<DepartmentMiscSort>(); try { ctx.DepartmentMiscSorts.DeleteOnSubmit(item); ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to remove Misc Sort Code: " + ex.Message); } } return result; }
public bool RemoveDisplayQuarter(int displayQuarterID) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { DisplayQuarter quarter = ctx.DisplayQuarters.Where(d => d.DisplayQuarterID == displayQuarterID).SingleOrDefault<DisplayQuarter>(); ctx.DisplayQuarters.DeleteOnSubmit(quarter); try { ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to remove Display Quarter: " + ex.Message); } } return result; }
public bool AddNewMiscSortCodeInclude(DepartmentMiscSortItem entity) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { DepartmentMiscSort misc = new DepartmentMiscSort(); misc.IncludeFilter = false; misc.MiscSortValue = entity.MiscSortText; misc.DepartmentID = entity.DepartmentId; ctx.DepartmentMiscSorts.InsertOnSubmit(misc); try { ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to add Misc Sort Value: " + ex.Message); } } return result; }
public bool AddNewDisplayQuarter(QuarterItemModel entity) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { DisplayQuarter quarter = new DisplayQuarter(); quarter.Title = entity.Title; quarter.UrlName = entity.UrlName; quarter.YearQuarterID = entity.YearQuarterID; ctx.DisplayQuarters.InsertOnSubmit(quarter); try { ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to add Display Quarter: " + ex.Message); } } return result; }
public bool AddNewDepartment(DepartmentAddEditModel entity) { bool result = false; using (ScheduleDataContext ctx = new ScheduleDataContext()) { Department dept = new Department(); if (entity.Description == "") { entity.Description = " "; } dept.Contact = entity.Contact; dept.Description = entity.Description; dept.EffectiveYearQuarterBegin = entity.EffectiveYearQuarterBegin; dept.EffectiveYearQuarterEnd = entity.EffectiveYearQuarterEnd; dept.Name = entity.Name; dept.UrlFriendlyName = entity.UrlName; ctx.Departments.InsertOnSubmit(dept); try { ctx.SubmitChanges(); result = true; } catch (Exception ex) { throw new Exception("Unable to add Department: " + ex.Message); } } return result; }