protected void Page_Load(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(_validateGroup))
{
vldCaptcha.ValidationGroup = _validateGroup;
vldRequire.ValidationGroup = _validateGroup;
}
vldCaptcha.ErrorMessage = clsDefault.AlertMessageColor(_errorMessage, clsDefault.AlertType.Fail);
vldRequire.ErrorMessage = clsDefault.AlertMessageColor(_errorMessage, clsDefault.AlertType.Fail);
GetCaptcha();
}
private void DefaultBuilder()
{
gvDefault.Visible = true; pnDetail.Visible = false;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region Procedure
#region SQLQuery
strSQL.Append("SELECT ");
strSQL.Append("B.Name LanguageName,");
strSQL.Append("A.UID,");
strSQL.Append("A.PackageName Subject,");
strSQL.Append("A.DetailSub,");
strSQL.Append("A.PicThumbnail,");
strSQL.Append("A.UnitPrice,");
strSQL.Append("A.ActiveDateFrom,");
strSQL.Append("A.ActiveDateTo,");
strSQL.Append("A.DepartmentUID,");
strSQL.Append("A.StatusFlag ");
strSQL.Append("FROM ");
strSQL.Append("Package A INNER JOIN Language B ON A.LanguageUID=B.UID AND B.Active='1' ");
if (clsSecurity.LoginChecker("admin"))
{
strSQL.Append("ORDER BY ");
strSQL.Append("A.MWhen DESC;");
}
else
{
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND B.Name='" + clsLanguage.LanguageCurrent + "' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= GETDATE()) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= GETDATE()) ");
strSQL.Append("ORDER BY ");
strSQL.Append("A.MWhen DESC;");
}
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
gvDefault.DataSource = dt;
gvDefault.DataBind();
}
else
{
lblDefault.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล");
}
#endregion
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append(tableDefault + ".UID,");
strSQL.Append(tableDefault + ".HN,");
strSQL.Append(tableDefault + ".PName,");
strSQL.Append(tableDefault + ".FName,");
strSQL.Append(tableDefault + ".LName,");
strSQL.Append(tableDefault + ".Email,");
strSQL.Append(tableDefault + ".Phone,");
strSQL.Append(tableDefault + ".DoctorName,");
strSQL.Append(tableDefault + ".DepartmentName,");
strSQL.Append(tableDefault + ".Comment,");
strSQL.Append(tableDefault + ".BirthDate,");
strSQL.Append(tableDefault + ".NID,");
strSQL.Append(tableDefault + ".AppointmentDate,");
strSQL.Append(tableDefault + ".MWhen,");
strSQL.Append(tableDefault + ".Sort,");
strSQL.Append(tableDefault + ".Active ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " ");
strSQL.Append("ORDER BY ");
strSQL.Append(tableDefault + ".Sort");
strSQL.Append("," + tableDefault + ".MWhen DESC");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception ex)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
gvDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region Header Builder
lblHeader.Text = clsSQL.Return("SELECT Name FROM MedicalCenterGroup WHERE UID=" + clsDefault.QueryStringChecker("group"), dbType, cs);
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append(tableDefault + ".UID,");
strSQL.Append(tableDefault + ".Name,");
strSQL.Append(tableDefault + ".Detail,");
strSQL.Append(tableDefault + ".MWhen,");
strSQL.Append(tableDefault + ".Sort,");
strSQL.Append(tableDefault + ".Active,");
strSQL.Append("Language.Name LanguageName,");
strSQL.Append("Language.Icon LanguageIcon ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " ");
strSQL.Append("INNER JOIN Language ON " + tableDefault + ".LanguageUID=Language.UID ");
#region Where
strSQL.Append("WHERE ");
strSQL.Append("MedicalCenterGroupUID=" + clsDefault.QueryStringChecker("group") + " ");
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append(tableDefault + ".Sort,");
strSQL.Append("Language.Sort");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception ex)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
gvDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
}
protected void btLogin_Click(object sender, EventArgs e)
{
#region Variable
var clsSQL = new clsSQL();
var clsDefault = new clsDefault();
var clsColorBox = new clsColorBox();
#endregion
#region Procedure
if (clsSecurity.LoginChecker(
clsSQL.CodeFilter(txtUsername.Text),
clsSQL.CodeFilter(txtPassword.Text),
cbEnableCookie.Checked))
{
//ucColorBox.Redirect(Request.RawUrl, "เข้าสู่ระบบแล้ว");
Response.Redirect(Request.RawUrl);
}
else
{
var script = "document.getElementById('dvUCLogon').scrollIntoView(true);";
Page.ClientScript.RegisterStartupScript(Page.GetType(),
"ucColorBoxScroller",
script,
true);
ucColorBox.Alert("Login Alert", "ไม่พบข้อมูลที่คุณกรอก", AlertImage: global::ucColorBox.Alerts.Fail);
lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn);
}
#endregion
}
protected void DefaultBuilder()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region Procedure
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("A.UID,");
strSQL.Append("A.Photo,");
strSQL.Append("A.Name,");
strSQL.Append("A.Detail,");
strSQL.Append("A.Type,");
strSQL.Append("A.MWhen,");
strSQL.Append("A.Sort,");
strSQL.Append("A.StatusFlag ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " A ");
#region Where
strSQL.Append("WHERE ");
//strSQL.Append("Type='Progress' ");
strSQL.Append("Type=Type ");
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append("A.Sort;");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString());
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
#region PageBuilder
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
#endregion
gvDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
#endregion
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Variable
string outMail = "";
#endregion
if (txtFromName.Text.Trim().Length > 0 &&
txtFromPhone.Text.Trim().Length > 0 &&
txtFromEmail.Text.Trim().Length > 0 &&
txtMessage.Text.Trim().Length > 0)
{
if (clsMail.SendTemplate(
"Feedback",
clsMail.GetEmailList("AutoSystemFrom"),
clsMail.GetEmailList("FeedbackTo"),
new string[, ]
{
{ "[FromName]", txtFromName.Text },
{ "[FromPhone]", txtFromPhone.Text },
{ "[FromEmail]", txtFromEmail.Text },
{ "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") },
{ "[Message]", txtMessage.Text }
},
out outMail))
{
txtFromName.Text = "";
txtFromEmail.Text = "";
txtFromPhone.Text = "";
txtMessage.Text = "";
//lblAlert.Text = clsDefault.AlertMessageColor("ระบบได้รับข้อความของคุณแล้ว");
//lblAlert.Focus();
ucColorBox1.Redirect("/Feedback/", "ได้รับข้อความของคุณแล้ว");
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblAlert.Focus();
}
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("กรุณากรอกข้อมูลให้ครบก่อนค่ะ", clsDefault.AlertType.Warn);
}
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
StringBuilder strSQL = new StringBuilder();
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("Content.UID,");
strSQL.Append("Content.Name,");
strSQL.Append("Content.Detail,");
strSQL.Append("Content.MWhen,");
strSQL.Append("Content.Active,");
strSQL.Append("Language.Name LanguageName,");
strSQL.Append("Language.Icon LanguageIcon ");
strSQL.Append("FROM ");
strSQL.Append("Content ");
strSQL.Append("INNER JOIN Language ON Content.LanguageUID=Language.UID ");
strSQL.Append("ORDER BY ");
strSQL.Append("Content.Name,");
strSQL.Append("Language.Sort");
#endregion
DataTable dt = new DataTable();
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception ex)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
gvDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
strSQL.Length = 0; strSQL.Capacity = 0;
}
protected void BindDefault()
{
dlDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
var clsSQL = new clsSQL(clsGlobal.dbType, clsGlobal.cs);
#endregion
#region Procedure
#region Header Builder
lblHeader.Text = clsSQL.Return("SELECT Name FROM " + tableParrent + " WHERE UID=" + clsDefault.QueryStringChecker("group"));
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("A.UID,");
strSQL.Append("A.PhotoPreview,");
strSQL.Append("A.Photo,");
strSQL.Append("A.Name,");
strSQL.Append("A.Detail,");
strSQL.Append("A.[View],");
strSQL.Append("A.MWhen,");
strSQL.Append("A.Sort,");
strSQL.Append("A.StatusFlag ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " A ");
#region Where
strSQL.Append("WHERE ");
strSQL.Append("PhotoGalleryGroupUID=" + clsDefault.QueryStringChecker("group") + " ");
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append("A.Sort");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString());
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
dlDefault.DataSource = dt;
dlDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
#endregion
}
private void GalleryBuilder()
{
#region Variable
bool errorCheck = false;
#endregion
#region Data Builder
if (_source != null && _source.Rows.Count > 0)
{
lblGallery.Text = "";
#region Error Check
if (!_source.Columns.Contains(_sourceFieldName) && _visible)
{
lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldName + " ใน Source ที่ส่งมา</div>";
errorCheck = true;
}
if (!_source.Columns.Contains(_sourceFieldDetail) && _visible)
{
lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldDetail + " ใน Source ที่ส่งมา</div>";
errorCheck = true;
}
if (!_source.Columns.Contains(_sourceFieldPhoto) && _visible)
{
lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldPhoto + " ใน Source ที่ส่งมา</div>";
errorCheck = true;
}
if (!_source.Columns.Contains(_sourceFieldPhotoPreview) && _visible)
{
lblGallery.Text += "<div>ไม่พบคอลัม " + _sourceFieldPhotoPreview + " ใน Source ที่ส่งมา</div>";
errorCheck = true;
}
if (errorCheck)
{
return;
}
#endregion
dlGallery.RepeatColumns = _repeatColumns;
dlGallery.DataSource = _source;
dlGallery.DataBind();
dlGallery.Visible = _visible;
}
else
{
if (_visible)
{
lblGallery.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลใน Source", clsDefault.AlertType.Warn);
}
}
#endregion
}
protected void BindDefault()
{
dlDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region Header Builder
lblHeader.Text = clsSQL.Return("SELECT Name FROM " + clsDefault.QueryStringChecker("globalname") + " WHERE UID=" + clsDefault.QueryStringChecker("globalid"), dbType, cs);
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append(tableDefault + ".UID,");
strSQL.Append(tableDefault + ".PhotoPreview,");
strSQL.Append(tableDefault + ".Photo,");
strSQL.Append(tableDefault + ".Name,");
strSQL.Append(tableDefault + ".Detail,");
strSQL.Append(tableDefault + ".[View],");
strSQL.Append(tableDefault + ".MWhen,");
strSQL.Append(tableDefault + ".Sort,");
strSQL.Append(tableDefault + ".Active ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " ");
#region Where
strSQL.Append("WHERE ");
strSQL.Append("GlobalName='" + clsDefault.QueryStringChecker("globalname") + "' ");
strSQL.Append("AND GlobalUID=" + clsDefault.QueryStringChecker("globalid") + " ");
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append(tableDefault + ".Sort");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
dlDefault.DataSource = dt;
dlDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
}
protected void btLogin_Click(object sender, EventArgs e)
{
clsSQL clsSQL = new clsSQL();
clsDefault clsDefault = new clsDefault();
if (clsSecurity.LoginChecker(
clsSQL.CodeFilter(txtUsername.Text),
clsSQL.CodeFilter(txtPassword.Text),
cbEnableCookie.Checked))
{
//LoginChecker();
Response.Redirect(Request.RawUrl);
}
else
{
lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (_dataSource != null && _dataSource.Rows.Count > 0)
{
lblTitle.Text = _title;
gvDefault.PageSize = _pageSize;
gvDefault.DataSource = _dataSource;
gvDefault.DataBind();
gvDefault.BottomPagerRow.Visible = true;
}
else
{
clsDefault clsDefault = new clsDefault();
lblMessage.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล", clsDefault.AlertType.Warn);
pnGVHeader.Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (_dataSource != null && _dataSource.Rows.Count > 0)
{
lblTitle.Text = _title;
gvDefault.PageSize = _pageSize;
gvDefault.DataSource = _dataSource;
gvDefault.DataBind();
gvDefault.BottomPagerRow.Visible = true;
}
else
{
clsDefault clsDefault = new clsDefault();
lblMessage.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล", clsDefault.AlertType.Warn);
pnGVHeader.Visible = false;
}
}
}
private void WebboardTypeBuilder()
{
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region Data Builder
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("UID,");
strSQL.Append("Name,");
strSQL.Append("Detail,");
strSQL.Append("Active ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " ");
if (clsSecurity.LoginGroup != "Admin")
{
strSQL.Append("WHERE ");
strSQL.Append("Active='1' ");
}
strSQL.Append("ORDER BY ");
strSQL.Append("Sort,Name");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
gvDefault.Visible = true;
gvDefault.DataSource = dt;
gvDefault.DataBind();
lblDefault.Text = "";
}
else
{
gvDefault.Visible = false;
lblDefault.Text = clsDefault.AlertMessageColor(
"ไม่พบข้อมูลที่ต้องการ",
clsDefault.AlertType.Info);
}
#endregion
}
protected void BindDefault()
{
dlDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region SQL Query
#region HealthPackage
strSQL.Append("SELECT ");
strSQL.Append("UID,Name,PicThumbnail Photo,'HealthPackage' GlobalName ");
strSQL.Append("FROM ");
strSQL.Append("HealthPackage ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) ");
#endregion
strSQL.Append("UNION ALL ");
#region Package
strSQL.Append("SELECT ");
strSQL.Append("UID,PackageName Name,PicThumbnail Photo,'Package' GlobalName ");
strSQL.Append("FROM ");
strSQL.Append("Package ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) ");
#endregion
strSQL.Append("UNION ALL ");
#region Event
strSQL.Append("SELECT ");
strSQL.Append("UID,Subject Name,PicThumbnail Photo,'Event' GlobalName ");
strSQL.Append("FROM ");
strSQL.Append("Event ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) ");
#endregion
strSQL.Append("UNION ALL ");
#region Promotion
strSQL.Append("SELECT ");
strSQL.Append("UID,PromotionName Name,PicThumbnail Photo,'Promotion' GlobalName ");
strSQL.Append("FROM ");
strSQL.Append("Promotion ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) ");
#endregion
strSQL.Append("UNION ALL ");
#region News
strSQL.Append("SELECT ");
strSQL.Append("UID,Subject Name,PicThumbnail Photo,'News' GlobalName ");
strSQL.Append("FROM ");
strSQL.Append("News ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= CONVERT(DATE,GETDATE())) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= CONVERT(DATE,GETDATE())) ");
#endregion
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
DataColumn dc = dt.Columns.Add("Choose", typeof(string));
#region HighlightBuilder
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["Choose"] = HighlightFinder(
dt.Rows[i]["UID"].ToString(),
dt.Rows[i]["GlobalName"].ToString());
}
dt.AcceptChanges();
#endregion
DataView dv = new DataView(dt);
dv.Sort = "Choose DESC";
dt = dv.ToTable();
lblDG.Text = "";
dlDefault.DataSource = dt;
dlDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region Procedure
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("A.UserGroupUID,");
strSQL.Append("B.Name AS UserGroupName,");
strSQL.Append("A.UID,");
strSQL.Append("A.Photo,");
strSQL.Append("A.Username,");
strSQL.Append("A.PName,");
strSQL.Append("A.FName,");
strSQL.Append("A.LName,");
strSQL.Append("A.Phone,");
strSQL.Append("A.Mobile,");
strSQL.Append("A.Email,");
strSQL.Append("A.Sort,");
strSQL.Append("A.StatusFlag ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " A ");
strSQL.Append("INNER JOIN P5_UserGroup B ");
strSQL.Append("ON A.UserGroupUID=B.UID ");
strSQL.Append("ORDER BY B.Sort,A.Sort;");
#endregion
dt = clsSQL.Bind(strSQL.ToString());
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
#region PageBuilder
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
#endregion
gvDefault.DataBind();
dt = null;
#region Bind UserGroup
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("UID,");
strSQL.Append("Name ");
strSQL.Append("FROM ");
strSQL.Append("UserGroup ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("ORDER BY ");
strSQL.Append("Sort;");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), new string[, ] {
{ }
});
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < gvDefault.Rows.Count; i++)
{
Label lblDGUserGroupUID = (Label)gvDefault.Rows[i].FindControl("lblDGUserGroupUID");
DropDownList ddlDGUserGroup = (DropDownList)gvDefault.Rows[i].FindControl("ddlDGUserGroup");
if (lblDGUserGroupUID != null && ddlDGUserGroup != null)
{
ddlDGUserGroup.DataSource = dt;
ddlDGUserGroup.DataTextField = "Name";
ddlDGUserGroup.DataValueField = "UID";
ddlDGUserGroup.DataBind();
ddlDGUserGroup.SelectedValue = lblDGUserGroupUID.Text;
}
}
}
#endregion
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
strSQL.Length = 0; strSQL.Capacity = 0;
#endregion
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
StringBuilder strSQL = new StringBuilder();
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("[User].UserGroupUID,");
strSQL.Append("UserGroup.Name AS UserGroupName,");
strSQL.Append("[User].UID,");
strSQL.Append("[User].Photo,");
strSQL.Append("[User].Username,");
strSQL.Append("[User].PName,");
strSQL.Append("[User].FName,");
strSQL.Append("[User].LName,");
strSQL.Append("[User].Phone,");
strSQL.Append("[User].Mobile,");
strSQL.Append("[User].Email,");
strSQL.Append("[User].Sort,");
strSQL.Append("[User].Active ");
strSQL.Append("FROM ");
strSQL.Append("[User] ");
strSQL.Append("INNER JOIN UserGroup ");
strSQL.Append("ON [User].UserGroupUID=UserGroup.UID ");
strSQL.Append("WHERE [User].Active<>'D' ");
strSQL.Append("ORDER BY UserGroup.Sort,[User].Sort");
#endregion
DataTable dt = new DataTable();
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception ex)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
gvDefault.DataBind();
dt = null;
#region Bind UserGroup
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("UID,");
strSQL.Append("Name ");
strSQL.Append("FROM ");
strSQL.Append("UserGroup ");
strSQL.Append("WHERE ");
strSQL.Append("Active='1' ");
strSQL.Append("ORDER BY ");
strSQL.Append("Sort");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), new string[, ] {
{ }
}, dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < gvDefault.Rows.Count; i++)
{
Label lblDGUserGroupUID = (Label)gvDefault.Rows[i].FindControl("lblDGUserGroupUID");
DropDownList ddlDGUserGroup = (DropDownList)gvDefault.Rows[i].FindControl("ddlDGUserGroup");
if (lblDGUserGroupUID != null && ddlDGUserGroup != null)
{
ddlDGUserGroup.DataSource = dt;
ddlDGUserGroup.DataTextField = "Name";
ddlDGUserGroup.DataValueField = "UID";
ddlDGUserGroup.DataBind();
ddlDGUserGroup.SelectedValue = lblDGUserGroupUID.Text;
}
}
}
#endregion
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
strSQL.Length = 0; strSQL.Capacity = 0;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
#region WebboardConfig
approveEnable = WebboardConfig("AnonymousEnable");
if (approveEnable != "1")
{
if (!clsSecurity.LoginChecker())
{
pnDetail.Visible = false;
lblDefault.Text = clsDefault.AlertMessageColor("กรุณาสมัครสมาชิก หรือ ล็อคอิน ก่อนตั้งคำถาม | <a href='/Register/' target='_Blank'>คลิกที่นี่เพื่อสมัครสมาชิก</a>", clsDefault.AlertType.Info);
ucColorBox1.SizeChange();
return;
}
}
#endregion
if (clsDefault.URLRouting("group") != "")
{
webDefault = "/Webboard/" + clsDefault.URLRouting("group") + "/";
#region Authorize
if (clsSecurity.LoginChecker())
{
dvAnonymous.Visible = false;
vadCName.Enabled = false; vadCEmail.Enabled = false;
}
if (clsSecurity.LoginGroup == "Admin")
{
dvAdmin.Visible = true;
}
#endregion
if (clsDefault.URLRouting("id") != "")
{
if (clsDefault.URLRouting("command") == "Edit")
{
vdPhoto.Enabled = false;
BindControl(clsDefault.URLRouting("group"));
BindDetail(clsDefault.URLRouting("id"));
}
else if (clsDefault.URLRouting("command") == "Delete")
{
pnDetail.Visible = false;
Delete(clsDefault.URLRouting("id"));
}
else if (clsDefault.URLRouting("command") == "Approve")
{
pnDetail.Visible = false;
Approve(clsDefault.URLRouting("id"));
}
else
{
ucColorBox1.Redirect(webDefault, "ไม่พบหน้าเว็บที่คุณต้องการ");
}
}
else
{
BindControl(clsDefault.URLRouting("group"));
}
}
else
{
ucColorBox1.Close();
}
}
}
protected void btLogin_Click(object sender, EventArgs e)
{
clsSQL clsSQL = new clsSQL();
clsDefault clsDefault = new clsDefault();
if(clsSecurity.LoginChecker(
clsSQL.CodeFilter(txtUsername.Text),
clsSQL.CodeFilter(txtPassword.Text),
cbEnableCookie.Checked))
{
//LoginChecker();
Response.Redirect(Request.RawUrl);
}
else
{
lblLogin.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่คุณกรอก", clsDefault.AlertType.Warn);
}
}
private void DoctorBuilder(string DoctorUID, string DepartmentUID, string MedicalCenterUID)
{
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("ISNULL(MC.Name,'') Department,");
strSQL.Append("DD.DepartmentUID,");
strSQL.Append("D.UID,");
strSQL.Append("D.Photo,");
#region Language Select
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name1,");
strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name2,");
strSQL.Append("D.SpecialtyTH Specialty,");
strSQL.Append("D.EducationTH Education,");
strSQL.Append("D.ExperianceTH Experiance,");
strSQL.Append("D.TypeTH Type,");
}
else
{
strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name2,");
strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name1,");
strSQL.Append("D.SpecialtyEN Specialty,");
strSQL.Append("D.EducationEN Education,");
strSQL.Append("D.ExperianceEN Experiance,");
strSQL.Append("D.TypeEN Type,");
}
#endregion
strSQL.Append("D.MedID,");
strSQL.Append("D.Phone,");
strSQL.Append("D.EMail ");
strSQL.Append("FROM ");
strSQL.Append("Doctor D ");
strSQL.Append("INNER JOIN DoctorDepartment DD ON D.UID=DD.DoctorUID ");
if (DepartmentUID != "0")
{
strSQL.Append("AND DD.DepartmentUID='" + DepartmentUID + "' ");
}
strSQL.Append("INNER JOIN MedicalCenter MC ON DD.DepartmentUID=MC.DepartmentUID ");
if (MedicalCenterUID != "0")
{
strSQL.Append("AND MC.UID=" + MedicalCenterUID + " ");
}
strSQL.Append("WHERE ");
strSQL.Append("D.Active='1' ");
strSQL.Append("AND D.UID=" + DoctorUID + " ");
strSQL.Append("ORDER BY ");
strSQL.Append("D.FNameTH");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
DoctorDetail.Visible = true;
lblDoctorPhoto.Text = "<img src='" + DoctorPhotoPath + (dt.Rows[0]["Photo"].ToString() != "" ? dt.Rows[0]["Photo"].ToString() : "default.jpg") +
"' alt='" + dt.Rows[0]["Name1"].ToString() + "' title='" + dt.Rows[0]["Name1"].ToString() + "'/>";
lblName1.Text = dt.Rows[0]["Name1"].ToString();
lblName2.Text = dt.Rows[0]["Name2"].ToString();
lblSpecialty.Text = dt.Rows[0]["Specialty"].ToString();
lblDepartment.Text = dt.Rows[0]["Department"].ToString();
lblEducation.Text = dt.Rows[0]["Education"].ToString();
}
else
{
DoctorDetail.Visible = false;
lblDefault.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูล", clsDefault.AlertType.Warn);
}
#endregion
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region Procedure
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("A.UID,");
strSQL.Append("A.FileName,");
strSQL.Append("A.Name,");
strSQL.Append("A.Detail,");
strSQL.Append("A.ContactName,");
strSQL.Append("A.ContactPhone,");
strSQL.Append("A.DateApprove,");
strSQL.Append("A.DateSubmit,");
strSQL.Append("A.DateInstall,");
strSQL.Append("A.DateUninstall,");
strSQL.Append("A.Location,");
strSQL.Append("A.ProducerName,");
strSQL.Append("A.VerifyName,");
strSQL.Append("A.InstallName,");
strSQL.Append("A.CWhen ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " A ");
strSQL.Append("ORDER BY A.UID DESC;");
#endregion
dt = clsSQL.Bind(strSQL.ToString());
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
FileInfo fi = new FileInfo(Server.MapPath(dt.Rows[i]["FileName"].ToString()));
if (!fi.Exists)
{
dt.Rows[i]["FileName"] = "";
}
}
catch (Exception)
{
dt.Rows[i]["FileName"] = "";
}
}
dt.AcceptChanges();
gvDefault.DataSource = dt;
#region PageBuilder
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
#endregion
gvDefault.DataBind();
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
strSQL.Length = 0; strSQL.Capacity = 0;
#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
}
private void DoctorBuilderDeptOneLine()
{
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("(");
strSQL.Append("SELECT TOP 1 MedicalCenter.UID ");
strSQL.Append("FROM DoctorDepartment ");
strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " ");
strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID ");
strSQL.Append(")MedicalCenterUID,");
strSQL.Append("(");
strSQL.Append("SELECT MC.Name + ' , ' ");
strSQL.Append("FROM DoctorDepartment DD ");
strSQL.Append("INNER JOIN MedicalCenter MC ON DD.DepartmentUID = MC.DepartmentUID ");
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("AND MC.LanguageUID=1 ");
}
else
{
strSQL.Append("AND MC.LanguageUID=2 ");
}
strSQL.Append("WHERE DD.DoctorUID = D.UID FOR XML PATH('')");
strSQL.Append(")Department,");
strSQL.Append("(");
strSQL.Append("SELECT TOP 1 DoctorDepartment.DepartmentUID ");
strSQL.Append("FROM DoctorDepartment ");
strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " ");
strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID ");
strSQL.Append(")DepartmentUID,");
strSQL.Append("D.UID,D.Photo,");
#region Language Select
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name1,");
strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name2,");
strSQL.Append("D.SpecialtyTH Specialty,");
strSQL.Append("D.EducationTH Education,");
strSQL.Append("D.ExperianceTH Experiance,");
strSQL.Append("D.TypeTH Type,");
}
else
{
strSQL.Append("D.PNameTH+' '+D.FNameTH+' '+D.LNameTH Name2,");
strSQL.Append("D.FNameEN+' '+D.LNameEN+', '+D.PNameEN Name1,");
strSQL.Append("D.SpecialtyEN Specialty,");
strSQL.Append("D.EducationEN Education,");
strSQL.Append("D.ExperianceEN Experiance,");
strSQL.Append("D.TypeEN Type,");
}
#endregion
strSQL.Append("D.MedID,D.Phone,D.EMail ");
strSQL.Append("FROM Doctor D ");
strSQL.Append("WHERE D.Active = '1' ");
#region SearchBuilder
#region Name
if (txtSearchName.Text.Trim() != "")
{
if (clsLanguage.LanguageCurrent == "th-TH")
{
strSQL.Append("AND (");
strSQL.Append("D.FNameTH LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%' ");
strSQL.Append("OR D.LNameTH LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%'");
strSQL.Append(") ");
}
else
{
strSQL.Append("AND (");
strSQL.Append("D.FNameEN LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%' ");
strSQL.Append("OR D.LNameEN LIKE '%" + clsSQL.CodeFilter(txtSearchName.Text) + "%'");
strSQL.Append(") ");
}
}
#endregion
#region Specialty
if (ddlSearchSpecialty.SelectedItem.Value != "null")
{
strSQL.Append("AND (");
strSQL.Append("SpecialtyTH LIKE '%" + ddlSearchSpecialty.SelectedItem.Text + "%' ");
strSQL.Append("OR SpecialtyEN LIKE '%" + ddlSearchSpecialty.SelectedItem.Text + "%' ");
strSQL.Append(") ");
}
#endregion
#region MedicalCenter
if (ddlSearchMedicalCenter.SelectedItem.Value != "null")
{
strSQL.Append("AND (");
strSQL.Append("SELECT COUNT(MedicalCenter.UID) ");
strSQL.Append("FROM DoctorDepartment ");
strSQL.Append("INNER JOIN MedicalCenter ON DoctorDepartment.DepartmentUID = MedicalCenter.DepartmentUID AND MedicalCenter.LanguageUID = " + (clsLanguage.LanguageCurrent == "th-TH" ? "1" : "2") + " ");
strSQL.Append("WHERE DoctorDepartment.DoctorUID = D.UID ");
strSQL.Append("AND MC.Name LIKE '%" + ddlSearchMedicalCenter.SelectedItem.Text + "%'");
strSQL.Append(")>0,");
}
#endregion
#region Schedule
#region Checked
bool cbChecked = false;
for (int c = 0; c < cbSearchSchedule.Items.Count; c++)
{
if (cbSearchSchedule.Items[c].Selected)
{
cbChecked = true;
break;
}
}
#endregion
if (cbChecked)
{
strSQL.Append("AND (");
strSQL.Append("SELECT ");
strSQL.Append("COUNT(UID) ");
strSQL.Append("FROM ");
strSQL.Append("DoctorSchedule ");
strSQL.Append("WHERE ");
strSQL.Append("DoctorUID=D.UID ");
//strSQL.Append("AND DATEPART(DW,DoctorSchedule.DateActive)=1");
strSQL.Append("AND " + clsSQL.QueryBuilderWhere(cbSearchSchedule, "DATEPART(DW,DoctorSchedule.DateActive)", "OR", false, true));
strSQL.Append(")>0 ");
}
#endregion
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append("D.FNameTH;");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
if (dt != null && dt.Rows.Count > 0)
{
gvDoctor.Visible = true;
gvDoctor.DataSource = dt;
gvDoctor.DataBind();
DoctorScheduleBuilder();
}
else
{
gvDoctor.Visible = false;
lblDoctor.Text = (clsLanguage.LanguageCurrent == "th-TH"?clsDefault.AlertMessageColor("ไม่พบข้อมูลแพทย์ที่ต้องการ.", clsDefault.AlertType.Info):clsDefault.AlertMessageColor("Not found data.", clsDefault.AlertType.Info));
}
#endregion
}
protected void btSubmit_Click(object sender, EventArgs e)
{
#region Variable
string outMail = "";
string outSQL = "";
string UID = "";
#endregion
if (txtFromName.Text.Trim().Length > 0 &&
txtFromPhone.Text.Trim().Length > 0 &&
txtFromEmail.Text.Trim().Length > 0 &&
txtMessage.Text.Trim().Length > 0)
{
UID = clsSQL.GetNewID("UID", "Inquiry", "", dbType, cs).ToString();
if (!clsSQL.Insert(
"Inquiry",
new string[, ] {
{ "UID", UID },
{ "MedicalCenterUID", (ddlMedicalCenter.SelectedItem.Value == "null"?"null":ddlMedicalCenter.SelectedItem.Value) },
{ "Name", "'" + clsSQL.CodeFilter(txtFromName.Text) + "'" },
{ "Email", "'" + clsSQL.CodeFilter(txtFromEmail.Text) + "'" },
{ "Phone", "'" + clsSQL.CodeFilter(txtFromPhone.Text) + "'" },
{ "Message", "'" + clsSQL.CodeFilter(txtMessage.Text) + "'" },
{ "Status", "'RECEIVED'" },
{ "CWhen", "GETDATE()" },
{ "CUser", /*clsSecurity.LoginUID*/ "0" },
{ "MWhen", "GETDATE()" },
{ "MUser", /*clsSecurity.LoginUID*/ "0" },
{ "Sort", "0" },
{ "Active", "'1'" }
},
new string[, ] {
{}
},
dbType,
cs,
out outSQL))
{
ucColorBox1.Alert(Message: "เกิดข้อผิดพลาดขณะบันทึกข้อมูล", AlertImage: ucColorBox.Alerts.Fail);
return;
}
#region MailToUser
try
{
//string outMailMessage="";
//clsMail.Send(
// "*****@*****.**",
// txtFromEmail.Text.Trim(),
// "โรงพยาบาลกรุงเทพจันทบุรี ได้รับข้อมูลของคุณแล้ว",
// "คุณได้ส่งคำถาม '" + txtMessage.Text.Trim() + "' มายังโรงพยาบาล",
// out outMailMessage);
if (clsMail.SendTemplate(
"InquiryConfirm",
clsMail.GetEmailList("GlobalFrom"),
txtFromEmail.Text,
new string[, ]
{
{ "[UID]", UID },
{ "[MedicalCenter]", ddlMedicalCenter.SelectedItem.Text },
{ "[FromName]", txtFromName.Text },
{ "[FromPhone]", txtFromPhone.Text },
{ "[FromEmail]", txtFromEmail.Text },
{ "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") },
{ "[Message]", txtMessage.Text }
},
out outMail))
{
ucColorBox1.Redirect("/Inquiry/", "ได้รับข้อความของคุณแล้ว");
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblAlert.Focus();
}
}
catch (Exception) { }
#endregion
#region MailToAdmin
if (clsMail.SendTemplate(
"Inquiry",
clsMail.GetEmailList("AutoSystemFrom"),
clsMail.GetEmailList("InquiryTo"),
new string[, ]
{
{ "[UID]", UID },
{ "[MedicalCenter]", ddlMedicalCenter.SelectedItem.Text },
{ "[FromName]", txtFromName.Text },
{ "[FromPhone]", txtFromPhone.Text },
{ "[FromEmail]", txtFromEmail.Text },
{ "[CWhen]", DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss") },
{ "[Message]", txtMessage.Text }
},
out outMail))
{
ucColorBox1.Redirect("/Inquiry/", "ได้รับข้อความของคุณแล้ว");
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("เกิดข้อผิดพลาดขณะพยายามส่งอีเมล์<br/>" + outMail, clsDefault.AlertType.Fail);
lblAlert.Focus();
}
#endregion
}
else
{
lblAlert.Text = clsDefault.AlertMessageColor("กรุณากรอกข้อมูลให้ครบก่อนค่ะ", clsDefault.AlertType.Warn);
}
}
protected void BindDefault()
{
gvDefault.Visible = true; pnDGHeader.Visible = true;
#region Variable
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
#endregion
#region Header Builder
lblHeader.Text = "ประวัติการส่งใบสมัครงาน";
#endregion
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("Jobs.Name JobsName,");
strSQL.Append("ISNULL(" + tableDefault + ".JobsName,'')" + " JobsNameManual,");
strSQL.Append(tableDefault + ".Photo,");
strSQL.Append(tableDefault + ".UID,");
strSQL.Append(tableDefault + ".PrenameTH,");
strSQL.Append(tableDefault + ".ForenameTH,");
strSQL.Append(tableDefault + ".SurnameTH,");
strSQL.Append(tableDefault + ".MWhen,");
strSQL.Append(tableDefault + ".Sort,");
strSQL.Append(tableDefault + ".StatusFlag ");
strSQL.Append("FROM ");
strSQL.Append(tableDefault + " ");
strSQL.Append("INNER JOIN Jobs ON " + tableDefault + ".JobsUID=Jobs.UID ");
#region Where
strSQL.Append("WHERE ");
strSQL.Append("JobsHistory.StatusFlag<>'D' ");
//strSQL.Append("MedicalCenterGroupUID=" + clsDefault.QueryStringChecker("group") + " ");
#endregion
strSQL.Append("ORDER BY ");
strSQL.Append(tableDefault + ".CWhen DESC;");
#endregion
#region Data Builder
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblDG.Text = "";
gvDefault.DataSource = dt;
if (Request.QueryString["page"] != null)
{
try
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString());
}
catch (Exception)
{
gvDefault.PageIndex = int.Parse(Request.QueryString["page"].ToString()) - 1;
}
}
gvDefault.DataBind();
dt = null;
}
else
{
pnDGHeader.Visible = false;
lblDG.Text = clsDefault.AlertMessageColor("ไม่พบข้อมูลที่ต้องการ", clsDefault.AlertType.Info);
}
#endregion
}
