public static void AvoidDuplicateEmail(SignUpInfo info) { string dQuery = string.Format(@"select * from customer where email = ('{0}')", info.eMailAddress); cmdString = new SqlCommand(dQuery, cntString); try { cntString.Open(); //cmdString.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmdString); DataTable dt = new DataTable(); DataSet ds = new DataSet(); da.Fill(dt); ds.Tables.Add(dt); if (dt.Rows.Count > 0) { info.eMailAddress = "Existing Email"; } } finally { cntString.Close(); } }
protected void check_Click(object sender, EventArgs e) { email = eMail.Text; password = pWord.Text; SignUpInfo newUserInfo = new SignUpInfo(username, email, password); connectionClass.SignIn(newUserInfo); if (newUserInfo.eMailAddress == "email matching") { Session["login"] = newUserInfo.userName; Response.Write("<script type='text/javascript'>"); Response.Write("alert('welcome');"); //Response.Write("document.location.href='login.aspx';"); Response.Write("</script>"); sessionCheck.Text = newUserInfo.userName + " Welcome!!"; logintable.Visible = false; } else { Response.Write("<script type='text/javascript'>"); Response.Write("alert('not matching');"); //Response.Write("document.location.href='login.aspx';"); Response.Write("</script>"); } }
protected void check_Click(object sender, EventArgs e) { username = uName.Text; email = eMail.Text; password = pWord.Text; if (Regex.IsMatch(email, "^([0-9a-zA-Z]([-.\\w]*[0-9a-zA-Z])*@([0-9a-zA-Z][-\\w]*[0-9a-zA-Z]\\.)+[a-zA-Z]{2,9})$")) { emailCheck.Text = "valid email"; SignUpInfo newUserInfo = new SignUpInfo(username, email, password); connectionClass.AvoidDuplicateEmail(newUserInfo); if (newUserInfo.eMailAddress == "Existing Email") { Response.Write("<script type='text/javascript'>"); Response.Write("alert('Please use other email');"); //Response.Write("document.location.href='login.aspx';"); Response.Write("</script>"); emailCheck.Text = newUserInfo.eMailAddress; } else { try { connectionClass.SignUp(newUserInfo); //Response.Write("<script type='text/javascript'>"); //Response.Write("alert('Thank you for sign up! ');"); //Response.Write("</script>"); //ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Thank you');window.location.href='http://www.naver.com'</script>"); ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('Thank you');</script>"); } catch { Response.Write("<script type='text/javascript'>"); Response.Write("alert('Failed ');"); Response.Write("</script>"); } finally { } } } else { emailCheck.Text = "invalid email"; } }
public static void SignUp(SignUpInfo info) { string cQuery = string.Format(@"insert into customer (customerID,userName,email,password) values(NEXT VALUE FOR finalreview.sqCustomerID, '{0}', '{1}', '{2}')", info.userName, info.eMailAddress, info.passWord); cmdString = new SqlCommand(cQuery, cntString); try { cntString.Open(); cmdString.ExecuteNonQuery(); } finally { cntString.Close(); } }
public static void SignIn(SignUpInfo info) { string SQuery = string.Format(@"select email,password,username from customer where email = ('{0}') and password=('{1}') ", info.eMailAddress, info.passWord); cmdString = new SqlCommand(SQuery, cntString); try { cntString.Open(); // cmdString.ExecuteNonQuery(); SqlDataAdapter da = new SqlDataAdapter(cmdString); DataTable dt = new DataTable(); DataSet ds = new DataSet(); da.Fill(dt); ds.Tables.Add(dt); if (dt.Rows.Count > 0) { info.eMailAddress = "email matching"; info.userName = dt.Rows[0]["userName"].ToString(); } else { info.eMailAddress = "email not matching"; } } finally { cntString.Close(); } }