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