public static TblTeacherDto ToDto(this TblTeacher entity) { if (entity == null) { return(new TblTeacherDto()); } return(new TblTeacherDto { TeacherId = entity.TeacherId, TeacherBirthday = entity.TeacherBirthday, TeacherName = entity.TeacherName, TeacherNum = entity.TeacherNum, TeacherPassword = entity.TeacherPassword, TeacherSex = entity.TeacherSex, TeacherTitle = entity.TeacherTitle, DeptNum = entity.DeptNum, CreateTime = entity.CreateTime, CreatedBy = entity.CreatedBy, ModifyBy = entity.ModifyBy, ModifyTime = entity.ModifyTime, DeleteBy = entity.DeleteBy, DeleteTime = entity.DeleteTime, IsDeleted = entity.IsDeleted, Version = entity.Version }); }
public ActionResult Edit([Bind(Include = "TeacherId,SchoolId,TeacherCode,UserId,TeacherName,TeacherAddress,TeacherEmail,TeacherContactNr,TeacherStartDate,TeacherEndDate")] TblTeacher tblTeacher) { if (ModelState.IsValid) { db.Entry(tblTeacher).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SchoolId = new SelectList(db.TblSchools.Where(a => a.SchoolId == tblTeacher.SchoolId), "SchoolId", "SchoolCode", tblTeacher.SchoolId); return(View(tblTeacher)); }
public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TblTeacher tblTeacher = db.TblTeachers.Find(id); if (tblTeacher == null) { return(HttpNotFound()); } return(View(tblTeacher)); }
public ActionResult DeleteConfirmed(int id) { TblTeacher tblTeacher = db.TblTeachers.Find(id); var learners = db.TblLearners.Where(a => a.TeacherId == tblTeacher.TeacherId); if (learners.Any()) { TempData["DelFail"] = "You cannot delete a Teacher that has Learners linked to."; return(RedirectToAction("Index")); } db.TblTeachers.Remove(tblTeacher); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit(TblTeacher teacher, string Answers) { db.Entry(teacher).State = System.Data.Entity.EntityState.Modified; db.Entry(teacher).Property(e => e.CreateBy).IsModified = false; db.Entry(teacher).Property(e => e.CreateDate).IsModified = false; teacher.ModifyBy = FullName; teacher.ModifyDate = DateTime.Now; if (Answers == Constants.AnswerType.Yes) { teacher.IsAdmin = true; } else { teacher.IsAdmin = false; } db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "TeacherId,SchoolId,TeacherCode,UserId,TeacherName,TeacherAddress,TeacherEmail,TeacherContactNr,TeacherStartDate,TeacherEndDate")] TblTeacher tblTeacher) { TblUser tblUser = new TblUser(); if (ModelState.IsValid) { db.TblTeachers.Add(tblTeacher); db.SaveChanges(); tblUser.SchoolId = tblTeacher.SchoolId; tblUser.UserName = tblTeacher.TeacherName; tblUser.UserAccessTypeId = 4; tblUser.EmailAddress = tblTeacher.TeacherEmail; tblUser.IsUserVerified = false; tblUser.UserStartDate = tblTeacher.TeacherStartDate; tblUser.UserEndDate = tblTeacher.TeacherEndDate; db.TblUsers.Add(tblUser); db.SaveChanges(); var Schl = db.TblSchools.Find(tblTeacher.SchoolId); var code = Schl != null ? Schl.SchoolCode : ""; SendVerificationEmail(tblUser.EmailAddress, code); tblTeacher.UserId = tblUser.UserId; db.Entry(tblTeacher).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.SchoolId = new SelectList(db.TblSchools.Where(a => a.SchoolId == tblTeacher.SchoolId), "SchoolId", "SchoolCode", tblTeacher.SchoolId); return(View(tblTeacher)); }
public ActionResult Create(TblTeacher teacher, string Answers) { if (teacher.FullName != null) { teacher.CreateDate = DateTime.Now; teacher.CreateBy = FullName; if (Answers == Constants.AnswerType.Yes) { teacher.IsAdmin = true; } else { teacher.IsAdmin = false; } db.TblTeacher.Add(teacher); db.SaveChanges(); return(RedirectToAction("Index")); } else { return(View()); } }
// GET: TCHR/Teachers/Edit/5 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)); } TblTeacher tblTeacher = db.TblTeachers.Find(id); if (tblTeacher == null) { return(HttpNotFound()); } ViewBag.School = new SelectList(db.TblSchools.Where(a => a.SchoolId == school), "SchoolId", "SchoolCode", tblTeacher.SchoolId); ViewBag.SchoolId = tblTeacher.SchoolId; return(View(tblTeacher)); }