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