private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); clsIO clsIO = new clsIO(); #endregion #region Delete Photo #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Icon "); strSQL.Append("FROM "); strSQL.Append("MedicalCenter "); strSQL.Append("WHERE "); strSQL.Append("MedicalCenterGroupUID=" + id); #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); strSQL.Length = 0; strSQL.Capacity = 0; if (dt != null && dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["Icon"] != DBNull.Value) { clsIO.FileExist(dt.Rows[i]["Icon"].ToString(), true); } } dt = null; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + parameterChar + "UID"); #endregion if (clsSQL.Execute(strSQL.ToString(), new string[, ] { { parameterChar + "UID", id } }, dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
private void LoginChecker() { #region Login Checker if (clsSecurity.LoginChecker()) { pnLogin.Visible = false; pnLogout.Visible = true; lblUsername.Text = clsSecurity.LoginUsername; if (_showGroup) { lblGroupName.Text = "<div title='Group' style='padding:5px;'>" + "<span class='Icon16 Info'></span>" + clsSecurity.LoginGroup + "</div>"; } if (clsSecurity.GetAuthority(clsSecurity.LoginGroupAuthority, "Admin") == "1" || clsSecurity.GetAuthority(clsSecurity.LoginGroupAuthority, "HR") == "1") { lblAuthority.Text = "<div style='padding-top:8px;padding-left:5px;'><a href='" + UrlManagement + "'><span class='Icon16 Config'/></a></div>"; } } else { pnLogin.Visible = true; pnLogout.Visible = false; } #endregion }
private void LoginChecker() { #region Login Checker if (clsSecurity.LoginChecker()) { pnLogin.Visible = false; pnLogout.Visible = true; lblUsername.Text = clsSecurity.LoginUsername; if (_showGroup) { lblGroupName.Text = "<div title='Group' style='padding:5px;'>" + "<span class='Icon16 Info'></span>" + clsSecurity.LoginGroup + "</div>"; } if (UrlManagement.Trim().Length > 0) { if (clsSecurity.LoginGroup.ToLower() == "admin" || clsSecurity.GetAuthority(clsSecurity.LoginGroupAuthority, "Admin") == "1") { lblAuthority.Text = "<div style=''><a href='" + UrlManagement + "'>Management</a></div>"; } } } else { pnLogin.Visible = true; pnLogout.Visible = false; } #endregion }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin") && !clsSecurity.LoginChecker("hr")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var clsIO = new clsIO(); var strSQL = new StringBuilder(); #endregion #region Procedure #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (clsSecurity.LoginChecker()) { txtUsername.Enabled = false; #region Admin Checker if (clsSecurity.LoginChecker("admin")) { pnAdmin.Visible = true; } else { pnAdmin.Visible = false; } #endregion BindDefault(); } else { //clsDefault.Redirect("/Register", "กรุณาสมัครสมาชิก หรือ ล็อคอิน ก่อนเข้าใช้งาน"); ucColorBox1.Redirect("/Register", "กรุณาสมัครสมาชิก หรือ ล็อคอินก่อนเข้าใช้งาน"); } } }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var clsIO = new clsIO(); var strSQL = new StringBuilder(); #endregion #region Procedure #region Delete Photo /* #region SQL Query * strSQL.Append("SELECT "); * strSQL.Append("Icon "); * strSQL.Append("FROM "); * strSQL.Append(tableDefault + " "); * strSQL.Append("WHERE "); * strSQL.Append("UID=" + id); #endregion * string photoDelete = clsSQL.Return(strSQL.ToString(), dbType, cs); * if (!string.IsNullOrEmpty(photoDelete)) * { * clsIO.FileExist(photoDelete, true); * } * strSQL.Length = 0; strSQL.Capacity = 0; */ #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #endregion }
protected void btDGSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin") && !clsSecurity.LoginChecker("hr")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable StringBuilder strSQL = new StringBuilder(); #endregion #region SQL Builder for (int i = 0; i < gvDefault.Rows.Count; i++) { #region CurrentPageChecker var cbDGCurrentPage = (CheckBox)gvDefault.Rows[i].FindControl("cbDGCurrentPage"); if (!cbDGCurrentPage.Checked) { continue; } #endregion Label lblDGID = (Label)gvDefault.Rows[i].FindControl("lblDGID"); CheckBox cbDGActive = (CheckBox)gvDefault.Rows[i].FindControl("cbDGActive"); TextBox txtDGSort = (TextBox)gvDefault.Rows[i].FindControl("txtDGSort"); if (lblDGID != null && cbDGActive != null) { #region SQL Query strSQL.Append("UPDATE "); strSQL.Append(tableDefault + " "); strSQL.Append("SET "); strSQL.Append("Sort=" + clsSQL.CodeFilter(txtDGSort.Text) + ","); strSQL.Append("StatusFlag='" + (cbDGActive.Checked ? "A" : "D") + "' "); strSQL.Append("WHERE "); strSQL.Append("UID=" + lblDGID.Text); strSQL.Append(";"); #endregion } } #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect("/Management/" + webDefault, "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); } else { ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail); } }
private void BindUser() { if (clsSecurity.LoginChecker()) { #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region DataBuilder #region SQL Query strSQL.Append("SELECT "); strSQL.Append("PName,FName,LName,HN,Mobile,Phone,Email "); strSQL.Append("FROM "); strSQL.Append("[User] "); strSQL.Append("WHERE "); strSQL.Append("[UID]=" + parameterChar + "UID"); #endregion dt = clsSQL.Bind(strSQL.ToString(), new string[, ] { { parameterChar + "UID", clsSecurity.LoginUID } }, dbType, cs); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["PName"] != DBNull.Value && dt.Rows[0]["PName"].ToString() != "") { ddlPName.SelectedValue = dt.Rows[0]["PName"].ToString(); } if (dt.Rows[0]["FName"] != DBNull.Value && dt.Rows[0]["FName"].ToString() != "") { txtFName.Text = dt.Rows[0]["FName"].ToString(); } if (dt.Rows[0]["LName"] != DBNull.Value && dt.Rows[0]["LName"].ToString() != "") { txtLName.Text = dt.Rows[0]["LName"].ToString(); } if (dt.Rows[0]["Email"] != DBNull.Value && dt.Rows[0]["Email"].ToString() != "") { txtEmail.Text = dt.Rows[0]["Email"].ToString(); } if (dt.Rows[0]["Phone"] != DBNull.Value && dt.Rows[0]["Phone"].ToString() != "") { txtPhone.Text += dt.Rows[0]["Phone"].ToString() + ","; } if (dt.Rows[0]["Mobile"] != DBNull.Value && dt.Rows[0]["Mobile"].ToString() != "") { txtPhone.Text += dt.Rows[0]["Mobile"].ToString() + ","; } txtPhone.Text = clsDefault.LastStringRemover(txtPhone.Text, ","); } #endregion } }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); clsIO clsIO = new clsIO(); string photoName; #endregion #region Delete Photo photoName = clsSQL.Return( "SELECT Icon FROM " + tableDefault + " WHERE UID=" + parameterChar + "UID", new string[, ] { { parameterChar + "UID", id } }, dbType, cs); clsIO.FileExist(photoName, true); #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + parameterChar + "UID"); #endregion if (clsSQL.Execute(strSQL.ToString(), new string[, ] { { parameterChar + "UID", id } }, dbType, cs)) { ucColorBox1.Redirect(webDefault); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (clsSecurity.LoginChecker("admin")) { pnManage.Visible = true; } if (clsDefault.URLRouting("id") == "") { DefaultBuilder(); } else { DetailBuilder(clsDefault.URLRouting("id")); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (clsSecurity.LoginChecker()) { //clsDefault.Redirect("/Profile", "คุณสมัครสมาชิกไว้แล้ว"); ucColorBox1.Redirect("/Profile", "คุณสมัครสมาชิกไว้แล้ว"); } } }
protected void btDGSubmit_Click(object sender, EventArgs e) { if (!clsSecurity.LoginChecker("admin")) { //clsDefault.Redirect("/Management/Login.aspx", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } StringBuilder strSQL = new StringBuilder(); for (int i = 0; i < gvDefault.Rows.Count; i++) { #region CurrentPageChecker var cbDGCurrentPage = (CheckBox)gvDefault.Rows[i].FindControl("cbDGCurrentPage"); if (!cbDGCurrentPage.Checked) { continue; } #endregion Label lblDGID = (Label)gvDefault.Rows[i].FindControl("lblDGID"); DropDownList ddlDGUserGroup = (DropDownList)gvDefault.Rows[i].FindControl("ddlDGUserGroup"); CheckBox cbDGActive = (CheckBox)gvDefault.Rows[i].FindControl("cbDGActive"); if (lblDGID != null && ddlDGUserGroup != null && cbDGActive != null) { #region SQL Query strSQL.Append("UPDATE "); strSQL.Append("[User] "); strSQL.Append("SET "); strSQL.Append("UserGroupUID=" + ddlDGUserGroup.SelectedItem.Value + ","); strSQL.Append("Active='" + (cbDGActive.Checked ? "1" : "0") + "' "); strSQL.Append("WHERE "); strSQL.Append("UID=" + lblDGID.Text); strSQL.Append(";"); #endregion } } if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { //clsDefault.Redirect("/Management/User.aspx", "แก้ไขข้อมูลเสร็จสิ้น"); ucColorBox1.Redirect("/Management/User.aspx", "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); } else { //lblDG.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะบันทึกข้อมูลในฐานข้อมูล กรุณาลองใหม่" + "<br/>" + strSQL.ToString(), "fail"); ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail); } }
protected void btSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion StringBuilder strSQL = new StringBuilder(); int id = 0; string outSQL; #region Update if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit") { id = int.Parse(Request.QueryString["id"].ToString()); if (clsSQL.Update("Content", new string[, ] { { "Content", "N'" + clsSQL.CodeFilter(ucContent.Text) + "'" }, { "MUser", "'" + clsSecurity.LoginUID + "'" }, { "MWhen", "GETDATE()" }, { "Sort", clsDefault.CodeFilter(txtSort.Text) }, { "Active", "'" + (cbActive.Checked ? "1" : "0") + "'" } }, new string[, ] { { } }, "UID=" + id.ToString(), dbType, cs, out outSQL)) { ucColorBox1.ReloadParent(); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion }
protected void Page_Load(object sender, EventArgs e) { if (security.LoginChecker() == true) { clsCustomer customer = new clsCustomer(); DataTable dt = new DataTable(); dt = customer.SearchCustomerByUsername(security.LoginUsername); if (dt.Rows.Count > 0 && dt != null) { txtName.Text = dt.Rows[0]["Forename"].ToString(); txtSurname.Text = dt.Rows[0]["Surname"].ToString(); if (dt.Rows[0]["SEX"].ToString() == "M") { rdbMale.Checked = true; } else { rdbFemale.Checked = true; } if (!string.IsNullOrEmpty(dt.Rows[0]["IDCard"].ToString())) { txtIDCardNo.Text = dt.Rows[0]["IDCard"].ToString(); } txtAddress.Text = dt.Rows[0]["Address"].ToString(); txtDistrict.Text = dt.Rows[0]["District"].ToString(); txtPrefecture.Text = dt.Rows[0]["Prefecture"].ToString(); txtProvince.Text = dt.Rows[0]["Province"].ToString(); txtZipcode.Text = dt.Rows[0]["Zipcode"].ToString(); txtEmail.Text = dt.Rows[0]["Email"].ToString(); txtTel.Text = dt.Rows[0]["Tel"].ToString(); txtDetail.Text = dt.Rows[0]["Detail"].ToString(); } } BindSelectedPackage(); BindContent(); }
protected void btDGSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); var outError = ""; var statusFlag = ""; #endregion #region SQL Builder for (int i = 0; i < dlDefault.Items.Count; i++) { Label lblDGID = (Label)dlDefault.Items[i].FindControl("lblDGID"); Label lblDGName = (Label)dlDefault.Items[i].FindControl("lblDGName"); CheckBox cbDGActive = (CheckBox)dlDefault.Items[i].FindControl("cbDGActive"); if (lblDGID != null && lblDGName != null && cbDGActive != null) { statusFlag = clsSQL.Return("SELECT StatusFlag FROM Highlight WHERE GlobalUID=" + lblDGID.Text + " AND GlobalName='" + lblDGName.Text + "';", dbType, cs); if (statusFlag != "" && statusFlag != (cbDGActive.Checked?"A":"D")) { #region UPDATE SQL Query strSQL.Append("UPDATE "); strSQL.Append("Highlight "); strSQL.Append("SET "); strSQL.Append("MWhen=GETDATE(),"); strSQL.Append("MUser="******","); strSQL.Append("StatusFlag='" + (cbDGActive.Checked?"A":"D") + "' "); strSQL.Append("WHERE "); strSQL.Append("GlobalUID=" + lblDGID.Text + " "); strSQL.Append("AND GlobalName='" + lblDGName.Text + "'"); strSQL.Append(";"); #endregion } else if (statusFlag == "") { if (cbDGActive.Checked) { #region INSERT SQL Query strSQL.Append("INSERT INTO "); strSQL.Append("Highlight "); strSQL.Append("(GlobalUID,GlobalName,CWhen,CUser,MWhen,MUser,Sort,StatusFlag)"); strSQL.Append("VALUES("); strSQL.Append(lblDGID.Text + ","); strSQL.Append("'" + lblDGName.Text + "',"); strSQL.Append("GETDATE(),"); strSQL.Append(clsSecurity.LoginUID + ","); strSQL.Append("GETDATE(),"); strSQL.Append(clsSecurity.LoginUID + ","); strSQL.Append("0,"); strSQL.Append("'A'"); strSQL.Append(")"); strSQL.Append(";"); #endregion } } if (strSQL.Length > 0) { if (!clsSQL.Execute(strSQL.ToString(), dbType, cs, out outError)) { ucColorBox1.Alert("SQL Error", outError, AlertImage: ucColorBox.Alerts.Fail); return; } strSQL.Length = 0; strSQL.Capacity = 0; } } } #endregion ucColorBox1.Redirect("/Management/Highlight.aspx" + clsDefault.QueryStringMerge(), "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย"); }
private void Delete(string id) { pnDetail.Visible = false; #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable clsIO clsIO = new clsIO(); StringBuilder strSQL = new StringBuilder(); #endregion #region Delete Photo #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Photo "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion string photoDelete = clsSQL.Return(strSQL.ToString(), dbType, cs); if (!string.IsNullOrEmpty(photoDelete)) { clsIO.FileExist(photoDelete, true); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete PhotoPreview #region SQL Query strSQL.Append("SELECT "); strSQL.Append("PhotoPreview "); strSQL.Append("FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion string photoPreviewDelete = clsSQL.Return(strSQL.ToString(), dbType, cs); if (!string.IsNullOrEmpty(photoPreviewDelete)) { clsIO.FileExist(photoPreviewDelete, true); } strSQL.Length = 0; strSQL.Capacity = 0; #endregion #region Delete Database #region SQL Query strSQL.Append("DELETE FROM "); strSQL.Append(tableDefault + " "); strSQL.Append("WHERE "); strSQL.Append("UID=" + id); #endregion if (clsSQL.Execute(strSQL.ToString(), dbType, cs)) { ucColorBox1.Redirect(webDefault + clsDefault.QueryStringRemover(new string[] { "id", "command" })); } else { ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล"); return; } strSQL.Length = 0; strSQL.Capacity = 0; #endregion }
protected void btSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); var id = 0; var outSQL = ""; var photoName = ""; #endregion #region Procedure #region Update if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit") { id = int.Parse(Request.QueryString["id"].ToString()); #region Photo Upload if (fuPhoto.HasFile) { var clsIO = new clsIO(); string outErrorMessage; string outFilename; if (clsIO.UploadPhoto( fuPhoto, pathUpload, tableDefault + 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[, ] { { "Icon", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"Icon") }, { "Name", "'" + txtName.Text.SQLQueryFilter() + "'" }, { "Detail", "'" + txtDetail.Text.SQLQueryFilter() + "'" }, { "Content", "'" + ucContent.Text.SQLQueryFilter() + "'" }, { "NameEN", "'" + txtNameEN.Text.SQLQueryFilter() + "'" }, { "DetailEN", "'" + txtDetailEN.Text.SQLQueryFilter() + "'" }, { "ContentEN", "'" + ucContentEN.Text.SQLQueryFilter() + "'" }, { "MUser", clsSecurity.LoginUID }, { "MWhen", functionGetDate }, { "Sort", txtSort.Text.SQLQueryFilter() }, { "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" } }, new string[, ] { { } }, "UID=" + id.ToString(), out outSQL)) { ucColorBox1.ReloadParent(); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion #region Insert else { id = int.Parse(clsSQL.Return("SELECT ISNULL(MAX(UID),0)+1 FROM " + tableDefault)); #region Photo Upload if (fuPhoto.HasFile) { clsIO clsIO = new clsIO(); string outErrorMessage; string outFilename; if (clsIO.UploadPhoto( fuPhoto, pathUpload, tableDefault + 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[, ] { { "Icon", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"null") }, { "Name", "'" + txtName.Text.SQLQueryFilter() + "'" }, { "Detail", "'" + txtDetail.Text.SQLQueryFilter() + "'" }, { "Content", "'" + ucContent.Text.SQLQueryFilter() + "'" }, { "NameEN", "'" + txtNameEN.Text.SQLQueryFilter() + "'" }, { "DetailEN", "'" + txtDetailEN.Text.SQLQueryFilter() + "'" }, { "ContentEN", "'" + ucContentEN.Text.SQLQueryFilter() + "'" }, { "CUser", clsSecurity.LoginUID }, { "CWhen", functionGetDate }, { "MUser", clsSecurity.LoginUID }, { "MWhen", functionGetDate }, { "Sort", txtSort.Text.SQLQueryFilter() }, { "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" } }, new string[, ] { { } }, out outSQL)) { ucColorBox1.ReloadParent(); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion #endregion }
private void ContentBuilder() { #region Variable StringBuilder strSQL = new StringBuilder(); StringBuilder strScript = new StringBuilder(); DataTable dt = new DataTable(); bool foundChecker = false; int dtIndex = 0; clsSQL clsSQL = new clsSQL(); clsLanguage clsLanguage = new clsLanguage(); clsSecurity clsSecurity = new clsSecurity(); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Language.UID LanguageUID,"); strSQL.Append("Language.Name LanguageName,"); strSQL.Append("Content.UID,"); strSQL.Append("Content.Name,"); strSQL.Append("Content.Detail,"); strSQL.Append("Content.Content "); strSQL.Append("FROM "); strSQL.Append("Content "); strSQL.Append("INNER JOIN Language ON Content.LanguageUID=Language.UID "); strSQL.Append("AND Language.Active='1' "); strSQL.Append("WHERE "); strSQL.Append("Content.Active='1' "); strSQL.Append("AND Content.Name='" + _contentName.Trim() + "' "); strSQL.Append("ORDER BY "); strSQL.Append("Language.Sort ASC"); #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); if (dt != null && dt.Rows.Count > 0) { strScript.Append("<div class='" + (clsSecurity.LoginChecker("Admin") ? "dvContent" : "dvContentNormal") + "'>"); #region Find Language for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["LanguageName"].ToString() == clsLanguage.LanguageCurrent) { foundChecker = true; dtIndex = i; #region Content Builder if (dt.Rows[i]["Content"] != DBNull.Value) { strScript.Append(dt.Rows[i]["Content"].ToString()); } #endregion break; } } #endregion #region Default Builder if (!foundChecker) { if (dt.Rows[0]["Content"] != DBNull.Value) { strScript.Append(dt.Rows[0]["Content"].ToString()); } } #endregion #region Admin Builder if (clsSecurity.LoginChecker("Admin")) { strScript.Append("<div class='dvContentMenu'>"); strScript.Append("<a href='/Management/ContentManage.aspx?id=" + dt.Rows[dtIndex]["UID"].ToString() + "&command=edit' "); strScript.Append("title='แก้ไขข้อมูล' "); if (_modalRefreshOnClose) { strScript.Append("class='cbIFrameRefreshOnClose'"); } else { strScript.Append("class='cbIFrame'"); } strScript.Append(">"); strScript.Append("<span class='Icon16 Edit' />"); strScript.Append("</a>"); strScript.Append("</div>"); } #endregion strScript.Append("</div>"); lblContent.Text = strScript.ToString(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { #region WebboardConfig approveEnable = WebboardConfig("AnonymousEnable"); if (approveEnable != "1") { if (!clsSecurity.LoginChecker()) { pnDetail.Visible = false; lblDefault.Text = clsDefault.AlertMessageColor("กรุณาสมัครสมาชิก หรือ ล็อคอิน ก่อนตั้งคำถาม | <a href='/Register/' target='_Blank'>คลิกที่นี่เพื่อสมัครสมาชิก</a>", clsDefault.AlertType.Info); ucColorBox1.SizeChange(); return; } } #endregion if (clsDefault.URLRouting("group") != "") { webDefault = "/Webboard/" + clsDefault.URLRouting("group") + "/"; #region Authorize if (clsSecurity.LoginChecker()) { dvAnonymous.Visible = false; vadCName.Enabled = false; vadCEmail.Enabled = false; } if (clsSecurity.LoginGroup == "Admin") { dvAdmin.Visible = true; } #endregion if (clsDefault.URLRouting("id") != "") { if (clsDefault.URLRouting("command") == "Edit") { vdPhoto.Enabled = false; BindControl(clsDefault.URLRouting("group")); BindDetail(clsDefault.URLRouting("id")); } else if (clsDefault.URLRouting("command") == "Delete") { pnDetail.Visible = false; Delete(clsDefault.URLRouting("id")); } else if (clsDefault.URLRouting("command") == "Approve") { pnDetail.Visible = false; Approve(clsDefault.URLRouting("id")); } else { ucColorBox1.Redirect(webDefault, "ไม่พบหน้าเว็บที่คุณต้องการ"); } } else { BindControl(clsDefault.URLRouting("group")); } } else { ucColorBox1.Close(); } } }
private void ContentBuilder() { #region Variable StringBuilder strSQL = new StringBuilder(); StringBuilder strScript = new StringBuilder(); DataTable dt = new DataTable(); bool foundChecker = false; int dtIndex=0; clsSQL clsSQL = new clsSQL(); clsLanguage clsLanguage = new clsLanguage(); clsSecurity clsSecurity = new clsSecurity(); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Language.UID LanguageUID,"); strSQL.Append("Language.Name LanguageName,"); strSQL.Append("Content.UID,"); strSQL.Append("Content.Name,"); strSQL.Append("Content.Detail,"); strSQL.Append("Content.Content "); strSQL.Append("FROM "); strSQL.Append("Content "); strSQL.Append("INNER JOIN Language ON Content.LanguageUID=Language.UID "); strSQL.Append("AND Language.Active='1' "); strSQL.Append("WHERE "); strSQL.Append("Content.Active='1' "); strSQL.Append("AND Content.Name='"+_contentName.Trim()+"' "); strSQL.Append("ORDER BY "); strSQL.Append("Language.Sort ASC"); #endregion dt = clsSQL.Bind(strSQL.ToString(), dbType, cs); if (dt != null && dt.Rows.Count > 0) { strScript.Append("<div class='" + (clsSecurity.LoginChecker("Admin") ? "dvContent" : "dvContentNormal") + "'>"); #region Find Language for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["LanguageName"].ToString() == clsLanguage.LanguageCurrent) { foundChecker = true; dtIndex=i; #region Content Builder if (dt.Rows[i]["Content"] != DBNull.Value) { strScript.Append(dt.Rows[i]["Content"].ToString()); } #endregion break; } } #endregion #region Default Builder if (!foundChecker) { if (dt.Rows[0]["Content"] != DBNull.Value) { strScript.Append(dt.Rows[0]["Content"].ToString()); } } #endregion #region Admin Builder if (clsSecurity.LoginChecker("Admin")) { strScript.Append("<div class='dvContentMenu'>"); strScript.Append("<a href='/Management/ContentManage.aspx?id="+dt.Rows[dtIndex]["UID"].ToString()+"&command=edit' "); strScript.Append("title='แก้ไขข้อมูล' "); if (_modalRefreshOnClose) { strScript.Append("class='cbIFrameRefreshOnClose'"); } else { strScript.Append("class='cbIFrame'"); } strScript.Append(">"); strScript.Append("<span class='Icon16 Edit' />"); strScript.Append("</a>"); strScript.Append("</div>"); } #endregion strScript.Append("</div>"); lblContent.Text = strScript.ToString(); } }
private void MenuBuilder() { ucMenuMega.Item item = new ucMenuMega.Item(); clsSecurity clsSecurity = new clsSecurity(); item = new ucMenuMega.Item(); item.UID = 1; //item.ParentUID = 1; item.Name = "จัดการข้อมูลเว็บไซต์"; item.Detail = ""; item.URL = ""; ucMenuMega1.Items.Add(item); item = new ucMenuMega.Item(); item.UID = 27; item.ParentUID = 1; item.Name = "IntroPage Manage"; item.Detail = ""; item.URL = "IntroPage.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } /* * item = new ucMenuMega.Item(); * item.UID = 11; * item.ParentUID = 1; * item.Name = "Template Manage"; * item.Detail = ""; * item.URL = "Template.aspx"; * ucMenuMega1.Items.Add(item); */ item = new ucMenuMega.Item(); item.UID = 12; item.ParentUID = 1; item.Name = "Content Manage"; item.Detail = ""; item.URL = "Content.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 13; item.ParentUID = 1; item.Name = "Medical Center Manage"; item.Detail = ""; item.URL = "MedicalCenterGroup.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 14; item.ParentUID = 1; item.Name = "Service Manage"; item.Detail = ""; item.URL = "ServiceGroup.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 15; item.ParentUID = 1; item.Name = "Slider Manage"; item.Detail = ""; item.URL = "Slider.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 26; item.ParentUID = 1; item.Name = "Highlight Manage"; item.Detail = ""; item.URL = "Highlight.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 16; item.ParentUID = 1; item.Name = "E-Mail Template"; item.Detail = ""; item.URL = "EmailTemplate.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 17; item.ParentUID = 1; item.Name = "E-Mail Manage"; item.Detail = ""; item.URL = "EmailList.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 2; //item.ParentUID = 1; item.Name = "จัดการข้อมูลการติดต่อกับลูกค้า"; item.Detail = ""; item.URL = ""; ucMenuMega1.Items.Add(item); item = new ucMenuMega.Item(); item.UID = 21; item.ParentUID = 2; item.Name = "User Manage"; item.Detail = ""; item.URL = "User.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 22; item.ParentUID = 2; item.Name = "Inquire Manage"; item.Detail = ""; item.URL = "Inquiry.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 23; item.ParentUID = 2; item.Name = "Doctor Appointment Manage"; item.Detail = ""; item.URL = "DoctorAppointment.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 24; item.ParentUID = 2; item.Name = "Jobs Manage"; item.Detail = ""; item.URL = "Jobs.aspx"; ucMenuMega1.Items.Add(item); item = new ucMenuMega.Item(); item.UID = 25; item.ParentUID = 2; item.Name = "Jobs History Manage"; item.Detail = ""; item.URL = "JobsHistory.aspx"; ucMenuMega1.Items.Add(item); }
private void ContentBuilder() { #region Variable var strSQL = new StringBuilder(); var strScript = new StringBuilder(); var dt = new DataTable(); var dtIndex = 0; var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs); var clsSecurity = new clsSecurity(); #endregion #region Procedure #region SQL Query strSQL.Append("SELECT "); strSQL.Append("Content.UID,"); strSQL.Append("Content.Name,"); strSQL.Append("Content.Detail,"); strSQL.Append("Content.Content,Content.ContentEN "); strSQL.Append("FROM "); strSQL.Append("P5_Content Content "); strSQL.Append("WHERE "); strSQL.Append("Content.StatusFlag='A' "); strSQL.Append("AND Content.Name='" + _contentName.Trim() + "';"); #endregion dt = clsSQL.Bind(strSQL.ToString()); if (dt != null && dt.Rows.Count > 0) { strScript.Append("<div class='" + (clsSecurity.LoginChecker("Admin") ? "dvContent" : "dvContentNormal") + "'>"); #region Default Builder if (dt.Rows[0]["Content"] != DBNull.Value) { var clsLanguage = new clsLanguage(); if (clsLanguage.LanguageCurrent == "th-TH") { strScript.Append(dt.Rows[0]["Content"].ToString()); } else { strScript.Append((dt.Rows[0]["ContentEN"].ToString() != ""? dt.Rows[0]["ContentEN"].ToString(): dt.Rows[0]["Content"].ToString())); } } #endregion #region Admin Builder if (clsSecurity.LoginChecker("Admin")) { strScript.Append("<div class='dvContentMenu'>"); strScript.Append("<a href='/Management/ContentManage.aspx?id=" + dt.Rows[dtIndex]["UID"].ToString() + "&command=edit' "); strScript.Append("title='แก้ไขข้อมูล' "); if (_modalRefreshOnClose) { strScript.Append("class='cbIFrameRefreshOnClose'"); } else { strScript.Append("class='cbIFrame'"); } strScript.Append(">"); strScript.Append("<span class='Icon16 Edit' />"); strScript.Append("</a>"); strScript.Append("</div>"); } #endregion strScript.Append("</div>"); lblContent.Text = strScript.ToString(); } #endregion }
private void MenuBuilder() { ucMenuMega.Item item = new ucMenuMega.Item(); clsSecurity clsSecurity = new clsSecurity(); item = new ucMenuMega.Item(); item.UID = 1; //item.ParentUID = 1; item.Name = "จัดการข้อมูลเว็บไซต์"; item.Detail = ""; item.URL = ""; ucMenuMega1.Items.Add(item); item = new ucMenuMega.Item(); item.UID = 27; item.ParentUID = 1; item.Name = "IntroPage Manage"; item.Detail = ""; item.URL = "IntroPage.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } /* item = new ucMenuMega.Item(); item.UID = 11; item.ParentUID = 1; item.Name = "Template Manage"; item.Detail = ""; item.URL = "Template.aspx"; ucMenuMega1.Items.Add(item); */ item = new ucMenuMega.Item(); item.UID = 12; item.ParentUID = 1; item.Name = "Content Manage"; item.Detail = ""; item.URL = "Content.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 13; item.ParentUID = 1; item.Name = "Medical Center Manage"; item.Detail = ""; item.URL = "MedicalCenterGroup.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 14; item.ParentUID = 1; item.Name = "Service Manage"; item.Detail = ""; item.URL = "ServiceGroup.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 15; item.ParentUID = 1; item.Name = "Slider Manage"; item.Detail = ""; item.URL = "Slider.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 26; item.ParentUID = 1; item.Name = "Highlight Manage"; item.Detail = ""; item.URL = "Highlight.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 16; item.ParentUID = 1; item.Name = "E-Mail Template"; item.Detail = ""; item.URL = "EmailTemplate.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 17; item.ParentUID = 1; item.Name = "E-Mail Manage"; item.Detail = ""; item.URL = "EmailList.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 2; //item.ParentUID = 1; item.Name = "จัดการข้อมูลการติดต่อกับลูกค้า"; item.Detail = ""; item.URL = ""; ucMenuMega1.Items.Add(item); item = new ucMenuMega.Item(); item.UID = 21; item.ParentUID = 2; item.Name = "User Manage"; item.Detail = ""; item.URL = "User.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 22; item.ParentUID = 2; item.Name = "Inquire Manage"; item.Detail = ""; item.URL = "Inquiry.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 23; item.ParentUID = 2; item.Name = "Doctor Appointment Manage"; item.Detail = ""; item.URL = "DoctorAppointment.aspx"; if (clsSecurity.LoginChecker("admin")) { ucMenuMega1.Items.Add(item); } item = new ucMenuMega.Item(); item.UID = 24; item.ParentUID = 2; item.Name = "Jobs Manage"; item.Detail = ""; item.URL = "Jobs.aspx"; ucMenuMega1.Items.Add(item); item = new ucMenuMega.Item(); item.UID = 25; item.ParentUID = 2; item.Name = "Jobs History Manage"; item.Detail = ""; item.URL = "JobsHistory.aspx"; ucMenuMega1.Items.Add(item); }
private void BindDefault(string UID) { #region Variable StringBuilder strSQL = new StringBuilder(); DataTable dt = new DataTable(); #endregion #region SQL Query strSQL.Append("SELECT "); strSQL.Append("ServiceGroupUID,"); strSQL.Append("LanguageUID,"); strSQL.Append("UID,"); strSQL.Append("Icon,"); strSQL.Append("Name,"); strSQL.Append("Detail,"); strSQL.Append("Content,"); strSQL.Append("Location,"); strSQL.Append("OfficeHours,"); strSQL.Append("Phone,"); strSQL.Append("EMail,"); strSQL.Append("Price,"); strSQL.Append("MetaKeywords,"); strSQL.Append("MetaDescription "); strSQL.Append("FROM "); strSQL.Append("Service "); strSQL.Append("WHERE "); //strSQL.Append("UID=" + parameterChar + "UID "); strSQL.Append("DepartmentUID=" + parameterChar + "UID "); strSQL.Append("AND LanguageUID=" + clsLanguage.LanguageUIDCurrent.ToString() + " "); strSQL.Append("AND Active='1'"); #endregion #region Data Builder dt = clsSQL.Bind(strSQL.ToString(), new string[, ] { { parameterChar + "UID", UID } }, dbType, cs); if (dt != null && dt.Rows.Count > 0) { #region DataBuilder Page.Title = dt.Rows[0]["Name"].ToString(); if (dt.Rows[0]["MetaKeywords"] != DBNull.Value && dt.Rows[0]["MetaKeywords"].ToString() != "") { Page.MetaKeywords = dt.Rows[0]["MetaKeywords"].ToString(); } if (dt.Rows[0]["MetaDescription"] != DBNull.Value && dt.Rows[0]["MetaDescription"].ToString() != "") { Page.MetaDescription = dt.Rows[0]["MetaDescription"].ToString(); } lblIcon.Text = "<img src='" + dt.Rows[0]["Icon"].ToString() + "' title='" + dt.Rows[0]["Name"].ToString() + "' alt='" + dt.Rows[0]["Name"].ToString() + "' style='width:120px;'/>"; lblName.Text = "<h1>" + dt.Rows[0]["Name"].ToString() + "</h1>"; lblDetail.Text = dt.Rows[0]["Detail"].ToString(); lblContent.Text = dt.Rows[0]["Content"].ToString(); lblLocationValue.Text = dt.Rows[0]["Location"].ToString(); lblOfficeHoursValue.Text = dt.Rows[0]["OfficeHours"].ToString(); lblPhoneValue.Text = dt.Rows[0]["Phone"].ToString(); if (dt.Rows[0]["EMail"] != DBNull.Value) { lblEMailValue.Text = "<a href='mailto:" + dt.Rows[0]["EMail"].ToString() + "'>" + dt.Rows[0]["EMail"].ToString() + "</a>"; } if (dt.Rows[0]["Price"] != DBNull.Value && !string.IsNullOrEmpty(dt.Rows[0]["Price"].ToString())) { lblPrice.Text = dt.Rows[0]["Price"].ToString(); } else { lblPrice.Text = "<div style='text-align:center;'>-</div>"; } #endregion #region GalleryBuilder BindGallery(dt.Rows[0]["UID"].ToString()); #endregion #region Admin Menu if (clsSecurity.LoginChecker("admin")) { lblAdminMenu.Text = "<div class='dvContentMenu'>" + "<a href='/Management/ServiceManage.aspx?group=" + dt.Rows[0]["ServiceGroupUID"].ToString() + "&id=" + dt.Rows[0]["UID"].ToString() + "&command=edit" + "&language=" + dt.Rows[0]["LanguageUID"].ToString() + "' title='แก้ไขข้อมูล' class='cbIFrame'>" + "<span class='Icon16 Edit' />" + "</a>" + "</div>"; } else { lblAdminMenu.Text = ""; } #endregion } else { //ucColorBox1.Redirect("/", "ไม่พบหน้าที่คุณต้องการ"); ucColorBox1.Alert("ไม่พบข้อมูล", "ไม่พบหน้าที่คุณต้องการ"); } #endregion }
protected void btSubmit_Click(object sender, EventArgs e) { #region Authorize if (!clsSecurity.LoginChecker("admin")) { ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin"); return; } #endregion #region Variable var strSQL = new StringBuilder(); var id = 0; var outSQL = ""; #endregion #region Procedure #region Update if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit") { id = int.Parse(Request.QueryString["id"].ToString()); if (clsSQL.Update("Content", new string[, ] { { "Content", "'" + ucContent.Text.SQLQueryFilter() + "'" }, { "ContentEN", "'" + ucContentEN.Text.SQLQueryFilter() + "'" }, { "MUser", clsSecurity.LoginUID }, { "MWhen", functionGetDate }, { "Sort", txtSort.Text.SQLQueryFilter() }, { "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" } }, new string[, ] { { } }, "UID=" + id.ToString(), out outSQL)) { ucColorBox1.ReloadParent(); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion #region Insert else { if (clsSQL.Insert("Content", new string[, ] { { "Name", "'" + txtName.Text.SQLQueryFilter() + "'" }, { "Detail", "'" + txtDetail.Text.SQLQueryFilter() + "'" }, { "Content", "'" + ucContent.Text.SQLQueryFilter() + "'" }, { "ContentEN", "'" + ucContentEN.Text.SQLQueryFilter() + "'" }, { "CUser", clsSecurity.LoginUID }, { "CWhen", functionGetDate }, { "MUser", clsSecurity.LoginUID }, { "MWhen", functionGetDate }, { "Sort", txtSort.Text.SQLQueryFilter() }, { "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" } }, new string[, ] { { } }, out outSQL)) { ucColorBox1.ReloadParent(); } else { ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล", outSQL, AlertImage: ucColorBox.Alerts.Fail); } } #endregion #endregion }