protected void Button1_Click(object sender, EventArgs e)
{
RegularExpressionValidator6.Validate();
// 라벨 초기화
name_label.Text = "";
email_label.Text = "";
if (RegularExpressionValidator6.IsValid && TextBox1.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 name = \'" + TextBox1.Text + "\' WHERE id = \'" + Application["id"].ToString().Trim() + "\'";
try
{
Con.Open();
// SQL UPDATE 문 생성
int rowsAffected = Cmd.ExecuteNonQuery();
// ExecuteNonQuery()문은 CREATE, ALTER, DROP, INSERT, UPDATE, DELETE 문을 수행할때 사용
if (rowsAffected == 1)
{
name_label.Text = "수정되었습니다!";
name_label2.Text = TextBox1.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 TextBox1_TextChanged(object sender, EventArgs e)
{
RegularExpressionValidator6.Validate();//유효성 검사
}
protected void submitReq_Click(object sender, EventArgs e)
{
RequiredFieldValidator11.Validate();
RequiredFieldValidator10.Validate();
RequiredFieldValidator9.Validate();
RegularExpressionValidator6.Validate();
RequiredFieldValidator12.Validate();
if (RequiredFieldValidator11.IsValid == false ||
RequiredFieldValidator10.IsValid == false ||
RequiredFieldValidator9.IsValid == false ||
RegularExpressionValidator6.IsValid == false ||
RequiredFieldValidator12.IsValid == false)
{
return;
}
var pickup_Address = loginT1.Text;
var recipient_Address = loginT2.Text;
var recipient_phone = loginT3.Text;
var description = loginT4.Text;
DeliveryDetail d = new DeliveryDetail();
User aUser = Session["CurrentUser"] as User;
d.PickupAddress = pickup_Address;
d.ReceipientAddress = recipient_Address;
d.ReceipientPhone = recipient_phone;
d.Description = description;
aUser.DeliveryDetailsList.Add(d);
// Storing into table Delivery Request.
String connStr = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
String insert = "Insert into ParabA2_WADsp16_delivery_request(accessCode, pickupAddress, receipientAddress, receipientPhone, description) " +
"values(" + aUser.AccessCode + ", '" +
pickup_Address + "', '" +
recipient_Address + "', '" +
recipient_phone + "', '" +
description + "')";
SqlCommand command = new SqlCommand(insert, conn);
try
{
conn.Open();
command.BeginExecuteNonQuery();
}
finally
{
conn.Close();
}
String header = "Delivery Request";
String subject = "T & P Delivery Service - New Request Confirmation";
String body = "Valued Customer " + aUser.FullName + ",<br/>You have requested a new delivery. Details shown below. <br/> <br/>" +
"Pickup Address : " + d.PickupAddress + "<br/>" +
"Recipient Address : " + d.ReceipientAddress + "<br/>" +
"Description : " + d.Description + "<br/><br/>" +
"Please note that any modifications made after 2 hours of submission of the original request shall be rejected.<br/><br/>" +
"Thank You again for keeping trust on us.<br/><br/>T & P Delivery Service Team";
String email = aUser.EmailAddress;
if (send_mail_to_user(email, header, subject, body))
{
ScriptManager.RegisterClientScriptBlock(this, typeof(Page), "", "alert('Thank You for submitting a delivery request." +
" We are more than happy to serve you. An invoice email has been sent to the email address in our file');", true);
}
Session["CurrentUser"] = aUser;
login_users.Visible = false;
current_users_panel.Visible = false;
new_users_panel.Visible = false;
user_account_panel.Visible = true;
recover_password.Visible = false;
}
