public ActionResult Edit([Bind(Include = "ApplyId,CertificationID,StudentID,Comments,StatusID")] tbl_Apply tbl_Apply) { if (ModelState.IsValid) { db.Entry(tbl_Apply).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } List <SelectListItem> li = new List <SelectListItem> { new SelectListItem() { Text = "Request", Value = "1" }, new SelectListItem() { Text = "Approved", Value = "2" }, new SelectListItem() { Text = "Cancelled", Value = "3" } }; ViewBag.CertificationID = new SelectList(db.tbl_Certification, "CertificationID", "CertificationName", tbl_Apply.CertificationID); //ViewBag.StatusID = new SelectList(db.tbl_Status, "StatusID", "Status", tbl_Apply.StatusID); ViewBag.StatusID = new SelectList(li, "Value", "Text"); ViewBag.StudentID = new SelectList(db.tbl_Student, "StudentID", "FirstName", tbl_Apply.StudentID); return(View(tbl_Apply)); }
public ActionResult Details(int?id) { if (id == null) { return(View("Notfound")); } tbl_Apply tbl_Apply = db.tbl_Apply.Find(id); if (tbl_Apply == null) { return(View("Notfound")); } return(View(tbl_Apply)); }
public ActionResult Create([Bind(Include = "ApplyId,CertificationID,StudentID,Comments,StatusID")] tbl_Apply tbl_Apply) { if (ModelState.IsValid) { tbl_Apply.StatusID = 1; db.tbl_Apply.Add(tbl_Apply); db.SaveChanges(); return(Content("<html><body><script>alert('Applied successfully'); window.location.href = '/tbl_Apply/MyIndex';</script></body></html>")); } ViewBag.CertificationID = new SelectList(db.tbl_Certification, "CertificationID", "CertificationName", tbl_Apply.CertificationID); ViewBag.StatusID = new SelectList(db.tbl_Status, "StatusID", "Status", 1, tbl_Apply.tbl_Status.Status); ViewBag.StudentID = new SelectList(db.tbl_Student, "StudentID", "FirstName", tbl_Apply.StudentID); return(View(tbl_Apply)); }
public ActionResult DeleteConfirmed(int id) { tbl_Apply tbl_Apply = db.tbl_Apply.Find(id); db.tbl_Apply.Remove(tbl_Apply); db.SaveChanges(); int a = Convert.ToInt32(Session["UserID"]); if (a == 0) { return(RedirectToAction("MyIndex")); } else { return(RedirectToAction("Index")); } }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } tbl_Apply tbl_Apply = db.tbl_Apply.Find(id); if (tbl_Apply == null) { return(View("Notfound")); } ViewBag.CertificationID = new SelectList(db.tbl_Certification, "CertificationID", "CertificationName", tbl_Apply.CertificationID); ViewBag.StatusID = new SelectList(db.tbl_Status, "StatusID", "Status", tbl_Apply.StatusID); ViewBag.StudentID = new SelectList(db.tbl_Student, "StudentID", "FirstName", tbl_Apply.StudentID); return(View(tbl_Apply)); }
public ActionResult ApplyCertification(tbl_Apply u) { try { if (u.ApplyId != 0) { if (ModelState.IsValid) { tbl_Apply user = new tbl_Apply { ApplyId = u.ApplyId, CertificationID = u.CertificationID, StudentID = u.StudentID, StatusID = u.StatusID, }; Context.tbl_Apply.Add(user); Context.SaveChanges(); } else { return(View()); } } else { return(View()); } ViewBag.Message = "Successfully Added"; return(RedirectToAction("ApplysList")); } catch (Exception) { return(RedirectToAction("CertificationLis2")); } }