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.lipase       = Convert.ToInt32(TextBox1.Text);


        rt.palm_pathology_lipases.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_lipases.Single(palm_pathology_lipase => palm_pathology_lipase.slave_id == Session["slave_id"].ToString());
        Lab00.Text    = Session["pateint_name"].ToString();
        Label249.Text = Session["ref_doctor"].ToString();
        Label00.Text  = DateTime.Now.ToString();
        Label260.Text = Convert.ToString(ppb.lipase);

        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)
        {
            Response.Redirect("~/home.aspx");
        }
        if (Session["print"] == null)
        {
            Label1.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
        {
            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());
                Label249.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());
                Label249.Text         = ppp.ref_doc;
                Session["ref_doctor"] = ppp.ref_doc;
            }
            Lab00.Text    = Session["pateint_name"].ToString();
            Label249.Text = Session["ref_doctor"].ToString();
            palm_pathology_lipase ppm = new palm_pathology_lipase();
            ppm           = rt.palm_pathology_lipases.Single(palm_pathology_lipase => palm_pathology_lipase.slave_id == Session["slave_id"].ToString());
            Label260.Text = Convert.ToString(ppm.lipase);

            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"]));
            Label00.Text = Convert.ToString(pps.date);


            MultiView1.ActiveViewIndex = 1;
        }
    }