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 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 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 btAdd_Click(object sender, EventArgs e)
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RequiredFieldValidator3.Validate();
if (!RequiredFieldValidator3.IsValid || !RequiredFieldValidator2.IsValid || !RequiredFieldValidator1.IsValid)
{
eMessage.Message("请填写完整信息！", UpdatePanel1, this);
}
else
{
SqlConnection con = new SqlConnection(DealData.constring);
SqlCommand cmd = new SqlCommand("usp_InsertNews", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Title", SqlDbType.NVarChar, 50)).Value = HttpUtility.HtmlEncode(txtTitle.Text);
cmd.Parameters.Add(new SqlParameter("@Content", SqlDbType.NText)).Value = HttpUtility.HtmlEncode(txtContent.Text).Replace("\r", "<br>").Replace(" ", " ");
cmd.Parameters.Add(new SqlParameter("@DeleteTime", SqlDbType.DateTime)).Value = Convert.ToDateTime(txtDeleteTime.Text);
cmd.Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 50)).Value = Session["UserName"].ToString();
try
{
con.Open();
if (cmd.ExecuteNonQuery() > 0)
{
eMessage.Message("发布成功！", UpdatePanel1, this);
}
}
catch (SqlException err)
{
eMessage.Message(err);
eMessage.Message("与数据库连接发生故障！详细信息：" + err.Message, UpdatePanel1, this);
}
finally
{
if (con != null)
{
con.Close();
}
}
}
}
protected void btnOdemeIleri_Click(object sender, EventArgs e)
{
Page.Validate();
if (CreditCardNumber.Text.Length == 16 && CVC2.Text.Length == 3 && IsValid && CardOwner.Text.Length > 4 && Data.CreditCardValidation.ValidateCardNumber(CreditCardNumber.Text))
{
Ay = dlistAYtmp.SelectedValue;
Yil = dlistYILtmp.SelectedValue;
btnIleri();
}
else if (!Data.CreditCardValidation.ValidateCardNumber(CreditCardNumber.Text))
{
RegularExpressionValidator1.IsValid = false;
//RegularExpressionValidator1.ErrorMessage = "Test Başarısız";
RegularExpressionValidator1.Text = "Test Başarısız";
}
else
{
RequiredFieldValidator1.Validate();
RequiredFieldValidator2.Validate();
RequiredFieldValidator3.Validate();
}
}
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 recover_button_click(object sender, EventArgs e)
{
RegularExpressionValidator3.Validate();
RequiredFieldValidator3.Validate();
if (RegularExpressionValidator3.IsValid == false ||
RequiredFieldValidator3.IsValid == false)
{
login_users.Visible = false;
current_users_panel.Visible = false;
new_users_panel.Visible = false;
user_account_panel.Visible = false;
recover_password.Visible = true;
return;
}
String messageString = "";
List <User> allUsersList = Application["AllUsersList"] as List <User>;
String email_id = email_T2.Text;
int tempAccessCode = 0;
if ((Application["AllUsersList"] != null) && (check_Existing_User(allUsersList, email_id)))
{
for (int i = 0; i < allUsersList.Count; i++)
{
if (allUsersList[i].EmailAddress.Equals(email_id))
{
// get accessCode from the database
String connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
String select = "select accessCode from ParabA2_WADsp16_users" +
" where emailAddress = '" +
allUsersList[i].EmailAddress + "'";
SqlCommand command = new SqlCommand(select, conn);
try
{
conn.Open();
SqlDataReader sqlReader = command.ExecuteReader();
while (sqlReader.Read())
{
tempAccessCode = (int)sqlReader["accessCode"];
}
String header = "Recover Password";
String subject = "We have recovered your Access Code!";
String body = "Valued Customer,<br/>Thank you for contacting us. Your access code is " + tempAccessCode.ToString() + ".<br/>Thank You.<br/><br/>T & P Delivery Service – Security Team";
if (send_mail_to_user(allUsersList[i].EmailAddress, header, subject, body))
{
messageString = "alert('Your Access code has been sent to the email address in file');";
}
}
finally
{
conn.Close();
}
break;
}
}
//send email logic
login_users.Visible = true;
current_users_panel.Visible = true;
new_users_panel.Visible = false;
user_account_panel.Visible = false;
recover_password.Visible = false;
}
else
{
messageString = "alert('Sorry Your Email Account cannot be verified');";
login_users.Visible = false;
current_users_panel.Visible = false;
new_users_panel.Visible = false;
user_account_panel.Visible = false;
recover_password.Visible = true;
}
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", messageString, true);
}
