// GET: Parents/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var parent = _db.Parents.Find(id);
if (parent == null)
{
return(HttpNotFound());
}
var deleteParent = new AddEditParentViewModel
{
Id = parent.Id,
MotherFather = parent.MotherFather,
FirstName = parent.FirstName,
Address = parent.Address,
HomePhone = parent.HomePhone,
CellPhone = parent.CellPhone,
Email = parent.Email
};
var students = _db.Students.Where(s => s.Parent.Id == parent.Id).ToList();
if (students.Count > 0)
{
deleteParent.ErrorMessage = "This will result in the permanant deletion of student(s) ";
var firstStudent = true;
foreach (var student in students)
{
if (firstStudent == false)
{
deleteParent.ErrorMessage += " AND ";
}
deleteParent.ErrorMessage += student.FirstName;
firstStudent = false;
}
deleteParent.ErrorMessage += " AND all their reports and session notes!";
}
return(View(deleteParent));
}
public ActionResult Create([Bind(Include = "MotherFather,FirstName,Address,HomePhone,CellPhone,Email,SelectedMotherFather,CaseManagerUser")] AddEditParentViewModel model)
{
if (ModelState.IsValid)
{
var parent = _db.Parents.Create();
parent.MotherFather = model.SelectedMotherFather;
parent.FirstName = model.FirstName;
parent.Email = model.Email;
parent.Address = model.Address;
parent.HomePhone = model.HomePhone;
parent.CellPhone = model.CellPhone;
if (model.CaseManagerUser != null)
{
parent.CaseManagerUser = _db.Users.Find(model.CaseManagerUser.Id);
}
_db.Parents.Add(parent);
_db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(model));
}
// GET: Parents/Create
public ActionResult Create()
{
var viewModel = new AddEditParentViewModel {
SelectedMotherFather = "M"
}; // M is default
List <SelectListItem> staffList = new List <SelectListItem>();
var sortedUsers = _db.Users.OrderBy(u => u.LastName).ToList();
foreach (ApplicationUser user in sortedUsers)
{
if (Utilities.UserIsInRole(user.Id, "Staff"))
{
staffList.Add(new SelectListItem
{
Text = user.LastName + @", " + user.FirstName,
Value = user.Id
});
}
}
viewModel.StaffMembers = staffList;
return(View(viewModel));
}
public ActionResult Edit([Bind(Include = "Id,MotherFather,FirstName,Address,HomePhone,CellPhone,Email,SelectedMotherFather,CaseManagerUser")] AddEditParentViewModel viewModel)
{
if (ModelState.IsValid)
{
var parent = _db.Parents.Find(viewModel.Id);
if (parent != null)
{
parent.FirstName = viewModel.FirstName;
parent.Address = viewModel.Address;
parent.HomePhone = viewModel.HomePhone;
parent.CellPhone = viewModel.CellPhone;
parent.Email = viewModel.Email;
parent.MotherFather = viewModel.SelectedMotherFather;
if (string.IsNullOrEmpty(viewModel.CaseManagerUser.Id))
{
//parent.CaseManagerUser = null; // this statement is not peformed by Entity Framework
var sqlString = "UPDATE Parent Set CaseManagerUser_Id = NULL ";
sqlString += "WHERE Id =" + viewModel.Id;
using (var context = new SenecaContext())
{
context.Database.ExecuteSqlCommand(sqlString);
}
}
else
{
parent.CaseManagerUser =
(from u in _db.Users where u.Id == viewModel.CaseManagerUser.Id select u).Single();
}
_db.SaveChanges();
return(RedirectToAction("Index"));
}
}
return(View(viewModel));
}
// GET: Parents/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Parent parent = _db.Parents.Find(id);
if (parent == null)
{
return(HttpNotFound());
}
var viewModel = new AddEditParentViewModel
{
Id = parent.Id,
Address = parent.Address,
CellPhone = parent.CellPhone,
Email = parent.Email,
FirstName = parent.FirstName,
HomePhone = parent.HomePhone,
SelectedMotherFather = parent.MotherFather
};
List <SelectListItem> staffList = new List <SelectListItem>();
var sortedUsers = _db.Users.OrderBy(u => u.LastName).ThenBy(u => u.FirstName).ToList();
staffList.Add(new SelectListItem {
Text = @" (none)", Value = "", Selected = false
});
var staffRoleId = (from r in _db.Roles where (r.Name == "Staff") select r.Id).Single();
foreach (var user in sortedUsers)
{
foreach (var role in user.Roles)
{
if (role.RoleId == staffRoleId)
{
if (parent.CaseManagerUser == null)
{
staffList.Add(new SelectListItem {
Text = user.FirstName + @" " + user.LastName, Value = user.Id, Selected = false
});
}
else
{
if (user.Id == parent.CaseManagerUser.Id)
{
staffList.Add(new SelectListItem {
Text = user.FirstName + @" " + user.LastName, Value = user.Id, Selected = true
});
}
else
{
staffList.Add(new SelectListItem {
Text = user.FirstName + @" " + user.LastName, Value = user.Id, Selected = false
});
}
}
}
}
}
viewModel.StaffMembers = staffList;
return(View(viewModel));
}
