protected void GridView1_SelectedIndexChanged1(object sender, EventArgs e) { try { ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); String memo = Convert.ToString(GridView1.SelectedRow.Cells[0].Text); Session["memo"] = memo; Panel16.Visible = false; Panel17.Visible = true; Label112.Text = Label126.Text = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; //Label115.Text = d.Text; pop = rt.palm_opd_pathlogies.Single(palm_opd_pathlogy => palm_opd_pathlogy.patient_code == Session["pateint_code"].ToString()); String ref_doctor = pop.ref_by; } catch (NullReferenceException rtt) { Response.Redirect("~/login.aspx"); } palm_doctor_employee pdd = new palm_doctor_employee(); try { pdd = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == pop.ref_by); Label113.Text = pdd.doctor_name; } catch (Exception er) { Label113.Text = pop.ref_by; } pob = rt.palm_opd_pathlogy_billms.Single(palm_opd_pathlogy_billm => palm_opd_pathlogy_billm.memo == Session["memo"].ToString()); Label114.Text = pob.memo; Label122.Text = pob.memo; Label126.Text = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Label128.Text = pdd.doctor_name; Label124.Text = Convert.ToString(pob.inserted_on); TextBox2.Text = Convert.ToString(pob.advanced); TextBox3.Text = Convert.ToString(pob.balence); BindData1(); /* } * catch (InvalidOperationException ioe) * {Label134.Text="No Record Found"; * }*/ DataClassesDataContext df = new DataClassesDataContext(); palm_opd_Bill_master bill_master = new palm_opd_Bill_master(); palm_opd_Bill_slave bill_slave = new palm_opd_Bill_slave(); palm_doctor_employee pde = new palm_doctor_employee(); try { bill_master = df.palm_opd_Bill_masters.Single(palm_opd_Bill_master => palm_opd_Bill_master.pateint_code == TextBox1.Text); Label00.Text = Convert.ToString(bill_master.cash_memo); palm_pateints_profile ppp = new palm_pateints_profile(); Label81.Text = bill_master.opd_code; pde = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == bill_master.emp_id); palm_department pd = new palm_department(); pd = df.palm_departments.Single(palm_department => palm_department.department_code == pde.department); Label02.Text = pde.doctor_name; label9.Text = pd.department_desc; ppm = df.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == bill_master.pateint_code); Label01.Text = ppm.pateient_title + " ." + ppm.pateient_last_name + " " + ppm.pateient_first_name + " " + ppm.pateient_middle_name; Label84.Text = ppm.gender; ppp = df.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == bill_master.pateint_code); Label80.Text = ppp.ref_doc; Label83.Text = ppp.age; Label82.Text = Convert.ToString(bill_master.inserted_on); bill_slave = df.palm_opd_Bill_slaves.Single(palm_opd_Bill_slave => palm_opd_Bill_slave.opd_bill_id == bill_master.cash_memo); Label86.Text = Convert.ToString(bill_slave.amount); Label001.Text = Convert.ToString(bill_slave.amount); Label90.Text = Convert.ToString(bill_slave.amount); Label91.Text = Convert.ToString(bill_slave.amount); } catch (Exception rt1) { } }
protected void Button1_Click(object sender, EventArgs e) { DataSet dt1 = new DataSet(); dt1 = obj.investigation_byopd(Session["opd_code"].ToString()); if (dt1.Tables[0].Rows.Count == 0) { String path_id = obj.getpath_id(); pop.path_id = path_id; if (Session["external"] == null) { pop.ref_by = Convert.ToString(Session["emp_code"]); } else { pop.ref_by = Convert.ToString(Session["external"]); } pop.opd_code = Convert.ToString(Session["opd_code"]); pop.patient_code = Convert.ToString(Session["pateint_code"]); pop.inserted_by = Convert.ToString(Session["emp_code"]); pop.inserted_on = DateTime.Today; pop.is_done = "Not Completed"; rt.palm_opd_pathlogies.InsertOnSubmit(pop); rt.SubmitChanges(); pop = rt.palm_opd_pathlogies.Single(palm_opd_pathlogy => palm_opd_pathlogy.opd_code == Convert.ToString(Session["opd_code"])); pop1.path_id = pop.path_id;; pop1.test_name = DropDownList1.SelectedItem.Text; pop1.description = TextBox2.Text; pop1.date = DateTime.Now.ToString();; pop1.is_done = "Not Completed"; ; rt.palm_opd_pathlogy_slaves.InsertOnSubmit(pop1); rt.SubmitChanges(); } else { pop1.path_id = dt1.Tables[0].Rows[0]["path_id"].ToString(); pop1.test_name = DropDownList1.SelectedItem.Text; pop1.description = TextBox2.Text; pop1.date = DateTime.Now.ToString(); pop1.is_done = "Not Completed"; ; rt.palm_opd_pathlogy_slaves.InsertOnSubmit(pop1); rt.SubmitChanges(); } // bill section DataSet dt = new DataSet(); dt = obj.getbillstatus(Session["opd_code"].ToString()); palm_opd_pathlogy_billm pob = new palm_opd_pathlogy_billm(); palm_opd_pathlogy_bill pos = new palm_opd_pathlogy_bill(); pathology_test_report ptr = new pathology_test_report(); dt1 = obj.pathologybill_byopd(Session["opd_code"].ToString()); if (dt.Tables[0].Rows.Count == 0) { string cashmemo = obj.getlast_pathology_cashmemo(); pob.memo = cashmemo; pob.opd_code = Session["opd_code"].ToString(); pob.patient_code = Session["pateint_code"].ToString(); pob.inserted_by = Session["emp_code"].ToString(); pob.inserted_on = DateTime.Now.ToString(); rt.palm_opd_pathlogy_billms.InsertOnSubmit(pob); rt.SubmitChanges(); //pathology save pos.memo = cashmemo; pos.patient_code = Session["pateint_code"].ToString(); pos.test_name = DropDownList1.SelectedItem.Text; ptr = rt.pathology_test_reports.Single(pathology_test_report => pathology_test_report.test_code == DropDownList1.SelectedValue); pos.charge = ptr.test_rate; rt.palm_opd_pathlogy_bills.InsertOnSubmit(pos); rt.SubmitChanges(); } else { int i = dt.Tables[0].Rows.Count - 1; if (dt.Tables[0].Rows[i]["total"].ToString() != "") { string cashmemo = obj.getlast_pathology_cashmemo(); pob.memo = cashmemo; pob.opd_code = Session["opd_code"].ToString(); pob.patient_code = Session["pateint_code"].ToString(); pob.inserted_by = Session["emp_code"].ToString(); pob.inserted_on = DateTime.Now.ToString(); rt.palm_opd_pathlogy_billms.InsertOnSubmit(pob); rt.SubmitChanges(); //pathology save pos.memo = cashmemo; pos.patient_code = Session["pateint_code"].ToString(); pos.test_name = DropDownList1.SelectedItem.Text; ptr = rt.pathology_test_reports.Single(pathology_test_report => pathology_test_report.test_code == DropDownList1.SelectedValue); pos.charge = ptr.test_rate; rt.palm_opd_pathlogy_bills.InsertOnSubmit(pos); rt.SubmitChanges(); } else { // pob = rt.palm_opd_pathlogy_billms.Single(palm_opd_pathlogy_billm => palm_opd_pathlogy_billm.opd_code == Session["opd_code"].ToString()); DataSet ds = new DataSet(); ds = obj.getactivememo(Session["opd_code"].ToString()); pos.memo = ds.Tables[0].Rows[0]["memo"].ToString(); pos.patient_code = Session["pateint_code"].ToString(); pos.test_name = DropDownList1.SelectedItem.Text; ptr = rt.pathology_test_reports.Single(pathology_test_report => pathology_test_report.test_code == DropDownList1.SelectedValue); pos.charge = ptr.test_rate; rt.palm_opd_pathlogy_bills.InsertOnSubmit(pos); rt.SubmitChanges(); } } BindData(); }