using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class print_form : System.Web.UI.Page
{
    SqlConnection con;
    SqlCommand com;
    SqlDataReader dr;
    protected void Page_Load(object sender, EventArgs e)
    {
        bool hostel, transport;
        string date1, course, sem;

        if (Session["out"].ToString() == "false")
        {
          Response.Redirect("log_out.aspx");
        }
        else if (Session["u_type"].ToString() == "user")
        {
            Response.Redirect("log_out.aspx");
        }
        else if (Session["u_type"].ToString() == "Account")
        {
            Response.Redirect("log_out.aspx");
        }
       
        con = new SqlConnection(ConfigurationManager.ConnectionStrings["regis_dbConnectionString"].ConnectionString);


        if (!Page.IsPostBack)
        {

            con.Open();
            string str = "select registration_no,name,father_name,dob,gender,blood_group,category,yearly_income,permanant_address,hostel,transport,registration_date,admin_receive,current_session,current_course,current_branch,current_sem,due_with_fine,clr_bal_total,halt,route,total_receive from registration_master where registration_no='" + Session["roll_no"].ToString() + "'";
            com = new SqlCommand(str, con);
            dr = com.ExecuteReader();
            if (dr.HasRows)
            {
                while (dr.Read())
                {
                    txt_box_roll_no.Text = dr[0].ToString();
                    txt_box_roll_no1.Text = dr[0].ToString();
                    txt_box_roll_no2.Text = dr[0].ToString();
                    txt_box_name1.Text = dr[1].ToString();
                    txt_box_name2.Text = dr[1].ToString();
                    txt_box_name3.Text = dr[1].ToString();
                    txt_box_father.Text = dr[2].ToString();
                    txt_box_father1.Text = dr[2].ToString();
                    txt_box_father2.Text = dr[2].ToString();
                    txt_box_dob.Text = dr[3].ToString();
                    txt_box_dob1.Text = dr[3].ToString();
                    txt_box_dob2.Text = dr[3].ToString();
                    txt_box_gender.Text = dr[4].ToString();
                    txt_box_gender1.Text = dr[4].ToString();
                    txt_box_gender2.Text = dr[4].ToString();
                    txt_box_blood.Text = dr[5].ToString();
                    txt_box_blood1.Text = dr[5].ToString();
                    txt_box_blood2.Text = dr[5].ToString();
                    txt_box_category.Text = dr[6].ToString();
                    txt_box_category1.Text = dr[6].ToString();
                    //txt_box_category2.Text = dr[6].ToString();
                    txt_box_year.Text = dr[7].ToString();
                    txt_box_year1.Text = dr[7].ToString();
                    txt_box_year2.Text = dr[7].ToString();
                    txt_box_address.Text = dr[8].ToString();
                    txt_box_address1.Text = dr[8].ToString();
                    txt_box_address2.Text = dr[8].ToString();
                    hostel = Convert.ToBoolean(dr[9].ToString());
                    transport = Convert.ToBoolean(dr[10].ToString());
                    date1 = dr[11].ToString();
                    //txt_box_deposite.Text = dr[12].ToString();
                    //txt_box_deposite1.Text = dr[12].ToString();
                    //txt_box_deposite2.Text = dr[12].ToString();
                    txt_box_session.Text = dr[13].ToString();
                    txt_box_session1.Text = dr[13].ToString();
                    txt_box_session2.Text = dr[13].ToString();
                    course = dr[14].ToString();
                    sem = dr[16].ToString();
                    course = course + " " + sem;
                    txt_box_course.Text = course;
                    txt_box_course1.Text = course;
                    txt_box_course2.Text = course;
                    txt_box_branch.Text = dr[15].ToString();
                    txt_box_branch1.Text = dr[15].ToString();
                    txt_box_branch2.Text = dr[15].ToString();
                    txt_box_due.Text = dr[17].ToString();
                    txt_box_due1.Text = dr[17].ToString();
                    txt_box_due2.Text = dr[17].ToString();
                    txt_box_outstanding.Text = dr[18].ToString();
                    txt_box_outstanding1.Text = dr[18].ToString();
                    txt_box_outstanding2.Text = dr[18].ToString();
                    txt_box_halt.Text = dr[19].ToString();
                    txt_box_halt1.Text = dr[19].ToString();
                    txt_box_halt2.Text = dr[19].ToString();
                    txt_box_route.Text = dr[20].ToString();
                    txt_box_route1.Text = dr[20].ToString();
                    txt_box_route2.Text = dr[20].ToString();
                    txt_box_deposite.Text = dr[21].ToString();
                    txt_box_deposite1.Text = dr[21].ToString();
                    txt_box_deposite2.Text = dr[21].ToString();


                    if (hostel)
                    {
                        radio_btn_yes_hostel.Checked = true;
                        radio_btn_yes_hostel1.Checked = true;
                        radio_btn_yes_hostel2.Checked = true;
                        radio_btn_no_hostel.Checked = false;
                        radio_btn_no_hostel1.Checked = false;
                        radio_btn_no_hostel2.Checked = false;
                    }
                    else
                    {
                        radio_btn_no_hostel.Checked = true;
                        radio_btn_no_hostel1.Checked = true;
                        radio_btn_no_hostel2.Checked = true;
                        radio_btn_yes_hostel.Checked = false;
                        radio_btn_yes_hostel1.Checked = false;
                        radio_btn_yes_hostel2.Checked = false;
                    }
                    if (transport)
                    {
                        radio_btn_yes_transport.Checked = true;
                        radio_btn_yes_transport1.Checked = true;
                        radio_btn_yes_transport2.Checked = true;
                        radio_btn_no_transport.Checked = false;
                        radio_btn_no_transport1.Checked = false;
                        radio_btn_no_transport2.Checked = false;
                    }
                    else
                    {
                        radio_btn_no_transport.Checked = true;
                        radio_btn_no_transport1.Checked = true;
                        radio_btn_no_transport2.Checked = true;
                        radio_btn_yes_transport.Checked = false;
                        radio_btn_yes_transport1.Checked = false;
                        radio_btn_yes_transport2.Checked = false;

                    }

                }
            }
            com.Dispose();
            con.Close();


            if (Session["print_ht"].ToString() == "true")
            {
                btn_print_hostel.Enabled = true;

            }
            else
            {
                btn_print_hostel.Enabled = false;
            }
        }
        

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Session["ctrl"] = hi;
        ClientScript.RegisterStartupScript(this.GetType(), "onclick", "<script language=javascript>window.open('Print.aspx','PrintMe','height=300px,width=300px,scrollbars=1');</script>");
       
    }
    protected void LinkButton1_Click(object sender, EventArgs e)
    {
        Response.Redirect("signout.aspx");
    }
    protected void btn_print_hostel_Click(object sender, EventArgs e)
    {
      Session["ctrl"] = hello;
      ClientScript.RegisterStartupScript(this.GetType(), "onclick", "<script language=javascript>window.open('Print.aspx','PrintMe','height=300px,width=300px,scrollbars=1');</script>");
       
    }
    protected void btn_back_Click(object sender, EventArgs e)
    {
      Response.Redirect("admin_form.aspx");
    }
    protected void btn_logout_Click(object sender, EventArgs e)
    {
      string session_check = "false";
      Session["out"] = session_check;
      Response.Redirect("log_out.aspx");
    }
}