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>";
}
}
protected void txtID_TextChanged(object sender, EventArgs e)
{
//強制先完成RegularExpression驗證
RegularExpressionValidator1.Validate();
//判斷IsValid的值
if (RegularExpressionValidator1.IsValid)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["教務系統ConnectionString"].ConnectionString);
SqlCommand cmd = new SqlCommand("select dbo.fnCheckCourseID('" + txtID.Text + "')", conn);
SqlDataReader dr;
conn.Open();
dr = cmd.ExecuteReader();
dr.Read();
if (dr[0].ToString() == "1")
{
Label1.Text = "編號可用";
Label1.ForeColor = System.Drawing.Color.Green;
}
else
{
Label1.Text = "編號重複";
Label1.ForeColor = System.Drawing.Color.Red;
}
conn.Close();
}
else
{
Label1.Text = "";
}
}
protected void txtssn_TextChanged(object sender, EventArgs e)
{
// List<StudentInfor> allUsersList = Application["AllUserList"] as List<StudentInfor>;
string validatessn = txtssn.Text;
if (Application["AllUsersList"] != null)
{
List <StudentInfor> allUsersList = Application["AllUsersList"] as List <StudentInfor>;
if (allUsersList != null)
{
for (int i = 0; i < allUsersList.Count; i++)
{
if (allUsersList[i].SocialSecurityNumber == validatessn)
{
string message = ": already exist. Please go to login page.";
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("<script type = 'text/javascript'>");
sb.Append("window.onload=function(){");
sb.Append("alert('");
sb.Append(validatessn);
sb.Append(message);
sb.Append("')};");
sb.Append("</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", sb.ToString());
txtssn.Text = "";
}
}
}
RequiredFieldValidator1.Validate();
RegularExpressionValidator1.Validate();
}
}
protected void UpdateCate_Click(object sender, EventArgs e)
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RegularExpressionValidator1.Validate();
RequiredFieldValidator3.Validate();
List <String> list = new List <string>();
list.Add(this.txtProductName.Text);
list.Add(this.DropDownList3.SelectedItem.Value);
list.Add(this.DropDownList2.SelectedItem.Value);
list.Add(this.txtUnitPrice.Text);
list.Add(this.RadioButtonList1.SelectedItem.Text);
if (lblProID.Text.Equals(""))
{
new products().insert(list);
}
else
{
new products().update(Int32.Parse(lblProID.Text), list);
}
LoadProduct();
}
protected void tb_newSvvMailId_TextChanged(object sender, EventArgs e)
{
RegularExpressionValidator1.Validate();
if (RegularExpressionValidator1.IsValid && tb_newSvvMailId.Text != null)
{
string error;
string id;// no use of this ID here;it is for forgot pass token link;
string sp_name = "sp_isStdEmailIdExist";
if (!(DataAccessLayer.isEmailIDExist_getItsID(tb_newSvvMailId.Text.Trim(), sp_name, out error, out id)))
{
ValidEmailId = true;
lbl_isValid_isInvalid.Text = "<br/><div style='display:inline-flex; vertical-align:central;'><div class='icon material-icons mdl-color-text--primary'>done</div><label style='padding-top:2px' for='tt2'class='mdl-radio__label mdl-color-text--primary'> Valid Email ID/Student not Exists</label></div>";
}
else
{
if (error == null)
{
ValidEmailId = false;
lbl_isValid_isInvalid.CssClass = "mdl-color-text--accent";
string html = "<br/><div style='display:inline-flex; vertical-align:central;'><div class='icon material-icons mdl-color-text--accent'>error</div><label style='padding-top:2px' for='tt2'class='mdl-radio__label'> User already exits</label></div>";
lbl_isValid_isInvalid.Controls.Add(new LiteralControl(html));
}
else
{
lbl_changeSvvEmailId_Status.Text = error;
}
}
}
}
protected void Button3_Click(object sender, EventArgs e)
{
RegularExpressionValidator1.Validate();
// 라벨 초기화
name_label.Text = "";
email_label.Text = "";
if (RegularExpressionValidator1.IsValid && TextBox3.Text != "")
{
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;
Cmd.CommandText = "UPDATE db_user SET email = \'" + TextBox3.Text + "' WHERE id = \'" + Application["id"].ToString().Trim() + "\'";
try
{
Con.Open();
int rowsAffected = Cmd.ExecuteNonQuery();
if (rowsAffected == 1)
{
email_label.Text = "수정되었습니다!";
}
Con.Close();
}
catch { }
}
}
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 Page_Load(object sender, EventArgs e)
{
RequiredFieldValidator1.Validate();
CompareValidator1.Validate();
RegularExpressionValidator1.Validate();
RequiredFieldValidator2.Validate();
RequiredFieldValidator3.Validate();
}
protected void AddCate_Click(object sender, EventArgs e)
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RegularExpressionValidator1.Validate();
RequiredFieldValidator3.Validate();
AddProduct();
LoadProduct();
}
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 TextBox4_TextChanged(object sender, EventArgs e)
{
//email validated
RegularExpressionValidator1.Validate();
bool v = false;
try
{
System.Net.Mail.MailAddress address = new System.Net.Mail.MailAddress(TextBox4.Text);
v = address.Address == TextBox4.Text;
}
catch (Exception)
{
}
if (RegularExpressionValidator1.IsValid && (v))
{
TextBox4.CssClass = "valid";
}
else
{
TextBox4.CssClass = "invalid";
}
}
protected void btnCreateUser_Click(object sender, EventArgs e)
{
UserNameRequired.Validate();
RegularExpressionValidator1.Validate();
// create new user
string username = tbUsername.Text;
string password = Global.CalculateMD5Hash(DateTime.UtcNow.ToString()).Substring(26);
Membership.CreateUser(username, password);
// email = username
MembershipUser newUser = Membership.GetUser(username);
newUser.Email = username;
Membership.UpdateUser(newUser);
// Add default roles
Roles.AddUserToRole(username, "order");
Roles.AddUserToRole(username, "view_orders");
Roles.AddUserToRole(username, "edit_profile");
// fill default prfile
ProfileCommon profile = UserProfile.GetProfile(username);
profile.Category = ddlCategory.SelectedValue;
profile.Name = tbName.Text;
profile.Surname = tbSurname.Text;
profile.SearchSize = UInt16.Parse(ddlSearchSize.SelectedValue);
profile.Language = UInt16.Parse(ddlLanguages.SelectedValue);
profile.Save();
// send info email
Global.SendAccountInfo(username, profile.Name + " " + profile.Surname, password);
Response.Redirect("~/Administrator/");
}
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 TextBox3_TextChanged(object sender, EventArgs e)
{
RegularExpressionValidator1.Validate();//유효성 검사
}
