protected void Button1_Click(object sender, EventArgs e)
{
RegularExpressionValidator1.Validate();
if (TextBox1.Text == "" || RegularExpressionValidator1.IsValid == false)
{
Label3.Text = "전화번호가 틀렸습니다.</br>";
}
else
{
Label3.Text = "올바른 전화번호 입니다.</br>";
}
RegularExpressionValidator2.Validate();
if (RegularExpressionValidator2.IsValid == false || TextBox2.Text == "")
{
Label4.Text = "이메일이 틀렸습니다.</br>";
}
else
{
Label4.Text = "올바른 이메일 주소 입니다.</br>";
}
}
private bool validateall()
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RequiredFieldValidator3.Validate();
RequiredFieldValidator4.Validate();
RequiredFieldValidator5.Validate();
RequiredFieldValidator6.Validate();
RequiredFieldValidator7.Validate();
RequiredFieldValidator8.Validate();
RequiredFieldValidator9.Validate();
RegularExpressionValidator1.Validate();
RegularExpressionValidator2.Validate();
RegularExpressionValidator3.Validate();
RegularExpressionValidator4.Validate();
RegularExpressionValidator5.Validate();
RegularExpressionValidator6.Validate();
RegularExpressionValidator7.Validate();
CompareValidator1.Validate();
CompareValidator2.Validate();
CompareValidator3.Validate();
if (!RequiredFieldValidator1.IsValid || !RequiredFieldValidator2.IsValid || !RequiredFieldValidator3.IsValid || !RequiredFieldValidator4.IsValid || !RequiredFieldValidator5.IsValid || !RequiredFieldValidator6.IsValid || !RequiredFieldValidator7.IsValid || !RequiredFieldValidator8.IsValid || !RequiredFieldValidator9.IsValid ||
!RegularExpressionValidator1.IsValid || !RegularExpressionValidator2.IsValid || !RegularExpressionValidator3.IsValid || !RegularExpressionValidator4.IsValid || !RegularExpressionValidator5.IsValid || !RegularExpressionValidator6.IsValid || !RegularExpressionValidator7.IsValid || !CompareValidator1.IsValid || !CompareValidator2.IsValid || !CompareValidator3.IsValid)
{
return(false);
}
return(true);
}
protected void login_B_Click(object sender, EventArgs e)
{
RequiredFieldValidator1.Validate();
RegularExpressionValidator1.Validate();
RequiredFieldValidator2.Validate();
RegularExpressionValidator2.Validate();
if (RequiredFieldValidator1.IsValid == false ||
RegularExpressionValidator1.IsValid == false ||
RequiredFieldValidator2.IsValid == false ||
RegularExpressionValidator2.IsValid == false)
{
return;
}
String email = email_T.Text;
String code = password_T.Text;
int current_User_Index = -1;
List <User> allUsersList = Application["AllUsersList"] as List <User>;
if ((Application["AllUsersList"] != null) && (current_User_Index = check_Valid_User_Login(allUsersList, email, code)) >= 0)
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('Successpully Logged In!');", true);
Session["CurrentUser"] = allUsersList[current_User_Index];
login_L1.Text = "Welcome " + allUsersList[current_User_Index].FullName + " !";
login_users.Visible = false;
current_users_panel.Visible = false;
new_users_panel.Visible = false;
user_account_panel.Visible = true;
recover_password.Visible = false;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('Unable to Login. Invalid email-id or access-code!');", true);
}
}
protected void BtReg_Click(object sender, EventArgs e)
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RequiredFieldValidator3.Validate();
RequiredFieldValidator4.Validate();
RequiredFieldValidator5.Validate();
RequiredFieldValidator6.Validate();
RequiredFieldValidator7.Validate();
CompareValidator1.Validate();
RegularExpressionValidator1.Validate();
RegularExpressionValidator2.Validate();
RegularExpressionValidator3.Validate();
RequiredFieldValidator8.Validate();
RequiredFieldValidator9.Validate();
if (!RequiredFieldValidator8.IsValid || !RequiredFieldValidator9.IsValid || !RequiredFieldValidator1.IsValid || !RequiredFieldValidator2.IsValid || !RequiredFieldValidator3.IsValid || !RequiredFieldValidator4.IsValid || !RequiredFieldValidator5.IsValid || !RequiredFieldValidator6.IsValid || !RequiredFieldValidator7.IsValid || !CompareValidator1.IsValid || !RegularExpressionValidator1.IsValid || !RegularExpressionValidator2.IsValid || !RegularExpressionValidator3.IsValid)
{
eMessage.Message("请仔细检查输入！", UpdatePanel1, this);
return;
}
if (!this.SerialNumber1.CheckSN(txtCheck.Text) || txtCheck.Text == null || txtCheck.Text == "")
{
eMessage.Message("请输入正确的验证码", UpdatePanel1, this);
this.SerialNumber1.Create();
return;
}
if (!Regex.IsMatch(txtIdReg.Text, "^\\d{10}$"))
{
eMessage.Message("不正确的ID", UpdatePanel1, this);
SerialNumber1.Create();
return;
}
if (!Regex.IsMatch(txtNameReg.Text, "^[\u4E00-\u9FA5]{0,}$"))
{
eMessage.Message("请输入正确的姓名", UpdatePanel1, this);
SerialNumber1.Create();
return;
}
if (txtPawReg.Text != txtPawRegCnf.Text)
{
eMessage.Message("您两次输入的密码不同", UpdatePanel1, this);
SerialNumber1.Create();
return;
}
var cn = new SqlConnection();
cn.ConnectionString = DealData.constring;
SqlCommand cmd = new SqlCommand("usp_VaUserName", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 50)).Value = txtUsrReg.Text;
try
{
cn.Open();
if ((string)cmd.ExecuteScalar() != null)
{
eMessage.Message("该用户名已被注册!", UpdatePanel1, this);
SerialNumber1.Create();
return;
}
}
catch (Exception e1)
{
eMessage.Message("系统发生问题，请稍后重试或联系管理员", UpdatePanel1, this);
SerialNumber1.Create();
eMessage.Message(e1);
}
finally
{
cn.Close();
}
int state = 0;
var cn2 = new SqlConnection();
cn2.ConnectionString = DealData.constring;
SqlCommand cmd2 = new SqlCommand("usp_CreateUser", cn2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.Add(new SqlParameter("@username", SqlDbType.NVarChar, 50)).Value = txtUsrReg.Text;
cmd2.Parameters.Add(new SqlParameter("@studentid", SqlDbType.NVarChar, 50)).Value = txtIdReg.Text;
cmd2.Parameters.Add(new SqlParameter("@password", SqlDbType.NVarChar, 50)).Value = txtPawReg.Text;
cmd2.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, 50)).Value = txtEmailReg.Text;
cmd2.Parameters.Add(new SqlParameter("@question", SqlDbType.NVarChar, 50)).Value = txtQueReg.Text;
cmd2.Parameters.Add(new SqlParameter("@key", SqlDbType.NVarChar, 50)).Value = txtAnsReg.Text;
cmd2.Parameters.Add(new SqlParameter("@RealName", SqlDbType.NVarChar, 50)).Value = txtNameReg.Text;
try
{
cn2.Open();
if (cmd2.ExecuteNonQuery() > 0)
{
eMessage.Message("注册成功，请等待老师的审核！", UpdatePanel1, this);
SerialNumber1.Create();
state = 1;
}
else
{
eMessage.Message("注册失败,请稍后再试", UpdatePanel1, this);
SerialNumber1.Create();
state = -1;
}
}
catch (Exception e2)
{
eMessage.Message("系统发生错误请稍后再试", UpdatePanel1, this);
SerialNumber1.Create();
eMessage.Message(e2);
}
finally
{
cn2.Close();
if (state == 1)
{
Response.Redirect("~/Default.aspx");
}
}
}
protected void TextBox4_TextChanged(object sender, EventArgs e)
{
RegularExpressionValidator2.Validate();//유효성 검사
}
protected void Button1_Click(object sender, EventArgs e)
{
bool IsPwSame = false;
// 현재 비밀번호
CompareValidator1.Validate();
CompareValidator2.Validate();
RegularExpressionValidator2.Validate();
RegularExpressionValidator3.Validate();
RegularExpressionValidator4.Validate();
if (CompareValidator1.IsValid && CompareValidator2.IsValid && RegularExpressionValidator2.IsValid &&
RegularExpressionValidator3.IsValid && RegularExpressionValidator4.IsValid)
{
string connectionString = @"server=(local)\SQLExpress;Integrated Security=true;database=db_user";//서버 연결
SqlConnection Con = new SqlConnection(connectionString);
// SQL COMMAND OBJECT를 만들고 SQL COMMAND 넣기
SqlCommand Cmd = new SqlCommand();
Cmd.Connection = Con;
try
{
// SQL COMMAND 수행하기
Con.Open();
// 현재 비밀번호가 맞는지 체크
Cmd.CommandText = "SELECT pw FROM db_user WHERE id = \'" + Application["id"].ToString().TrimEnd() + "\'";
SqlDataReader reader = Cmd.ExecuteReader();
if (reader.Read())
{
string pw = reader["pw"].ToString().TrimEnd();
if (pw == TextBox1.Text)
{
IsPwSame = true;
}
}
reader.Close();
if (IsPwSame) // 현재 비밀번호가 맞으면
{
//새 비밀번호를 DB에 업데이트
Cmd.CommandText = "UPDATE db_user SET pw = \'" + TextBox2.Text + "\' WHERE id = \'" + Application["id"].ToString().TrimEnd() + "\'";
// ExecuteNonQuery()문은 CREATE, ALTER, DROP, INSERT, UPDATE, DELETE 문을 수행할때 사용
int rowsAffected = Cmd.ExecuteNonQuery(); //편집구문에따라 영향받는 줄은 몇줄인가?
if (rowsAffected == 1) //영향받는 줄은 1줄
{
Response.Redirect(".\\pwchanged.aspx"); //비밀번호 변경후로 이동
}
}
else // 현재 비밀번호가 아니라면 다시 입력
{
Label1.Text = "비밀번호가 다릅니다!";
}
Con.Close();
}
catch
{ // 예외 처리
Label1.Text = "안되는대?";
}
}
}
