protected void btDelete_Click(object sender, EventArgs e) { var clsDefault = new clsDefault(); try { var fi = new FileInfo(Server.MapPath(hidFileName.Value)); if (fi.Exists) { fi.Delete(); BindDetail(Request.QueryString["id"].ToString()); lblSQL.Text = clsDefault.AlertMessageFlat("ลบไฟล์เสร็จสมบูรณ์", clsDefault.AlertType.Success); } else { lblSQL.Text = clsDefault.AlertMessageFlat("ไม่พบไฟล์ : " + fi.FullName, clsDefault.AlertType.Fail); } } catch (Exception ex) { lblSQL.Text = clsDefault.AlertMessageFlat("เกิดข้อผิดพลาดขณะลบไฟล์ : " + ex.Message, clsDefault.AlertType.Fail); } }
protected void btSubmit_Click(object sender, EventArgs e) { #region Variable #endregion #region Procedure if (fuPhoto.HasFile) { if (!Path.GetExtension(fuPhoto.FileName).Contains("jpg")) { lblSQL.Text = clsDefault.AlertMessageFlat("โปรดเลือกภาพ JPG เท่านั้น", clsDefault.AlertType.Warn); return; } try { fuPhoto.SaveAs(Server.MapPath("/Images/bgHome.jpg")); getDefault(); lblSQL.Text = clsDefault.AlertMessageFlat("อัพโหลดรูปภาพเสร็จสิ้น * หากภาพไม่อัพเดท โปรดกดปุ่ม F5 เพื่อรีเฟรชหน้าเว็บ", clsDefault.AlertType.Success); } catch (Exception ex) { lblSQL.Text = clsDefault.AlertMessageFlat(ex.Message, clsDefault.AlertType.Fail); } } #endregion }
protected void btSendMail_Click(object sender, EventArgs e) { #region Variable var strSQL = new StringBuilder(); var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); var clsDefault = new clsDefault(); #endregion #region Procedure if (hidFileName.Value != "") { #region SQLQuery strSQL.Append("INSERT INTO "); strSQL.Append("P5_Job"); strSQL.Append("(FileName,Name,Detail,ContactName,ContactPhone,ContactEmail,Location,CWhen,MWhen)"); strSQL.Append("VALUES("); strSQL.Append("'" + hidFileName.Value.Trim() + "',"); strSQL.Append("'" + txtName.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtDetail.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtContactName.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtContactPhone.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtContactEmail.Text.SQLQueryFilter() + "',"); strSQL.Append("'" + txtLocation.Text.SQLQueryFilter() + "',"); strSQL.Append("GETDATE(),"); strSQL.Append("GETDATE()"); strSQL.Append(");"); #endregion if (clsSQL.Execute(strSQL.ToString())) { #region MailSender var clsMail = new clsMail(); var outMessage = ""; //Send to Admin try { if (!clsMail.SendByGmail( "*****@*****.**", "G00des1gn", System.Configuration.ConfigurationManager.AppSettings["mailTo"], "P5GraphicDesign : มีใบงานใหม่ '" + txtName.Text.SQLQueryFilter() + "'", string.Format("<h1>มีใบงานใหม่ : {0}</h1><div><b>จาก</b> : {1}</div><div><b>เบอร์โทร</b> : {2}</div><div><b>รายละเอียด</b> : {3}</div><hr/><a href='http://www.p5graphicdesign.com/Management/Job.aspx'>คลิกที่นี่เพื่อดูข้อมูล</a>", txtName.Text.SQLQueryFilter(), txtContactName.Text.SQLQueryFilter(), txtContactPhone.Text.SQLQueryFilter(), txtDetail.Text.SQLQueryFilter()), out outMessage, "P5GraphicDesign : มีใบงานใหม่ '" + txtName.Text.SQLQueryFilter() + "'", "*****@*****.**", "", "", System.Net.Mail.MailPriority.High)) { Response.Write("Send to Admin : " + outMessage); //ucColorBox1.Alert("พบข้อผิดพลาดขณะส่งเมล์", outMessage, AlertImage: ucColorBox.Alerts.Fail); return; } } catch (Exception exMailToAdmin) { Response.Write(exMailToAdmin.Message); } if (txtContactEmail.Text.Trim() != "" && txtContactEmail.Text.Contains("@") && txtContactEmail.Text.Contains(".")) { //Send to Customer try { if (!clsMail.SendByGmail( "*****@*****.**", "G00des1gn", txtContactEmail.Text.Trim(), "P5GraphicDesign : ได้รับใบงาน '" + txtName.Text.SQLQueryFilter() + "' ของคุณแล้ว", string.Format("<h1>ได้รับใบงานใหม่เรียบร้อยแล้ว : {0}</h1><div><b>จาก</b> : {1}</div><div><b>เบอร์โทร</b> : {2}</div><div><b>รายละเอียด</b> : {3}</div>", txtName.Text.SQLQueryFilter(), txtContactName.Text.SQLQueryFilter(), txtContactPhone.Text.SQLQueryFilter(), txtDetail.Text.SQLQueryFilter()), out outMessage, "P5GraphicDesign : ได้รับใบงาน '" + txtName.Text.SQLQueryFilter() + "' ของคุณแล้ว", "", "", "", System.Net.Mail.MailPriority.High)) { Response.Write(outMessage); //ucColorBox1.Alert("พบข้อผิดพลาดขณะส่งเมล์", outMessage, AlertImage: ucColorBox.Alerts.Fail); return; } } catch (Exception exMailToCustomer) { Response.Write("Send to Customer : " + exMailToCustomer.Message); } } #endregion txtName.Text = ""; txtDetail.Text = ""; txtContactName.Text = ""; txtContactPhone.Text = ""; txtLocation.Text = ""; hidFileName.Value = ""; lblSendMailAlert.Text = clsDefault.AlertMessageFlat("บันทึกข้อมูลเสร็จสมบูรณ์", clsDefault.AlertType.Success); lblSendMailAlert.Focus(); } else { lblSendMailAlert.Text = clsDefault.AlertMessageFlat("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>" + strSQL.ToString(), clsDefault.AlertType.Fail); lblSendMailAlert.Focus(); } } else { lblSendMailAlert.Text = clsDefault.AlertMessageFlat("โปรดเลือกอัพโหลดไฟล์ก่อนทำการส่งข้อมูล", clsDefault.AlertType.Fail); lblSendMailAlert.Focus(); } #endregion }