void BindData1()
{
Seminar S = new Seminar();
DataTable dt = S.GetSEMINAR(txtSearchSeminarCitizen.Text, "", "", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
}
protected void lbuSearch_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtSearchSeminarCitizen.Text))
{
notification.Attributes["class"] = "alert alert_danger";
notification.InnerHtml = "";
notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>";
notification.InnerHtml += "<div> - กรุณากรอกรหัสบัตรประชาชนในช่องคำค้นหา</div>";
return;
}
else
{
notification.Attributes["class"] = "none";
notification.InnerHtml = "";
}
if (txtSearchSeminarCitizen.Text.Length < 13)
{
notification.Attributes["class"] = "alert alert_danger";
notification.InnerHtml = "";
notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>";
notification.InnerHtml += "<div> - กรุณากรอกรหัสบัตรประชาชนในช่องค้นหาให้ครบ 13 หลัก</div>";
return;
}
else
{
notification.Attributes["class"] = "none";
notification.InnerHtml = "";
}
using (OracleConnection con = new OracleConnection(DatabaseManager.CONNECTION_STRING))
{
con.Open();
string result = "";
using (OracleCommand com = new OracleCommand("SELECT CITIZEN_ID FROM TB_SEMINAR WHERE CITIZEN_ID = '" + txtSearchSeminarCitizen.Text + "'", con))
{
using (OracleDataReader reader = com.ExecuteReader())
{
while (reader.Read())
{
result = reader.GetString(0);
}
}
}
if (result == txtSearchSeminarCitizen.Text)
{
Seminar s = new Seminar();
DataTable dt = s.GetSEMINAR(txtSearchSeminarCitizen.Text, "", "", "", "");
GridView1.DataSource = dt;
GridView1.DataBind();
SetViewState(dt);
notification.Attributes["class"] = "none";
notification.InnerHtml = "";
}
else
{
notification.Attributes["class"] = "alert alert_danger";
notification.InnerHtml = "";
notification.InnerHtml += "<div><img src='Image/Small/red_alert.png' /><strong>แจ้งเตือน</strong></div>";
notification.InnerHtml += "<div> - ไม่พบข้อมูลของรหัสบัตรประชาชนดังกล่าว</div>";
return;
}
}
}
