protected void Page_Load(object sender, EventArgs e) { if (Session["uid"] == null && Session["email"] == null) { //Response.WriteFile("login.aspx"); Response.Redirect("login.aspx"); } else { uid = Convert.ToInt32(Session["uid"]); email = Session["email"].ToString(); // dt = tq.getTable("SELECT users_tb.uid,users_tb.fname,users_tb.lname,messages_tb.* FROM users_tb ,messages_tb WHERE messages_tb.sid=" + uid + " AND messages_tb.sid=users_tb.uid AND messages_tb.delete_status=0 AND messages_tb.archive_status=0 AND messages_tb.trash_status=0 ORDER BY messages_tb.date_time DESC"); if (dt.Rows.Count != 0) { GridView2.DataSource = dt; GridView2.DataBind(); } } talk2it t2i = new talk2it(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=0 AND trash_status=0 AND delete_status=0"); msg_in.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE sid=" + Session["uid"]); msg_sent.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=1"); msg_archive.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND trash_status=1"); msg_trash.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["uid"] == null && Session["email"] == null) { //Response.WriteFile("login.aspx"); Response.Redirect("login.aspx"); } else { uid = Convert.ToInt32(Session["uid"]); email = Session["email"].ToString(); // if (!IsPostBack) { load_data(); } } talk2it t2i = new talk2it(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + "AND archive_status=0 AND trash_status=0 AND delete_status=0"); msg_in.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE sid=" + Session["uid"]); msg_sent.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=1"); msg_archive.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND trash_status=1"); msg_trash.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); }
public void load_data() { dt = tq.getTable("SELECT * FROM users_tb WHERE status=0"); if (dt.Rows.Count != 0) { GridView2.DataSource = dt; GridView2.DataBind(); } }
protected void Button1_Click(object sender, EventArgs e) { talk2it tq = new talk2it(); DataTable dt = tq.getTable("SELECT uid,status FROM users_tb WHERE email='" + email.Text + "' AND password='******' AND isBlocked='false'"); if (dt.Rows.Count == 0) { notify.Text = "Please signup to login"; notify.ForeColor = System.Drawing.Color.Red; //notify.BackColor = System.Drawing.Color.Red; } else { if (dt.Rows[0].ItemArray.GetValue(1).ToString() == "1") { Session["uid"] = dt.Rows[0].ItemArray.GetValue(0).ToString(); Session["email"] = email.Text; Response.Redirect("admin_home.aspx"); } else { Session["uid"] = dt.Rows[0].ItemArray.GetValue(0).ToString(); Session["email"] = email.Text; Response.Redirect("home.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["uid"] == null && Session["email"] == null) { Response.Redirect("login.aspx"); } else { uidd = Session["uid"].ToString(); bind_image(); /* string[] filePaths = Directory.GetFiles(Server.MapPath("images/user/")); * List<ListItem> files = new List<ListItem>(); * foreach (string filePath in filePaths) * { * string fileName = Path.GetFileName(filePath); * files.Add(new ListItem(fileName, "images/user/" + fileName)); * } * GridView1.DataSource = files; * GridView1.DataBind();*/ talk2it t2i = new talk2it(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=0 AND trash_status=0 AND delete_status=0"); msg_in.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE sid=" + Session["uid"]); msg_sent.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=1"); msg_archive.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND trash_status=1"); msg_trash.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); int uid = Convert.ToInt32(Session["uid"]); string email = Session["email"].ToString(); } dt = tq.getTable("SELECT * FROM users_tb "); if (dt.Rows.Count != 0) { string name = dt.Columns[1].ToString() + " " + dt.Columns[2].ToString(); string gender = dt.Columns[6].ToString(); string image = dt.Columns[7].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (Session["uid"] == null && Session["email"] == null) { //Response.WriteFile("login.aspx"); Response.Redirect("login.aspx"); } else { uid = Convert.ToInt32(Session["uid"]); // Response.Write(_localTime); dt = tq.getTable("SELECT friends_tb.f_list,users_tb.fname FROM friends_tb,users_tb WHERE uid=" + uid + " AND fid=" + uid); if (dt.Rows.Count != 0) { string list = dt.Rows[0].ToString(); //dt= tq.getTable("SELECT * FROM users_tb WHERE fname<>"+dt.Rows[1]+" AND isActive=1 AND uid IN ("+list+");"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["uid"] == null && Session["email"] == null) { Response.Redirect("login.aspx"); } else { int uid = Convert.ToInt32(Session["uid"]); string email = Session["email"].ToString(); dt = it.getTable("select * from friends_tb where fid=" + uid); if (dt == null) { Label5.Text = "You Have No Friends..."; } else { string flist = dt.Rows[3].ToString(); Response.Write(flist); } } }
protected void Page_Load(object sender, EventArgs e) { bind_image(); /* string[] filePaths = Directory.GetFiles(Server.MapPath("images/user/")); * List<ListItem> files = new List<ListItem>(); * foreach (string filePath in filePaths) * { * string fileName = Path.GetFileName(filePath); * files.Add(new ListItem(fileName, "images/user/" + fileName)); * } * GridView1.DataSource = files; * GridView1.DataBind();*/ talk2it t2i = new talk2it(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=0 AND trash_status=0 AND delete_status=0"); msg_in.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE sid=" + Session["uid"]); msg_sent.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND archive_status=1"); msg_archive.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); dt = new DataTable(); dt = t2i.getTable("SELECT count(*) FROM messages_tb WHERE rid=" + Session["uid"] + " AND trash_status=1"); msg_trash.Text = dt.Rows[0].ItemArray.GetValue(0).ToString(); if (Session["uid"] == null && Session["email"] == null) { Response.Redirect("login.aspx"); } else { int uid = Convert.ToInt32(Session["uid"]); string email = Session["email"].ToString(); //Response.Write(uid); int f = 0, s = 0, r = 0; dt = tq.getTable("SELECT f_list,r_receive,r_send FROM friends_tb WHERE fid=" + uid); if (dt.Rows.Count != 0) { if (Convert.ToInt32(dt.Rows[0]) == uid) { string[] separators = { "," }; string value = dt.Rows[0].ToString(); string[] words = value.Split(separators, StringSplitOptions.RemoveEmptyEntries); foreach (var word in words) { f = f + 1; } } //Console.WriteLine(word); } //int f_req=r-f; } dt = tq.getTable("SELECT * FROM users_tb "); if (dt.Rows.Count != 0) { string name = dt.Columns[1].ToString() + " " + dt.Columns[2].ToString(); string gender = dt.Columns[6].ToString(); string image = dt.Columns[7].ToString(); } }