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