public void LoadPersonList(ContosoUnivContext dbContext, string selectedPerson = "")
{
selectedPerson ??= "";
var persons =
from person in dbContext.Person
join idPerson in dbContext.IdentityPerson on person.PersonId equals idPerson.PersonId
into identityPersonTbl
from idPerson2 in identityPersonTbl.DefaultIfEmpty()
where idPerson2 == null
select new
{
Id = person.PersonId,
person.FirstName,
person.LastName,
person.Discriminator
};
PersonList = persons
.Select(person => new SelectListItem
{
Value = person.Id.ToString(),
Text = person.LastName + ", " + person.FirstName + " ( " + person.Discriminator + " )",
Selected = person.Id.ToString() == selectedPerson
})
.OrderBy(o => o.Text)
.ToList();
}
public void LoadCourseInfo(ContosoUnivContext dbContext)
{
var personInfoList =
from person in dbContext.Person
join idperson in dbContext.IdentityPerson on person.PersonId equals idperson.PersonId
join aspuser in dbContext.AspNetUsers on idperson.IdentityId equals aspuser.Id
where aspuser.UserName == this.Username
select new { person.PersonId, person.FirstName, person.LastName };
var personInfo = personInfoList.Any() ? personInfoList.First() : null;
if (personInfo != null)
{
FullName = $"{personInfo.FirstName} {personInfo.LastName}";
var courseInfoList =
from crsInst in dbContext.CourseInstructor
join crs in dbContext.Course on crsInst.CourseId equals crs.CourseId
join dept in dbContext.Department on crs.DepartmentId equals dept.DepartmentId
where crsInst.PersonId == personInfo.PersonId
select new CourseInfo
{
CourseName = crs.Title,
Department = dept.Name,
NumCredits = crs.Credits.ToString()
};
CourseList = courseInfoList.OrderBy(o => o.CourseName).ToList();
}
}
public void CreateGradeList(ContosoUnivContext dbContext)
{
using ( dbContext )
{
var personInfoList =
from person in dbContext.Person
join idperson in dbContext.IdentityPerson on person.PersonId equals idperson.PersonId
join aspuser in dbContext.AspNetUsers on idperson.IdentityId equals aspuser.Id
where aspuser.UserName == this.Username
select new { person.PersonId, person.FirstName, person.LastName };
var personInfo = personInfoList.Any() ? personInfoList.First() : null;
if (personInfo != null)
{
FullName = $"{personInfo.FirstName} {personInfo.LastName}";
var grades =
from grade in dbContext.StudentGrade
join person in dbContext.Person on grade.StudentId equals person.PersonId
join course in dbContext.Course on grade.CourseId equals course.CourseId
where person.PersonId == personInfo.PersonId
select new GradeInfo
{
CourseName = course.Title,
Grade = grade.Grade.ToString()
};
GradeList = grades.OrderBy(o => o.CourseName).ToList();
}
}
}
public void LoadUserList(ContosoUnivContext dbContext)
{
var userList =
from userRole in dbContext.AspNetUserRoles
join user in dbContext.AspNetUsers on userRole.UserId equals user.Id
where userRole.RoleId == Id
select user.UserName;
UserList = userList.OrderBy(o => o).ToList();
}
public void LoadRoleInfo(ContosoUnivContext dbContext)
{
RoleInfoList = dbContext.AspNetRoles
.Select(role => new RoleInfo
{
Id = role.Id,
RoleName = role.Name,
NumUsers = role.AspNetUserRoles.Count
})
.OrderBy(o => o.RoleName)
.ToList();
}
public void LoadRoleList(ContosoUnivContext dbContext, string selectedRoles)
{
selectedRoles ??= "";
var selectedRoleList = selectedRoles.Split(new char[] { ';' });
var roles = dbContext.AspNetRoles.Select(role => role.Name).ToList();
RoleList = roles
.Select(role => new SelectListItem
{
Value = role,
Text = role,
Selected = selectedRoleList.Contains(role)
})
.OrderBy(o => o.Text)
.ToList();
}
public HomeController(ILogger <HomeController> logger, ContosoUnivContext dbContext)
{
_logger = logger;
}
public void LoadPermitList(ContosoUnivContext dbContext)
{
var permitList = dbContext.AspNetRoleClaims.Where(rc => rc.RoleId == Id).Select(rc2 => rc2.ClaimType);
PermitList = permitList.OrderBy(o => o).ToList();
}
public RoleController(ContosoUnivContext dbContext, RoleManager <IdentityRole> roleManager)
{
_dbContext = dbContext;
_roleManager = roleManager;
}
public void LoadDetails(ContosoUnivContext dbContext)
{
Name = dbContext.AspNetRoles.Find(Id).Name;
LoadUserList(dbContext);
LoadPermitList(dbContext);
}
public StudentController(ContosoUnivContext dbContext)
{
_dbContext = dbContext;
}
public InstructorController(ContosoUnivContext dbContext)
{
_dbContext = dbContext;
}
public ViewCoursesModel(ContosoUnivContext dbContext)
{
_dbContext = dbContext;
}
public DeleteModel(RoleManager <IdentityRole> roleManager, ContosoUnivContext dbContext)
{
_roleManager = roleManager;
_dbContext = dbContext;
}
public IndexModel(ContosoUnivContext dbContext)
{
_dbContext = dbContext;
}
public UserController(ContosoUnivContext dbContext, UserManager <IdentityUser> userManager)
{
_dbContext = dbContext;
_userManager = userManager;
}
public CreateModel(UserManager <IdentityUser> userManager, ContosoUnivContext dbContext)
{
_userManager = userManager;
_dbContext = dbContext;
}
public ViewGradesModel(ContosoUnivContext dbContext)
{
_dbContext = dbContext;
}
public DetailsModel(ContosoUnivContext dbContext)
{
_dbContext = dbContext;
}
