public ViewResult SubmitForm([Bind] SchoolProject.Models.Form.Student form) { Student st = new Student(); st.student_id = form.student_id; st.lastname = form.lastname; st.firstname = form.firstname; st.middlename = form.middlename; st.program = form.program; st.status = form.status; st.academic_year = form.academic_year; st.yearlevel = form.yearlevel; st.username = form.username; st.password = form.password; st.sem = form.sem; st.birthday = form.birthday; _context.student.Add(st); int rec = _context.SaveChanges(); if (rec == 1) { IQueryable <Admin_User> admin = from s in _context.admin_user select s; IQueryable <Professor> profe = from s in _context.professor select s; IQueryable <Programs> prog = from s in _context.program select s; IQueryable <Student> stud = from s in _context.student select s; IQueryable <Subject> subj = from s in _context.subject select s; IQueryable <Parent_User> par = from s in _context.parent_user select s; ViewBag.parent_user = par; ViewBag.subject = subj; ViewBag.student = stud; ViewBag.admin_user = admin; ViewBag.professor = profe; ViewBag.programs = prog; return(View()); } else { return(View("Error")); } }
public ViewResult SubmitForm([Bind] SchoolProject.Models.Form.Student form) { var user = _context.student .Where(u => u.username == form.username && u.password == form.password) .FirstOrDefault(); if (user == null) { ViewBag.error = "Login error!"; return(View("InitForm")); } else { var studid = _context.student .Where(u => u.username == form.username) .Select(u => u.student_id) .FirstOrDefault(); httpContext.Session.SetString("username", form.username); httpContext.Session.SetInt32("uid", studid); return(View()); } }