public IActionResult UserList()
{
TempData["ResultMessage"] = "Admin";
String connection = _configuration.GetConnectionString("localDatabase");
var model = new List <AdminUserActivity>();
using (SqlConnection sqlconn = new SqlConnection(connection))
{
string sqlquery = "select AI.UserID, AI.Username, AI.Usermail, AR.Rolename from AccountInfo AI, UserRoles UR, AccountRoles AR where UR.UserID=AI.UserID AND AR.Roleid=UR.Roleid;";
using (SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlconn))
{
sqlconn.Open();
SqlDataReader reader = sqlcomm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var user = new AdminUserActivity();
user.UserID = (int)reader["UserID"];
user.Username = (string)reader["Username"];
user.Usermail = (string)reader["Usermail"];
user.Rolename = (string)reader["Rolename"];
model.Add(user);
}
reader.Close();
}
}
}
return(View(model));
}
public IActionResult UserActivity()
{
//Used to display pages accessible by admins on the top menu
TempData["ResultMessage"] = "Admin";
String connection = _configuration.GetConnectionString("localDatabase");
var model = new List <AdminUserActivity>();
using (SqlConnection sqlconn = new SqlConnection(connection))
{
string sqlquery = "select AI.UserID, AI.Username, AI.Usermail, AR.Rolename, AcS.LoginDate, AcS.IsLoggedIn from AccountInfo AI, AccountSessions AcS, UserRoles UR, AccountRoles AR where AI.UserID=AcS.UserID AND UR.UserID=AI.UserID AND AR.Roleid=UR.Roleid;";
using (SqlCommand sqlcomm = new SqlCommand(sqlquery, sqlconn))
{
sqlconn.Open();
SqlDataReader reader = sqlcomm.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
var user = new AdminUserActivity();
user.UserID = (int)reader["UserID"];
user.Username = (string)reader["Username"];
user.Usermail = (string)reader["Usermail"];
user.Rolename = (string)reader["Rolename"];
user.LoginDate = (DateTime)reader["LoginDate"];
user.IsLoggedIn = (int)reader["IsLoggedIn"];
model.Add(user);
}
reader.Close();
}
}
}
return(View(model));
}