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