public ActionResult PostNewMark(MarksVM post)
{
using (var ctx = new CSEntities())
{
ctx.AddNewMark(post.Course.FirstOrDefault(), post.StudentID, post.Mark, post.Date.FirstOrDefault().ToString(), post.Teacher);
return(RedirectToAction("Marks", "Home"));
}
}
public ActionResult Marks()
{
MarksVM model = new MarksVM();
using (var ctx = new CSEntities())
{
int UserIDint = Int32.Parse(Session["ID"].ToString());
var UserRole = from p in ctx.People where p.ID == UserIDint
select p.RoleID;
string UserIDstring = Session["ID"].ToString();
if (UserRole.FirstOrDefault().ToString() == "3" || UserRole.FirstOrDefault().ToString() == "4")
{
model.MarksByUser = ctx.MarksByUser(UserIDint).ToList();
}
else
{
model.MarksList = (from t in ctx.MarkLists select t).ToList();
}
model.Teacher = Session["LNAME"].ToString();
model.TeacherID = Int32.Parse(Session["ID"].ToString());
model.Course = (from c in ctx.Courses
join ct in ctx.CourseTeachers on c.ID equals ct.CourseID
join t in ctx.Teachers on ct.TeacherID equals t.ID
join p in ctx.People on t.PersonID equals p.ID
where p.ID == model.TeacherID && c.Closed == false
select c.Name).ToList();
model.Date = (from cs in ctx.ClassSchedules
join t in ctx.Teachers on cs.TeacherID equals t.ID
join p in ctx.People on t.PersonID equals p.ID
where p.ID == model.TeacherID
select cs.StartTime).ToList();
}
return(View(model));
}
