public async Task <ActionResult> Login(LoginViewModel model, string returnUrl)
{
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ExternalCookie);
if (!ModelState.IsValid)
{
return(View(model));
}
// This doesn't count login failures towards account lockout
// To enable password failures to trigger account lockout, change to shouldLockout: true
var result = await SignInManager.PasswordSignInAsync(model.Email, model.Password, model.RememberMe, shouldLockout : false);
switch (result)
{
case SignInStatus.Success:
if (!UserManager.IsInRole(UserManager.FindByEmail(model.Email).Id, "Admin"))
{
RNSITEntities db = new RNSITEntities();
string departmentId = model.Email.Substring(0, model.Email.IndexOf('@'));
TempData["Department"] = db.DEPTs.Where(x => x.DeptId.Trim().ToLower() == departmentId).First().DeptId;
}
return(RedirectToLocal(returnUrl));
case SignInStatus.LockedOut:
return(View("Lockout"));
case SignInStatus.RequiresVerification:
return(RedirectToAction("SendCode", new { ReturnUrl = returnUrl, RememberMe = model.RememberMe }));
case SignInStatus.Failure:
default:
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
}
public Page <STUDENT> FilterStudent(int PageSize, int CurrentPage, string SearchText, int SortBy, string Department)
{
/*
* PageSize - no. of records
* CurrentPage - Page no.
* SearchText - Student Name only
* SortBy - drop down for section (value returned=1) sem(2) USN(3)
* Department - dropdown department name. (value returned should be dept name)
*/
Page <STUDENT> students;
var filters = new Filters <STUDENT>();
filters.Add(!string.IsNullOrEmpty(SearchText), x => x.NAME.Contains(SearchText));
filters.Add(!string.IsNullOrEmpty(SearchText), x => x.DEPT.DeptName.Equals(Department));
var sorts = new Sorts <STUDENT>();
sorts.Add(SortBy == 1, x => x.Section, true);
sorts.Add(SortBy == 2, x => x.Sem, true);
sorts.Add(SortBy == 3, x => x.USN, true);
using (var Context = new RNSITEntities())
{
students = Context.STUDENTs.Paginate(CurrentPage, PageSize, sorts, filters);
}
return(students);
}
public ActionResult SectionList(string Sem)
{
var db = new RNSITEntities();
string DeptId = ((string)TempData.Peek("Department")).ToUpper();
IQueryable Sec = db.spGetSection(DeptId, int.Parse(Sem)).AsQueryable();
if (HttpContext.Request.IsAjaxRequest())
{
return(Json(new SelectList(Sec, "ID", "Value"), JsonRequestBehavior.AllowGet));
}
return(View(Sec));
}
public ActionResult PrintSubjectCombinations()
{
RNSITEntities db = new RNSITEntities();
string department = (string)TempData.Peek("Department");
if (User.IsInRole("Admin"))
{
var subCombs = db.SubCombs;
return(View(subCombs.ToList()));
}
else
{
var subCombs = db.SubCombs.Where(x => x.DeptId == department);
return(View(subCombs.ToList()));
}
}
public JsonResult GetSem(string name)
{
var db = new RNSITEntities();
//name = ((string)TempData.Peek("Department")).ToUpper();
List <SelectListItem> Semester = new List <SelectListItem>();
List <spGetSem_Result> l = db.spGetSem(name).ToList();
foreach (var s in l)
{
Semester.Add(new SelectListItem {
Text = s.ID.ToString().Trim(), Value = s.Value.ToString().Trim()
});
}
return(Json(Semester, JsonRequestBehavior.AllowGet));
}
public ActionResult ViewClassDetails(string Semester, string Section)
{
if (Semester == null || Section == null || Semester == "0" || Section == "0")
{
ModelState.AddModelError(string.Empty, "Please provide all the details");
return(View());
}
var db = new RNSITEntities();
string Department = ((string)TempData.Peek("Department")).ToUpper();
StudentTeacherRetrival studentDetails = new StudentTeacherRetrival();
studentDetails.USN = db.spGetStudentsInClass(Department, int.Parse(Semester), Section).First().USN;
var details = db.GetTeacherDetailsByUSN(studentDetails.USN);
Session["Check"] = true;
return(View("StudentDetailsFirstPage"));
}
public void CreateRolesAndUsers()
{
ApplicationDbContext context = new ApplicationDbContext();
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
if (!roleManager.RoleExists("Clerk"))
{
var role = new IdentityRole();
role.Name = "Clerk";
roleManager.Create(role);
}
if (!roleManager.RoleExists("Hod"))
{
var role = new IdentityRole();
role.Name = "Hod";
roleManager.Create(role);
}
if (!roleManager.RoleExists("Admin"))
{
var role = new IdentityRole();
role.Name = "Admin";
roleManager.Create(role);
}
RNSITEntities db = new RNSITEntities();
List <DEPT> departmentList = db.DEPTs.ToList();
foreach (var department in departmentList)
{
var userName = department.DeptId.ToLower().Trim() + "@rnsit.ac.in";
if (UserManager.FindByEmail(userName) == null)
{
var user = new ApplicationUser();
user.UserName = userName;
user.Email = userName;
string userPWD = "P@ssw0rd@" + department.DeptId.ToLower().Trim();
var chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
UserManager.AddToRole(user.Id, "Clerk");
}
department.Password = userPWD;
userName = department.DeptId.ToLower().Trim() + "@hod.rnsit.ac.in";
user = new ApplicationUser();
user.UserName = userName;
user.Email = userName;
userPWD = "P@ssw0rd@" + department.DeptId.ToLower().Trim();
chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
UserManager.AddToRole(user.Id, "Hod");
}
department.HodPassword = userPWD;
db.DEPTs.Attach(department);
db.Entry(department).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
}
}