public ActionResult Login(Membership model)
{
using (var context = new SmSEntities())
{
bool AdminIsValid = context.AdminTBs.Any(x => x.Email == model.Email && x.Password == model.Password);
bool StudentIsValid = context.StudentTBs.Any(x => x.Email == model.Email && x.Password == model.Password);
bool TeacherIsValid = context.TeacherTBs.Any(x => x.Email == model.Email && x.Password == model.Password);
if (AdminIsValid)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
return(RedirectToAction("Index", "Home"));
}
else if (StudentIsValid)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
return(RedirectToAction("Index", "Home"));
}
else if (TeacherIsValid)
{
FormsAuthentication.SetAuthCookie(model.Email, false);
var name = db.TeacherTBs.Single(c => c.Email == model.Email).TeacherName;
return(RedirectToAction("Index", "Home"));
}
ModelState.AddModelError("", "Invalid Username or PAssword");
return(View());
}
}
public override string[] GetRolesForUser(string username)
{
using (var context = new SmSEntities())
{
if (context.AdminTBs.Any(x => x.Email == username))
{
var AdminResult = (from roleTB in context.RoleTBs
join adminTB in context.AdminTBs on roleTB.Id equals adminTB.RoleId
where adminTB.Email == username
select roleTB.Role).ToArray();
return(AdminResult);
}
if (context.StudentTBs.Any(x => x.Email == username))
{
var StudentResult = (from roleTB in context.RoleTBs
join studentTB in context.StudentTBs on roleTB.Id equals studentTB.RoleId
where studentTB.Email == username
select roleTB.Role).ToArray();
return(StudentResult);
}
if (context.TeacherTBs.Any(x => x.Email == username))
{
var TeacherResult = (from roleTB in context.RoleTBs
join teacherTB in context.TeacherTBs on roleTB.Id equals teacherTB.RoleId
where teacherTB.Email == username
select roleTB.Role).ToArray();
return(TeacherResult);
}
}
throw new NotImplementedException();
}
public ActionResult Show()
{
//ViewBag.RegNo = enrollCourseManager.GetSelectListItemsForDropdown();
SmSEntities db = new SmSEntities();
var user = User.Identity.Name;
var uid = db.StudentTBs.Single(c => c.Email == user).Id;
ViewBag.RegNo = enrollCourseManager.StudentResultByEmail(uid);
return(View());
}
public ActionResult CourseShowByStudent()
{
SmSEntities db = new SmSEntities();
var n = User.Identity.Name;
ViewBag.RegNo = (from e in db.EnrollCourseTBs
join s in db.StudentTBs on e.StudentId equals s.Id where s.Email == n
select new
{
Text = e.StudentTB.RegistrationNo,
Value = e.StudentId
}).Distinct().ToList();
//ViewBag.RegNo = enrollCourseManager.GetSelectListItemsForDropdown();
return(View());
}
