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));
}
