using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class index : System.Web.UI.Page
{
    SqlConnection conn;
    connection objconn = new connection();
    protected void Page_Load(object sender, EventArgs e)
    {
                conn = new SqlConnection(@"server=70.86.97.226;database=iid;uid=piyush;pwd=nid123;Min Pool Size=5;Max Pool Size=60;Connect Timeout=50;");

    }
    protected void btnSearch_Click(object sender, EventArgs e)
    {
        try
        {
            string sql = "select * from final_result09 where rs_candidate_id='" + txtstudentid.Text + "'";
            conn.Open();
            SqlCommand cmd = new SqlCommand(sql, conn);
            SqlDataAdapter dap = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            int count = dap.Fill(dt);
            if (count > 0)
            {
               
                
                
                //string status = dt.Rows[0].ItemArray[5].ToString();
                if (dt.Rows[0].ItemArray[4].ToString() == "Sorry! You are not selected.")
                {
                    lblcnd_category.Visible = false;
                    lblCategory.Visible = false;
                    lblcnd_status.Text = dt.Rows[0].ItemArray[4].ToString();
                    lblcnd_name.Text = dt.Rows[0].ItemArray[2].ToString();
                }
                else
                { 
                    lblCategory.Visible = true;
                    lblcnd_category.Visible = true;
                    lblcnd_status.Text = dt.Rows[0].ItemArray[4].ToString();
                    lblcnd_name.Text = dt.Rows[0].ItemArray[2].ToString();
                    lblcnd_category.Text = dt.Rows[0].ItemArray[3].ToString();
                    if (lblcnd_category.Text == "" || lblcnd_category.Text == null)
                    {
                        lblCategory.Visible = false;
                        lblcnd_category.Visible = false;
                    }
                    //lblprogram.Visible = true;
                    //lblcnd_program.Text = dt.Rows[0].ItemArray[5].ToString();
                }
                
            }
            else
            {
                lblerror.Text = "Please enter correct Candidate Id";
                txtstudentid.Text = "";
            }
            conn.Close();
        }
        catch (Exception ex)
        {
            lblerror.Text = ex.Message;
        }
    }
    
}