private void DefaultBuilder()
{
#region Variable
var strSQL = new StringBuilder();
var dt = new DataTable();
#endregion
#region Procedure
#region NewsBuilder
#region SQLQuery
strSQL.Append("SELECT TOP 1 ");
strSQL.Append("UID,Subject Name,DetailSub,PicThumbnail Photo ");
strSQL.Append("FROM ");
strSQL.Append("News ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= GETDATE()) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= GETDATE()) ");
strSQL.Append("AND LanguageUID=" + clsLanguage.LanguageUIDCurrent.ToString() + " ");
strSQL.Append("ORDER BY ");
strSQL.Append("CWhen DESC;");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblNewsPhoto.Text = string.Format(
"<a href='/News/{0}/{1}/'><img src='" + dt.Rows[0]["Photo"].ToString() + "' width='320px' alt='" + dt.Rows[0]["Name"].ToString() + "' title='" + dt.Rows[0]["Name"].ToString() + "'/></a>",
dt.Rows[0]["UID"].ToString(),
clsDefault.URLRoutingFilter(dt.Rows[0]["Name"]));
lblNewsName.Text = "<h5>" + dt.Rows[0]["Name"].ToString() + "</h5>";
lblNewsDetailSub.Text = dt.Rows[0]["DetailSub"].ToString();
lblNewsURL.Text = string.Format(
"<a href='/News/{0}/{1}/'> » อ่านต่อ</a>",
dt.Rows[0]["UID"].ToString(),
clsDefault.URLRoutingFilter(dt.Rows[0]["Name"]));
dt = null;
}
else
{
}
#endregion
#region PromotionBuilder
#region SQLQuery
strSQL.Append("SELECT TOP 1 ");
strSQL.Append("UID,PromotionName Name,DetailSub,PicThumbnail Photo ");
strSQL.Append("FROM ");
strSQL.Append("Promotion ");
strSQL.Append("WHERE ");
strSQL.Append("StatusFlag='A' ");
strSQL.Append("AND (ActiveDateFrom IS NULL OR ActiveDateFrom <= GETDATE()) ");
strSQL.Append("AND (ActiveDateTo IS NULL OR ActiveDateTo >= GETDATE()) ");
strSQL.Append("AND LanguageUID=" + clsLanguage.LanguageUIDCurrent.ToString() + " ");
strSQL.Append("ORDER BY ");
strSQL.Append("MWhen DESC;");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
lblPromotionPhoto.Text = string.Format(
"<a href='/Promotion/{0}/{1}/'><img src='" + dt.Rows[0]["Photo"].ToString() + "' width='320px' alt='" + dt.Rows[0]["Name"].ToString() + "' title='" + dt.Rows[0]["Name"].ToString() + "'/></a>",
dt.Rows[0]["UID"].ToString(),
clsDefault.URLRoutingFilter(dt.Rows[0]["Name"]));
lblPromotionName.Text = "<h5>" + dt.Rows[0]["Name"].ToString() + "</h5>";
lblPromotionDetailSub.Text = dt.Rows[0]["DetailSub"].ToString();
lblPromotionURL.Text = string.Format(
"<a href='/Promotion/{0}/{1}/'> » อ่านต่อ</a>",
dt.Rows[0]["UID"].ToString(),
clsDefault.URLRoutingFilter(dt.Rows[0]["Name"]));
dt = null;
}
else
{
}
#endregion
#endregion
}
private string CenterBuilder()
{
#region Variable
clsDefault clsDefault = new clsDefault();
clsSQL clsSQL = new clsSQL();
clsLanguage clsLanguage = new clsLanguage();
StringBuilder strSQL = new StringBuilder();
StringBuilder strCenter = new StringBuilder();
DataTable dtGroup = new DataTable();
DataTable dt = new DataTable();
#endregion
#region MedicalCenterGroup : SQL Query
strSQL.Append("SELECT ");
strSQL.Append("MedicalCenterGroup.UID,");
strSQL.Append("MedicalCenterGroup.Name ");
strSQL.Append("FROM ");
strSQL.Append("MedicalCenterGroup ");
strSQL.Append("INNER JOIN Language ON MedicalCenterGroup.LanguageUID=Language.UID AND Language.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("MedicalCenterGroup.Active='1' ");
strSQL.Append("AND Language.Name='" + clsLanguage.LanguageCurrent + "' ");
strSQL.Append("ORDER BY ");
strSQL.Append("MedicalCenterGroup.Sort");
#endregion
dtGroup = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
strCenter.Append("<div style='padding:0 10px 0 10px;width:400px;'>");
if (dtGroup != null && dtGroup.Rows.Count > 0)
{
for (int i = 0; i < dtGroup.Rows.Count; i++)
{
strCenter.Append("<h4>" + dtGroup.Rows[i]["Name"].ToString() + "</h4>");
#region MedicalCenter
#region MedicalCenter : SQL Query
strSQL.Append("SELECT ");
//strSQL.Append("UID,");
strSQL.Append("DepartmentUID UID,");
strSQL.Append("Name ");
strSQL.Append("FROM ");
strSQL.Append("MedicalCenter ");
strSQL.Append("WHERE ");
strSQL.Append("MedicalCenterGroupUID=" + dtGroup.Rows[i]["UID"].ToString() + " ");
strSQL.Append("AND Active='1' ");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
strCenter.Append("<table cellpadding='0' cellspacing='0'>");
for (int j = 0; j < dt.Rows.Count; j++)
{
if ((j+1) % 2 != 0)
{
strCenter.Append("<tr>");
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("<a href='/MedicalCenter/" + dt.Rows[j]["UID"].ToString() + "/" + clsDefault.URLRoutingFilter(dt.Rows[j]["Name"]) + "/'>");
strCenter.Append(dt.Rows[j]["Name"].ToString());
strCenter.Append("</a>");
strCenter.Append("</td>");
}
else
{
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("<a href='/MedicalCenter/" + dt.Rows[j]["UID"].ToString() + "/" + clsDefault.URLRoutingFilter(dt.Rows[j]["Name"]) + "/'>");
strCenter.Append(dt.Rows[j]["Name"].ToString());
strCenter.Append("</a>");
strCenter.Append("</td>");
strCenter.Append("</tr>");
}
}
if (dt.Rows.Count % 2 != 0)
{
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("</td>");
strCenter.Append("</tr>");
}
strCenter.Append("</table>");
dt = null;
}
else
{
strCenter.Append("<div style='text-align:center;'>-</div>");
}
#endregion
}
}
else
{
strCenter.Append("-");
}
strCenter.Append("</div>");
/*
strCenter.Append("<tr>");
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("<a href='/Center/" + dt.Rows[i]["MedicalCenterUID"].ToString() + "/" + dt.Rows[i]["MedicalCenterName"].ToString() + "/'>");
strCenter.Append(dt.Rows[i]["MedicalCenterName"].ToString());
strCenter.Append("</a>");
strCenter.Append("</td>");
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("<a href='/Center/" + dt.Rows[i]["MedicalCenterUID"].ToString() + "/" + dt.Rows[i]["MedicalCenterName"].ToString() + "/'>");
strCenter.Append(dt.Rows[i]["MedicalCenterName"].ToString());
strCenter.Append("</a>");
strCenter.Append("</td>");
strCenter.Append("</tr>");
*/
return strCenter.ToString();
}
private void MenuBuilder()
{
#region Variable
clsSQL clsSQL = new clsSQL();
clsDefault clsDefault = new clsDefault();
ucMenuMega.Item item = new ucMenuMega.Item();
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
DataTable dtService = new DataTable();
#endregion
item = new ucMenuMega.Item();
item.UID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "About Hospital";
break;
case "km-KH":
item.Name = "គេហទំព័រដើម";
break;
default:
item.Name = "รู้จักเรา";
break;
}
item.Detail = "";
item.URL = "";
ucMenuMega1.Items.Add(item);
#region รู้จักเรา
item = new ucMenuMega.Item();
item.UID = 11;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Overview";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ទស្សនីយភាពរួមមន្ទីពេទ្យបាងកកចាន់បុរី"+"</span>";
break;
default:
item.Name = "โรงพยาบาลกรุงเทพจันทบุรี";
break;
}
item.Detail = "";
item.URL = "/AboutHospital";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 12;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Hospital Facilities";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "គ្រឿងបរិក្ខាផេ្សងៗ"+"</span>";
break;
default:
item.Name = "สิ่งอำนวยความสะดวกในโรงพยาบาล";
break;
}
item.Detail = "";
item.URL = "/Facilities";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 13;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Award & Accreditations";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "រង្វាន់ធានាគុណភាពសេវាកម្ម"+"</span>";
break;
default:
item.Name = "รางวัลและการประกันคุณภาพบริการ";
break;
}
item.Detail = "";
item.URL = "/Awards";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 14;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Advanced Technologies";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "បច្ទេកវិទ្យាទំនើប"+"</span>";
break;
default:
item.Name = "เทคโนโลยีเพื่อการรักษาผู้ป่วย";
break;
}
item.Detail = "";
item.URL = "/AdvancedTechnologies";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 15;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Hospital Network";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "បណ្តាញរបស់មន្ទីពេទ្យ"+"</span>";
break;
default:
item.Name = "กลุ่มโรงพยาบาลเครือข่าย";
break;
}
item.Detail = "";
item.URL = "/HospitalNetwork";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 16;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Vision & Mission";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ទស្សនៈវិស័យរបស់" + "</span>";
break;
default:
item.Name = "วิสัยทัศน์ และ พันธกิจ";
break;
}
item.Detail = "";
item.URL = "/VisionMission";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 17;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "About Chanthaburi";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "About Chanthaburi" + "</span>";
break;
default:
item.Name = "ข้อมูลทั่วไปของจังหวัดจันทบุรี";
break;
}
item.Detail = "";
item.URL = "/AboutChanthaburi";
ucMenuMega1.Items.Add(item);
#endregion
item = new ucMenuMega.Item();
item.UID = 2;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Healthcare Services";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "គ្លីនិក& មជ្ឈមណ្ឌលព្យាបាលជំងឺផ្សេងៗ"+"</span>";
break;
default:
item.Name = "บริการทางการแพทย์";
break;
}
item.Detail = "";
item.MegaData = CenterBuilder();
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Patient Services";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "សេវាកម្មអ្នកជម្ងឺ"+"</span>";
break;
default:
item.Name = "บริการสำหรับผู้ป่วย";
break;
}
item.Detail = "";
ucMenuMega1.Items.Add(item);
#region บริการสำหรับผู้ป่วย
item = new ucMenuMega.Item();
item.UID = 31;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Room & Facilities";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "បរិក្ខាប្រើប្រាស់ក្នុងបន្ទប់"+"</span>";
break;
default:
item.Name = "ห้องพักผู้ป่วยและสิ่งอำนวยความสะดวก";
break;
}
item.Detail = "";
item.URL = "";
ucMenuMega1.Items.Add(item);
#region Service
#region ServiceGroup
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("ServiceGroup.UID,ServiceGroup.Name ");
strSQL.Append("FROM ");
strSQL.Append("ServiceGroup ");
strSQL.Append("INNER JOIN Language ");
strSQL.Append("ON ServiceGroup.LanguageUID=Language.UID AND Language.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("ServiceGroup.Active='1' ");
strSQL.Append("AND Language.Name='" + ucLanguageDB1.LanguageCurrent + "' ");
strSQL.Append("ORDER BY ");
strSQL.Append("ServiceGroup.Sort ASC");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
for (int g = 0; g < dt.Rows.Count; g++)
{
item = new ucMenuMega.Item();
item.UID = int.Parse("31"+(g+1).ToString());
item.ParentUID = 31;
item.Name = dt.Rows[g]["Name"].ToString();
item.Detail = "";
item.URL = "";
ucMenuMega1.Items.Add(item);
#region Service
#region SQL Query
strSQL.Append("SELECT ");
//strSQL.Append("UID,");
strSQL.Append("Service.DepartmentUID UID,");
strSQL.Append("Service.Name ");
strSQL.Append("FROM ");
strSQL.Append("Service ");
strSQL.Append("INNER JOIN Language ");
strSQL.Append("ON Service.LanguageUID=Language.UID AND Language.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("Service.Active='1' ");
strSQL.Append("AND Service.ServiceGroupUID='" + dt.Rows[g]["UID"].ToString() + "' ");
strSQL.Append("AND Language.Name='" + ucLanguageDB1.LanguageCurrent + "' ");
strSQL.Append("ORDER BY ");
strSQL.Append("Service.Sort ASC");
#endregion
dtService = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dtService != null && dtService.Rows.Count > 0)
{
for (int s = 0; s < dtService.Rows.Count; s++)
{
item = new ucMenuMega.Item();
item.UID = int.Parse("31" + (g + 1).ToString()+(s+1).ToString());
item.ParentUID = int.Parse("31" + (g + 1).ToString());
item.Name = dtService.Rows[s]["Name"].ToString();
item.Detail = "";
item.URL = "/Service/"+dtService.Rows[s]["UID"].ToString()+"/"+clsDefault.URLRoutingFilter(dtService.Rows[s]["Name"].ToString())+"/";
ucMenuMega1.Items.Add(item);
}
dtService = null;
}
#endregion
}
dt = null;
}
#endregion
#endregion
item = new ucMenuMega.Item();
item.UID = 33;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Chivawattana Membership Card";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ចូលជាសមាជិកកម្មវិធីជីវះវឌ្ឍនះ"+"</span>";
break;
default:
item.Name = "สมาชิกบัตรชีววัฒนะ";
break;
}
item.Detail = "";
item.URL = "/Chivawattana/";
ucMenuMega1.Items.Add(item);
/*
item = new ucMenuMega.Item();
item.UID = 34;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Checkup Result";
break;
default:
item.Name = "ผลตรวจสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/CheckupCondition/";
ucMenuMega1.Items.Add(item);
*/
item = new ucMenuMega.Item();
item.UID = 35;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Health Packages";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "កញ្ចប់ សុខភាព"+"</span>";
break;
default:
item.Name = "แพคเกจตรวจสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/HealthPackage";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 36;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Packages";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "កញ្ចប់ សុខភាព"+"</span>";
break;
default:
item.Name = "แพคเกจโรคทั่วไป";
break;
}
item.Detail = "";
item.URL = "/Package";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 37;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Promotions";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ការផ្ដល់ជូនពិសេស"+"</span>";
break;
default:
item.Name = "โปรโมชั่น";
break;
}
item.Detail = "";
item.URL = "/Promotion";
ucMenuMega1.Items.Add(item);
#endregion
item = new ucMenuMega.Item();
item.UID = 4;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Find a Doctor";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ស្វែងរកគ្រូពេទ្យ & ធ្វើការណាត់"+"</span>";
break;
default:
item.Name = "ค้นหาและนัดหมายแพทย์";
break;
}
item.Detail = "";
item.URL = "/DoctorSchedule";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Hospital News";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ព័ត៍មាន"+"</span>";
break;
default:
item.Name = "ข่าวสารโรงพยาบาล";
break;
}
item.Detail = "";
ucMenuMega1.Items.Add(item);
#region ข่าวสารโรงพยาบาล
item = new ucMenuMega.Item();
item.UID = 51;
item.ParentUID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Events";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ព្រឹត្តការណ៍"+"</span>";
break;
default:
item.Name = "กิจกรรม";
break;
}
item.Detail = "";
item.URL = "/Event";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 52;
item.ParentUID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "News";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ព័ត៍មាន"+"</span>";
break;
default:
item.Name = "ข่าวประชาสัมพันธ์";
break;
}
item.Detail = "";
item.URL = "/News";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 53;
item.ParentUID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Health Articles";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "សុខភាព មាត្រា"+"</span>";
break;
default:
item.Name = "บทความสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/Article";
ucMenuMega1.Items.Add(item);
#endregion
item = new ucMenuMega.Item();
item.UID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Contact Us";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ទំនាក់ទំនងមន្ទីពេទ្យបាងកកចាន់បុរី"+"</span>";
break;
default:
item.Name = "ติดต่อเรา";
break;
}
item.Detail = "";
ucMenuMega1.Items.Add(item);
#region ติดต่อเรา
item = new ucMenuMega.Item();
item.UID = 61;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Inquiry";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "សាកសួរពត៌មានលំអិត"+"</span>";
break;
default:
item.Name = "ฝากคำถามถึงโรงพยาบาล";
break;
}
item.Detail = "";
item.URL = "/Inquiry/";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 62;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Feedback";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ផ្តល់មតិរិះគន់ដើម្បីកែប្រែ"+"</span>";
break;
default:
item.Name = "แนะนำ/ติชม ถึงผู้บริหาร";
break;
}
item.Detail = "";
item.URL = "/Feedback/";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 63;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Webboard";
break;
case "km-KH":
item.Name = "Webboard";
break;
default:
item.Name = "เว็บบอร์ดตอบปัญหาสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/Webboard/";
//ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 64;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Maps & Directions";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ផែនទី"+"</span>";
break;
default:
item.Name = "แผนที่และการเดินทาง";
break;
}
item.Detail = "";
item.URL = "/Maps/";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 65;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Jobs";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "រួមការងារជាមួយយើង"+"</span>";
break;
default:
item.Name = "ร่วมงานกับเรา";
break;
}
item.Detail = "";
item.URL = "/Jobs/";
ucMenuMega1.Items.Add(item);
#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
}
private string CenterBuilder()
{
#region Variable
clsDefault clsDefault = new clsDefault();
clsSQL clsSQL = new clsSQL();
clsLanguage clsLanguage = new clsLanguage();
StringBuilder strSQL = new StringBuilder();
StringBuilder strCenter = new StringBuilder();
DataTable dtGroup = new DataTable();
DataTable dt = new DataTable();
#endregion
#region MedicalCenterGroup : SQL Query
strSQL.Append("SELECT ");
strSQL.Append("MedicalCenterGroup.UID,");
strSQL.Append("MedicalCenterGroup.Name ");
strSQL.Append("FROM ");
strSQL.Append("MedicalCenterGroup ");
strSQL.Append("INNER JOIN Language ON MedicalCenterGroup.LanguageUID=Language.UID AND Language.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("MedicalCenterGroup.Active='1' ");
strSQL.Append("AND Language.Name='" + clsLanguage.LanguageCurrent + "' ");
strSQL.Append("ORDER BY ");
strSQL.Append("MedicalCenterGroup.Sort");
#endregion
dtGroup = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
strCenter.Append("<div style='padding:0 10px 0 10px;width:400px;'>");
if (dtGroup != null && dtGroup.Rows.Count > 0)
{
for (int i = 0; i < dtGroup.Rows.Count; i++)
{
strCenter.Append("<h4>" + dtGroup.Rows[i]["Name"].ToString() + "</h4>");
#region MedicalCenter
#region MedicalCenter : SQL Query
strSQL.Append("SELECT ");
//strSQL.Append("UID,");
strSQL.Append("DepartmentUID UID,");
strSQL.Append("Name ");
strSQL.Append("FROM ");
strSQL.Append("MedicalCenter ");
strSQL.Append("WHERE ");
strSQL.Append("MedicalCenterGroupUID=" + dtGroup.Rows[i]["UID"].ToString() + " ");
strSQL.Append("AND Active='1' ");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
strCenter.Append("<table cellpadding='0' cellspacing='0'>");
for (int j = 0; j < dt.Rows.Count; j++)
{
if ((j + 1) % 2 != 0)
{
strCenter.Append("<tr>");
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("<a href='/MedicalCenter/" + dt.Rows[j]["UID"].ToString() + "/" + clsDefault.URLRoutingFilter(dt.Rows[j]["Name"]) + "/'>");
strCenter.Append(dt.Rows[j]["Name"].ToString());
strCenter.Append("</a>");
strCenter.Append("</td>");
}
else
{
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("<a href='/MedicalCenter/" + dt.Rows[j]["UID"].ToString() + "/" + clsDefault.URLRoutingFilter(dt.Rows[j]["Name"]) + "/'>");
strCenter.Append(dt.Rows[j]["Name"].ToString());
strCenter.Append("</a>");
strCenter.Append("</td>");
strCenter.Append("</tr>");
}
}
if (dt.Rows.Count % 2 != 0)
{
strCenter.Append("<td style='width:200px;'>");
strCenter.Append("</td>");
strCenter.Append("</tr>");
}
strCenter.Append("</table>");
dt = null;
}
else
{
strCenter.Append("<div style='text-align:center;'>-</div>");
}
#endregion
}
}
else
{
strCenter.Append("-");
}
strCenter.Append("</div>");
/*
*
*
* strCenter.Append("<tr>");
* strCenter.Append("<td style='width:200px;'>");
* strCenter.Append("<a href='/Center/" + dt.Rows[i]["MedicalCenterUID"].ToString() + "/" + dt.Rows[i]["MedicalCenterName"].ToString() + "/'>");
* strCenter.Append(dt.Rows[i]["MedicalCenterName"].ToString());
* strCenter.Append("</a>");
* strCenter.Append("</td>");
* strCenter.Append("<td style='width:200px;'>");
* strCenter.Append("<a href='/Center/" + dt.Rows[i]["MedicalCenterUID"].ToString() + "/" + dt.Rows[i]["MedicalCenterName"].ToString() + "/'>");
* strCenter.Append(dt.Rows[i]["MedicalCenterName"].ToString());
* strCenter.Append("</a>");
* strCenter.Append("</td>");
* strCenter.Append("</tr>");
*
*
*/
return(strCenter.ToString());
}
private void MenuBuilder()
{
#region Variable
clsSQL clsSQL = new clsSQL();
clsDefault clsDefault = new clsDefault();
ucMenuMega.Item item = new ucMenuMega.Item();
StringBuilder strSQL = new StringBuilder();
DataTable dt = new DataTable();
DataTable dtService = new DataTable();
#endregion
item = new ucMenuMega.Item();
item.UID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "About Hospital";
break;
case "km-KH":
item.Name = "គេហទំព័រដើម";
break;
default:
item.Name = "รู้จักเรา";
break;
}
item.Detail = "";
item.URL = "";
ucMenuMega1.Items.Add(item);
#region รู้จักเรา
item = new ucMenuMega.Item();
item.UID = 11;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Overview";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ទស្សនីយភាពរួមមន្ទីពេទ្យបាងកកចាន់បុរី" + "</span>";
break;
default:
item.Name = "โรงพยาบาลกรุงเทพจันทบุรี";
break;
}
item.Detail = "";
item.URL = "/AboutHospital";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 12;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Hospital Facilities";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "គ្រឿងបរិក្ខាផេ្សងៗ" + "</span>";
break;
default:
item.Name = "สิ่งอำนวยความสะดวกในโรงพยาบาล";
break;
}
item.Detail = "";
item.URL = "/Facilities";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 13;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Award & Accreditations";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "រង្វាន់ធានាគុណភាពសេវាកម្ម" + "</span>";
break;
default:
item.Name = "รางวัลและการประกันคุณภาพบริการ";
break;
}
item.Detail = "";
item.URL = "/Awards";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 14;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Advanced Technologies";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "បច្ទេកវិទ្យាទំនើប" + "</span>";
break;
default:
item.Name = "เทคโนโลยีเพื่อการรักษาผู้ป่วย";
break;
}
item.Detail = "";
item.URL = "/AdvancedTechnologies";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 15;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Hospital Network";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "បណ្តាញរបស់មន្ទីពេទ្យ" + "</span>";
break;
default:
item.Name = "กลุ่มโรงพยาบาลเครือข่าย";
break;
}
item.Detail = "";
item.URL = "/HospitalNetwork";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 16;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Vision & Mission";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ទស្សនៈវិស័យរបស់" + "</span>";
break;
default:
item.Name = "วิสัยทัศน์ และ พันธกิจ";
break;
}
item.Detail = "";
item.URL = "/VisionMission";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 17;
item.ParentUID = 1;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "About Chanthaburi";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "About Chanthaburi" + "</span>";
break;
default:
item.Name = "ข้อมูลทั่วไปของจังหวัดจันทบุรี";
break;
}
item.Detail = "";
item.URL = "/AboutChanthaburi";
ucMenuMega1.Items.Add(item);
#endregion
item = new ucMenuMega.Item();
item.UID = 2;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Healthcare Services";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "គ្លីនិក& មជ្ឈមណ្ឌលព្យាបាលជំងឺផ្សេងៗ" + "</span>";
break;
default:
item.Name = "บริการทางการแพทย์";
break;
}
item.Detail = "";
item.MegaData = CenterBuilder();
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Patient Services";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "សេវាកម្មអ្នកជម្ងឺ" + "</span>";
break;
default:
item.Name = "บริการสำหรับผู้ป่วย";
break;
}
item.Detail = "";
ucMenuMega1.Items.Add(item);
#region บริการสำหรับผู้ป่วย
item = new ucMenuMega.Item();
item.UID = 31;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Room & Facilities";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "បរិក្ខាប្រើប្រាស់ក្នុងបន្ទប់" + "</span>";
break;
default:
item.Name = "ห้องพักผู้ป่วยและสิ่งอำนวยความสะดวก";
break;
}
item.Detail = "";
item.URL = "";
ucMenuMega1.Items.Add(item);
#region Service
#region ServiceGroup
#region SQL Query
strSQL.Append("SELECT ");
strSQL.Append("ServiceGroup.UID,ServiceGroup.Name ");
strSQL.Append("FROM ");
strSQL.Append("ServiceGroup ");
strSQL.Append("INNER JOIN Language ");
strSQL.Append("ON ServiceGroup.LanguageUID=Language.UID AND Language.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("ServiceGroup.Active='1' ");
strSQL.Append("AND Language.Name='" + ucLanguageDB1.LanguageCurrent + "' ");
strSQL.Append("ORDER BY ");
strSQL.Append("ServiceGroup.Sort ASC");
#endregion
dt = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dt != null && dt.Rows.Count > 0)
{
for (int g = 0; g < dt.Rows.Count; g++)
{
item = new ucMenuMega.Item();
item.UID = int.Parse("31" + (g + 1).ToString());
item.ParentUID = 31;
item.Name = dt.Rows[g]["Name"].ToString();
item.Detail = "";
item.URL = "";
ucMenuMega1.Items.Add(item);
#region Service
#region SQL Query
strSQL.Append("SELECT ");
//strSQL.Append("UID,");
strSQL.Append("Service.DepartmentUID UID,");
strSQL.Append("Service.Name ");
strSQL.Append("FROM ");
strSQL.Append("Service ");
strSQL.Append("INNER JOIN Language ");
strSQL.Append("ON Service.LanguageUID=Language.UID AND Language.Active='1' ");
strSQL.Append("WHERE ");
strSQL.Append("Service.Active='1' ");
strSQL.Append("AND Service.ServiceGroupUID='" + dt.Rows[g]["UID"].ToString() + "' ");
strSQL.Append("AND Language.Name='" + ucLanguageDB1.LanguageCurrent + "' ");
strSQL.Append("ORDER BY ");
strSQL.Append("Service.Sort ASC");
#endregion
dtService = clsSQL.Bind(strSQL.ToString(), dbType, cs);
strSQL.Length = 0; strSQL.Capacity = 0;
if (dtService != null && dtService.Rows.Count > 0)
{
for (int s = 0; s < dtService.Rows.Count; s++)
{
item = new ucMenuMega.Item();
item.UID = int.Parse("31" + (g + 1).ToString() + (s + 1).ToString());
item.ParentUID = int.Parse("31" + (g + 1).ToString());
item.Name = dtService.Rows[s]["Name"].ToString();
item.Detail = "";
item.URL = "/Service/" + dtService.Rows[s]["UID"].ToString() + "/" + clsDefault.URLRoutingFilter(dtService.Rows[s]["Name"].ToString()) + "/";
ucMenuMega1.Items.Add(item);
}
dtService = null;
}
#endregion
}
dt = null;
}
#endregion
#endregion
item = new ucMenuMega.Item();
item.UID = 33;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Chivawattana Membership Card";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ចូលជាសមាជិកកម្មវិធីជីវះវឌ្ឍនះ" + "</span>";
break;
default:
item.Name = "สมาชิกบัตรชีววัฒนะ";
break;
}
item.Detail = "";
item.URL = "/Chivawattana/";
ucMenuMega1.Items.Add(item);
/*
* item = new ucMenuMega.Item();
* item.UID = 34;
* item.ParentUID = 3;
* switch (ucLanguageDB1.LanguageCurrent)
* {
* case "en-US":
* item.Name = "Checkup Result";
* break;
* default:
* item.Name = "ผลตรวจสุขภาพ";
* break;
* }
* item.Detail = "";
* item.URL = "/CheckupCondition/";
* ucMenuMega1.Items.Add(item);
*/
item = new ucMenuMega.Item();
item.UID = 35;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Health Packages";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "កញ្ចប់ សុខភាព" + "</span>";
break;
default:
item.Name = "แพคเกจตรวจสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/HealthPackage";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 36;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Packages";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "កញ្ចប់ សុខភាព" + "</span>";
break;
default:
item.Name = "แพคเกจโรคทั่วไป";
break;
}
item.Detail = "";
item.URL = "/Package";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 37;
item.ParentUID = 3;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Promotions";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ការផ្ដល់ជូនពិសេស" + "</span>";
break;
default:
item.Name = "โปรโมชั่น";
break;
}
item.Detail = "";
item.URL = "/Promotion";
ucMenuMega1.Items.Add(item);
#endregion
item = new ucMenuMega.Item();
item.UID = 4;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Find a Doctor";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ស្វែងរកគ្រូពេទ្យ & ធ្វើការណាត់" + "</span>";
break;
default:
item.Name = "ค้นหาและนัดหมายแพทย์";
break;
}
item.Detail = "";
item.URL = "/DoctorSchedule";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Hospital News";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ព័ត៍មាន" + "</span>";
break;
default:
item.Name = "ข่าวสารโรงพยาบาล";
break;
}
item.Detail = "";
ucMenuMega1.Items.Add(item);
#region ข่าวสารโรงพยาบาล
item = new ucMenuMega.Item();
item.UID = 51;
item.ParentUID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Events";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ព្រឹត្តការណ៍" + "</span>";
break;
default:
item.Name = "กิจกรรม";
break;
}
item.Detail = "";
item.URL = "/Event";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 52;
item.ParentUID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "News";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ព័ត៍មាន" + "</span>";
break;
default:
item.Name = "ข่าวประชาสัมพันธ์";
break;
}
item.Detail = "";
item.URL = "/News";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 53;
item.ParentUID = 5;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Health Articles";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "សុខភាព មាត្រា" + "</span>";
break;
default:
item.Name = "บทความสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/Article";
ucMenuMega1.Items.Add(item);
#endregion
item = new ucMenuMega.Item();
item.UID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Contact Us";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ទំនាក់ទំនងមន្ទីពេទ្យបាងកកចាន់បុរី" + "</span>";
break;
default:
item.Name = "ติดต่อเรา";
break;
}
item.Detail = "";
ucMenuMega1.Items.Add(item);
#region ติดต่อเรา
item = new ucMenuMega.Item();
item.UID = 61;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Inquiry";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "សាកសួរពត៌មានលំអិត" + "</span>";
break;
default:
item.Name = "ฝากคำถามถึงโรงพยาบาล";
break;
}
item.Detail = "";
item.URL = "/Inquiry/";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 62;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Feedback";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ផ្តល់មតិរិះគន់ដើម្បីកែប្រែ" + "</span>";
break;
default:
item.Name = "แนะนำ/ติชม ถึงผู้บริหาร";
break;
}
item.Detail = "";
item.URL = "/Feedback/";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 63;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Webboard";
break;
case "km-KH":
item.Name = "Webboard";
break;
default:
item.Name = "เว็บบอร์ดตอบปัญหาสุขภาพ";
break;
}
item.Detail = "";
item.URL = "/Webboard/";
//ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 64;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Maps & Directions";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "ផែនទី" + "</span>";
break;
default:
item.Name = "แผนที่และการเดินทาง";
break;
}
item.Detail = "";
item.URL = "/Maps/";
ucMenuMega1.Items.Add(item);
item = new ucMenuMega.Item();
item.UID = 65;
item.ParentUID = 6;
switch (ucLanguageDB1.LanguageCurrent)
{
case "en-US":
item.Name = "Jobs";
break;
case "km-KH":
item.Name = "<span style='font-size:7.5pt;'>" + "រួមការងារជាមួយយើង" + "</span>";
break;
default:
item.Name = "ร่วมงานกับเรา";
break;
}
item.Detail = "";
item.URL = "/Jobs/";
ucMenuMega1.Items.Add(item);
#endregion
}