public ActionResult PromoteUnPromoteStudent(FormCollection collection) { List <int> studentids = new List <int>(); string[] keys = collection.AllKeys; foreach (var name in keys) { if (name.Contains("name")) { string idname = name; string[] valueids = idname.Split(' '); studentids.Add(Convert.ToInt32(valueids[1])); } } foreach (int studentid in studentids) { var student = db.StudentTables.Find(studentid); var promotesemesterid = db.ProgrammeSemestersTables.Where(p => p.ProgrammeID == student.ProgrammeID).FirstOrDefault(); var promotestudent = new StudentPromoteTable(); promotestudent.IsActive = true; promotestudent.ProgrammeSemesterID = promotesemesterid.ProgrammeSemesterID; promotestudent.StudentID = studentid; db.StudentPromoteTables.Add(promotestudent); db.SaveChanges(); } Session["Message"] = "Student promoted successfully"; return(RedirectToAction("UnPromoteStudent")); }
public ActionResult DeleteConfirmed(int id) { StudentPromoteTable studentPromoteTable = db.StudentPromoteTables.Find(id); db.StudentPromoteTables.Remove(studentPromoteTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "StudentPromoteID,StudentID,ProgrammeSemesterID,IsActive")] StudentPromoteTable studentPromoteTable) { if (ModelState.IsValid) { db.Entry(studentPromoteTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProgrammeSemesterID = new SelectList(db.ProgrammeSemestersTables, "ProgrammeSemesterID", "Description", studentPromoteTable.ProgrammeSemesterID); ViewBag.StudentID = new SelectList(db.StudentTables, "StudentID", "Name", studentPromoteTable.StudentID); return(View(studentPromoteTable)); }
// GET: StudentPromoteTables/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentPromoteTable studentPromoteTable = db.StudentPromoteTables.Find(id); if (studentPromoteTable == null) { return(HttpNotFound()); } return(View(studentPromoteTable)); }
// GET: StudentPromoteTables/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } StudentPromoteTable studentPromoteTable = db.StudentPromoteTables.Find(id); if (studentPromoteTable == null) { return(HttpNotFound()); } ViewBag.ProgrammeSemesterID = new SelectList(db.ProgrammeSemestersTables, "ProgrammeSemesterID", "Description", studentPromoteTable.ProgrammeSemesterID); ViewBag.StudentID = new SelectList(db.StudentTables, "StudentID", "Name", studentPromoteTable.StudentID); return(View(studentPromoteTable)); }
public ActionResult PromoteAllStudent(FormCollection collection) { List <int> studentids = new List <int>(); string[] keys = collection.AllKeys; foreach (var name in keys) { if (name.Contains("name")) { string idname = name; string[] valueids = idname.Split(' '); studentids.Add(Convert.ToInt32(valueids[1])); } } foreach (int studentid in studentids) { var student = db.StudentTables.Find(studentid); var studentcurrentsemester = db.StudentPromoteTables.Where(s => s.IsActive == true && s.StudentID == studentid).FirstOrDefault(); var promotestudent = new StudentPromoteTable(); promotestudent.IsActive = true; var programsemester = db.ProgrammeSemestersTables.Where(p => p.ProgrammeSemesterID > studentcurrentsemester.ProgrammeSemesterID && p.ProgrammeID == student.ProgrammeID).FirstOrDefault(); if (programsemester == null) { Session["Message"] = "program semester completed (last semester)"; return(RedirectToAction("PromoteStudent")); } promotestudent.ProgrammeSemesterID = db.ProgrammeSemestersTables.Where(p => p.ProgrammeSemesterID > studentcurrentsemester.ProgrammeSemesterID && p.ProgrammeID == student.ProgrammeID).FirstOrDefault().ProgrammeSemesterID; promotestudent.StudentID = studentid; db.StudentPromoteTables.Add(promotestudent); db.SaveChanges(); studentcurrentsemester.IsActive = false; db.Entry(studentcurrentsemester).State = EntityState.Modified; db.SaveChanges(); } Session["Message"] = "Student promoted successfully"; return(RedirectToAction("PromoteStudent")); }