protected void Page_Load(object sender, EventArgs e)
{
if (Session["uname"] == null)
{
Response.Redirect("Login.aspx");
}
else
{
returnname nam12 = new returnname();
Label2.Text = nam12.id1(Session["uname"].ToString()).ToString();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
cn.Open();
string str = "select * from reg where Email='" + Session["uname"].ToString() + "'";
SqlCommand cmd = new SqlCommand(str, cn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Label1.Text = dr[1].ToString();
LinkButton12.Text = dr[1].ToString();
}
profilepic();
cn.Close();
fillpendingreq();
fillfriend();
fillpen();
fillpost();
follow();
notification();
body.Controls.Add(new LiteralControl("<script>$(document).ready(function(){$('[data-toggle='tooltip']').tooltip();});</script>"));
}
}
protected void Button2_Click(object sender, EventArgs e)
{
try
{
string pass = string.Empty;
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
cn.Open();
string str = "select * from reg where Email='" + TextBox3.Text + "'";
SqlCommand cmd = new SqlCommand(str, cn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
returnname r = new returnname();
pass = dr[12].ToString();
em.send_maill(r.name(TextBox3.Text), TextBox3.Text, 2, pass);
}
else if (TextBox3.Text == "")
{
alert1.Visible = true;
Label3.Text = "OOPs! Fields cannot be left blank";
}
else
{
alert1.Visible = true;
Label3.Text = "OOPs! Please check your E-mail";
}
cn.Close();
}
catch (Exception ew)
{
Label1.Text = ew.Message;
}
}
void fillfriend()
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from friend where (receiver='" + Session["uname"].ToString() + "'or sender='" + Session["uname"].ToString() + "') and status='1' order by dor desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
a = new ArrayList();
r = new returnname();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr[1].ToString() == Session["uname"].ToString())
{
a.Add(dr[2].ToString());
}
else
{
a.Add(dr[1].ToString());
}
}
foreach (object o in a)
{
LinkButton l = new LinkButton();
l.Text = o.ToString();
abc A = new abc();
int t = A.chkpicstat(o.ToString());
if (t == 0)
{
if (A.chkgender(o.ToString()))
{
friend.Controls.Add(new LiteralControl("<li><a href='#' data-toggle='tooltip' data-placement='bottom' title='" + r.name(o.ToString()) + "'><img src='temp/b.jpg' alt='Profile Pics' width='55' height='60'></a>"));
}
else
{
friend.Controls.Add(new LiteralControl("<li><a href='#' data-toggle='tooltip' data-placement='bottom' title='" + r.name(o.ToString()) + "'><img src='temp/g.jpg' alt='Profile Pics' width='55' height='60'></a>"));
}
}
else
{
friend.Controls.Add(new LiteralControl("<li><a href='#' data-toggle='tooltip' data-placement='bottom' title='" + r.name(o.ToString()) + "'><img src='Account/" + o.ToString() + "/p.jpg' alt='Profile Pics' width='55' height='60'></a>"));
}
friend.Controls.Add(new LiteralControl("</li>"));
}
cn.Close();
}
void fillpendingreq()
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from friend where receiver='" + Session["uname"].ToString() + "' and status='0' order by fid desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
r = new returnname();
foreach (DataRow dr in ds.Tables[0].Rows)
{
Label l = new Label();
string s = r.name(dr[1].ToString());
l.Text = s;
request.Controls.Add(new LiteralControl("<div class='panel panel-default relative text-center'>"));
A = new abc();
int t = A.chkpicstat(dr[1].ToString());
if (t == 0)
{
if (A.chkgender(dr[1].ToString()))
{
request.Controls.Add(new LiteralControl("<img src='temp/b.jpg' class='media-object' height='50' width='60' style='margin-top:10px'>"));
}
else
{
request.Controls.Add(new LiteralControl("<img src='temp/g.jpg' class='media-object' height='50' width='60' style='margin-top:10px'>"));
}
}
else
{
request.Controls.Add(new LiteralControl("<img src='Account/" + dr[1].ToString() + "/p.jpg' class='media-object' height='50' width='60' style='margin-top:10px'>"));
}
request.Controls.Add(l);
request.Controls.Add(new LiteralControl(" <div class='panel-body panel-boxed text-center'><div class='rating'>"));
string str1 = "<a href='accept.aspx?reqid=" + dr[0].ToString() + "' class='btn btn-primary'>Accept</a>";
request.Controls.Add(new LiteralControl(" "));
string str2 = "<a href='reject.aspx?reqid=" + dr[0].ToString() + "' class='btn btn-danger'>Reject</a>";
request.Controls.Add(new LiteralControl(str1));
request.Controls.Add(new LiteralControl(" "));
request.Controls.Add(new LiteralControl(str2));
request.Controls.Add(new LiteralControl("</div><hr/></div></div>"));
request.Controls.Add(new LiteralControl("<br/>"));
}
cn.Close();
}
public void notmsg()
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from notification order by nid desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
int c = 0;
foreach (DataRow dr in ds.Tables[0].Rows)
{
c++;
if (a.Contains(dr[1].ToString()))
{
abc A = new abc();
int t1 = A.chkpicstat(dr[1].ToString());
if (t1 == 0)
{
if (A.chkgender(dr[1].ToString()))
{
noti.Controls.Add(new LiteralControl("<div class='media'><div class='media-left'><a href='#'><img src='temp/b.jpg' class='media-object' width='60' height='60'></a></div>"));
}
else
{
noti.Controls.Add(new LiteralControl("<div class='media'><div class='media-left'><a href='#'><img src='temp/g.jpg' class='media-object' width='60' height='60'></a></div>"));
}
}
else
{
noti.Controls.Add(new LiteralControl("<div class='media'><div class='media-left'><a href='#'><img src='Account/" + dr[1].ToString() + "/p.jpg' class='media-object' width='60' height='60'></a></div>"));
}
returnname r = new returnname();
noti.Controls.Add(new LiteralControl("<div class='media-body message'><div class='panel panel-default'><div class='panel-heading panel-heading-white'><a href='#'>" + r.name(dr[1].ToString()) + "</a></div><div class='panel-body'><p>" + dr[2].ToString() + "</p></div></div></div></div>"));
}
}
cmd.Dispose();
cn.Close();
if (c == 0)
{
noti.Controls.Add(new LiteralControl("<div class='panel panel-default'><div class='panel-body'><p style='text-align:center'>There are no notifications. </p></div></div>"));
}
}
protected void login_Click(object sender, EventArgs e)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
cn.Open();
string str = "select * from reg where Email='" + email.Value + "' and Pass='******'";
SqlCommand cmd = new SqlCommand(str, cn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
if (dr[10].ToString() == "0")
{
if (dr[9].ToString() == "0")
{
Session["uname"] = email.Value;
Response.Redirect("index.aspx");
}
else
{
otp = rand();
abc A = new abc();
A.otpsave(otp, email.Value);
returnname r = new returnname();
em.send_maill(r.name(email.Value), email.Value, 3, otp);
Response.Redirect("ChkOTP.aspx");
}
}
else
{
alert.Visible = true;
Label4.Text = "Your Account has been deactivated";
}
}
else
{
alert1.Visible = true;
Label3.Text = "OOPs! Check your E-mail & Password";
}
cn.Close();
}
void fillpost()
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from wallpost order by wid desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
r = new returnname();
validfriend v1 = new validfriend();
a.Add(Session["uname"].ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (a.Contains(dr[1].ToString()))
{
if (v1.stat(dr[1].ToString()))
{
LinkButton l1 = new LinkButton();
l1.Text = "Like";
TextBox text = new TextBox();
text.Attributes["class"] = "form-control";
l1.CommandName = dr[0].ToString();
l1.Click += new EventHandler(like_post);
text.ID = dr[0].ToString();
string s = r.name(dr[1].ToString());
text.AutoPostBack = true;
text.TextChanged += new EventHandler(send_comment);
A = new abc();
int t1 = A.chkpicstat(dr[1].ToString());
if (t1 == 0)
{
if (A.chkgender(dr[1].ToString()))
{
wall.Controls.Add(new LiteralControl("<div class='timeline-block'><div class='panel panel-default'><div class='panel-heading'><div class='media'><div class='media-left'> <a><img src='temp/b.jpg' class='media-object' width='60' height='60'></a></div><div class='media-body'><a class='pull-right text-muted'><i class='icon-reply-all-fill fa fa-2x '></i></a><a href='#'>" + s + "</a><span>on " + dr[3].ToString() + "</span></div></div></div><div class='panel-body'><p>" + dr[2].ToString().Replace(System.Environment.NewLine, "<br>") + "</p></div><div class='view-all-comments'><a href='#'><i class='fa fa-thumbs-o-up'></i>"));
}
else
{
wall.Controls.Add(new LiteralControl("<div class='timeline-block'><div class='panel panel-default'><div class='panel-heading'><div class='media'><div class='media-left'> <a><img src='temp/g.jpg' class='media-object' width='60' height='60'></a></div><div class='media-body'><a class='pull-right text-muted'><i class='icon-reply-all-fill fa fa-2x '></i></a><a href='#'>" + s + "</a><span>on " + dr[3].ToString() + "</span></div></div></div><div class='panel-body'><p>" + dr[2].ToString().Replace(System.Environment.NewLine, "<br>") + "</p></div><div class='view-all-comments'><a href='#'><i class='fa fa-thumbs-o-up'></i>"));
}
}
else
{
wall.Controls.Add(new LiteralControl(" <div class='timeline-block'><div class='panel panel-default'><div class='panel-heading'><div class='media'><div class='media-left'> <a><img src='Account/" + dr[1].ToString() + "/p.jpg' class='media-object' width='60' height='60'></a></div><div class='media-body'><a class='pull-right text-muted'><i class='icon-reply-all-fill fa fa-2x '></i></a><a href='#'>" + s + "</a><span>on " + dr[3].ToString() + "</span></div></div></div><div class='panel-body'><p>" + dr[2].ToString().Replace(System.Environment.NewLine, "<br>") + "</p></div><div class='view-all-comments'><a href='#'><i class='fa fa-thumbs-o-up'></i>"));
}
string[] b = dr[4].ToString().Split('/');
if (!A.islike(Session["uname"].ToString(), l1.CommandName))
{
wall.Controls.Add(l1);
}
if (dr[5].ToString() == "0")
{
wall.Controls.Add(new LiteralControl("</a><span></span></div><ul class='comments'>"));
}
else
{
wall.Controls.Add(new LiteralControl("</a><span> "));
for (int i = 0; i < b.Length; i++)
{
wall.Controls.Add(new LiteralControl(" " + b[i] + ""));
}
wall.Controls.Add(new LiteralControl(" " + dr[5].ToString() + "Likes</a></span></div><ul class='comments'>"));
}
cmd.Dispose();
cn.Close();
SqlConnection cn1 = new SqlConnection();
cn1.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd1 = new SqlCommand("select * from comment order by cid asc", cn1);
DataSet ds1 = new DataSet();
SqlDataAdapter ad1 = new SqlDataAdapter(cmd1);
SqlCommandBuilder cmdb1 = new SqlCommandBuilder(ad1);
ad1.Fill(ds1);
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
string[] st = dr1[4].ToString().Split(' ');
if (dr1[1].ToString().Contains(text.ID))
{
wall.Controls.Add(new LiteralControl("<li class='media'><div class='media-left'><a href='#'>"));
int t = A.chkpicstat(dr1[2].ToString());
if (t == 0)
{
if (A.chkgender(dr1[2].ToString()))
{
wall.Controls.Add(new LiteralControl("<img src='temp/b.jpg' class='media-object' width='60' height='60'>"));
}
else
{
wall.Controls.Add(new LiteralControl("<img src='temp/g.jpg' class='media-object' width='60' height='60'>"));
}
}
else
{
wall.Controls.Add(new LiteralControl("<img src='Account/" + dr1[2].ToString() + "/p.jpg' class='media-object' width='60' height='60'>"));
}
wall.Controls.Add(new LiteralControl("</a></div><div class='media-body'><a href='#' class='comment-author pull-left'>" + r.name(dr1[2].ToString()) + "</a><span>" + dr1[3].ToString() + "</span><div class='comment-date'>" + st[0] + "</div></div></li>"));
}
}
wall.Controls.Add(new LiteralControl(" <li class='comment-form'><div class='input-group'><span class='input-group-btn'><a href='#' class='btn btn-default'><i class='fa fa-comments'></i></a></span>"));
wall.Controls.Add(text);
wall.Controls.Add(new LiteralControl("</div></li></ul></div></div>"));
cmd1.Dispose();
cn1.Close();
}
}
}
}
void fillmessage()
{
r = new returnname();
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from message where (receiver='" + Session["uname"].ToString() + "'or sender='" + Session["uname"].ToString() + "') order by msgid desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
b = new ArrayList();
b.Add(Session["uname"].ToString());
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (b.Contains(dr[1].ToString()))
{
string sender = r.name(dr[1].ToString());
msg.Controls.Add(new LiteralControl("<div class='media'><div class='media-body message'><div class='panel panel-default'><div class='panel-heading panel-heading-white'><div class='pull-right'><small class='text-muted'>" + dr[4].ToString() + "</small></div><a href='#'>" + sender + "</a></div><div class='panel-body'>" + dr[3].ToString() + "</div></div></div><div class='media-right'>"));
abc A = new abc();
int t = A.chkpicstat(dr[1].ToString());
if (t == 0)
{
if (A.chkgender(dr[1].ToString()))
{
msg.Controls.Add(new LiteralControl("<img src='temp/b.jpg' alt='' class='media-object' width='60'></div></div><br/>"));
}
else
{
msg.Controls.Add(new LiteralControl("<img src='temp/g.jpg' alt='' class='media-object' width='60'></div></div><br/>"));
}
}
else
{
msg.Controls.Add(new LiteralControl("<img src='Account/" + dr[1].ToString() + "/p.jpg' alt='' class='media-object' width='60'></div></div><br/>"));
}
}
if (b.Contains(dr[2].ToString()))
{
string receiver = r.name(dr[1].ToString());
int t = A.chkpicstat(dr[1].ToString());
if (t == 0)
{
if (A.chkgender(dr[1].ToString()))
{
msg.Controls.Add(new LiteralControl("<div class='media'><div class='media-left'><img src='temp/b.jpg' alt='' class='media-object' width='60'></div> <div class='media-body message'><div class='panel panel-default'><div class='panel-heading panel-heading-white'><div class='pull-right'><small class='text-muted'>" + dr[4].ToString() + "</small></div><a href='#'>" + receiver + "</a></div><div class='panel-body'>" + dr[3].ToString() + "</div></div></div></div><br/>"));
}
else
{
msg.Controls.Add(new LiteralControl("<div class='media'><div class='media-left'><img src='temp/g.jpg' alt='' class='media-object' width='60'></div> <div class='media-body message'><div class='panel panel-default'><div class='panel-heading panel-heading-white'><div class='pull-right'><small class='text-muted'>" + dr[4].ToString() + "</small></div><a href='#'>" + receiver + "</a></div><div class='panel-body'>" + dr[3].ToString() + "</div></div></div></div><br/>"));
}
}
else
{
msg.Controls.Add(new LiteralControl(" <div class='media'><div class='media-left'><img src='Account/" + dr[1].ToString() + "/p.jpg' alt='' class='media-object' width='60'></div> <div class='media-body message'><div class='panel panel-default'><div class='panel-heading panel-heading-white'><div class='pull-right'><small class='text-muted'>" + dr[4].ToString() + "</small></div><a href='#'>" + receiver + "</a></div><div class='panel-body'>" + dr[3].ToString() + "</div></div></div></div><br/>"));
}
}
}
cn.Close();
}
void fillfriend()
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from friend where (receiver='" + Session["uname"].ToString() + "'or sender='" + Session["uname"].ToString() + "') and status='1' order by dor desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
int c = 0;
a = new ArrayList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
c++;
if (dr[1].ToString() == Session["uname"].ToString())
{
a.Add(dr[2].ToString());
}
else
{
a.Add(dr[1].ToString());
}
}
foreach (object o in a)
{
returnname r = new returnname();
LinkButton l = new LinkButton();
l.Text = o.ToString();
l.ForeColor = System.Drawing.Color.White;
l.Font.Name = "Comic Sans MS";
l.CommandName = r.name(o.ToString());
l.Click += new EventHandler(l_click);
A = new abc();
int t = A.chkpicstat(o.ToString());
if (t == 0)
{
if (A.chkgender(o.ToString()))
{
frnds.Controls.Add(new LiteralControl("<li class='list-group-item active'><div class='media'><div class='media-left'><img src='temp/b.jpg' alt='' class='media-object' width='65' height='60'></div> <div class='media-body'><span class='user'>" + l.CommandName + ""));
}
else
{
frnds.Controls.Add(new LiteralControl("<li class='list-group-item active'><div class='media'><div class='media-left'><img src='temp/g.jpg' alt='' class='media-object' width='65' height='60'></div> <div class='media-body'><span class='user'>" + l.CommandName + ""));
}
}
else
{
frnds.Controls.Add(new LiteralControl(" <li class='list-group-item active'><div class='media'><div class='media-left'><img src='Account/" + o.ToString() + "/p.jpg' alt='' class='media-object' width='65' height='60'></div> <div class='media-body'><span class='user'>" + l.CommandName + ""));
}
frnds.Controls.Add(l);
frnds.Controls.Add(new LiteralControl("</span></div></div></li><hr/>"));
}
cn.Close();
if (c == 0)
{
frnds.Controls.Add(new LiteralControl("<p>Sorry there are no friends whom you can chat.</p>"));
}
}
void fillfriend()
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["cn"].ToString();
SqlCommand cmd = new SqlCommand("select * from friend where (receiver='" + Session["uname"].ToString() + "'or sender='" + Session["uname"].ToString() + "') and status='1' order by dor desc", cn);
DataSet ds = new DataSet();
SqlDataAdapter ad = new SqlDataAdapter(cmd);
SqlCommandBuilder cmdb = new SqlCommandBuilder(ad);
ad.Fill(ds);
int c = 0;
a = new ArrayList();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr[1].ToString() == Session["uname"].ToString())
{
a.Add(dr[2].ToString());
}
else
{
a.Add(dr[1].ToString());
}
}
foreach (object o in a)
{
c++;
returnname r = new returnname();
LinkButton l = new LinkButton();
l.Text = o.ToString();
l.Click += new EventHandler(l_click);
Button b = new Button();
Button b1 = new Button();
b.Text = "Follow";
b1.Text = "Unfriend";
b.Attributes["class"] = "btn btn-default btn-sm";
b1.Attributes["class"] = "btn btn-success btn-sm";
b.CommandName = l.Text;
b1.CommandName = l.Text;
b.Click += new EventHandler(b_click);
b1.Click += new EventHandler(b1_click);
panel.Controls.Add(new LiteralControl("<div class='col-md-6 col-lg-4 item'><div class='panel panel-default'><div class='panel-heading'><div class='media'><div class='pull-left'>"));
abc A = new abc();
int t = A.chkpicstat(o.ToString());
if (t == 0)
{
if (A.chkgender(o.ToString()))
{
panel.Controls.Add(new LiteralControl("<img src='temp/b.jpg' alt='People' class='media-object img-circle' width='40' height='40'>"));
}
else
{
panel.Controls.Add(new LiteralControl("<img src='temp/g.jpg' alt='People' class='media-object img-circle' width='40' height='40'>"));
}
}
else
{
panel.Controls.Add(new LiteralControl("<img src='Account/" + o.ToString() + "/p.jpg' alt='People' class='media-object img-circle' width='40' height='40'>"));
}
panel.Controls.Add(new LiteralControl("</div><div class='media-body'><h4 class='media-heading margin-v-5'>"));
panel.Controls.Add(new LiteralControl("" + r.name(o.ToString()) + "<br/>"));
panel.Controls.Add(l);
panel.Controls.Add(new LiteralControl("</h4></div></div></div><div class='panel-footer'><div class='row'><div class='col-xs-6 col-sm-6 col-md-6'>"));
if (!v.isinfollow(Session["uname"].ToString(), b.CommandName))
{
panel.Controls.Add(b);
}
panel.Controls.Add(new LiteralControl("</div><div class='col-xs-6 col-sm-6 col-md-6'>"));
panel.Controls.Add(b1);
panel.Controls.Add(new LiteralControl("</div></div></div></div></div>"));
}
cn.Close();
if (c == 0)
{
panel.Controls.Add(new LiteralControl("<div class='panel panel-default'><div class='panel-body'><p style='text-align:center'>There is no Friends of your's search for Friends. </p></div></div>"));
}
}