public async Task <ActionResult> Create([Bind(Include = "Id,MinimumGrade,MaximumGrade,Remark,ClassName")] PrincipalCommentVm model) { if (ModelState.IsValid) { foreach (var item in model.ClassName) { var myGrade = await Db.PrincipalComments.CountAsync(x => x.MaximumGrade.Equals(model.MaximumGrade) && x.MinimumGrade.Equals(model.MinimumGrade) && x.ClassName.Equals(item)); if (myGrade >= 1) { TempData["UserMessage"] = "Principal Comment Already Exist in Database."; TempData["Title"] = "Error."; ViewBag.ClassName = new SelectList(Db.SchoolClasses, "ClassCode", "ClassCode"); return(View(model)); } var principalComment = new PrincipalComment() { MaximumGrade = model.MaximumGrade, MinimumGrade = model.MinimumGrade, Remark = model.Remark, ClassName = item }; Db.PrincipalComments.Add(principalComment); } await Db.SaveChangesAsync(); ViewBag.ClassName = new SelectList(Db.SchoolClasses.AsNoTracking(), "ClassCode", "ClassCode"); TempData["UserMessage"] = "Principal Comment Added Successfully."; TempData["Title"] = "Success."; return(RedirectToAction("Index")); } return(View(model)); }
public async Task <ActionResult> DeleteConfirmed(int id) { PrincipalComment principalComment = await Db.PrincipalComments.FindAsync(id); if (principalComment != null) { Db.PrincipalComments.Remove(principalComment); } await Db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "Id,MinimumGrade,MaximumGrade,Remark,ClassName")] PrincipalComment principalComment) { if (ModelState.IsValid) { Db.Entry(principalComment).State = EntityState.Modified; await Db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.ClassName = new SelectList(Db.SchoolClasses.AsNoTracking(), "ClassCode", "ClassCode"); return(View(principalComment)); }
// GET: PrincipalComments/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PrincipalComment principalComment = await Db.PrincipalComments.FindAsync(id); if (principalComment == null) { return(HttpNotFound()); } return(View(principalComment)); }
// GET: PrincipalComments/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PrincipalComment principalComment = await Db.PrincipalComments.FindAsync(id); if (principalComment == null) { return(HttpNotFound()); } ViewBag.ClassName = new SelectList(Db.SchoolClasses.AsNoTracking(), "ClassCode", "ClassCode"); return(View(principalComment)); }