// GET: UserDetail
public ActionResult UserDetail()
{
if (globalVariable.loggedin)
{
ViewBag.loggedin = true;
ViewBag.username = globalVariable.username;
ViewBag.admin = globalVariable.admin;
}
connectionString();
con.Open();
com.Connection = con;
com.CommandText = "SELECT * FROM user_t";
dr = com.ExecuteReader();
var model = new List <userDetailModel>();
while (dr.Read())
{
var ud = new userDetailModel();
ud.uid = Convert.ToInt32(dr["U_id"]);
ud.username = Convert.ToString(dr["Username"]);
ud.email = Convert.ToString(dr["Email"]);
if (Convert.ToInt32(dr["Admin_check"]) == 1)
{
ud.access = "Admin Privilege";
}
else
{
ud.access = "Limited";
}
if (Convert.ToInt32(dr["ban"]) == 1)
{
ud.status = "Banned";
}
else
{
ud.status = "Active";
}
ud.rating = Convert.ToInt32(dr["Rating"]);
model.Add(ud);
}
con.Close();
//msg count
var m = new userDetailModel();
MessageController ms = new MessageController();
m.msgCount = ms.msgCount();
model.Add(m);
return(View(model));
}
// GET: ViewAccount
public ActionResult ViewAccount(int?uid)
{
connectionString();
con.Open();
com.Connection = con;
com.CommandText = "SELECT * FROM user_t WHERE U_id='" + uid + "'";
dr = com.ExecuteReader();
var model = new List <userDetailModel>();
while (dr.Read())
{
var ud = new userDetailModel();
ud.username = Convert.ToString(dr["Username"]);
ud.email = Convert.ToString(dr["Email"]);
ud.rating = Convert.ToInt32(dr["Rating"]);
ud.admin = Convert.ToInt32(dr["Admin_check"]);
model.Add(ud);
}
con.Close();
return(View(model));
}
