/// <summary> /// บันทึก Log การส่งอีเมล์จากระบบ Template /// </summary> /// <param name="UID">EmailTemplateUID</param> /// <param name="From">จากเมล์</param> /// <param name="To">ถึงเมล์</param> /// <param name="Cc">แนบเมล์</param> /// <param name="Bcc">ไม่เปิดเผยเมล์</param> /// <param name="Result">ผลการส่ง</param> /// <returns>true=บันทึกสำเร็จ , false=บันทึกไม่สำเร็จ</returns> private bool SendTemplateLog(string UID, string From, string To, string Cc, string Bcc, string Result) { #region Variable bool rtnValue = false; clsSQL clsSQL = new clsSQL(); clsSecurity clsSecurity = new clsSecurity(); clsNet clsNet = new clsNet(); string outSQL; #endregion #region SQL Query if (clsSQL.Insert( "EmailTemplateLog", new string[, ] { { "UID", clsSQL.GetNewID("UID", "EmailTemplateLog", "", dbType, cs).ToString() }, { "EmailTemplateUID", UID }, { "EmailFrom", "'" + clsSQL.CodeFilter(From) + "'" }, { "EmailTo", "'" + clsSQL.CodeFilter(To) + "'" }, { "EmailCc", "'" + clsSQL.CodeFilter(Cc) + "'" }, { "EmailBcc", "'" + clsSQL.CodeFilter(Bcc) + "'" }, { "Result", "'" + clsSQL.CodeFilter(Result) + "'" }, { "CWhen", "GETDATE()" }, { "CUser", "0" }, { "CIP", "'" + clsNet.IPGet() + "'" }, { "CHostname", "'" + clsNet.ComNameGet() + "'" } }, new string[, ] { {} }, dbType, cs, out outSQL)) { rtnValue = true; } #endregion return(rtnValue); }
protected void btSubmit_Click(object sender, EventArgs e) { #region Validation if (!ucCaptchaEncrypt1.Checker()) { lblCaptcha.Text = clsDefault.AlertMessageColor("คำตอบไม่ถูกต้อง", clsDefault.AlertType.Fail); lblCaptcha.Focus(); return; } #endregion #region Authorize if (!clsSecurity.LoginChecker() && (txtCName.Text.Trim() == "" || txtCEmail.Text.Trim() == "")) { //ucColorBox1.Redirect("/Webboard/", "กรุณาล็อคอิน หรือ ระบุชื่อและอีเมล์ก่อนส่งข้อมูล"); ucColorBox1.Alert("เกิดข้อผิดพลาด", "กรุณาล็อคอิน หรือ กรอกชื่อและอีเมล์ก่อน", AlertImage: ucColorBox.Alerts.Fail); return; } #endregion #region Variable clsIO clsIO = new clsIO(); StringBuilder strSQL = new StringBuilder(); int id = 0; string outSQL; string outErrorMessage; string outFilename; string photoName = ""; #endregion #region Update if (clsDefault.URLRouting("id") != "" && clsDefault.URLRouting("command") == "Edit") { id = int.Parse(clsDefault.URLRouting("id")); #region Photo Upload if (fuPhoto.HasFile) { if (clsIO.UploadPhoto( fuPhoto, pathUpload, "Q" + id.ToString(), out outErrorMessage, out outFilename, maxWidth: photoWidth, maxHeight: photoHeight)) { photoName = outFilename; } else { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail); return; } } #endregion if (clsSQL.Update(tableDefault, new string[, ] { { "WebboardGroupUID", ddlWebboardGroup.SelectedItem.Value }, { "Photo", (photoName == ""?"Photo":"'" + pathUpload + photoName + "'") }, { "Name", "'" + clsSQL.CodeFilter(ReservedWords(txtName.Text)) + "'" }, { "Detail", "'" + clsSQL.CodeFilter(ReservedWords(ucDetail.Text)) + "'" }, { "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeywords.Text) + "'" }, { "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" }, { "Status", (ddlStatus.SelectedItem.Value != "N"?"'" + ddlStatus.SelectedItem.Value + "'":"null") }, { "MUser", (clsSecurity.LoginChecker()?clsSecurity.LoginUID:"0") }, { "MWhen", "GETDATE()" }, { "MIPAddress", "'" + clsNet.IPGet() + "'" }, { "MComputername", "'" + clsNet.ComNameGet() + "'" }, { "Sort", clsSQL.CodeFilter(txtSort.Text) }, { "Active", "'" + (cbActive.Checked ? "1" : "0") + "'" } }, new string[, ] { { parameterChar + "UID", id.ToString() } }, "UID=" + parameterChar + "UID", dbType, cs, out outSQL)) { ucColorBox1.ReloadParent(); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion #region Insert else { #region Find New ID id = clsSQL.GetNewID("UID", tableDefault, "", dbType, cs); if (id == 0) { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล", "ไม่สามารถหา UID ใหม่ได้", AlertImage: ucColorBox.Alerts.Fail); return; } #endregion #region Photo Upload if (fuPhoto.HasFile) { if (clsIO.UploadPhoto( fuPhoto, pathUpload, "Q" + id.ToString(), out outErrorMessage, out outFilename, maxWidth: photoWidth, maxHeight: photoHeight)) { photoName = outFilename; } else { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail); return; } } #endregion if (clsSQL.Insert(tableDefault, new string[, ] { { "UID", id.ToString() }, { "WebboardGroupUID", ddlWebboardGroup.SelectedItem.Value }, { "Photo", (photoName == ""?"''":"'" + pathUpload + photoName + "'") }, { "Name", "'" + clsSQL.CodeFilter(ReservedWords(txtName.Text)) + "'" }, { "Detail", "'" + clsSQL.CodeFilter(ReservedWords(ucDetail.Text)) + "'" }, { "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeywords.Text) + "'" }, { "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" }, { "Status", (ddlStatus.SelectedItem.Value != "N"?"'" + ddlStatus.SelectedItem.Value + "'":"null") }, { "Views", "0" }, { "CName", (txtCName.Text.Trim() == ""?"null":"'" + clsSQL.CodeFilter(txtCName.Text) + "'") }, { "CEmail", (txtCEmail.Text.Trim() == ""?"null":"'" + clsSQL.CodeFilter(txtCEmail.Text) + "'") }, { "CUser", (clsSecurity.LoginChecker()?clsSecurity.LoginUID:"0") }, { "CWhen", "GETDATE()" }, { "CIPAddress", "'" + clsNet.IPGet() + "'" }, { "CComputername", "'" + clsNet.ComNameGet() + "'" }, { "MUser", (clsSecurity.LoginChecker()?clsSecurity.LoginUID:"0") }, { "MWhen", "GETDATE()" }, { "MIPAddress", "'" + clsNet.IPGet() + "'" }, { "MComputername", "'" + clsNet.ComNameGet() + "'" }, { "Sort", clsSQL.CodeFilter(txtSort.Text) }, { "Active", "'" + (approveEnable != "1"?"1":"0") + "'" } }, new string[, ] { { } }, dbType, cs, out outSQL)) { string outMessage; clsMail clsMail = new clsMail(); if (approveEnable != "1") { clsMail.SendTemplate( "WebboardTopicAlert", clsMail.GetEmailList("GlobalFrom"), clsMail.GetEmailList("WebboardTo"), new string[, ] { { "[Username]", clsSecurity.LoginUsername }, { "[CName]", clsSQL.CodeFilter(txtCName.Text) }, { "[CEmail]", clsSQL.CodeFilter(txtCName.Text) }, { "[IPAddress]", clsNet.IPGet() }, { "[ComputerName]", clsNet.ComNameGet() }, { "[Name]", clsDefault.URLRoutingFilter(txtName.Text) }, { "[Detail]", clsSQL.CodeFilter(ucDetail.Text) }, { "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") }, { "[WebboardGroupUID]", ddlWebboardGroup.SelectedItem.Value }, { "[UID]", id.ToString() } }, out outMessage); ucColorBox1.ReloadParent(); } else { clsMail.SendTemplate( "WebboardTopicApprove", clsMail.GetEmailList("GlobalFrom"), clsMail.GetEmailList("WebboardTo"), new string[, ] { { "[Username]", clsSecurity.LoginUsername }, { "[CName]", clsSQL.CodeFilter(txtCName.Text) }, { "[CEmail]", clsSQL.CodeFilter(txtCName.Text) }, { "[IPAddress]", clsNet.IPGet() }, { "[ComputerName]", clsNet.ComNameGet() }, { "[Name]", clsDefault.URLRoutingFilter(txtName.Text) }, { "[Detail]", clsSQL.CodeFilter(ucDetail.Text) }, { "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") }, { "[WebboardGroupUID]", ddlWebboardGroup.SelectedItem.Value }, { "[UID]", id.ToString() } }, out outMessage); ucColorBox1.Redirect(webDefault + clsDefault.URLRouting("group") + "/", "ดำเนินการเสร็จสิ้น", "เมื่อเจ้าหน้าที่ทำการตรวจสอบข้อมูลคำถามของคุณเรียบร้อยแล้ว จะทำการเผยแพร่โดยเร็ว"); } } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion }
/// <summary> /// บันทึก Log การส่งอีเมล์จากระบบ Template /// </summary> /// <param name="UID">EmailTemplateUID</param> /// <param name="From">จากเมล์</param> /// <param name="To">ถึงเมล์</param> /// <param name="Cc">แนบเมล์</param> /// <param name="Bcc">ไม่เปิดเผยเมล์</param> /// <param name="Result">ผลการส่ง</param> /// <returns>true=บันทึกสำเร็จ , false=บันทึกไม่สำเร็จ</returns> private bool SendTemplateLog(string UID, string From, string To, string Cc, string Bcc, string Result) { #region Variable bool rtnValue = false; clsSQL clsSQL = new clsSQL(); clsSecurity clsSecurity=new clsSecurity(); clsNet clsNet = new clsNet(); string outSQL; #endregion #region SQL Query if(clsSQL.Insert( "EmailTemplateLog", new string[,]{ {"UID",clsSQL.GetNewID("UID","EmailTemplateLog","",dbType,cs).ToString()}, {"EmailTemplateUID",UID}, {"EmailFrom","'"+clsSQL.CodeFilter(From)+"'"}, {"EmailTo","'"+clsSQL.CodeFilter(To)+"'"}, {"EmailCc","'"+clsSQL.CodeFilter(Cc)+"'"}, {"EmailBcc","'"+clsSQL.CodeFilter(Bcc)+"'"}, {"Result","'"+clsSQL.CodeFilter(Result)+"'"}, {"CWhen","GETDATE()"}, {"CUser","0"}, {"CIP","'"+clsNet.IPGet()+"'"}, {"CHostname","'"+clsNet.ComNameGet()+"'"}}, new string[,]{{}}, dbType, cs, out outSQL)) { rtnValue = true; } #endregion return rtnValue; }