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
}
