Exemple #1
0
        private void registerAccount(account a)
        {
            account Account = new account();

            Account.name            = a.name;
            Account.password        = a.password;
            Account.email_address   = a.email_address;
            Account.contact_number  = a.contact_number;
            Account.activation_code = a.activation_code;
            using (ecommerceEntities db = new ecommerceEntities())
            {
                db.accounts.Add(Account);
                db.SaveChanges();
                sendCode();
                //Response.Redirect("WebForm2.aspx?email_address="+txtEmail.Text);
            }
        }
Exemple #2
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            account A      = new account();
            Random  random = new Random();

            activationcode    = random.Next(1001, 9999).ToString();
            A.name            = txtName.Text;
            A.password        = txtConfirmpassword.Text;
            A.email_address   = txtEmail.Text;
            A.activation_code = "Unregistered";
            registerAccount(A);
            using (SqlConnection con = new SqlConnection(CS))
            {
                string myquery = "select *from account where email_address='" + Request.QueryString["txtEmail"] + "'";
                con.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.CommandText = myquery;
                cmd.Connection  = con;
                SqlDataAdapter da = new SqlDataAdapter();
                da.SelectCommand = cmd;
                DataSet ds = new DataSet();
                da.Fill(ds);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    string activationcode;
                    activationcode = ds.Tables[0].Rows[0]["activationcode"].ToString();
                    if (activationcode == Request["code"])
                    {
                        changeStatus();
                    }
                }
                else
                {
                }
            }
        }