protected void btLogin_Click(object sender, EventArgs e)
{
#region Variable
var clsSQL = new clsSQL();
var clsDefault = new clsDefault();
var clsColorBox = new clsColorBox();
#endregion
#region Procedure
if (clsSecurity.LoginChecker(
clsSQL.CodeFilter(txtUsername.Text),
clsSQL.CodeFilter(txtPassword.Text),
cbEnableCookie.Checked))
{
//ucColorBox.Redirect(Request.RawUrl, "เข้าสู่ระบบแล้ว");
Response.Redirect(Request.RawUrl);
}
else
{
var script = "document.getElementById('dvUCLogon').scrollIntoView(true);";
Page.ClientScript.RegisterStartupScript(Page.GetType(),
"ucColorBoxScroller",
script,
true);
ucColorBox.Alert("Login Alert", "ไม่พบข้อมูลที่คุณกรอก", AlertImage: global::ucColorBox.Alerts.Fail);
lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn);
}
#endregion
}
protected void btDGSubmit_Click(object sender, EventArgs e)
{
#region Authorize
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin");
return;
}
#endregion
#region Variable
StringBuilder strSQL = new StringBuilder();
#endregion
#region SQL Builder
for (int i = 0; i < gvDefault.Rows.Count; i++)
{
Label lblDGID = (Label)gvDefault.Rows[i].FindControl("lblDGID");
TextBox txtDGWord = (TextBox)gvDefault.Rows[i].FindControl("txtDGWord");
TextBox txtDGWordReplace = (TextBox)gvDefault.Rows[i].FindControl("txtDGWordReplace");
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("Word='" + clsSQL.CodeFilter(txtDGWord.Text) + "',");
strSQL.Append("WordReplace='" + clsSQL.CodeFilter(txtDGWordReplace.Text) + "',");
strSQL.Append("Sort=" + clsSQL.CodeFilter(txtDGSort.Text) + ",");
strSQL.Append("Active='" + (cbDGActive.Checked ? "1" : "0") + "' ");
strSQL.Append("WHERE ");
strSQL.Append("UID=" + lblDGID.Text);
strSQL.Append(";");
#endregion
}
}
#endregion
if (clsSQL.Execute(strSQL.ToString(), dbType, cs))
{
ucColorBox1.Redirect(webDefault, "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย");
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail);
}
}
protected void btLogin_Click(object sender, EventArgs e)
{
clsSQL clsSQL = new clsSQL();
clsDefault clsDefault = new clsDefault();
if (clsSecurity.LoginChecker(
clsSQL.CodeFilter(txtUsername.Text),
clsSQL.CodeFilter(txtPassword.Text),
cbEnableCookie.Checked))
{
//LoginChecker();
Response.Redirect(Request.RawUrl);
}
else
{
lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn);
}
}
/// <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 btDGSubmit_Click(object sender, EventArgs e)
{
#region AdminChecker
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect("/", "เกิดข้อผิดพลาด", "คุณไม่ได้รับสิทธิ์ในการบันทึกข้อมูล กรุณาล็อคอินด้วยสิทธิ์ Admin");
return;
}
#endregion
#region Variable
var strSQL = new StringBuilder();
#endregion
#region Procedure
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" : "I") + "' ");
strSQL.Append("WHERE ");
strSQL.Append("UID=" + lblDGID.Text);
strSQL.Append(";");
#endregion
}
}
if (clsSQL.Execute(strSQL.ToString()))
{
ucColorBox1.Redirect("/Management/" + webDefault, "ดำเนินการเสร็จสิ้น", "แก้ไขข้อมูลเสร็จเรียบร้อย");
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะบันทึกข้อมูลลงฐานข้อมูล<br/>" + strSQL.ToString(), AlertImage: ucColorBox.Alerts.Fail);
}
#endregion
}
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
}
private void DoctorBuilderDeptOneLine()
{
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("(");
strSQL.Append("SELECT TOP 1 MedicalCenter.UID ");
strSQL.Append("FROM DoctorDepartment ");
strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " ");
strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID ");
strSQL.Append(")MedicalCenterUID,");
strSQL.Append("(");
strSQL.Append("SELECT MC.Name + ' , ' ");
strSQL.Append("FROM DoctorDepartment DD ");
strSQL.Append("INNER JOIN MedicalCenter MC ON DD.DepartmentUID = MC.DepartmentUID ");
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("AND MC.LanguageUID=1 ");
}
else
{
strSQL.Append("AND MC.LanguageUID=2 ");
}
strSQL.Append("WHERE DD.DoctorUID = D.UID FOR XML PATH('')");
strSQL.Append(")Department,");
strSQL.Append("(");
strSQL.Append("SELECT TOP 1 DoctorDepartment.DepartmentUID ");
strSQL.Append("FROM DoctorDepartment ");
strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " ");
strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID ");
strSQL.Append(")DepartmentUID,");
strSQL.Append("D.UID,D.Photo,");
#region Language Select
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name1,");
strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name2,");
strSQL.Append("D.SpecialtyTH Specialty,");
strSQL.Append("D.EducationTH Education,");
strSQL.Append("D.ExperianceTH Experiance,");
strSQL.Append("D.TypeTH Type,");
}
else
{
strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name2,");
strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name1,");
strSQL.Append("D.SpecialtyEN Specialty,");
strSQL.Append("D.EducationEN Education,");
strSQL.Append("D.ExperianceEN Experiance,");
strSQL.Append("D.TypeEN Type,");
}
#endregion
strSQL.Append("D.MedID,D.Phone,D.EMail ");
strSQL.Append("FROM Doctor D ");
strSQL.Append("WHERE D.Active = '1' ");
#region SearchBuilder
#region Name
if (txtSearchName.Text.Trim() != "")
{
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("AND (");
strSQL.Append("D.FNameTH LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%' ");
strSQL.Append("OR D.LNameTH LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%'");
strSQL.Append(") ");
}
else
{
strSQL.Append("AND (");
strSQL.Append("D.FNameEN LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%' ");
strSQL.Append("OR D.LNameEN LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%'");
strSQL.Append(") ");
}
}
#endregion
#region Specialty
if (ddlSearchSpecialty.SelectedItem.Value != "null")
{
strSQL.Append("AND (");
strSQL.Append("SpecialtyTH LIKE '%" + ddlSearchSpecialty.SelectedItem.Text + "%' ");
strSQL.Append("OR SpecialtyEN LIKE '%" + ddlSearchSpecialty.SelectedItem.Text + "%' ");
strSQL.Append(") ");
}
#endregion
#region MedicalCenter
if (ddlSearchMedicalCenter.SelectedItem.Value != "null")
{
strSQL.Append("AND (");
strSQL.Append("SELECT COUNT(MedicalCenter.UID) ");
strSQL.Append("FROM DoctorDepartment ");
strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " ");
strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID ");
strSQL.Append("AND MC.Name LIKE '%" + ddlSearchMedicalCenter.SelectedItem.Text + "%'");
strSQL.Append(")>0,");
}
#endregion
#region Schedule
#region Checked
bool cbChecked = false;
for (int c = 0; c < cbSearchSchedule.Items.Count; c++)
{
if (cbSearchSchedule.Items[c].Selected)
{
cbChecked = true;
break;
}
}
#endregion
if (cbChecked)
{
strSQL.Append("AND (");
strSQL.Append("SELECT ");
strSQL.Append("COUNT(UID) ");
strSQL.Append("FROM ");
strSQL.Append("DoctorSchedule ");
strSQL.Append("WHERE ");
strSQL.Append("DoctorUID=D.UID ");
//strSQL.Append("AND DATEPART(DW,DoctorSchedule.DateActive)=1");
strSQL.Append("AND " + clsSQL.QueryBuilderWhere(cbSearchSchedule, "DATEPART(DW,DoctorSchedule.DateActive)", "OR", false, true));
strSQL.Append(")>0 ");
}
#endregion
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append("D.FNameTH;");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
gvDoctor.Visible = true;
gvDoctor.DataSource = dt;
gvDoctor.DataBind();
DoctorScheduleBuilder();
}
else
{
gvDoctor.Visible = false;
lblDoctor.Text = (clsLanguage.LanguageCurrent == "th-TH"?clsDefault.AlertMessageColor("ไม่พบข้อมูลแพทย์ที่ต้องการ.", clsDefault.AlertType.Info):clsDefault.AlertMessageColor("Not found data.", clsDefault.AlertType.Info));
}
#endregion
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Authorize
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin");
return;
}
#endregion
#region Variable
StringBuilder strSQL = new StringBuilder();
int id = 0;
string outSQL;
string photoName = "";
#endregion
#region Update
if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit")
{
id = int.Parse(Request.QueryString["id"].ToString());
#region Photo Upload
if (fuPhoto.HasFile)
{
clsIO clsIO = new clsIO();
string outErrorMessage; string outFilename;
if (clsIO.UploadPhoto(
fuPhoto, pathUpload,
"Service" + 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[, ] {
{ "UID", id.ToString() },
{ "LanguageUID", rbLanguage.SelectedItem.Value },
{ "ServiceGroupUID", clsDefault.QueryStringChecker("group") },
{ "DepartmentUID", (txtDepartmentUID.Text != ""?"'" + clsSQL.CodeFilter(txtDepartmentUID.Text) + "'":"null") },
{ "Icon", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"Icon") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "[Content]", "'" + clsSQL.CodeFilter(ucContent.Text) + "'" },
{ "Price", "'" + clsSQL.CodeFilter(ucPrice.Text) + "'" },
{ "Location", "'" + clsSQL.CodeFilter(txtLocation.Text) + "'" },
{ "OfficeHours", "'" + clsSQL.CodeFilter(txtOfficeHours.Text) + "'" },
{ "Phone", "'" + clsSQL.CodeFilter(txtPhone.Text) + "'" },
{ "EMail", "'" + clsSQL.CodeFilter(txtEMail.Text) + "'" },
{ "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeyword.Text) + "'" },
{ "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "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)
{
clsIO clsIO = new clsIO();
string outErrorMessage; string outFilename;
if (clsIO.UploadPhoto(
fuPhoto, pathUpload,
"Service" + 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() },
{ "LanguageUID", rbLanguage.SelectedItem.Value },
{ "ServiceGroupUID", clsDefault.QueryStringChecker("group") },
{ "DepartmentUID", (txtDepartmentUID.Text.Trim() != ""?"'" + clsSQL.CodeFilter(txtDepartmentUID.Text) + "'":"null") },
{ "Icon", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"null") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "[Content]", "'" + clsSQL.CodeFilter(ucContent.Text) + "'" },
{ "Price", "'" + clsSQL.CodeFilter(ucPrice.Text) + "'" },
{ "Location", "'" + clsSQL.CodeFilter(txtLocation.Text) + "'" },
{ "OfficeHours", "'" + clsSQL.CodeFilter(txtOfficeHours.Text) + "'" },
{ "Phone", "'" + clsSQL.CodeFilter(txtPhone.Text) + "'" },
{ "EMail", "'" + clsSQL.CodeFilter(txtEMail.Text) + "'" },
{ "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeyword.Text) + "'" },
{ "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", "GETDATE()" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "Active", "'" + (cbActive.Checked ? "1" : "0") + "'" }
}, new string[, ] {
{ }
},
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#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 = "";
var photoFullName = "";
#endregion
#region Update
if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit")
{
id = int.Parse(Request.QueryString["id"].ToString());
clsIO clsIO = new clsIO();
string outErrorMessage; string outFilename;
#region Photo Upload
if (fuPhoto.HasFile)
{
if (clsIO.UploadPhoto(
fuPhoto, pathUpload,
"HealthPackage" + id.ToString() + "_T",
out outErrorMessage,
out outFilename,
maxWidth: photoWidth,
maxHeight: photoHeight))
{
photoName = outFilename;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
}
#endregion
#region PhotoFull Upload
if (fuPhotoFull.HasFile)
{
if (clsIO.UploadPhoto(
fuPhotoFull, pathUpload,
"HealthPackage" + id.ToString(),
out outErrorMessage,
out outFilename))
{
photoFullName = outFilename;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
}
#endregion
if (clsSQL.Update(tableDefault,
new string[, ] {
{ "LanguageUID", rbLanguage.SelectedItem.Value },
{ "DepartmentUID", (txtDepartmentUID.Text != ""?clsSQL.CodeFilter(txtDepartmentUID.Text):"null") },
{ "PicThumbnail", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"PicThumbnail") },
{ "PicFull", (!string.IsNullOrEmpty(photoFullName)?"'" + pathUpload + photoFullName + "'":"PicFull") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + ucContent.Text.SQLQueryFilter() + "'" },
{ "DetailSub", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "ActiveDateFrom", (ucDateStart.Text != ""?"'" + ucDateStart.Text.SQLQueryFilter() + "'":"null") },
{ "ActiveDateTo", (ucDateEnd.Text != ""?"'" + ucDateEnd.Text.SQLQueryFilter() + "'":"null") },
{ "UnitPrice", "'" + txtPrice.Text.SQLQueryFilter() + "'" },
{ "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeyword.Text) + "'" },
{ "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "D") + "'" }
}, 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
clsIO clsIO = new clsIO();
string outErrorMessage; string outFilename;
#region Photo Upload
if (fuPhoto.HasFile)
{
if (clsIO.UploadPhoto(
fuPhoto, pathUpload,
"HealthPackage" + id.ToString() + "_T",
out outErrorMessage,
out outFilename,
maxWidth: photoWidth,
maxHeight: photoHeight))
{
photoName = outFilename;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
}
#endregion
#region PhotoFull Upload
if (fuPhotoFull.HasFile)
{
if (clsIO.UploadPhoto(
fuPhotoFull, pathUpload,
"HealthPackage" + id.ToString(),
out outErrorMessage,
out outFilename))
{
photoFullName = outFilename;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
}
#endregion
if (clsSQL.Insert(tableDefault,
new string[, ] {
{ "LanguageUID", rbLanguage.SelectedItem.Value },
{ "DepartmentUID", (txtDepartmentUID.Text != ""?clsSQL.CodeFilter(txtDepartmentUID.Text):"null") },
{ "PicThumbnail", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"null") },
{ "PicFull", (!string.IsNullOrEmpty(photoFullName)?"'" + pathUpload + photoFullName + "'":"null") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + ucContent.Text.SQLQueryFilter() + "'" },
{ "DetailSub", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "ActiveDateFrom", (ucDateStart.Text != ""?"'" + ucDateStart.Text.SQLQueryFilter() + "'":"null") },
{ "ActiveDateTo", (ucDateEnd.Text != ""?"'" + ucDateEnd.Text.SQLQueryFilter() + "'":"null") },
{ "UnitPrice", "'" + txtPrice.Text.SQLQueryFilter() + "'" },
{ "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeyword.Text) + "'" },
{ "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", "GETDATE()" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "D") + "'" }
}, new string[, ] {
{ }
},
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
}
protected void btLogin_Click(object sender, EventArgs e)
{
clsSQL clsSQL = new clsSQL();
clsDefault clsDefault = new clsDefault();
if(clsSecurity.LoginChecker(
clsSQL.CodeFilter(txtUsername.Text),
clsSQL.CodeFilter(txtPassword.Text),
cbEnableCookie.Checked))
{
//LoginChecker();
Response.Redirect(Request.RawUrl);
}
else
{
lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn);
}
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Authorize
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin");
return;
}
#endregion
#region Variable
StringBuilder strSQL = new StringBuilder();
int id = 0;
string outSQL;
string photoName = "";
string photoPreviewName = "";
#endregion
#region Update
if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit")
{
id = int.Parse(Request.QueryString["id"].ToString());
#region Photo Upload
if (fuPhoto.HasFile)
{
clsIO clsIO = new clsIO();
string outErrorMessage;
string outFilename;
string outFilenamePreview;
#region Photo
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
#region Photo Preview
if (clsIO.UploadPhoto(
fuPhoto, pathUpload,
tableDefault + id.ToString() + "Preview",
out outErrorMessage,
out outFilenamePreview,
maxWidth: photoPreviewWidth,
maxHeight: photoPreviewHeight))
{
photoPreviewName = outFilenamePreview;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
#endregion
}
#endregion
if (clsSQL.Update(tableDefault,
new string[, ] {
{ "UID", id.ToString() },
{ "PhotoPreview", (!string.IsNullOrEmpty(photoPreviewName)?"'" + pathUpload + photoPreviewName + "'":"PhotoPreview") },
{ "Photo", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"Photo") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "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)
{
clsIO clsIO = new clsIO();
string outErrorMessage;
string outFilename;
string outFilenamePreview;
#region Photo
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
#region PhotoPreview
if (clsIO.UploadPhoto(
fuPhoto, pathUpload,
tableDefault + id.ToString() + "Preview",
out outErrorMessage,
out outFilenamePreview,
maxWidth: photoPreviewWidth,
maxHeight: photoPreviewHeight))
{
photoPreviewName = outFilenamePreview;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
#endregion
}
#endregion
if (clsSQL.Insert(tableDefault,
new string[, ] {
{ "UID", id.ToString() },
{ "GlobalUID", clsDefault.QueryStringChecker("globalid") },
{ "GlobalName", "'" + clsDefault.QueryStringChecker("globalname") + "'" },
{ "PhotoPreview", (!string.IsNullOrEmpty(photoPreviewName)?"'" + pathUpload + photoPreviewName + "'":"null") },
{ "Photo", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"null") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "[View]", "0" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", "GETDATE()" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "Active", "'" + (cbActive.Checked ? "1" : "0") + "'" }
}, new string[, ] {
{ }
},
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
}
protected void btBook_Click(object sender, EventArgs e)
{
#region Variable
string outSQL;
string outMailMessage;
clsMail clsMail;
#endregion
#region Insert Data
if (clsSQL.Insert(
"DoctorAppointment",
new string[, ] {
{ "UID", clsSQL.GetNewID("UID", "DoctorAppointment", "", dbType, cs).ToString() },
{ "HN", "'" + clsSQL.CodeFilter(txtHN.Text) + "'" },
{ "PName", "'" + clsSQL.CodeFilter(ddlPName.SelectedItem.Text) + "'" },
{ "FName", "'" + clsSQL.CodeFilter(txtFName.Text) + "'" },
{ "LName", "'" + clsSQL.CodeFilter(txtLName.Text) + "'" },
{ "Email", "'" + clsSQL.CodeFilter(txtEmail.Text) + "'" },
{ "Phone", "'" + clsSQL.CodeFilter(txtPhone.Text) + "'" },
{ "DoctorUID", clsDefault.URLRouting("doctorUID") },
{ "DoctorName", "'" + clsSQL.CodeFilter(lblName1.Text) + "'" },
{ "DepartmentUID", "'" + clsDefault.URLRouting("departmentUID") + "'" },
{ "DepartmentName", "'" + clsSQL.CodeFilter(lblDepartment.Text) + "'" },
{ "AppointmentDate", "'" + clsSQL.CodeFilter(ucDateTimeFlat1.DateTime.ToString("yyyy-MM-dd HH:mm")) + "'" },
{ "Comment", "'" + clsSQL.CodeFilter(txtComment.Text) + "'" },
{ "BirthDate", "'" + ucBirthDate.DateTime.ToString("yyyy-MM-dd") + "'" },
{ "NID", "'" + txtNID.Text.SQLQueryFilter() + "'" },
{ "CWhen", "GETDATE()" },
{ "CUser", (clsSecurity.LoginChecker()?clsSecurity.LoginUID:"0") },
{ "MWhen", "GETDATE()" },
{ "MUser", (clsSecurity.LoginChecker()?clsSecurity.LoginUID:"0") },
{ "Sort", "0" },
{ "Active", "'1'" }
},
new string[, ] {
},
dbType,
cs,
out outSQL))
{
lblBookAlert.Text = clsDefault.AlertMessageColor("ระบบบันทึกข้อมูลการทำนัดของคุณแล้ว", clsDefault.AlertType.Success);
string doctor = lblName1.Text;
#region Mail to Admin
clsMail = new clsMail();
if (!clsMail.SendTemplate(
"DoctorScheduleAdmin",
clsMail.GetEmailList("AutoSystemFrom"),
clsMail.GetEmailList("DoctorScheduleTo"),
new string[, ] {
{ "[PName]", ddlPName.SelectedItem.Text },
{ "[FName]", txtFName.Text },
{ "[LName]", txtLName.Text },
{ "[HN]", txtHN.Text },
{ "[Email]", txtEmail.Text },
{ "[Phone]", txtPhone.Text },
{ "[Doctor]", doctor },
{ "[Department]", lblDepartment.Text },
{ "[BookDateTime]", ucDateTimeFlat1.DateTime.ToString("dd/MM/yyyy HH:mm") },
{ "[Comment]", txtComment.Text },
{ "[BirthDate]", ucBirthDate.Text },
{ "[NID]", txtNID.Text }
},
out outMailMessage))
{
lblBookAlert.Text += clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะส่งเมล์ไปยังลูกค้า", clsDefault.AlertType.Fail);
}
//List<clsMail.EmailList> mails = new List<global::clsMail.EmailList>();
//mails = clsMail.GetEmailList("DoctorScheduleTo");
//for (int i = 0; i < mails.Count; i++)
//{
// lblBookAlert.Text+="<br/>"+mails[i].EmailAddress;
//}
lblBookAlert.Text += "<br/>" + outMailMessage;
#endregion
#region Mail to User
clsMail = new clsMail();
if (!clsMail.SendTemplate(
"DoctorScheduleUser",
clsMail.GetEmailList("GlobalFrom"),
txtEmail.Text.Trim(),
new string[, ] {
{ "[PName]", ddlPName.SelectedItem.Text },
{ "[FName]", txtFName.Text },
{ "[LName]", txtLName.Text },
{ "[HN]", txtHN.Text },
{ "[Email]", txtEmail.Text },
{ "[Phone]", txtPhone.Text },
{ "[Doctor]", doctor },
{ "[Department]", lblDepartment.Text },
{ "[BookDateTime]", ucDateTimeFlat1.DateTime.ToString("dd/MM/yyyy HH:mm") },
{ "[Comment]", txtComment.Text }
},
out outMailMessage))
{
lblBookAlert.Text += clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะส่งเมล์ไปยังลูกค้า", clsDefault.AlertType.Fail);
}
#endregion
}
else
{
lblBookAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>" + outSQL, clsDefault.AlertType.Fail);
}
#endregion
}
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
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Authorize
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect(webDefault, "กรุณาล็อคอินด้วยสิทธิ์ Admin");
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,
"Group" + id.ToString(),
out outErrorMessage,
out outFilename,
maxWidth: photoWidth,
maxHeight: photoHeight,
resizeMode: clsIO.ResizeMode.crop))
{
photoName = outFilename;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
}
#endregion
if (clsSQL.Update(tableDefault,
new string[, ] {
{ "WebboardTypeUID", ddlWebboardType.SelectedItem.Value },
{ "GlobalUID", "'" + clsSQL.CodeFilter(txtGlobalUID.Text) + "'" },
{ "Icon", (photoName != ""?"'" + pathUpload + photoName + "'":"Icon") },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeywords.Text) + "'" },
{ "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "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,
"Group" + id.ToString(),
out outErrorMessage,
out outFilename,
maxWidth: photoWidth,
maxHeight: photoHeight,
resizeMode: clsIO.ResizeMode.crop))
{
photoName = outFilename;
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดไฟล์รูปภาพ<br/>" + outErrorMessage, AlertImage: ucColorBox.Alerts.Fail);
return;
}
}
#endregion
if (clsSQL.Insert(tableDefault,
new string[, ] {
{ "UID", id.ToString() },
{ "WebboardTypeUID", clsDefault.URLRouting("type") },
{ "GlobalUID", "'" + clsSQL.CodeFilter(txtGlobalUID.Text) + "'" },
{ "Icon", "'" + pathUpload + photoName + "'" },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "MetaKeywords", "'" + clsSQL.CodeFilter(txtMetaKeywords.Text) + "'" },
{ "MetaDescription", "'" + clsSQL.CodeFilter(txtMetaDescription.Text) + "'" },
{ "Views", "0" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", "GETDATE()" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "Active", "'" + (cbActive.Checked ? "1" : "0") + "'" }
}, new string[, ] {
{ }
},
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Variable
string outMail = "";
string outSQL = "";
string UID = "";
#endregion
if (txtFromName.Text.Trim().Length > 0 &&
txtFromPhone.Text.Trim().Length > 0 &&
txtFromEmail.Text.Trim().Length > 0 &&
txtMessage.Text.Trim().Length > 0)
{
UID = clsSQL.GetNewID("UID", "Inquiry", "", dbType, cs).ToString();
if (!clsSQL.Insert(
"Inquiry",
new string[, ] {
{ "UID", UID },
{ "MedicalCenterUID", (ddlMedicalCenter.SelectedItem.Value == "null"?"null":ddlMedicalCenter.SelectedItem.Value) },
{ "Name", "'" + clsSQL.CodeFilter(txtFromName.Text) + "'" },
{ "Email", "'" + clsSQL.CodeFilter(txtFromEmail.Text) + "'" },
{ "Phone", "'" + clsSQL.CodeFilter(txtFromPhone.Text) + "'" },
{ "Message", "'" + clsSQL.CodeFilter(txtMessage.Text) + "'" },
{ "Status", "'RECEIVED'" },
{ "CWhen", "GETDATE()" },
{ "CUser", /*clsSecurity.LoginUID*/ "0" },
{ "MWhen", "GETDATE()" },
{ "MUser", /*clsSecurity.LoginUID*/ "0" },
{ "Sort", "0" },
{ "Active", "'1'" }
},
new string[, ] {
{}
},
dbType,
cs,
out outSQL))
{
ucColorBox1.Alert(Message: "เกิดข้อผิดพลาดขณะบันทึกข้อมูล", AlertImage: ucColorBox.Alerts.Fail);
return;
}
#region MailToUser
try
{
//string outMailMessage="";
//clsMail.Send(
// "*****@*****.**",
// txtFromEmail.Text.Trim(),
// "โรงพยาบาลกรุงเทพจันทบุรี ได้รับข้อมูลของคุณแล้ว",
// "คุณได้ส่งคำถาม '" + txtMessage.Text.Trim() + "' มายังโรงพยาบาล",
// out outMailMessage);
if (clsMail.SendTemplate(
"InquiryConfirm",
clsMail.GetEmailList("GlobalFrom"),
txtFromEmail.Text,
new string[, ]
{
{ "[UID]", UID },
{ "[MedicalCenter]", ddlMedicalCenter.SelectedItem.Text },
{ "[FromName]", txtFromName.Text },
{ "[FromPhone]", txtFromPhone.Text },
{ "[FromEmail]", txtFromEmail.Text },
{ "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") },
{ "[Message]", txtMessage.Text }
},
out outMail))
{
ucColorBox1.Redirect("/Inquiry/", "ได้รับข้อความของคุณแล้ว");
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblAlert.Focus();
}
}
catch (Exception) { }
#endregion
#region MailToAdmin
if (clsMail.SendTemplate(
"Inquiry",
clsMail.GetEmailList("AutoSystemFrom"),
clsMail.GetEmailList("InquiryTo"),
new string[, ]
{
{ "[UID]", UID },
{ "[MedicalCenter]", ddlMedicalCenter.SelectedItem.Text },
{ "[FromName]", txtFromName.Text },
{ "[FromPhone]", txtFromPhone.Text },
{ "[FromEmail]", txtFromEmail.Text },
{ "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") },
{ "[Message]", txtMessage.Text }
},
out outMail))
{
ucColorBox1.Redirect("/Inquiry/", "ได้รับข้อความของคุณแล้ว");
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblAlert.Focus();
}
#endregion
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("กรุณากรอกข้อมูลให้ครบก่อนค่ะ", clsDefault.AlertType.Warn);
}
}
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
try
{
#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;
#region Photo
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
}
#endregion
if (clsSQL.Update(tableDefault,
new string[, ] {
{ "Photo", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"Photo") },
{ "UserGroupUID", ddlUserGroup.SelectedItem.Value },
{ "PName", "'" + ddlPName.SelectedItem.Value + "'" },
{ "FName", "'" + txtFName.Text.SQLQueryFilter() + "'" },
{ "LName", "'" + txtLName.Text.SQLQueryFilter() + "'" },
{ "BirthDate", (ucBirthdate.Text != ""?"'" + ucBirthdate.DateTime.ToString("yyyy-MM-dd") + "'":"null") },
{ "Gender", "'" + rbGender.SelectedItem.Value + "'" },
{ "NID", "'" + txtNID.Text.SQLQueryFilter() + "'" },
{ "Phone", "'" + txtPhone.Text.SQLQueryFilter() + "'" },
{ "Mobile", "'" + txtMobile.Text.SQLQueryFilter() + "'" },
{ "Email", "'" + txtEmail.Text.SQLQueryFilter() + "'" },
{ "Address", "'" + txtAddress.Text.SQLQueryFilter() + "'" },
{ "AddressDistrict", "'" + txtAddressDistrict.Text.SQLQueryFilter() + "'" },
{ "AddressPrefecture", "'" + txtAddressPrefecture.Text.SQLQueryFilter() + "'" },
{ "AddressProvince", "'" + txtAddressProvince.Text.SQLQueryFilter() + "'" },
{ "AddressPostal", "'" + txtAddressPostal.Text.SQLQueryFilter() + "'" },
{ "Profile", "'" + ucProfile.Text.SQLQueryFilter() + "'" },
{ "Signature", "'" + ucSignature.Text.SQLQueryFilter() + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", functionGetDate },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" }
}, new string[, ] {
{ parameterChar + "UID", id.ToString() }
},
"UID=" + parameterChar + "UID",
out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
#region Insert
else
{
#region Photo Upload
if (fuPhoto.HasFile)
{
var clsIO = new clsIO();
string outErrorMessage;
string outFilename;
#region Photo
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
}
#endregion
if (clsSQL.Insert(tableDefault,
new string[, ] {
{ "UserGroupUID", ddlUserGroup.SelectedItem.Value },
{ "[Username]", "'" + txtUsername.Text.SQLQueryFilter() + "'" },
{ "Password", "'" + clsSecurity.Encrypt(txtPassword.Text) + "'" },
{ "PName", "'" + ddlPName.SelectedItem.Value + "'" },
{ "FName", "'" + txtFName.Text.SQLQueryFilter() + "'" },
{ "LName", "'" + txtLName.Text.SQLQueryFilter() + "'" },
{ "BirthDate", (ucBirthdate.Text != ""?"'" + ucBirthdate.DateTime.ToString("yyyy-MM-dd") + "'":"null") },
{ "Gender", "'" + rbGender.SelectedItem.Value + "'" },
{ "NID", "'" + txtNID.Text.SQLQueryFilter() + "'" },
{ "Phone", "'" + txtPhone.Text.SQLQueryFilter() + "'" },
{ "Mobile", "'" + txtMobile.Text.SQLQueryFilter() + "'" },
{ "Email", "'" + txtEmail.Text.SQLQueryFilter() + "'" },
{ "[Address]", "'" + txtAddress.Text.SQLQueryFilter() + "'" },
{ "AddressDistrict", "'" + txtAddressDistrict.Text.SQLQueryFilter() + "'" },
{ "AddressPrefecture", "'" + txtAddressPrefecture.Text.SQLQueryFilter() + "'" },
{ "AddressProvince", "'" + txtAddressProvince.Text.SQLQueryFilter() + "'" },
{ "AddressPostal", "'" + txtAddressPostal.Text.SQLQueryFilter() + "'" },
{ "Profile", "'" + ucProfile.Text.SQLQueryFilter() + "'" },
{ "Signature", "'" + ucSignature.Text.SQLQueryFilter() + "'" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", functionGetDate },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", functionGetDate },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" }
}, new string[, ] {
{ }
},
out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
}
catch (Exception ex)
{
lblSQL.Text = "<div style='color:red;'>เกิดข้อผิดพลาด : " + ex.Message + "</div>";
lblSQL.Focus();
}
#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;
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Authorize
if (!clsSecurity.LoginChecker("admin") && !clsSecurity.LoginChecker("hr"))
{
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(tableDefault,
new string[, ] {
{ "Name", "'" + txtName.Text.SQLQueryFilter() + "'" },
{ "Detail", "'" + ucDetail.Text.SQLQueryFilter() + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "D") + "'" }
}, new string[, ] {
{ parameterChar + "UID", id.ToString() }
},
"UID=" + parameterChar + "UID",
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", Server.HtmlEncode(outSQL), AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
#region Insert
else
{
if (clsSQL.Insert(tableDefault,
new string[, ] {
{ "Name", "'" + txtName.Text.SQLQueryFilter() + "'" },
{ "Detail", "'" + ucDetail.Text.SQLQueryFilter() + "'" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", "GETDATE()" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "D") + "'" }
}, new string[, ] {
{ }
},
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", Server.HtmlEncode(outSQL), AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
#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[, ] {
{ "Photo", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"Photo") },
{ "Name", "'" + txtName.Text.SQLQueryFilter() + "'" },
{ "Detail", "'" + txtDetail.Text.SQLQueryFilter() + "'" },
{ "MUser", clsSecurity.LoginUID },
{ "MWhen", functionGetDate },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "StatusFlag", "'" + (cbActive.Checked ? "A" : "I") + "'" }
}, new string[, ] {
{ parameterChar + "UID", id.ToString() }
},
"UID=" + parameterChar + "UID",
out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
#region Insert
else
{
#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[, ] {
{ "Photo", (!string.IsNullOrEmpty(photoName)?"'" + pathUpload + photoName + "'":"null") },
{ "Name", "'" + txtName.Text.SQLQueryFilter() + "'" },
{ "Detail", "'" + txtDetail.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("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
#endregion
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Authorize
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect("/", "กรุณาล็อคอินด้วยสิทธิ์ Admin");
return;
}
#endregion
#region Variable
StringBuilder strSQL = new StringBuilder();
int id = 0;
string outSQL;
#endregion
#region Update
if (Request.QueryString["id"] != null && clsDefault.QueryStringChecker("command") == "edit")
{
id = int.Parse(Request.QueryString["id"].ToString());
if (clsSQL.Update(tableDefault,
new string[, ] {
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "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
if (clsSQL.Insert(tableDefault,
new string[, ] {
{ "UID", id.ToString() },
{ "LanguageUID", rbLanguage.SelectedItem.Value },
{ "Name", "'" + clsSQL.CodeFilter(txtName.Text) + "'" },
{ "Detail", "'" + clsSQL.CodeFilter(txtDetail.Text) + "'" },
{ "CUser", "'" + clsSecurity.LoginUID + "'" },
{ "CWhen", "GETDATE()" },
{ "MUser", "'" + clsSecurity.LoginUID + "'" },
{ "MWhen", "GETDATE()" },
{ "Sort", clsSQL.CodeFilter(txtSort.Text) },
{ "Active", "'" + (cbActive.Checked ? "1" : "0") + "'" }
}, new string[, ] {
{ }
},
dbType, cs, out outSQL))
{
ucColorBox1.ReloadParent();
}
else
{
ucColorBox1.Alert("เกิดข้อผิดพลาดขณะบันทึกข้อมูล<br/>", outSQL, AlertImage: ucColorBox.Alerts.Fail);
}
}
#endregion
}
