public ActionResult UnPromoteStudent(int SessionID, int DepartmentID, int ProgrammeID) { if (SessionID == 0 || DepartmentID == 0 || ProgrammeID == 0) { Session["Message"] = "Please fill fields"; return(View(new List <StudentPromoteMV>())); } List <StudentPromoteMV> list = new List <StudentPromoteMV>(); var studentlist = db.StudentTables.Where(s => s.SessionID == SessionID && s.DepartmentID == DepartmentID && s.ProgrammeID == ProgrammeID).ToList(); foreach (var item in studentlist) { var find = db.StudentPromoteTables.Where(p => p.StudentID == item.StudentID).FirstOrDefault(); if (find == null) { var studentpromote = new StudentPromoteMV(); var student = db.StudentTables.Find(item.StudentID); studentpromote.StudentID = item.StudentID; studentpromote.StudentName = student.Name; studentpromote.Reg_No = student.Reg_No; studentpromote.Enroll_No = student.Enroll_No; list.Add(studentpromote); } } return(View(list)); }
public ActionResult PromoteStudent(int SessionID, int DepartmentID, int ProgrammeID, int CurrentSemesterID) { if (SessionID == 0 || DepartmentID == 0 || ProgrammeID == 0 || CurrentSemesterID == 0) { Session["Message"] = "Please fill fields"; return(View(new List <StudentPromoteMV>())); } List <StudentPromoteMV> list = new List <StudentPromoteMV>(); var studentlist = db.StudentPromoteTables.Where(p => p.ProgrammeSemesterID == CurrentSemesterID && p.IsActive == true).ToList(); foreach (var item in studentlist) { var studentpromote = new StudentPromoteMV(); var student = db.StudentTables.Find(item.StudentID); studentpromote.StudentID = item.StudentID; studentpromote.StudentName = student.Name; studentpromote.Reg_No = student.Reg_No; studentpromote.Enroll_No = student.Enroll_No; studentpromote.IsActive = item.IsActive; studentpromote.ProgrammeSemesterID = item.ProgrammeSemesterID; list.Add(studentpromote); } return(View(list)); }