protected void Button1_Click(object sender, EventArgs e)
        {
            String idget = Request.Cookies["userid"].Value;

            if (SqlGetData.DataMan("INSERT into profile_details VALUES('" + idget + "','" + TextBox1.Text + "','" + TextBox2.Text + "','" + TextBox3.Text + "','" + TextBox4.Text + "','" + TextBox5.Text + "','" + TextBox6.Text + "','" + TextBox7.Text + "','" + TextBox8.Text + "','" + TextBox9.Text + "','" + TextBox10.Text + "','10','Basic','dp_dummy.jpg','cover_dummy.jpg')"))
            {
                Response.Redirect("home.aspx");
            }
        }
 public static bool check_table_presence(string id)
 {
     dataset_p = SqlGetData.GetData("SELECT * FROM profile_details where uid='" + id + "'");
     if (dataset_p.Tables["user_info"].Rows.Count > 0)
     {
         return(true);
     }
     else
     {
         return(false);
     }
 }
        protected void Button2_Click1(object sender, EventArgs e)
        {
            string newFirstName = TextBox3.Text;
            string newLastName  = TextBox4.Text;
            string newEmail     = TextBox5.Text;
            string newPassword  = TextBox6.Text;

            if (SqlGetData.DataMan("INSERT INTO user_info VALUES('" + newLastName + "','" + newFirstName + "','" + newEmail + "','" + newPassword + "')"))
            {
                string message = "SignUp process is done. Please login from above to continue.";
                Label1.Text = message;
            }
            else
            {
            }
        }
Exemplo n.º 4
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     if (FileUpload1.HasFile)
     {
         string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
         FileUpload1.PostedFile.SaveAs(Server.MapPath("~/dp/") + fileName);
         string bindfilename = fileName;
         try{
             if (SqlGetData.DataMan("UPDATE profile_details SET profile_pic='" + bindfilename + "' WHERE uid='" + picker + "'"))
             {
                 Response.Redirect("home.aspx");
             }
         }
         catch (Exception ex) {
             Response.Write(ex.Message);
         }
     }
 }
Exemplo n.º 5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.Cookies["userid"] != null)
            {
                picker = Request.Cookies["userid"].Value;
            }

            if (Request.Cookies["FullName"] == null)
            {
                Response.Redirect("index.aspx");
            }
            else
            {
                meroid      = Request.Cookies["userid"].Value;
                Label1.Text = Request.Cookies["FullName"].Value;
            }
            try
            {
                if (functions.check_table_presence(meroid))
                {
                    // Response.Write(meroid);
                    HyperLink1.Enabled = false;

                    dataset = SqlGetData.GetData("SELECT * FROM profile_details where uid='" + meroid + "'");
                    if (dataset.Tables["user_info"].Rows.Count > 0)
                    {
                        string getimagepath = dataset.Tables["user_info"].Rows[0][13].ToString();
                        //ImageBox.ImageUrl = getimagepath;
                        string bindimage = "~/dp/" + getimagepath;
                        Image1.ImageUrl = bindimage;
                    }
                }
                else
                {
                    HyperLink1.Text        = "Complete Your Profile";
                    HyperLink1.NavigateUrl = "completeprofile.aspx";
                }
            }
            catch (Exception ex)
            {
                Response.Write(ex.Message);
            }
        }
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                if (functions.cookieUpdater == "ok")
                {
                    string uid2 = functions.uid;

                    ds1 = SqlGetData.GetData("Select *from user_info where uid='" + uid2 + "'");

                    if (ds1.IsInitialized)
                    {
                        String userid   = ds1.Tables["user_info"].Rows[0][0].ToString();
                        String Lname    = ds1.Tables["user_info"].Rows[0][1].ToString();
                        String Fname    = ds1.Tables["user_info"].Rows[0][2].ToString();
                        String UEmail   = ds1.Tables["user_info"].Rows[0][3].ToString();
                        String space    = " ";
                        String FullName = Fname + space + Lname;
                        Response.Cookies["userid"].Value       = userid;
                        Response.Cookies["userid"].Expires     = DateTime.Now.AddDays(1);
                        Response.Cookies["FullName"].Value     = FullName;
                        Response.Cookies["FullName"].Expires   = DateTime.Now.AddDays(1);
                        Response.Cookies["UEmail"].Value       = UEmail;
                        Response.Cookies["UEmail"].Expires     = DateTime.Now.AddDays(1);
                        Response.Cookies["setCookies"].Value   = "ok";
                        Response.Cookies["setCookies"].Expires = DateTime.Now.AddDays(1);
                        Response.Redirect("home.aspx");
                        functions.cookieUpdater = "notok";
                    }
                    else
                    {
                    }
                }
                else
                {
                    Response.Redirect("logout.aspx");
                }
            }
            catch (Exception ex)
            {
                Console.Write(ex.Message);
            }
        }
