public ActionResult Create([Bind(Include = "LearnerId,TeacherId,SchoolId,LearnerCode,LearnerName,LearnerAddress,LearnerEmail,LearnerContactNr,LearnerStartDate,LearnerEndDate")] TblLearner tblLearner)
{
if (ModelState.IsValid)
{
db.TblLearners.Add(tblLearner);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SchoolId = new SelectList(db.TblSchools.Where(a => a.SchoolId == tblLearner.SchoolId), "SchoolId", "SchoolCode", tblLearner.SchoolId);
ViewBag.TeacherId = new SelectList(db.TblTeachers.Where(a => a.SchoolId == tblLearner.SchoolId), "TeacherId", "TeacherCode", tblLearner.TeacherId);
return(View(tblLearner));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TblLearner tblLearner = db.TblLearners.Find(id);
if (tblLearner == null)
{
return(HttpNotFound());
}
return(View(tblLearner));
}
public ActionResult DeleteConfirmed(int id)
{
TblLearner tblLearner = db.TblLearners.Find(id);
var guardians = db.TblGuardians.Where(a => a.LearnerId == tblLearner.LearnerId);
if (guardians.Any())
{
TempData["DelFail"] = "You cannot delete a Learner that has a Guardian linked to.";
return(RedirectToAction("Index"));
}
db.TblLearners.Remove(tblLearner);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(int?id)
{
Uri currentUrl = Request.UrlReferrer;
if (currentUrl == null)
{
return(HttpNotFound());
}
HttpCookie usesrCookie = Request.Cookies["UserInformation"];
if (usesrCookie == null)
{
return(RedirectToAction("LoginHomeIndex", "PCMSLogin"));
}
int?school = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[1]);
//Get UserID
int?userID = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]);
if (db.TblUsers.Find(userID) != null)
{
ViewBag.UserName = db.TblUsers.Find(userID).UserName;
}
else if (db.TblSystemAdmins.Find(userID) != null)
{
ViewBag.UserName = "******";
}
else
{
ViewBag.UserName = "";
}
bool check = false;
int userId = Int32.Parse(pcmsLoginController.LoggedOnUserData(usesrCookie)[3]);
if (userId == db.TblSystemAdmins.FirstOrDefault().UserId)
{
check = true;
}
ViewBag.PCMS = check;
var School = db.TblSchools.Find(school);
if (School != null)
{
ViewBag.SchoolCode = School.SchoolCode;
ViewBag.SchoolName = School.SchoolName;
}
else
{
ViewBag.SchoolCode = null;
ViewBag.SchoolName = null;
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TblLearner tblLearner = db.TblLearners.Find(id);
if (tblLearner == null)
{
return(HttpNotFound());
}
ViewBag.School = new SelectList(db.TblSchools.Where(a => a.SchoolId == school), "SchoolId", "SchoolCode", tblLearner.SchoolId);
ViewBag.SchoolId = tblLearner.SchoolId;
ViewBag.TeacherId = new SelectList(db.TblTeachers.Where(a => a.SchoolId == school), "TeacherId", "TeacherCode", tblLearner.TeacherId);
return(View(tblLearner));
}
