protected void Button1_Click(object sender, EventArgs e)
    {
        ppb.path_id      = Session["path_id"].ToString();
        ppb.pateint_code = Session["pateint_code"].ToString();
        ppb.slave_id     = Session["slave_id"].ToString();
        ppb.vdrl         = TextBox1.Text;


        rt.palm_pathology_vdrls.InsertOnSubmit(ppb);
        rt.SubmitChanges();
        pos         = rt.palm_opd_pathlogy_slaves.Single(palm_opd_pathlogy_slave => palm_opd_pathlogy_slave.slave_id == Convert.ToInt32(Session["slave_id"]));
        pos.date    = d.Text;
        pos.is_done = "Completed";
        rt.SubmitChanges();
        // fill print
        ppb           = rt.palm_pathology_vdrls.Single(palm_pathology_vdrl => palm_pathology_vdrl.slave_id == Session["slave_id"].ToString());
        Label223.Text = Session["pateint_name"].ToString();
        Label1.Text   = Session["ref_doctor"].ToString();
        Label225.Text = d.Text;
        labe6.Text    = Convert.ToString(ppb.vdrl);

        MultiView1.ActiveViewIndex = 1;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["emp_code"] == null)
        {
            Response.Redirect("~/home.aspx");
        }
        if (Session["pateint_name"] == null && Session["ref_doctor"] == null && Session["slave_id"] == null && Session["slave_id"] == null)
        {
            Response.Redirect("~/home.aspx");
        }


        if (Session["print"] == null)
        {
            labe1.Text = Session["pateint_name"].ToString();
            palm_doctor_employee pde = new palm_doctor_employee();
            // palm_doctor_employee pde = new palm_doctor_employee();
            // label0.Text = Session["pateint_name"].ToString();
            try
            {
                pde                   = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == Session["ref_doctor"].ToString());
                Label8.Text           = pde.doctor_name;
                Session["ref_doctor"] = pde.doctor_name;
            }
            catch (InvalidOperationException rtt)
            {
                palm_pateints_profile ppp = new palm_pateints_profile();
                ppp                   = rt.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Session["pateint_code"].ToString());
                Label8.Text           = ppp.ref_doc;
                Session["ref_doctor"] = ppp.ref_doc;
            }
            // Label11.Text = DateTime.Now.ToString();
        }
        else
        {
            Session["print"] = null;
            palm_doctor_employee pde = new palm_doctor_employee();
            //   palm_doctor_employee pde = new palm_doctor_employee();
            // palm_doctor_employee pde = new palm_doctor_employee();
            // label0.Text = Session["pateint_name"].ToString();
            try
            {
                pde                   = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == Session["ref_doctor"].ToString());
                Label1.Text           = pde.doctor_name;
                Session["ref_doctor"] = pde.doctor_name;
            }
            catch (InvalidOperationException rtt)
            {
                palm_pateints_profile ppp = new palm_pateints_profile();
                ppp                   = rt.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Session["pateint_code"].ToString());
                Label1.Text           = ppp.ref_doc;
                Session["ref_doctor"] = ppp.ref_doc;
            }
            Label223.Text = Session["pateint_name"].ToString();
            Label1.Text   = Session["ref_doctor"].ToString();
            palm_pathology_vdrl ppm = new palm_pathology_vdrl();
            ppm        = rt.palm_pathology_vdrls.Single(palm_pathology_vdrl => palm_pathology_vdrl.slave_id == Session["slave_id"].ToString());
            labe6.Text = Convert.ToString(ppm.vdrl);

            palm_opd_pathlogy_slave pps = new palm_opd_pathlogy_slave();
            pps           = rt.palm_opd_pathlogy_slaves.Single(palm_opd_pathlogy_slave => palm_opd_pathlogy_slave.slave_id == Convert.ToInt32(Session["slave_id"]));
            Label225.Text = Convert.ToString(pps.date);


            MultiView1.ActiveViewIndex = 1;
        }
    }