Exemplo n.º 7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         int id = 1;
         dataset = SqlGetData.GetData("SELECT * FROM profile_details where uid='" + id + "'");
         if (dataset.IsInitialized)
         {
             string getimagepath = dataset.Tables["user_info"].Rows[0][13].ToString();
             //ImageBox.ImageUrl = getimagepath;
             string bindimage = "~/dp/" + getimagepath;
             ImageBox.ImageUrl = bindimage;
         }
     }
     catch (Exception ex)
     {
         Response.Write(ex.Message);
     }
 }
Exemplo n.º 8
0
        protected void Button1_Click(object sender, EventArgs e)
        {
            if (TextBox1.Text != "")
            {
                string p_actor_username = Request.Cookies["FullName"].Value;
                string dateTime         = System.DateTime.Now.ToString();

                if (FileUpload1.HasFile)
                {
                    string fileName = Path.GetFileName(FileUpload1.PostedFile.FileName);
                    FileUpload1.PostedFile.SaveAs(Server.MapPath("~/post_img/") + fileName);
                    string bindfilename = fileName;


                    if (SqlGetData.DataMan("INSERT INTO POST (post_caption,post_actor,post_photo,post_date,post_actor_name)VALUES('" + TextBox1.Text + "','" + meroid + "','" + bindfilename + "','" + dateTime + "','" + p_actor_username + "') "))
                    {
                        Response.Redirect("home.aspx");
                    }
                }
            }
        }
        protected void Button1_Click(object sender, EventArgs e)
        {
            try {
                ds = SqlGetData.GetData("Select *from user_info where UEmail='" + TextBox1.Text + "' and UPassword='******'");

                if (ds.IsInitialized)
                {
                    String userid   = ds.Tables["user_info"].Rows[0][0].ToString();
                    String Lname    = ds.Tables["user_info"].Rows[0][1].ToString();
                    String Fname    = ds.Tables["user_info"].Rows[0][2].ToString();
                    String UEmail   = ds.Tables["user_info"].Rows[0][3].ToString();
                    String space    = " ";
                    String FullName = Fname + space + Lname;
                    Response.Cookies["userid"].Value   = userid;
                    Response.Cookies["userid"].Expires = DateTime.Now.AddDays(1);



                    Response.Cookies["FullName"].Value     = FullName;
                    Response.Cookies["FullName"].Expires   = DateTime.Now.AddDays(1);
                    Response.Cookies["UEmail"].Value       = UEmail;
                    Response.Cookies["UEmail"].Expires     = DateTime.Now.AddDays(1);
                    Response.Cookies["setCookies"].Value   = "ok";
                    Response.Cookies["setCookies"].Expires = DateTime.Now.AddDays(1);

                    if (functions.check_table_presence(userid))
                    {
                        functions.profile_completed = 1;
                    }

                    Response.Redirect("home.aspx");
                }
                else
                {
                    Response.Redirect("index.aspx");
                }
            }
            catch (Exception ex) {
                Console.Write(ex.Message);
            }

            /*
             * try
             * {
             *  con = new SqlConnection("server=ANONYMOUS\\SQLEXPRESS;integrated security=true;database=travel");
             *  con.Open();
             *  String qry = "Select *from user_info where UEmail='" + TextBox1.Text + "' and UPassword='******'";
             *  SqlCommand cmd = new SqlCommand(qry, con);
             *  SqlDataReader sdr = cmd.ExecuteReader();
             *  if (sdr.Read())
             *  {
             *      Response.Redirect("home.aspx");
             *  }
             *  else
             *  {
             *      Response.Redirect("index.aspx");
             *  }
             * }
             * catch (Exception ex) {
             *  Response.Write(ex.Message);
             * }*/
        }