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
}
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 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 btUpload_Click(object sender, EventArgs e)
{
string strFileName;
int i;
clsIO clsIO = new clsIO();
if (!fuUpload.HasFile)
{
lblUpload.Text = "โปรดเลือกรูปก่อน";
return;
}
if (fuUpload.PostedFile.ContentLength > maxSize * 1000)
{
lblUpload.Text = "<div style='color:red;'>ขนาดของไฟล์ใหญ่เกินไป ซึ่งต้องไม่เกิน " + maxSize + " KB</div>";
return;
}
for (i = 1; i < 10; i++)
{
strFileName = DateTime.Now.Year.ToString() +
DateTime.Now.Month.ToString() +
DateTime.Now.Day.ToString() +
DateTime.Now.Hour.ToString() +
DateTime.Now.Minute.ToString() +
DateTime.Now.Second.ToString() + "_" + i.ToString() +
System.IO.Path.GetExtension(fuUpload.FileName).ToLower();
if (!clsIO.FileExist(pathUpload + strFileName, false))
{
try
{
fuUpload.SaveAs(Server.MapPath(pathUpload + strFileName));
}
catch (Exception ex)
{
lblUpload.Text = "<div style='color:red;'>เกิดข้อผิดพลาดขณะอัพโหลดไฟล์ : " + ex.Message + "</div>";
return;
}
clsIO.ImageResize(maxWidth, 0, pathUpload + strFileName, "", webname, 0);
lblUpload.Text = "<div style='font-size:9pt;margin:5px 0px 5px 0px;'>อัพโหลดไฟล์เสร็จสิ้น : " +
"<span style='' title='Copy ชื่อไฟล์นี้ วางในหน้าแทรกภาพ'>" +
"<input id='txtInsertImages' type='text' value='" +
pathUpload + strFileName.Trim() +
"' style='border:1px solid #dddddd;background-color:#fafafa;width:300px;'/>" +
"</span></div>";
InsertTinyMCE("<img src=" + pathUpload + strFileName.Trim() + " />");
break;
}
}
}
private void Delete(string id)
{
pnDetail.Visible = false;
#region Authorize
if (!clsSecurity.LoginChecker("admin"))
{
ucColorBox1.Redirect(webDefault, "กรุณาล็อคอินด้วยสิทธิ์ 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 Photo FROM " + tableDefault + " WHERE UID=" + parameterChar + "UID",
new string[, ] {
{ parameterChar + "UID", id }
},
dbType,
cs);
if (photoName != "")
{
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 btInsertImages_Click(object sender, EventArgs e)
{
string strFileName;
int i;
clsIO clsIO = new clsIO();
if (fuInsertImages.PostedFile.ContentLength > maxSize * 1000)
{
lblInsertImages.Text = "<div style='color:red;'>ขนาดของไฟล์ใหญ่เกินไป ซึ่งต้องไม่เกิน " + maxSize + " KB</div>";
return;
}
for (i = 1; i < 10; i++)
{
strFileName = DateTime.Now.Year.ToString() +
DateTime.Now.Month.ToString() +
DateTime.Now.Day.ToString() +
DateTime.Now.Hour.ToString() +
DateTime.Now.Minute.ToString() +
DateTime.Now.Second.ToString() + "_" + i.ToString() +
System.IO.Path.GetExtension(fuInsertImages.FileName).ToLower();
if (!clsIO.FileExist(pathUpload + strFileName, false))
{
try
{
fuInsertImages.SaveAs(Server.MapPath(pathUpload + strFileName));
}
catch (Exception ex)
{
lblInsertImages.Text = "<div style='color:red;'>เกิดข้อผิดพลาดขณะอัพโหลดไฟล์ : " + ex.Message + "</div>";
return;
}
clsIO.ImageResize(maxWidth, 0, pathUpload + strFileName, "", webname, 0);
lblInsertImages.Text = "<div style='font-size:9pt;margin:5px 0px 5px 0px;'>อัพโหลดไฟล์เสร็จสิ้น : " +
"<span style='' title='Copy ชื่อไฟล์นี้ วางในหน้าแทรกภาพ'>" +
"<input id='txtInsertImages' type='text' value='" +
pathUpload + strFileName.Trim() +
"' style='border:1px solid #dddddd;background-color:#fafafa;width:300px;'/>" +
"</span></div>";
InsertTinyMCE("<img src=" + pathUpload + strFileName.Trim() + " />");
ChangeIFrameHeight(70);
break;
}
}
}
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 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 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 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
}
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("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 + "?group=" + clsDefault.QueryStringChecker("group"));
}
else
{
ucColorBox1.Redirect(webDefault + "?group=" + clsDefault.QueryStringChecker("group"), "เกิดข้อผิดพลาดขณะลบข้อมูล");
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
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 btSave_Click(object sender, EventArgs e)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
clsSecurity security = new clsSecurity();
clsIO IO = new clsIO();
string strDetailSub = string.Empty;
string strDetail = txtDetail.Text.Replace("<p>", "");
strDetail = strDetail.Replace("</p>", "");
string PicFull = "null";
string PicThumb = "null";
string pathPhoto = "/Images/Event/";
string pathImages = @"\Images\Event\";
string outError;
//upload Photo to server
if (txtImgFull.HasFile)
{
//Full Images
if (IO.UploadPhoto(txtImgFull, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 5120, 0, 0, "", 0, out outError, out PicFull) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicFull = pathImages + "" + PicFull;
}
}
else
{
PicFull = lblImagesFull.Text.Trim();
}
if (txtImgThum.HasFile)
{
//Thumb Images
if (IO.UploadPhoto(txtImgThum, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 2048, 0, 0, "", 0, out outError, out PicThumb) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicThumb = pathImages + "" + PicThumb;
}
}
else
{
PicThumb = lblImagesThumb.Text.Trim();
}
//insert data to database
try
{
if (txtDetail.Text.Length >= 200)
{
strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
}
else
{
strDetailSub = "<p>" + strDetail + ".....</p>";
}
//Insert new Event
if (string.IsNullOrEmpty(lblUID.Text) == true)
{
Event tbevent = new Event();
//Assign values for insert into database
tbevent.Subject = txtSubject.Text.Trim();
tbevent.Detail = txtDetail.Text;
tbevent.PicFull = PicFull;
tbevent.PicThumbnail = PicThumb;
tbevent.DepartmentUID = 1;
tbevent.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
tbevent.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
tbevent.Remark = txtRemark.Text.Trim();
tbevent.CWhen = DateTime.Now;
tbevent.CUser = Convert.ToInt32(security.LoginUID);
tbevent.MWhen = DateTime.Now;
tbevent.MUser = Convert.ToInt32(security.LoginUID);
tbevent.StatusFlag = rdbActive.Checked == true ? "A" : "D";
tbevent.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
tbevent.DetailSub = strDetailSub;
tbevent.MetaKeywords = txtMetaKeywords.Text.Trim();
tbevent.MetaDescription = txtMetaDescription.Text.Trim();
//Insert data of Event to database
db.Events.InsertOnSubmit(tbevent);
}
else //Update existing Event
{
var tbEvent = from ev in db.Events
where ev.UID == Convert.ToInt32(lblUID.Text.Trim())
select ev;
foreach (Event ev in tbEvent)
{
ev.Subject = txtSubject.Text.Trim();
ev.Detail = txtDetail.Text;
ev.PicFull = PicFull;
ev.PicThumbnail = PicThumb;
ev.DepartmentUID = 1;
ev.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
ev.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
ev.Remark = txtRemark.Text.Trim();
ev.MWhen = DateTime.Now;
ev.MUser = Convert.ToInt32(security.LoginUID);
ev.StatusFlag = rdbActive.Checked == true ? "A" : "D";
ev.MetaKeywords = txtMetaKeywords.Text.Trim();
ev.MetaDescription = txtMetaDescription.Text.Trim();
try
{
ev.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
}
catch (Exception ex)
{
ex.ToString();
}
ev.DetailSub = strDetailSub;
}
}
db.SubmitChanges();
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
}
}
private void PreLoading()
{
StringBuilder strScript = new StringBuilder();
clsIO clsIO = new clsIO();
string loaderImage = "Images/" + _loaderImage.ToString() + ".gif";
string loaderImageWidth = (clsIO.ImageWidth(ResolveClientUrl(loaderImage)) / 2).ToString();
string loaderImageHeight = (clsIO.ImageHeight(ResolveClientUrl(loaderImage)) / 2).ToString();
#region Create Display
if (!Page.ClientScript.IsStartupScriptRegistered(Page.GetType(), "PreLoading_BindDiv"))
{
StringBuilder strDIV = new StringBuilder();
strDIV.Append("<div id='" + _displayDiv + "' style='text-align:center;position:fixed;left:0;right:0;top:0;bottom:0;width:100%;height:100%;z-index: 99999;overflow:auto;");
#region Style
strDIV.Append("background-color:" + _backgroundColor + ";");
strDIV.Append("filter:alpha(opacity=" + (_opacity * 100).ToString() + ");");
strDIV.Append("opacity:" + _opacity.ToString() + ";");
#endregion
strDIV.Append("'>");
strDIV.Append("<div style='position:absolute;top: 50%;left: 50%;margin-top:-" + loaderImageHeight + "px;margin-left:-" + loaderImageWidth + "px;'>");
strDIV.Append("<img src='" + this.ResolveClientUrl(loaderImage) + "' alt=''/>");
strDIV.Append("</div>");
strDIV.Append("</div>");
Page.ClientScript.RegisterClientScriptBlock(
Page.GetType(),
"PreLoading_BindDiv",
strDIV.ToString()
);
}
#endregion
#region Create JavaScript
strScript.Append("<script type='text/javascript'>");
strScript.Append("window.onload = function PreLoading() {");
strScript.Append("if (document.getElementById)");
strScript.Append("{");
strScript.Append("document.getElementById('" + _displayDiv + "').style.visibility='hidden';");
strScript.Append("}");
strScript.Append("else");
strScript.Append("{");
strScript.Append("if (document.layers)");
strScript.Append("{");
strScript.Append("document." + _displayDiv + ".visibility = 'hidden';");
strScript.Append("}");
strScript.Append("else");
strScript.Append("{");
strScript.Append("document.all." + _displayDiv + ".style.visibility = 'hidden';");
strScript.Append("}");
strScript.Append("}");
strScript.Append("}");
strScript.Append("</script>");
if (!Page.ClientScript.IsStartupScriptRegistered(Page.GetType(), "PreLoading_Onload"))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "PreLoading_Onload", strScript.ToString());
strScript = null;
}
#endregion
}
protected void btSave_Click(object sender, EventArgs e)
{
clsSecurity security = new clsSecurity();
clsIO IO = new clsIO();
string strDetailSub = string.Empty;
string strDetail = txtDetail.Text.Replace("<p>", "");
strDetail = strDetail.Replace("</p>", "");
string PicFull = "null";
string PicThumb = "null";
string pathPhoto = "/Images/Article/";
string pathImages = @"\Images\Article\";
string outError;
//upload Photo to server
if (txtImanges.HasFile)
{
//Full Images
if (IO.UploadPhoto(txtImanges, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 5120, 0, 0, "", 0, out outError, out PicFull) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicFull = pathImages + "" + PicFull;
}
//Thumb Images
if (IO.UploadPhoto(txtImanges, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 1024, 100, 100, "", 0, out outError, out PicThumb) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicThumb = pathImages + "" + PicThumb;
}
}
else
{
PicFull = lblImagesFull.Text.Trim();
PicThumb = lblImagesThumb.Text.Trim();
}
//insert data to database
try
{
if (txtDetail.Text.Length >= 200)
{
strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
}
else
{
strDetailSub = "<p>" + strDetail + ".....</p>";
}
//Insert new Article
if (string.IsNullOrEmpty(lblUID.Text) == true)
{
Article tbarticle = new Article();
//Assign values for insert into database
tbarticle.Subject = txtSubject.Text.Trim();
tbarticle.Detail = txtDetail.Text;
tbarticle.PicFull = PicFull;
tbarticle.PicThumbnail = PicThumb;
tbarticle.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
tbarticle.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
tbarticle.Remark = txtRemark.Text.Trim();
tbarticle.CWhen = DateTime.Now;
tbarticle.CUser = Convert.ToInt32(security.LoginUID);
tbarticle.MWhen = DateTime.Now;
tbarticle.MUser = Convert.ToInt32(security.LoginUID);
tbarticle.StatusFlag = rdbActive.Checked == true ? "A" : "D";
tbarticle.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
tbarticle.DetailSub = strDetailSub;
tbarticle.NumberDislike = 0;
tbarticle.NumberLike = 0;
tbarticle.NumberView = 0;
tbarticle.Score = 0;
tbarticle.SampleSize = 0;
tbarticle.MetaKeywords = txtMetaKeywords.Text.Trim();
tbarticle.MetaDescription = txtMetaDescription.Text.Trim();
//Insert data of Event to database
db.Articles.InsertOnSubmit(tbarticle);
}
else //Update existing Event
{
var tbarticle = from a in db.Articles
where a.UID == Convert.ToInt32(lblUID.Text.Trim())
select a;
foreach (Article a in tbarticle)
{
a.Subject = txtSubject.Text.Trim();
a.Detail = txtDetail.Text;
a.PicFull = PicFull;
a.PicThumbnail = PicThumb;
a.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
a.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
a.Remark = txtRemark.Text.Trim();
a.MWhen = DateTime.Now;
a.MUser = Convert.ToInt32(security.LoginUID);
a.StatusFlag = rdbActive.Checked == true ? "A" : "D";
a.MetaKeywords = txtMetaKeywords.Text.Trim();
a.MetaDescription = txtMetaDescription.Text.Trim();
try
{
a.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
}
catch (Exception ex)
{
ex.ToString();
}
a.DetailSub = strDetailSub;
}
}
db.SubmitChanges();
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
}
catch (Exception ex)
{
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
}
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Variable
var outSQL = "";
var clsIO = new clsIO();
var outError="";
var outPhoto="";
var outMail = "";
#endregion
#region Procedure
if (fuPhoto.HasFile)
{
if(!clsIO.UploadPhoto(
fuPhoto,
"/Upload/Jobs/",
clsSQL.GetNewID("UID","JobsHistory","",dbType,cs).ToString(),
out outError,
out outPhoto,
512, 200, 200))
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดภาพ : " + outError);
return;
}
}
#region InsertData
if (!clsSQL.Insert(
"JobsHistory",
new string[,]{
{"JobsUID",ddlJobs.SelectedItem.Value},
{"JobsName","'"+txtJobsName.Text.SQLQueryFilter()+"'"},
{"Salary","'"+txtSalary.Text.SQLQueryFilter()+"'"},
{"Start","'"+txtStart.Text.SQLQueryFilter()+"'"},
{"ProvinceChange","'"+rbProvinceChange.SelectedItem.Value+"'"},
{"PrenameTH","'"+ddlPrenameTH.SelectedItem.Value+"'"},
{"ForenameTH","'"+txtForenameTH.Text.SQLQueryFilter()+"'"},
{"SurnameTH","'"+txtSurnameTH.Text.SQLQueryFilter()+"'"},
{"PrenameEN","'"+ddlPrenameEN.SelectedItem.Value+"'"},
{"ForenameEN","'"+txtForenameEN.Text.SQLQueryFilter()+"'"},
{"SurnameEN","'"+txtSurnameEN.Text.SQLQueryFilter()+"'"},
{"MarriageStatus","'"+rbMarriageStatus.SelectedItem.Value+"'"},
{"Gender","'"+rbGender.SelectedItem.Value+"'"},
{"Birthdate","'"+(ucBirthdate.Text.Trim()!=""?ucBirthdate.DateTime.ToString("yyyy-MM-dd"):"1900-01-01 00:00")+"'"},
{"Birthplace","'"+txtBirthplace.Text.SQLQueryFilter()+"'"},
{"Nationality","'"+txtNationality.Text.SQLQueryFilter()+"'"},
{"Race","'"+txtRace.Text.SQLQueryFilter()+"'"},
{"Religion","'"+txtReligion.Text.SQLQueryFilter()+"'"},
{"Weight","'"+txtWeight.Text.SQLQueryFilter()+"'"},
{"Height","'"+txtHeight.Text.SQLQueryFilter()+"'"},
{"NID","'"+txtNID.Text.SQLQueryFilter()+"'"},
{"NIDCreateBy","'"+txtNIDCreateBy.Text.SQLQueryFilter()+"'"},
{"NIDExpire","'"+(ucNIDExpire.Text!=""?ucNIDExpire.DateTime.ToString("yyyy-MM-dd"):"")+"'"},
{"Phone","'"+txtPhone.Text.SQLQueryFilter()+"'"},
{"Email","'"+txtEmail.Text.SQLQueryFilter()+"'"},
{"Address","'"+txtAddress.Text.SQLQueryFilter()+"'"},
{"EmergencyName","'"+txtEmergencyName.Text.SQLQueryFilter()+"'"},
{"EmergencyPhone","'"+txtEmergencyPhone.Text.SQLQueryFilter()+"'"},
{"EmergencyEmail","'"+txtEmergencyEmail.Text.SQLQueryFilter()+"'"},
{"EmergencyAddress","'"+txtEmergencyAddress.Text.SQLQueryFilter()+"'"},
{"EmergencyRelationship","'"+txtEmergencyRelationship.Text.SQLQueryFilter()+"'"},
{"Photo",(outPhoto!=""?"'"+outPhoto+"'":"null")},
{"Education","'"+ucEducation.Text.SQLQueryFilter()+"'"},
{"Experience","'"+ucExperience.Text.SQLQueryFilter()+"'"},
{"Resume","null"},
{"CWhen","GETDATE()"},
{"CUser","0"},
{"MWhen","GETDATE()"},
{"MUser","0"},
{"Sort","0"},
{"StatusFlag","'A'"}
},
new string[,] { { } },
dbType,
cs,
out outSQL))
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะรันคำสั่ง : " + Server.HtmlEncode(outSQL));
return;
}
else
{
#region MailSender
string JobsUID = clsSQL.Return("SELECT MAX(UID) FROM JobsHistory", dbType, cs);
if (!clsMail.SendTemplate(
"JobsApply",
clsMail.GetEmailList("AutoSystemFrom"),
clsMail.GetEmailList("JobsTo"),
new string[,]
{
{"[Photo]","<img src='"+System.Configuration.ConfigurationManager.AppSettings["website"]+"/Upload/Jobs/"+outPhoto+"'/>"},
{"[UID]", JobsUID},
{"[JobsName]", ddlJobs.SelectedItem.Text+(txtJobsName.Text.Trim()!=""?" ("+txtJobsName.Text.SQLQueryFilter()+")":"") },
{"[PrenameTH]",ddlPrenameTH.SelectedItem.Text},
{"[ForenameTH]",txtForenameTH.Text},
{"[SurnameTH]",txtSurnameTH.Text},
{"[Birthdate]",ucBirthdate.DateTime.ToString("dd/MM/yyyy")},
{"[Birthplace]",txtBirthplace.Text},
{"[Gender]",rbGender.SelectedItem.Text},
{"[Phone]",txtPhone.Text},
{"[Email]",txtEmail.Text},
{"[Start]",txtStart.Text.SQLQueryFilter()},
{"[Education]",ucEducation.Text.SQLQueryFilter()},
{"[Experience]",ucExperience.Text.SQLQueryFilter()},
{"[CWhen]",DateTime.Now.ToString("dd/MM/yyyy HH:mm")}
},
out outMail))
{
lblMessage.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblMessage.Focus();
return;
}
#endregion
ucColorBox1.Redirect("/Jobs/");
}
#endregion
#endregion
}
private void PreLoading()
{
StringBuilder strScript = new StringBuilder();
clsIO clsIO = new clsIO();
string loaderImage = "Images/" + _loaderImage.ToString() + ".gif";
string loaderImageWidth = (clsIO.ImageWidth(ResolveClientUrl(loaderImage)) / 2).ToString();
string loaderImageHeight = (clsIO.ImageHeight(ResolveClientUrl(loaderImage)) / 2).ToString();
#region Create Display
if (!Page.ClientScript.IsStartupScriptRegistered(Page.GetType(), "PreLoading_BindDiv"))
{
StringBuilder strDIV = new StringBuilder();
strDIV.Append("<div id='" + _displayDiv + "' style='text-align:center;position:fixed;left:0;right:0;top:0;bottom:0;width:100%;height:100%;z-index: 99999;overflow:auto;");
#region Style
strDIV.Append("background-color:" + _backgroundColor + ";");
strDIV.Append("filter:alpha(opacity=" + (_opacity * 100).ToString() + ");");
strDIV.Append("opacity:" + _opacity.ToString() + ";");
#endregion
strDIV.Append("'>");
strDIV.Append("<div style='position:absolute;top: 50%;left: 50%;margin-top:-" + loaderImageHeight + "px;margin-left:-" + loaderImageWidth + "px;'>");
strDIV.Append("<img src='" + this.ResolveClientUrl(loaderImage) + "' alt=''/>");
strDIV.Append("</div>");
strDIV.Append("</div>");
Page.ClientScript.RegisterClientScriptBlock(
Page.GetType(),
"PreLoading_BindDiv",
strDIV.ToString()
);
}
#endregion
#region Create JavaScript
strScript.Append("<script type='text/javascript'>");
strScript.Append("window.onload = function PreLoading() {");
strScript.Append("if (document.getElementById)");
strScript.Append("{");
strScript.Append("document.getElementById('" + _displayDiv + "').style.visibility='hidden';");
strScript.Append("}");
strScript.Append("else");
strScript.Append("{");
strScript.Append("if (document.layers)");
strScript.Append("{");
strScript.Append("document." + _displayDiv + ".visibility = 'hidden';");
strScript.Append("}");
strScript.Append("else");
strScript.Append("{");
strScript.Append("document.all." + _displayDiv + ".style.visibility = 'hidden';");
strScript.Append("}");
strScript.Append("}");
strScript.Append("}");
strScript.Append("</script>");
if (!Page.ClientScript.IsStartupScriptRegistered(Page.GetType(), "PreLoading_Onload"))
{
Page.ClientScript.RegisterClientScriptBlock(Page.GetType(), "PreLoading_Onload", strScript.ToString());
strScript = null;
}
#endregion
}
protected void btSave_Click(object sender, EventArgs e)
{
clsSecurity security = new clsSecurity();
clsIO IO = new clsIO();
string strDetailSub = string.Empty;
string strDetail = txtDetail.Text.Replace("<p>", "");
strDetail = strDetail.Replace("</p>", "");
string PicFull = "null";
string PicThumb = "null";
string pathPhoto = "/Images/Package/";
string pathImages = @"\Images\Package\";
string outError;
//upload Photo to server
if (txtImgFull.HasFile)
{
//Full Images
if (IO.UploadPhoto(txtImgFull, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 4096, 0, 0, "", 0, out outError, out PicFull) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicFull = pathImages + "" + PicFull;
}
}
else
{
PicFull = lblImagesFull.Text.Trim();
}
if (txtImgThum.HasFile)
{
//Thumb Images
if (IO.UploadPhoto(txtImgThum, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 2048, 0, 0, "", 0, out outError, out PicThumb) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicThumb = pathImages + "" + PicThumb;
}
}
else
{
PicThumb = lblImagesThumb.Text.Trim();
}
//insert data to database
try
{
if (txtDetail.Text.Length >= 200)
{
strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
}
else
{
strDetailSub = "<p>" + strDetail + ".....</p>";
}
//Insert new Package
if (string.IsNullOrEmpty(lblUID.Text) == true)
{
Package tbpackage = new Package();
//Assign values for insert into database
tbpackage.PackageName = txtSubject.Text.Trim();
tbpackage.Detail = txtDetail.Text;
tbpackage.PicFull = PicFull;
tbpackage.PicThumbnail = PicThumb;
tbpackage.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
if (!string.IsNullOrEmpty(txtDateTo.Text))
{
tbpackage.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
}
else
{
tbpackage.ActiveDateTo = null;
}
tbpackage.Remark = txtRemark.Text.Trim();
tbpackage.CWhen = DateTime.Now;
tbpackage.CUser = Convert.ToInt32(security.LoginUID);
tbpackage.MWhen = DateTime.Now;
tbpackage.MUser = Convert.ToInt32(security.LoginUID);
tbpackage.StatusFlag = rdbActive.Checked == true ? "A" : "D";
tbpackage.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
tbpackage.DepartmentUID = Convert.ToInt32(ddlDepartment.SelectedValue);
tbpackage.DetailSub = strDetailSub;
tbpackage.MetaKeywords = txtMetaKeywords.Text.Trim();
tbpackage.MetaDescription = txtMetaDescription.Text.Trim();
tbpackage.PackageCode = txtPackagecode.Text.Trim();
if (!string.IsNullOrEmpty(txtUnitPrice.Text))
{
tbpackage.UnitPrice = Convert.ToDouble(txtUnitPrice.Text.Trim());
}
else
{
tbpackage.UnitPrice = 0;
}
//Insert data of Event to database
db.Packages.InsertOnSubmit(tbpackage);
}
else //Update existing Event
{
var tbpackage = from p in db.Packages
where p.UID == Convert.ToInt32(lblUID.Text.Trim())
select p;
foreach (Package p in tbpackage)
{
p.PackageName = txtSubject.Text.Trim();
p.Detail = txtDetail.Text;
p.PicFull = PicFull;
p.PicThumbnail = PicThumb;
p.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
if (!string.IsNullOrEmpty(txtDateTo.Text))
{
p.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
}
else
{
p.ActiveDateTo = null;
}
p.Remark = txtRemark.Text.Trim();
p.MWhen = DateTime.Now;
p.MUser = Convert.ToInt32(security.LoginUID);
p.StatusFlag = rdbActive.Checked == true ? "A" : "D";
try
{
p.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
p.DepartmentUID = Convert.ToInt32(ddlDepartment.SelectedValue);
}
catch (Exception ex)
{
ex.ToString();
}
p.DetailSub = strDetailSub;
p.MetaKeywords = txtMetaKeywords.Text.Trim();
p.MetaDescription = txtMetaDescription.Text.Trim();
p.PackageCode = txtPackagecode.Text.Trim();
if (!string.IsNullOrEmpty(txtUnitPrice.Text))
{
p.UnitPrice = Convert.ToDouble(txtUnitPrice.Text.Trim());
}
else
{
p.UnitPrice = 0;
}
}
}
db.SubmitChanges();
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
}
}
protected void btInsertImages_Click(object sender, EventArgs e)
{
#region Variable
string strFileName;
clsIO clsIO = new clsIO();
string outErrorMessage = "";
string outFileName = "";
#endregion
#region Data Checker
if (fuInsertImages.PostedFile.ContentLength > maxSize * 1000)
{
lblInsertImages.Text = "<div class='fontWarn'>ขนาดไฟล์ใหญ่เกิน " + maxSize + " KB</div>";
lblInsertImages.Focus();
return;
}
#endregion
for (int i = 1; i < 10; i++)
{
#region FileName Builder
strFileName = prefixName +
DateTime.Now.Year.ToString() +
DateTime.Now.Month.ToString() +
DateTime.Now.Day.ToString() +
DateTime.Now.Hour.ToString() +
DateTime.Now.Minute.ToString() +
DateTime.Now.Second.ToString() + "_" + i.ToString();
#endregion
#region Upload
if (!clsIO.FileExist(
pathUpload + strFileName + fuInsertImages + Path.GetExtension(fuInsertImages.FileName).ToLower(),
false))
{
if (!clsIO.UploadPhoto(
fuInsertImages,
pathUpload,
strFileName,
out outErrorMessage,
out outFileName,
maxSize,
maxWidth,
maxHeight,
clsIO.ResizeAnchor.middlecenter,
clsIO.ResizeMode.max))
{
lblInsertImages.Text = "<div class='fontWarn'>เกิดข้อผิดพลาดขณะอัพโหลดไฟล์ : " + outErrorMessage + "</div>";
return;
}
#region Show Detail
/*
* lblInsertImages.Text = "<div style='font-size:9pt;margin:5px 0px 5px 0px;'>อัพโหลดไฟล์เสร็จสิ้น : " +
* "<span style='' title='Copy ชื่อไฟล์นี้ วางในหน้าแทรกภาพ'>" +
* "<input id='txtInsertImages' type='text' value='" +
* pathUpload + strFileName.Trim() +
* "' style='border:1px solid #dddddd;background-color:#fafafa;width:300px;'/>" +
* "</span></div>";
* ChangeIFrameHeight(70);
*/
#endregion
InsertTinyMCE("<img src=" + pathUpload + outFileName + " />");
break;
}
#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();
#endregion
#region Delete Photo
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("Icon ");
strSQL.Append("FROM ");
strSQL.Append("Service ");
strSQL.Append("WHERE ");
strSQL.Append("ServiceGroupUID=" + 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=" + id);
#endregion
if (clsSQL.Execute(strSQL.ToString(), dbType, cs))
{
ucColorBox1.Redirect(webDefault);
}
else
{
ucColorBox1.Redirect(webDefault, "เกิดข้อผิดพลาดขณะลบข้อมูล");
}
strSQL.Length = 0; strSQL.Capacity = 0;
#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 btSave_Click(object sender, EventArgs e)
{
clsSecurity security = new clsSecurity();
clsIO IO = new clsIO();
string strDetailSub = string.Empty;
string strDetail = txtDetail.Text.Replace("<p>", "");
strDetail = strDetail.Replace("</p>", "");
string PicFull = "null";
string PicThumb = "null";
string pathPhoto = "/Images/Article/";
string pathImages = @"\Images\Article\";
string outError;
//upload Photo to server
if (txtImanges.HasFile)
{
//Full Images
if (IO.UploadPhoto(txtImanges, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 5120, 0, 0, "", 0, out outError, out PicFull) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicFull = pathImages + "" + PicFull;
}
//Thumb Images
if (IO.UploadPhoto(txtImanges, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 1024, 100, 100, "", 0, out outError, out PicThumb) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicThumb = pathImages + "" + PicThumb;
}
}
else
{
PicFull = lblImagesFull.Text.Trim();
PicThumb = lblImagesThumb.Text.Trim();
}
//insert data to database
try
{
if (txtDetail.Text.Length >= 200)
{
strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
}
else
{
strDetailSub = "<p>" + strDetail + ".....</p>";
}
//Insert new Article
if (string.IsNullOrEmpty(lblUID.Text) == true)
{
Article tbarticle = new Article();
//Assign values for insert into database
tbarticle.Subject = txtSubject.Text.Trim();
tbarticle.Detail = txtDetail.Text;
tbarticle.PicFull = PicFull;
tbarticle.PicThumbnail = PicThumb;
tbarticle.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
tbarticle.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
tbarticle.Remark = txtRemark.Text.Trim();
tbarticle.CWhen = DateTime.Now;
tbarticle.CUser = Convert.ToInt32(security.LoginUID);
tbarticle.MWhen = DateTime.Now;
tbarticle.MUser = Convert.ToInt32(security.LoginUID);
tbarticle.StatusFlag = rdbActive.Checked == true ? "A" : "D";
tbarticle.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
tbarticle.DetailSub = strDetailSub;
tbarticle.NumberDislike = 0;
tbarticle.NumberLike = 0;
tbarticle.NumberView = 0;
tbarticle.Score = 0;
tbarticle.SampleSize = 0;
tbarticle.MetaKeywords = txtMetaKeywords.Text.Trim();
tbarticle.MetaDescription = txtMetaDescription.Text.Trim();
//Insert data of Event to database
db.Articles.InsertOnSubmit(tbarticle);
}
else //Update existing Event
{
var tbarticle = from a in db.Articles
where a.UID == Convert.ToInt32(lblUID.Text.Trim())
select a;
foreach (Article a in tbarticle)
{
a.Subject = txtSubject.Text.Trim();
a.Detail = txtDetail.Text;
a.PicFull = PicFull;
a.PicThumbnail = PicThumb;
a.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
a.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
a.Remark = txtRemark.Text.Trim();
a.MWhen = DateTime.Now;
a.MUser = Convert.ToInt32(security.LoginUID);
a.StatusFlag = rdbActive.Checked == true ? "A" : "D";
a.MetaKeywords = txtMetaKeywords.Text.Trim();
a.MetaDescription = txtMetaDescription.Text.Trim();
try
{
a.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
}
catch (Exception ex)
{
ex.ToString();
}
a.DetailSub = strDetailSub;
}
}
db.SubmitChanges();
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
}
catch (Exception ex)
{
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
}
}
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 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
var outSQL = "";
var clsIO = new clsIO();
var outError = "";
var outPhoto = "";
var outMail = "";
#endregion
#region Procedure
if (fuPhoto.HasFile)
{
if (!clsIO.UploadPhoto(
fuPhoto,
"/Upload/Jobs/",
clsSQL.GetNewID("UID", "JobsHistory", "", dbType, cs).ToString(),
out outError,
out outPhoto,
512, 200, 200))
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะอัพโหลดภาพ : " + outError);
return;
}
}
#region InsertData
if (!clsSQL.Insert(
"JobsHistory",
new string[, ] {
{ "JobsUID", ddlJobs.SelectedItem.Value },
{ "JobsName", "'" + txtJobsName.Text.SQLQueryFilter() + "'" },
{ "Salary", "'" + txtSalary.Text.SQLQueryFilter() + "'" },
{ "Start", "'" + txtStart.Text.SQLQueryFilter() + "'" },
{ "ProvinceChange", "'" + rbProvinceChange.SelectedItem.Value + "'" },
{ "PrenameTH", "'" + ddlPrenameTH.SelectedItem.Value + "'" },
{ "ForenameTH", "'" + txtForenameTH.Text.SQLQueryFilter() + "'" },
{ "SurnameTH", "'" + txtSurnameTH.Text.SQLQueryFilter() + "'" },
{ "PrenameEN", "'" + ddlPrenameEN.SelectedItem.Value + "'" },
{ "ForenameEN", "'" + txtForenameEN.Text.SQLQueryFilter() + "'" },
{ "SurnameEN", "'" + txtSurnameEN.Text.SQLQueryFilter() + "'" },
{ "MarriageStatus", "'" + rbMarriageStatus.SelectedItem.Value + "'" },
{ "Gender", "'" + rbGender.SelectedItem.Value + "'" },
{ "Birthdate", "'" + (ucBirthdate.Text.Trim() != ""?ucBirthdate.DateTime.ToString("yyyy-MM-dd"):"1900-01-01 00:00") + "'" },
{ "Birthplace", "'" + txtBirthplace.Text.SQLQueryFilter() + "'" },
{ "Nationality", "'" + txtNationality.Text.SQLQueryFilter() + "'" },
{ "Race", "'" + txtRace.Text.SQLQueryFilter() + "'" },
{ "Religion", "'" + txtReligion.Text.SQLQueryFilter() + "'" },
{ "Weight", "'" + txtWeight.Text.SQLQueryFilter() + "'" },
{ "Height", "'" + txtHeight.Text.SQLQueryFilter() + "'" },
{ "NID", "'" + txtNID.Text.SQLQueryFilter() + "'" },
{ "NIDCreateBy", "'" + txtNIDCreateBy.Text.SQLQueryFilter() + "'" },
{ "NIDExpire", "'" + (ucNIDExpire.Text != ""?ucNIDExpire.DateTime.ToString("yyyy-MM-dd"):"") + "'" },
{ "Phone", "'" + txtPhone.Text.SQLQueryFilter() + "'" },
{ "Email", "'" + txtEmail.Text.SQLQueryFilter() + "'" },
{ "Address", "'" + txtAddress.Text.SQLQueryFilter() + "'" },
{ "EmergencyName", "'" + txtEmergencyName.Text.SQLQueryFilter() + "'" },
{ "EmergencyPhone", "'" + txtEmergencyPhone.Text.SQLQueryFilter() + "'" },
{ "EmergencyEmail", "'" + txtEmergencyEmail.Text.SQLQueryFilter() + "'" },
{ "EmergencyAddress", "'" + txtEmergencyAddress.Text.SQLQueryFilter() + "'" },
{ "EmergencyRelationship", "'" + txtEmergencyRelationship.Text.SQLQueryFilter() + "'" },
{ "Photo", (outPhoto != ""?"'" + outPhoto + "'":"null") },
{ "Education", "'" + ucEducation.Text.SQLQueryFilter() + "'" },
{ "Experience", "'" + ucExperience.Text.SQLQueryFilter() + "'" },
{ "Resume", "null" },
{ "CWhen", "GETDATE()" },
{ "CUser", "0" },
{ "MWhen", "GETDATE()" },
{ "MUser", "0" },
{ "Sort", "0" },
{ "StatusFlag", "'A'" }
},
new string[, ] {
{ }
},
dbType,
cs,
out outSQL))
{
ucColorBox1.Alert("เกิดข้อผิดพลาด", "เกิดข้อผิดพลาดขณะรันคำสั่ง : " + Server.HtmlEncode(outSQL));
return;
}
else
{
#region MailSender
string JobsUID = clsSQL.Return("SELECT MAX(UID) FROM JobsHistory", dbType, cs);
if (!clsMail.SendTemplate(
"JobsApply",
clsMail.GetEmailList("AutoSystemFrom"),
clsMail.GetEmailList("JobsTo"),
new string[, ]
{
{ "[Photo]", "<img src='" + System.Configuration.ConfigurationManager.AppSettings["website"] + "/Upload/Jobs/" + outPhoto + "'/>" },
{ "[UID]", JobsUID },
{ "[JobsName]", ddlJobs.SelectedItem.Text + (txtJobsName.Text.Trim() != ""?" (" + txtJobsName.Text.SQLQueryFilter() + ")":"") },
{ "[PrenameTH]", ddlPrenameTH.SelectedItem.Text },
{ "[ForenameTH]", txtForenameTH.Text },
{ "[SurnameTH]", txtSurnameTH.Text },
{ "[Birthdate]", ucBirthdate.DateTime.ToString("dd/MM/yyyy") },
{ "[Birthplace]", txtBirthplace.Text },
{ "[Gender]", rbGender.SelectedItem.Text },
{ "[Phone]", txtPhone.Text },
{ "[Email]", txtEmail.Text },
{ "[Start]", txtStart.Text.SQLQueryFilter() },
{ "[Education]", ucEducation.Text.SQLQueryFilter() },
{ "[Experience]", ucExperience.Text.SQLQueryFilter() },
{ "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm") }
},
out outMail))
{
lblMessage.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblMessage.Focus();
return;
}
#endregion
ucColorBox1.Redirect("/Jobs/");
}
#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;
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 = "";
#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
}
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,
tableDefault + 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,
tableDefault + 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",(ddlDepartment.SelectedItem.Value!="null"?"'"+ddlDepartment.SelectedItem.Value+"'":"null")},
{"PicThumbnail",(!string.IsNullOrEmpty(photoName)?"'"+pathUpload+photoName+"'":"PicThumbnail")},
{"PicFull",(!string.IsNullOrEmpty(photoFullName)?"'"+pathUpload+photoFullName+"'":"PicFull")},
{"PromotionName","'"+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")},
{"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,
tableDefault + 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,
tableDefault + 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",(ddlDepartment.SelectedItem.Value!="null"?"'"+ddlDepartment.SelectedItem.Value+"'":"null")},
{"PicThumbnail",(!string.IsNullOrEmpty(photoName)?"'"+pathUpload+photoName+"'":"null")},
{"PicFull",(!string.IsNullOrEmpty(photoFullName)?"'"+pathUpload+photoFullName+"'":"null")},
{"PromotionName","'"+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")},
{"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 btSave_Click(object sender, EventArgs e)
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
clsSecurity security = new clsSecurity();
clsIO IO = new clsIO();
string strDetailSub = string.Empty;
string strDetail = txtDetail.Text.Replace("<p>", "");
strDetail = strDetail.Replace("</p>", "");
string PicFull = "null";
string PicThumb = "null";
string pathPhoto = "/Images/Event/";
string pathImages = @"\Images\Event\";
string outError;
//upload Photo to server
if(txtImgFull.HasFile)
{
//Full Images
if (IO.UploadPhoto(txtImgFull, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 5120, 0, 0, "", 0, out outError, out PicFull) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicFull = pathImages + "" + PicFull;
}
}
else
{
PicFull = lblImagesFull.Text.Trim();
}
if (txtImgThum.HasFile)
{
//Thumb Images
if (IO.UploadPhoto(txtImgThum, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 2048, 0, 0, "", 0, out outError, out PicThumb) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicThumb = pathImages + "" + PicThumb;
}
}
else
{
PicThumb = lblImagesThumb.Text.Trim();
}
//insert data to database
try
{
if (txtDetail.Text.Length >= 200)
{
strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
}
else
{
strDetailSub = "<p>" + strDetail + ".....</p>";
}
//Insert new Event
if (string.IsNullOrEmpty(lblUID.Text) == true)
{
Event tbevent = new Event();
//Assign values for insert into database
tbevent.Subject = txtSubject.Text.Trim();
tbevent.Detail = txtDetail.Text;
tbevent.PicFull = PicFull;
tbevent.PicThumbnail = PicThumb;
tbevent.DepartmentUID = 1;
tbevent.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
tbevent.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
tbevent.Remark = txtRemark.Text.Trim();
tbevent.CWhen = DateTime.Now;
tbevent.CUser = Convert.ToInt32(security.LoginUID);
tbevent.MWhen = DateTime.Now;
tbevent.MUser = Convert.ToInt32(security.LoginUID);
tbevent.StatusFlag = rdbActive.Checked == true ? "A" : "D";
tbevent.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
tbevent.DetailSub = strDetailSub;
tbevent.MetaKeywords = txtMetaKeywords.Text.Trim();
tbevent.MetaDescription = txtMetaDescription.Text.Trim();
//Insert data of Event to database
db.Events.InsertOnSubmit(tbevent);
}
else //Update existing Event
{
var tbEvent = from ev in db.Events
where ev.UID == Convert.ToInt32(lblUID.Text.Trim())
select ev;
foreach (Event ev in tbEvent)
{
ev.Subject = txtSubject.Text.Trim();
ev.Detail = txtDetail.Text;
ev.PicFull = PicFull;
ev.PicThumbnail = PicThumb;
ev.DepartmentUID = 1;
ev.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
ev.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
ev.Remark = txtRemark.Text.Trim();
ev.MWhen = DateTime.Now;
ev.MUser = Convert.ToInt32(security.LoginUID);
ev.StatusFlag = rdbActive.Checked == true ? "A" : "D";
ev.MetaKeywords = txtMetaKeywords.Text.Trim();
ev.MetaDescription = txtMetaDescription.Text.Trim();
try
{
ev.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
}
catch(Exception ex)
{
ex.ToString();
}
ev.DetailSub = strDetailSub;
}
}
db.SubmitChanges();
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
}
}
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,
"MedicalCenter" + 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},
{"MedicalCenterGroupUID",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)+"'"},
{"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,
"MedicalCenter" + 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},
{"MedicalCenterGroupUID",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)+"'"},
{"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
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 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 btSave_Click(object sender, EventArgs e)
{
clsSecurity security = new clsSecurity();
clsIO IO = new clsIO();
string strDetailSub = string.Empty;
string strDetail = txtDetail.Text.Replace("<p>", "");
strDetail = strDetail.Replace("</p>", "");
string PicFull = "null";
string PicThumb = "null";
string pathPhoto = "/Images/Package/";
string pathImages = @"\Images\Package\";
string outError;
//upload Photo to server
if (txtImgFull.HasFile)
{
//Full Images
if (IO.UploadPhoto(txtImgFull, pathPhoto, "f_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 4096, 0, 0, "", 0, out outError, out PicFull) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicFull = pathImages + "" + PicFull;
}
}
else
{
PicFull = lblImagesFull.Text.Trim();
}
if (txtImgThum.HasFile)
{
//Thumb Images
if (IO.UploadPhoto(txtImgThum, pathPhoto, "t_pic" + DateTime.Now.ToString("yyyyMMddHHmmss"), 2048, 0, 0, "", 0, out outError, out PicThumb) == false)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + outError.ToString() + "')", true);
return;
}
else
{
PicThumb = pathImages + "" + PicThumb;
}
}
else
{
PicThumb = lblImagesThumb.Text.Trim();
}
//insert data to database
try
{
if (txtDetail.Text.Length >= 200)
{
strDetailSub = "<p>" + strDetail.Substring(0, 200) + ".....</p>";
}
else
{
strDetailSub = "<p>" + strDetail + ".....</p>";
}
//Insert new Package
if (string.IsNullOrEmpty(lblUID.Text) == true)
{
Package tbpackage = new Package();
//Assign values for insert into database
tbpackage.PackageName = txtSubject.Text.Trim();
tbpackage.Detail = txtDetail.Text;
tbpackage.PicFull = PicFull;
tbpackage.PicThumbnail = PicThumb;
tbpackage.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
if (!string.IsNullOrEmpty(txtDateTo.Text))
{
tbpackage.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
}
else
{
tbpackage.ActiveDateTo = null;
}
tbpackage.Remark = txtRemark.Text.Trim();
tbpackage.CWhen = DateTime.Now;
tbpackage.CUser = Convert.ToInt32(security.LoginUID);
tbpackage.MWhen = DateTime.Now;
tbpackage.MUser = Convert.ToInt32(security.LoginUID);
tbpackage.StatusFlag = rdbActive.Checked == true ? "A" : "D";
tbpackage.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
tbpackage.DepartmentUID = Convert.ToInt32(ddlDepartment.SelectedValue);
tbpackage.DetailSub = strDetailSub;
tbpackage.MetaKeywords = txtMetaKeywords.Text.Trim();
tbpackage.MetaDescription = txtMetaDescription.Text.Trim();
tbpackage.PackageCode = txtPackagecode.Text.Trim();
if (!string.IsNullOrEmpty(txtUnitPrice.Text))
{
tbpackage.UnitPrice = Convert.ToDouble(txtUnitPrice.Text.Trim());
}
else
{
tbpackage.UnitPrice = 0;
}
//Insert data of Event to database
db.Packages.InsertOnSubmit(tbpackage);
}
else //Update existing Event
{
var tbpackage = from p in db.Packages
where p.UID == Convert.ToInt32(lblUID.Text.Trim())
select p;
foreach (Package p in tbpackage)
{
p.PackageName = txtSubject.Text.Trim();
p.Detail = txtDetail.Text;
p.PicFull = PicFull;
p.PicThumbnail = PicThumb;
p.ActiveDateFrom = Convert.ToDateTime(txtDateFrom.Text);
if (!string.IsNullOrEmpty(txtDateTo.Text))
{
p.ActiveDateTo = Convert.ToDateTime(txtDateTo.Text);
}
else
{
p.ActiveDateTo = null;
}
p.Remark = txtRemark.Text.Trim();
p.MWhen = DateTime.Now;
p.MUser = Convert.ToInt32(security.LoginUID);
p.StatusFlag = rdbActive.Checked == true ? "A" : "D";
try
{
p.LanguageUID = Convert.ToInt32(ddlLanguage.SelectedValue);
p.DepartmentUID = Convert.ToInt32(ddlDepartment.SelectedValue);
}
catch (Exception ex)
{
ex.ToString();
}
p.DetailSub = strDetailSub;
p.MetaKeywords = txtMetaKeywords.Text.Trim();
p.MetaDescription = txtMetaDescription.Text.Trim();
p.PackageCode = txtPackagecode.Text.Trim();
if (!string.IsNullOrEmpty(txtUnitPrice.Text))
{
p.UnitPrice = Convert.ToDouble(txtUnitPrice.Text.Trim());
}
else
{
p.UnitPrice = 0;
}
}
}
db.SubmitChanges();
clsColorBox clsColorBox = new clsColorBox();
clsColorBox.Refresh();
//Page.ClientScript.RegisterStartupScript(Page.GetType(), "closeWindow", "<script language='javascript'>parent.$.colorbox.close();</script>");
}
catch (Exception ex)
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "Information", "alert('" + ex.ToString() + "')", true);
}
}