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