public ActionResult Edit(FacultyCertificateM_M universityCertificateM_M) { if (ModelState.IsValid) { var data = db.FacultyCertificateM_M.Where(a => a.Id != universityCertificateM_M.Id); foreach (var item in data) { if (item.CertificateId == universityCertificateM_M.CertificateId && item.FacultyId == universityCertificateM_M.FacultyId) { ViewBag.errorMessage = "this certificate is already exsits in this university"; ViewBag.CertificateId = new SelectList(db.Certificates.Where(a => a.Is_Deleted != true), "Id", "CirtificateTypeName", universityCertificateM_M.CertificateId); ViewBag.FacultyId = new SelectList(db.Faculties.Where(a => a.Is_Dleted != true), "Id", "UniversityName", universityCertificateM_M.FacultyId); return(View(universityCertificateM_M)); } } var old = db.FacultyCertificateM_M.Find(universityCertificateM_M.Id); old.FacultyId = universityCertificateM_M.FacultyId; old.CertificateId = universityCertificateM_M.CertificateId; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CertificateId = new SelectList(db.Certificates.Where(a => a.Is_Deleted != true), "Id", "CirtificateTypeName", universityCertificateM_M.CertificateId); ViewBag.FacultyId = new SelectList(db.Faculties.Where(a => a.Is_Dleted != true), "Id", "UniversityName", universityCertificateM_M.FacultyId); return(View(universityCertificateM_M)); }
public ActionResult DeleteConfirmed(int id) { FacultyCertificateM_M universityCertificateM_M = db.FacultyCertificateM_M.Find(id); universityCertificateM_M.Is_deleted = true; db.SaveChanges(); return(RedirectToAction("Index")); }
// GET: UniversityCertificateM_M/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(RedirectToAction("errorpage", "home")); } FacultyCertificateM_M universityCertificateM_M = db.FacultyCertificateM_M.Find(id); if (universityCertificateM_M == null) { return(RedirectToAction("errorpage", "home")); } return(View(universityCertificateM_M)); }
// GET: UniversityCertificateM_M/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(RedirectToAction("errorpage", "home")); } FacultyCertificateM_M universityCertificateM_M = db.FacultyCertificateM_M.Find(id); if (universityCertificateM_M == null) { return(RedirectToAction("errorpage", "home")); } ViewBag.CertificateId = new SelectList(db.Certificates.Where(a => a.Is_Deleted != true), "Id", "CirtificateTypeName", universityCertificateM_M.CertificateId); ViewBag.FacultyId = new SelectList(db.Faculties.Where(a => a.Is_Dleted != true), "Id", "UniversityName", universityCertificateM_M.FacultyId); return(View(universityCertificateM_M)); }
public ActionResult Create(FacultyCertificateM_M universityCertificateM_M) { if (ModelState.IsValid) { var data = db.FacultyCertificateM_M.Where(a => a.Is_deleted != true && a.FacultyId == universityCertificateM_M.FacultyId && a.CertificateId == universityCertificateM_M.CertificateId).SingleOrDefault(); if (data != null) { ViewBag.errorMessage = "this certificate is already exsits in this university"; ViewBag.CertificateId = new SelectList(db.Certificates.Where(a => a.Is_Deleted != true), "Id", "CirtificateTypeName", universityCertificateM_M.CertificateId); ViewBag.FacultyId = new SelectList(db.Faculties.Where(a => a.Is_Dleted != true), "Id", "UniversityName", universityCertificateM_M.FacultyId); return(View(universityCertificateM_M)); } db.FacultyCertificateM_M.Add(universityCertificateM_M); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.CertificateId = new SelectList(db.Certificates.Where(a => a.Is_Deleted != true), "Id", "CirtificateTypeName", universityCertificateM_M.CertificateId); ViewBag.facultyId = new SelectList(db.Faculties.Where(a => a.Is_Dleted != true), "Id", "UniversityName", universityCertificateM_M.FacultyId); return(View(universityCertificateM_M)); }