public ActionResult AddDepartment()
{
ScheduleManager manager = new ScheduleManager();
var model = new DepartmentAddEditModel();
ViewBag.QuarterList = manager.GetHPQuarterList();
return View(model);
}
public ActionResult AddDepartment(DepartmentAddEditModel entity)
{
ScheduleManager manager = new ScheduleManager();
if (manager.AddNewDepartment(entity))
{
return RedirectToAction("ManageDepartments");
}
else
{
var model = entity;
return View(model);
}
}
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 DepartmentAddEditModel GetDepartmentForEdit(int id)
{
DepartmentAddEditModel result = new DepartmentAddEditModel();
using (ScheduleDataContext ctx = new ScheduleDataContext())
{
try
{
var item = ctx.Departments.Where(s=>s.DepartmentID == id).SingleOrDefault<Department>();
result.DepartmentID = item.DepartmentID;
result.Name = item.Name;
result.UrlName = item.UrlFriendlyName;
result.EffectiveYearQuarterBegin = item.EffectiveYearQuarterBegin;
result.EffectiveYearQuarterEnd = item.EffectiveYearQuarterEnd;
result.Contact = item.Contact;
result.Description = item.Description;
}
catch (Exception ex)
{
throw new SystemException("Cannot get department. " + 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;
}
