// GET: HomeQA public ActionResult HomeQA() { ViewBag.admin = 0; if (globalVariable.loggedin) { ViewBag.loggedin = true; ViewBag.username = globalVariable.username; ViewBag.admin = globalVariable.admin; ViewBag.rating = globalVariable.rating; } connectionString(); con.Open(); com.Connection = con; if (!globalVariable.searchreq) { com.CommandText = "SELECT * FROM qa q, user_t u WHERE q.U_id=u.U_id ORDER BY q.Qa_id DESC"; } else { com.CommandText = "SELECT * FROM qa q, user_t u WHERE q.U_id=u.U_id AND q.Qa_title LIKE '%" + globalVariable.search + "%' ORDER BY q.Qa_id DESC"; } dr = com.ExecuteReader(); var model = new List <qaModel>(); while (dr.Read()) { var qa = new qaModel(); qa.Qa_id = Convert.ToInt32(dr["Qa_id"]); qa.U_id = Convert.ToInt32(dr["U_id"]); qa.Username = Convert.ToString(dr["Username"]); qa.Qa_title = Convert.ToString(dr["Qa_title"]); qa.Qa_body = Convert.ToString(dr["Qa_body"]); qa.qaLike = qr.isLike(qa.Qa_id); qa.qaDislike = qr.isDislike(qa.Qa_id); qa.qalikeCount = qr.likeCount(qa.Qa_id); qa.qadislikeCount = qr.dislikeCount(qa.Qa_id); qa.commentCount = vp.countQAComment(qa.Qa_id); model.Add(qa); } //msg count var m = new qaModel(); MessageController ms = new MessageController(); m.msgCount = ms.msgCount(); model.Add(m); globalVariable.searchreq = false; con.Close(); return(View(model)); }
// 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: HomeVid public ActionResult HomeVid() { if (globalVariable.loggedin) { ViewBag.loggedin = true; ViewBag.username = globalVariable.username; ViewBag.admin = globalVariable.admin; ViewBag.rating = globalVariable.rating; } connectionString(); con.Open(); com.Connection = con; if (!globalVariable.searchreq) { com.CommandText = "SELECT * FROM video v, user_t u WHERE v.U_id=u.U_id ORDER BY v.Vid_id DESC"; } else { com.CommandText = "SELECT * FROM video v, user_t u WHERE v.U_id=u.U_id AND v.Vid_title LIKE '%" + globalVariable.search + "%'ORDER BY v.Vid_id DESC"; } dr = com.ExecuteReader(); var model = new List <VideoModel>(); while (dr.Read()) { var vid = new VideoModel(); vid.Vid_id = Convert.ToInt32(dr["Vid_id"]); vid.U_id = Convert.ToInt32(dr["U_id"]); vid.Username = Convert.ToString(dr["Username"]); vid.Vid_title = Convert.ToString(dr["Vid_title"]); vid.Vid_body = Convert.ToString(dr["Vid_body"]); vid.vidLike = vr.isLike(vid.Vid_id); vid.vidDislike = vr.isDislike(vid.Vid_id); vid.vidlikeCount = vr.likeCount(vid.Vid_id); vid.viddislikeCount = vr.dislikeCount(vid.Vid_id); vid.commentCount = vv.countVidComment(vid.Vid_id); model.Add(vid); } con.Close(); //msg count var m = new VideoModel(); MessageController ms = new MessageController(); m.msgCount = ms.msgCount(); model.Add(m); globalVariable.searchreq = false; return(View(model)); }
// GET: AdminPanel public ActionResult AdminPanel() { if (globalVariable.loggedin) { ViewBag.loggedin = true; ViewBag.username = globalVariable.username; ViewBag.admin = globalVariable.admin; } var model = new List <adminModel>(); connectionString(); con.Open(); com.Connection = con; //user count com.CommandText = "SELECT COUNT (U_id) FROM user_t"; dr = com.ExecuteReader(); while (dr.Read()) { am.userCount = dr.GetInt32(0); } con.Close(); //qa count con.Open(); com.CommandText = "SELECT COUNT (Qa_id) FROM qa"; dr = com.ExecuteReader(); while (dr.Read()) { am.qaCount = dr.GetInt32(0); } con.Close(); //vid count con.Open(); com.CommandText = "SELECT COUNT (Vid_id) FROM video"; dr = com.ExecuteReader(); while (dr.Read()) { am.vidCount = dr.GetInt32(0); } con.Close(); //msg count MessageController ms = new MessageController(); am.msgCount = ms.msgCount(); model.Add(am); //admin con.Open(); com.CommandText = "SELECT * FROM user_t WHERE Admin_check = '1'"; dr = com.ExecuteReader(); while (dr.Read()) { adminModel adName = new adminModel(); adName.adminUser = Convert.ToString(dr["Username"]); model.Add(adName); } con.Close(); //ban con.Open(); com.CommandText = "SELECT * FROM user_t WHERE ban = '1'"; dr = com.ExecuteReader(); while (dr.Read()) { adminModel banName = new adminModel(); banName.bannedUser = Convert.ToString(dr["Username"]); model.Add(banName); } con.Close(); //tutor con.Open(); com.CommandText = "SELECT * FROM user_t WHERE Rating >= '500'"; dr = com.ExecuteReader(); while (dr.Read()) { adminModel tutorName = new adminModel(); tutorName.tutorUser = Convert.ToString(dr["Username"]); model.Add(tutorName); } con.Close(); return(View(model)); }