public ActionResult DeleteConfirmed(int id) { MarkSheetTable markSheetTable = db.MarkSheetTables.Find(id); db.MarkSheetTables.Remove(markSheetTable); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult MarkSheetSubmit(FormCollection collection) { try { List <int> studentids = new List <int>(); string[] keys = collection.AllKeys; string ssubjectid = collection["SubjectID"]; if (ssubjectid == "0") { Session["Message"] = "Please select subject"; return(RedirectToAction("MarkSheet")); } int SubjectID = int.Parse(ssubjectid); int ProgrammeSemesterID = db.SubjectSemesterTables.Find(SubjectID).ProgrammeSemesterID; string[] studentidlist = collection.GetValues("item.StudentID"); string[] midtermmarks = collection.GetValues("item.ObtainMidTermMarks"); string[] finaltermmarks = collection.GetValues("item.ObtainFinalTermMarks"); List <MarkSheetTable> markslist = new List <MarkSheetTable>(); for (int i = 0; i < studentidlist.Length; i++) { var stdmarks = new MarkSheetTable(); stdmarks.StudentID = Convert.ToInt32(studentidlist[i]); stdmarks.ObtainMidTermMarks = Convert.ToInt32(midtermmarks[i]); stdmarks.ObtainFinalTermMarks = Convert.ToInt32(finaltermmarks[i]); stdmarks.SubjectSemesterID = SubjectID; stdmarks.ProgrammeSemesterID = ProgrammeSemesterID; markslist.Add(stdmarks); } foreach (MarkSheetTable item in markslist) { var findsubjectmarks = db.MarkSheetTables.Where(m => m.StudentID == item.StudentID && m.SubjectSemesterID == item.SubjectSemesterID && m.ProgrammeSemesterID == item.ProgrammeSemesterID).FirstOrDefault(); if (findsubjectmarks != null) { findsubjectmarks.ObtainMidTermMarks = item.ObtainMidTermMarks; findsubjectmarks.ObtainFinalTermMarks = item.ObtainFinalTermMarks; db.Entry(findsubjectmarks).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } else { db.MarkSheetTables.Add(item); db.SaveChanges(); } } Session["Message"] = "Mark sheet submit successfully"; } catch { Session["Message"] = "Please try again some problem"; } return(RedirectToAction("MarkSheet")); }
public ActionResult Edit(MarkSheetTable markSheetTable) { if (ModelState.IsValid) { db.Entry(markSheetTable).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.ProgrammeSemesterID = new SelectList(db.ProgrammeSemestersTables, "ProgrammeSemesterID", "Description", markSheetTable.ProgrammeSemesterID); ViewBag.StudentID = new SelectList(db.StudentTables, "StudentID", "Name", markSheetTable.StudentID); ViewBag.StudentID = new SelectList(GetSemesterSubject(), "SubjectSemesterID", "Name", markSheetTable.SubjectSemesterID); return(View(markSheetTable)); }
// GET: MarkSheetTables/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MarkSheetTable markSheetTable = db.MarkSheetTables.Find(id); if (markSheetTable == null) { return(HttpNotFound()); } return(View(markSheetTable)); }
// GET: MarkSheetTables/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MarkSheetTable markSheetTable = db.MarkSheetTables.Find(id); if (markSheetTable == null) { return(HttpNotFound()); } ViewBag.ProgrammeSemesterID = new SelectList(db.ProgrammeSemestersTables, "ProgrammeSemesterID", "Description", markSheetTable.ProgrammeSemesterID); ViewBag.StudentID = new SelectList(db.StudentTables, "StudentID", "Name", markSheetTable.StudentID); ViewBag.StudentID = new SelectList(GetSemesterSubject(), "SubjectSemesterID", "Name", markSheetTable.SubjectSemesterID); return(View(markSheetTable)); }