public List <getAllUserAndRoles> getAllUsersAndRoles()
{
//---- Create object of our entities class.
try
{
LoanViewModel lvm = new LoanViewModel();
var user = "******";
users.Email = user;
users.id = DataReaders.selectUserID(users);
var results = (from a in db.UserRoles
join c in db.Roles on a.RoleId equals c.RoleId
join b in db.Users on a.UserId equals b.id
//where a.UserId == users.id
select new Models.getAllUserAndRoles {
userid = b.id, roleid = c.RoleId, rolename = c.RoleName, email = b.Email, id = a.id
}).ToList();
var model = new LoanViewModel
{
getAllUserAndRoless = results.ToList(),
};
lvm.getAllUserAndRoless = results;
return(lvm.getAllUserAndRoless.ToList());
}
catch (Exception ex)
{
WebLog.Log(ex.Message.ToString());
return(null);
}
}
