// 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)); }