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