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