protected void Grid_SelectedIndexChanged(object sender, EventArgs e) { DataClassesDataContext rt = new DataClassesDataContext(); palm_pateint_master ppm = new palm_pateint_master(); palm_pateints_profile ppp = new palm_pateints_profile(); ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Grid.SelectedRow.Cells[0].Text); ppp = rt.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Grid.SelectedRow.Cells[0].Text); DropDownList14.SelectedValue = ppm.pateient_title; TextBox26.Text = ppm.pateient_last_name; TextBox27.Text = ppm.pateient_middle_name; TextBox3.Text = ppm.pateient_middle_name; TextBox28.Text = ppm.father_husbemd_name; TextBox29.Text = ""; TextBox31.Text = ppp.age; RadioButtonList2.SelectedValue = ppm.gender; try { DropDownList7.SelectedValue = ppm.blood_group; } catch (ArgumentOutOfRangeException aore) { } TextBox45.Text = ppp.ref_doc; DropDownList8.SelectedValue = ppm.civil_status; TextBox22.Text = ppp.permanent_home_no; TextBox33.Text = ppp.permanant_build_society; TextBox34.Text = ppp.permanant_area; TextBox35.Text = ppp.permanant_locality; TextBox36.Text = ppp.permanant_town; DropDownList9.SelectedIndex = DropDownList9.Items.IndexOf(DropDownList9.Items.FindByText(ppp.permanent_country_id.ToString())); DropDownList10.SelectedIndex = DropDownList9.Items.IndexOf(DropDownList9.Items.FindByText(ppp.permanent_state_id.ToString())); TextBox46.Text = ppp.permanant_district_id; TextBox40.Text = ppp.permanant_city; TextBox48.Text = ppp.permanant_tal_id; TextBox42.Text = ppp.tele_no; TextBox43.Text = ppp.mobile_no; TextBox44.Text = ppp.present_email_id; TextBox32.Text = ppp.permanent_pin_code; TextBox1.Text = ppp.present_email_id; TextBox2.Text = ppp.present_build_society; TextBox4.Text = ppp.present_area; TextBox5.Text = ppp.present_locality; TextBox6.Text = ppp.present_town; DropDownList1.SelectedValue = ppp.present_country_id.ToString(); DropDownList2.SelectedIndex = DropDownList9.Items.IndexOf(DropDownList9.Items.FindByText(ppp.present_state_id.ToString())); TextBox47.Text = ppp.present_district_id; TextBox7.Text = ppp.present_city; TextBox8.Text = ppp.present_tal; TextBox9.Text = ppp.tele_no; TextBox10.Text = ppp.mobile_no; TextBox11.Text = ppp.present_email_id; TextBox12.Text = ppp.permanent_pin_code; MultiView1.ActiveViewIndex = 1; }
protected void Button5_Click(object sender, EventArgs e) { DataClassesDataContext rt = new DataClassesDataContext(); palm_pateint_master ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Grid.SelectedRow.Cells[0].Text); palm_pateints_profile ppp = rt.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Grid.SelectedRow.Cells[0].Text); ppm.pateient_title = DropDownList14.SelectedValue; ppm.pateient_last_name = TextBox26.Text; TextBox27.Text = ppm.pateient_middle_name; ppm.pateient_middle_name = TextBox3.Text; ppm.father_husbemd_name = TextBox28.Text; TextBox29.Text = ""; ppp.age = TextBox31.Text; ppm.gender = RadioButtonList2.SelectedValue; ppm.blood_group = DropDownList7.SelectedValue; ppp.ref_doc = TextBox45.Text; ppm.civil_status = DropDownList8.SelectedValue; ppp.permanent_home_no = TextBox22.Text; ppp.permanant_build_society = TextBox33.Text; ppp.permanant_area = TextBox34.Text; ppp.permanant_locality = TextBox35.Text; ppp.permanant_town = TextBox36.Text; ppp.permanent_country_id = DropDownList9.SelectedIndex; ppp.permanent_state_id = DropDownList10.SelectedIndex; ppp.permanant_district_id = TextBox46.Text; ppp.permanant_city = TextBox40.Text; ppp.permanant_tal_id = TextBox48.Text; ppp.tele_no = TextBox42.Text; ppp.mobile_no = TextBox43.Text; ppp.present_email_id = TextBox44.Text; ppp.permanent_pin_code = TextBox32.Text; ppp.present_email_id = TextBox1.Text; ppp.present_build_society = TextBox2.Text; ppp.present_area = TextBox4.Text; ppp.present_locality = TextBox5.Text; ppp.present_town = TextBox6.Text; ppp.permanent_country_id = DropDownList1.SelectedIndex; ppp.permanent_state_id = DropDownList2.SelectedIndex; ppp.present_district_id = TextBox47.Text; ppp.present_city = TextBox7.Text; ppp.present_tal = TextBox8.Text; ppp.tele_no = TextBox9.Text; ppp.mobile_no = TextBox10.Text; ppp.present_email_id = TextBox11.Text; ppp.present_pin_code = TextBox12.Text; rt.SubmitChanges(); Response.Write("<SCRIPT>alert('Record Updated Succesfully')</SCRIPT>"); }
protected void save_Click(object sender, EventArgs e) { /*try * {*/ DataClassesDataContext rt = new DataClassesDataContext(); palm_pateint_master ppm = new palm_pateint_master(); palm_pateints_profile ppp = new palm_pateints_profile(); String prn = objb.getprnbll(); ppm.pateint_code = prn; ppp.pateint_code = prn; ppm.pateient_first_name = TextBox49.Text; ppm.pateient_title = DropDownList15.SelectedValue; ppm.pateient_middle_name = name.Text; ppm.pateient_last_name = TextBox58.Text; ppm.is_check_in = "1"; ppm.is_discharge = "1"; // ppm.gender = RadioButtonList3.SelectedValue; rt.palm_pateint_masters.InsertOnSubmit(ppm); rt.SubmitChanges(); ppp.age = TextBox52.Text; ppp.ref_doc = refdoct.Text; rt.palm_pateints_profiles.InsertOnSubmit(ppp); rt.SubmitChanges(); palm_opd_registration opr = new palm_opd_registration(); opr.opd_code = "OPD" + prn; opr.pateint_code = prn; opr.ref_doctor = refdoct.Text; opr.department_code = "123"; opr.consultant_doctor_name = refdoct.Text; rt.palm_opd_registrations.InsertOnSubmit(opr); rt.SubmitChanges(); Session["ref_doctor"] = refdoct.Text; opr = rt.palm_opd_registrations.Single(palm_opd_registration => palm_opd_registration.pateint_code == prn); //Session["ref_doctor"] =opr.ref_doctor; Session["opd_code"] = opr.opd_code; Session["pateint_code"] = prn; Response.Redirect("~/nurse_module/ext_investigation.aspx"); /* } * catch (Exception err) { * Response.Write("<script>alert('Failed Insert Record');</script>"); * }*/ }
protected void Page_Load(object sender, EventArgs e) { if (Session["emp_code"].ToString() == "") { Response.Redirect("~/home.aspx"); } if (Session["opd_only"] != null) { ppp = df.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Session["pateint_code"].ToString()); Label6.Text = ppp.age; Label10.Text = ppp.permanant_town; ppm = df.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); Label2.Text = Session["pateint_code"].ToString(); Label4.Text = Session["pateint_name"].ToString(); Label8.Text = ppm.gender; Label12.Text = ppm.civil_status; TextBox21.Text = obj.getopdbll(Session["pateint_code"].ToString()); MultiView1.ActiveViewIndex = 1; DataSet ds = new DataSet(); Session["opd_only"] = null; } }
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) { /*try * {*/ palm_pateint_master ppm1 = new palm_pateint_master(); long prn = bl.getprn(); pl.prn = prn; Session["prn"] = prn; pl.pateint_code = Session["Pateint_code"].ToString(); pl.inserted_by = Session["emp_code"].ToString(); pl.inserted_on = DateTime.Now; pl.department_code = Master.department.SelectedValue; pl.consultant_doctor_name = Master.departmentd.SelectedValue; pl.consultant1_doctor_name = Master.doctor1.Text; pl.consultant2_doctor_name = Master.doctor2.Text; pl.room_type = Master.room_type.Text; pl.room_no = Convert.ToInt32(Master.room_no.Text); pl.bed_no = Convert.ToInt32(Master.bed_no.Text); pl.date_of_admission = TextBox5.Text; pl.time_admission = TextBox6.Text; rt.palm_ipd_registrations.InsertOnSubmit(pl); rt.SubmitChanges(); pkd.prn = prn.ToString();; pkd.kin_next_name = TextBox1.Text; pkd.kin_reln_pateint = TextBox2.Text; pkd.kin_tele_no = TextBox3.Text; pkd.pateint_code = Session["pateint_code"].ToString(); // rt.palm_pateints_kin_details.InsertOnSubmit(pkd); rt.SubmitChanges(); palm_bed_category pbc = new palm_bed_category(); palm_pateint_master ppm = new palm_pateint_master(); ppm = rt1.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); pbc = rt.palm_bed_categories.Single(palm_bed_category => palm_bed_category.bed_no == Convert.ToInt32(Master.bed_no.Text)); pbc.status = "Occupied"; pbc.pateint_code = Session["pateint_code"].ToString(); pbc.prn = Session["prn"].ToString(); rt.SubmitChanges(); room_master rm = new room_master(); rm = rt.room_masters.Single(room_master => room_master.room_no == Convert.ToInt32(Master.room_no.Text)); rm.occupied = rm.occupied + 1; rt.SubmitChanges(); ppm = rt1.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); ppm.is_check_in = "1"; rt1.SubmitChanges(); Response.Write("<script>alert('Pateint Registration Successfull')</script>"); //checking in pateint /* palm_pateint_master ppm1 = new palm_pateint_master(); * // ppm1 = rt1.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); * ppm.is_check_in = "1"; * rt1.SubmitChanges();*/ int a = bl.checkin(Session["pateint_code"].ToString()); //print form try { //palm_pateint_master ppm = new palm_pateint_master(); ppm = rt1.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); // pl = rt.palm_ipd_registrations.Single(palm_ipd_registration => palm_ipd_registration.pateint_code == Session["pateint_code"].ToString()); Label88.Text = TextBox5.Text; Label90.Text = Convert.ToString(prn); Label164.Text = ppm.pateient_last_name + " " + ppm.pateient_first_name + " " + ppm.pateient_middle_name; Label163.Text = ppm.father_husbemd_name; Label98.Text = ppm.gender; } catch (InvalidOperationException rtt) { Label88.Text = "NA"; Label90.Text = "NA"; Label164.Text = "NA"; Label163.Text = "NA"; Label98.Text = "NA"; } try { palm_pateints_profile ppp = new palm_pateints_profile(); ppp = rt1.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Session["pateint_code"].ToString()); Label101.Text = "Indian"; Label120.Text = ppp.ref_doc; Label110.Text = ppp.present_pincode; Label161.Text = ppp.age; label0.Text = ppp.permanent_pin_code; mobile.Text = ppp.mobile_no; telephone.Text = ppp.tele_no; emailid.Text = ppp.present_email_id; label0.Text = ppp.present_pincode; Label166.Text = ppp.present_house_no + "" + ppp.present_build_society + " " + ppp.present_area + " " + ppp.present_area + " " + ppp.present_city + " " + ppp.present_town; Label121.Text = ppp.permanent_home_no + " " + ppp.present_build_society + " " + ppp.permanant_area + " " + ppp.permanant_locality + " " + ppp.permanant_city + " " + ppp.permanant_tal_id + " " + ppp.permanant_district_id; palm_state_master psm = new palm_state_master(); int state_id = Convert.ToInt32(ppp.present_state_id); psm = rt.palm_state_masters.Single(palm_state_master => palm_state_master.state_code == Convert.ToString(ppp.present_state_id)); Label109.Text = psm.state_desc; int state_id1 = Convert.ToInt32(ppp.permanent_state_id); psm = rt.palm_state_masters.Single(palm_state_master => palm_state_master.state_code == Convert.ToString(ppp.permanent_state_id)); Label168.Text = psm.state_desc; label0.Text = ppp.permanent_pin_code; palm_country_master pcm = new palm_country_master(); int id = Convert.ToInt32(ppp.present_country_id); pcm = rt.palm_country_masters.Single(palm_country_master => palm_country_master.country_code == Convert.ToString(ppp.permanent_country_id)); Label111.Text = pcm.country_desc; } catch (InvalidOperationException rtt) { Label101.Text = "NA"; Label120.Text = "NA"; Label110.Text = "NA"; Label166.Text = "NA"; Label121.Text = "NA"; Label109.Text = "NA"; Label168.Text = "NA"; label0.Text = "NA"; } try { palm_ipd_registration pir = new palm_ipd_registration(); String code = Session["pateint_code"].ToString(); pir = rt.palm_ipd_registrations.Single(palm_ipd_registration => palm_ipd_registration.pateint_code == Session["pateint_code"].ToString()); palm_doctor_employee pde = new palm_doctor_employee(); pde = rt1.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == pir.consultant_doctor_name); Label169.Text = pde.doctor_name; Label128.Text = pir.consultant1_doctor_name; Label129.Text = pir.consultant2_doctor_name; toa.Text = pir.time_admission; String room_type = pir.room_type; switch (room_type) { case "Delux": CheckBox4.Checked = true; break; case "Private _Room": CheckBox5.Checked = true; break; case "Semi Private Room": CheckBox6.Checked = true; break; case "Genral Ward": checkbox0.Checked = true; break; default: break; } } catch (InvalidOperationException rtt) { Label169.Text = "---"; Label128.Text = "---"; Label129.Text = "---"; } try { palm_pateints_kin_detail ppk = new palm_pateints_kin_detail(); String code = Session["pateint_code"].ToString(); ppk = rt.palm_pateints_kin_details.Single(palm_pateints_kin_detail => palm_pateints_kin_detail.pateint_code == Session["pateint_code"].ToString()); Label132.Text = ppk.kin_next_name; lab0.Text = ppk.kin_reln_pateint; Label000.Text = ppk.kin_tele_no; } catch (InvalidOperationException rtt) { Label132.Text = "---"; lab0.Text = "---"; Label000.Text = "---"; } catch (Exception err) { } MultiView1.ActiveViewIndex = 2; /*} * catch (Exception err) { }*/ }
protected void Page_Load(object sender, EventArgs e) { if (Session["printing"] != null) { Session["printing"] = null; try { palm_pateint_master ppm = new palm_pateint_master(); ppm = rt1.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); // pl = rt.palm_ipd_registrations.Single(palm_ipd_registration => palm_ipd_registration.pateint_code == Session["pateint_code"].ToString()); Label88.Text = TextBox5.Text; Label90.Text = Convert.ToString(Session["prn"].ToString()); Label164.Text = ppm.pateient_last_name + " " + ppm.pateient_first_name + " " + ppm.pateient_middle_name; Label163.Text = ppm.father_husbemd_name; Label98.Text = ppm.gender; } catch (InvalidOperationException rtt) { Label88.Text = "NA"; Label90.Text = "NA"; Label164.Text = "NA"; Label163.Text = "NA"; Label98.Text = "NA"; } try { palm_pateints_profile ppp = new palm_pateints_profile(); ppp = rt1.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Session["pateint_code"].ToString()); Label101.Text = "Indian"; Label120.Text = ppp.ref_doc; Label110.Text = ppp.present_pincode; Label161.Text = ppp.age; label0.Text = ppp.permanent_pin_code; mobile.Text = ppp.mobile_no; telephone.Text = ppp.tele_no; emailid.Text = ppp.present_email_id; label0.Text = ppp.present_pincode; Label166.Text = ppp.present_house_no + "" + ppp.present_build_society + " " + ppp.present_area + " " + ppp.present_area + " " + ppp.present_city + " " + ppp.present_town; Label121.Text = ppp.permanent_home_no + " " + ppp.present_build_society + " " + ppp.permanant_area + " " + ppp.permanant_locality + " " + ppp.permanant_city + " " + ppp.permanant_tal_id + " " + ppp.permanant_district_id; palm_state_master psm = new palm_state_master(); int state_id = Convert.ToInt32(ppp.present_state_id); psm = rt.palm_state_masters.Single(palm_state_master => palm_state_master.state_code == Convert.ToString(ppp.present_state_id)); Label109.Text = psm.state_desc; int state_id1 = Convert.ToInt32(ppp.permanent_state_id); psm = rt.palm_state_masters.Single(palm_state_master => palm_state_master.state_code == Convert.ToString(ppp.permanent_state_id)); Label168.Text = psm.state_desc; label0.Text = ppp.permanent_pin_code; palm_country_master pcm = new palm_country_master(); int id = Convert.ToInt32(ppp.present_country_id); pcm = rt.palm_country_masters.Single(palm_country_master => palm_country_master.country_code == Convert.ToString(ppp.permanent_country_id)); Label111.Text = pcm.country_desc; } catch (InvalidOperationException rtt) { Label101.Text = "NA"; Label120.Text = "NA"; Label110.Text = "NA"; Label166.Text = "NA"; Label121.Text = "NA"; Label109.Text = "NA"; Label168.Text = "NA"; label0.Text = "NA"; } try { palm_ipd_registration pir = new palm_ipd_registration(); String code = Session["pateint_code"].ToString(); pir = rt.palm_ipd_registrations.Single(palm_ipd_registration => palm_ipd_registration.pateint_code == Session["pateint_code"].ToString()); palm_doctor_employee pde = new palm_doctor_employee(); pde = rt1.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == pir.consultant_doctor_name); Label169.Text = pde.doctor_name; Label128.Text = pir.consultant1_doctor_name; Label129.Text = pir.consultant2_doctor_name; String room_type = pir.room_type; switch (room_type) { case "Delux": CheckBox4.Checked = true; break; case "Private _Room": CheckBox5.Checked = true; break; case "Semi Private Room": CheckBox6.Checked = true; break; case "Genral Ward": checkbox0.Checked = true; break; default: break; } Label89.Text = pir.date_of_discharge; toa.Text = pir.time_admission; tod.Text = pir.time_of_discharge; } catch (InvalidOperationException rtt) { Label169.Text = "---"; Label128.Text = "---"; Label129.Text = "---"; } try { palm_pateints_kin_detail ppk = new palm_pateints_kin_detail(); String code = Session["pateint_code"].ToString(); ppk = rt.palm_pateints_kin_details.Single(palm_pateints_kin_detail => palm_pateints_kin_detail.pateint_code == Session["pateint_code"].ToString()); Label132.Text = ppk.kin_next_name; lab0.Text = ppk.kin_reln_pateint; Label000.Text = ppk.kin_tele_no; } catch (InvalidOperationException rtt) { Label132.Text = "---"; lab0.Text = "---"; Label000.Text = "---"; } MultiView1.ActiveViewIndex = 2; } }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { pops = rt.palm_opd_pathlogy_slaves.Single(palm_opd_pathlogy_slave => palm_opd_pathlogy_slave.slave_id == Convert.ToInt16(GridView1.SelectedRow.Cells[0].Text)); Session["pateint_code"] = GridView1.SelectedRow.Cells[1].Text; ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); Session["Pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["test_asked"] = GridView1.SelectedRow.Cells[5].Text; ptr = rt.pathology_test_reports.Single(pathology_test_report => pathology_test_report.test_name == GridView1.SelectedRow.Cells[5].Text); Session["path_id"] = pops.path_id; try { pde = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == GridView1.SelectedRow.Cells[2].Text); Session["ref_doctor"] = "Dr." + pde.doctor_name; } catch (InvalidOperationException rt1) { 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()); Session["ref_doctor"] = ppp.ref_doc;; } Session["slave_id"] = GridView1.SelectedRow.Cells[0].Text; String test_code = ptr.test_code; switch (test_code) { case "lft": Response.Redirect("~/pathology/reports/LFT.aspx"); break; case "cbc": Response.Redirect("~/pathology/reports/cbc.aspx"); break; case "ur": Response.Redirect("~/pathology/reports/urine_routine.aspx"); break; case "rbs": Response.Redirect("~/pathology/reports/rbs.aspx"); break; case "bg": Response.Redirect("~/pathology/reports/blood_group.aspx"); break; case "crp": Response.Redirect("~/pathology/reports/crp.aspx"); break; case "ua": Response.Redirect("~/pathology/reports/uric_acid.aspx"); break; case "hba1c": Response.Redirect("~/pathology/reports/hb1ac.aspx"); break; case "sr": Response.Redirect("~/pathology/reports/stool_examination.aspx"); break; case "mp": Response.Redirect("~/pathology/reports/mp.aspx"); break; case "hbsag": Response.Redirect("~/pathology/reports/hbsag.aspx"); break; case "Dengue IgM": Response.Redirect("~/pathology/reports/dengue_igm.aspx"); break; case "Dengue NS1": Response.Redirect("~/pathology/reports/dengue_ns1.aspx"); break; case "esr": Response.Redirect("~/pathology/reports/esr.aspx"); break; case "lp": Response.Redirect("~/pathology/reports/lipid_profile.aspx"); break; case "rft": Response.Redirect("~/pathology/reports/rft.aspx"); break; case "c": Response.Redirect("~/pathology/reports/calcium.aspx"); break; case "vitb12": Response.Redirect("~/pathology/reports/vit_b12.aspx"); break; case "vitd3": Response.Redirect("~/pathology/reports/vitd3.aspx"); break; case "bt_ct": Response.Redirect("~/pathology/reports/bt_ct.aspx"); break; case "fbs_plbs": Response.Redirect("~/pathology/reports/fbs_plbs.aspx"); break; case "wt": Response.Redirect("~/pathology/reports/widal_test.aspx"); break; case "vdrl": Response.Redirect("~/pathology/reports/VDRL.aspx"); break; case "ra": Response.Redirect("~/pathology/reports/ra_test.aspx"); break; case "el": Response.Redirect("~/pathology/reports/electrolyte.aspx"); break; case "cpk": Response.Redirect("~/pathology/reports/cpk.aspx"); break; case "hcv": Response.Redirect("~/pathology/reports/HCV.aspx"); break; case "g6pd": Response.Redirect("~/pathology/reports/g6pd.aspx"); break; case "a": Response.Redirect("~/pathology/reports/amylase.aspx"); break; case "lipase": Response.Redirect("~/pathology/reports/lipase.aspx"); break; case "cn": Response.Redirect("~/pathology/reports/CREATNINE.aspx"); break; default: Response.Write("<script>alert('Report Module is not Ready.')</script>"); break; } }
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e) { palm_pateint_master ppm = new palm_pateint_master(); ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == GridView2.SelectedRow.Cells[1].Text); String test_name = GridView2.SelectedRow.Cells[6].Text; ptr = rt.pathology_test_reports.Single(pathology_test_report => pathology_test_report.test_name == test_name); String test_code = ptr.test_code; switch (test_code) { case "cn": Session["print"] = 1; Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Response.Redirect("~/pathology/reports/CREATNINE.aspx"); break; case "hba1c": Session["print"] = 1; Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Response.Redirect("~/pathology/reports/hb1ac.aspx"); break; case "rbs": Session["print"] = 1; Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Response.Redirect("~/pathology/reports/rbs.aspx"); break; case "lft": Session["print"] = 1; Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Response.Redirect("~/pathology/reports/LFT.aspx"); break; case "cbc": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/cbc.aspx"); break; case "ur": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/urine_routine.aspx"); break; case "bg": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/blood_group.aspx"); break; case "lipase": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/lipase.aspx"); break; case "crp": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/crp.aspx"); break; case "ua": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/uric_acid.aspx"); break; case "sr": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/stool_examination.aspx"); break; case "mp": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/mp.aspx"); break; case "hbsag": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/hbsag.aspx"); break; case "Dengue IgM": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/dengue_igm.aspx"); break; case "Dengue NS1": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/dengue_ns1.aspx"); break; case "esr": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/esr.aspx"); break; case "lp": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/lipid_profile.aspx"); break; case "rft": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/rft.aspx"); break; case "c": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/calcium.aspx"); break; case "vitb12": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/vit_b12.aspx"); break; case "vitd3": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/vitd3.aspx"); break; case "bt_ct": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/bt_ct.aspx"); break; case "fbs_plbs": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/fbs_plbs.aspx"); break; case "wt": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/widal_test.aspx"); break; case "vdrl": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/VDRL.aspx"); break; case "ra": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/ra_test.aspx"); break; case "el": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/electrolyte.aspx"); break; case "cpk": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/cpk.aspx"); break; case "hcv": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/HCV.aspx"); break; case "g6pd": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/g6pd.aspx"); break; case "a": Session["pateint_name"] = ppm.pateient_title + " " + ppm.pateient_first_name + " " + ppm.pateient_last_name; Session["pateint_code"] = GridView2.SelectedRow.Cells[1].Text; Session["slave_id"] = GridView2.SelectedRow.Cells[0].Text; Session["ref_doctor"] = GridView2.SelectedRow.Cells[3].Text; Session["print"] = 1; Response.Redirect("~/pathology/reports/amylase.aspx"); break; default: Response.Write("<script>alert('Report Module is not Ready.')</script>"); break; } }
protected void Button1_Click(object sender, EventArgs e) { try { poh.menstrul_history = TextBox1.Text; } catch (Exception rttt) { poh.menstrul_history = ""; } try { poh.past_medical_history = TextBox4.Text; } catch (Exception rttt) { poh.past_medical_history = ""; } try { poh.past_surgical_history = TextBox5.Text; } catch (Exception rttt) { poh.past_surgical_history = ""; } try { poh.bowel = TextBox7.Text; } catch (Exception rttt) { poh.bowel = ""; } try { poh.bladder = TextBox9.Text; } catch (Exception rttt) { poh.bladder = ""; } try { poh.appetite = TextBox8.Text; } catch (Exception rttt) { poh.appetite = ""; } try { poh.sleep_pattern = TextBox10.Text; } catch (Exception rttt) { poh.sleep_pattern = ""; } try { poh.addiction = TextBox11.Text; } catch (Exception rttt) { poh.addiction = ""; } try { poh.allergic_history = TextBox6.Text; } catch (Exception rttt) { poh.allergic_history = ""; } try { poh.menstrul_history = RadioButtonList1.SelectedValue; } catch (Exception rttt) { poh.menstrul_history = ""; } poh.opd_code = Session["opd_code"].ToString(); poh.inserted_by = Session["emp_code"].ToString(); poh.inserted_on = DateTime.Now; ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); ppm.is_discharge = "1"; rt.palm_opd_histories.InsertOnSubmit(poh); /* try * {*/ rt.SubmitChanges(); /*} * catch (Exception rtt) { Response.Write("<script>alert('pateint dose exist')</script>"); } */ // reciept fill Label81.Text = Session["opd_code"].ToString(); por = rt.palm_opd_registrations.Single(palm_opd_registration => palm_opd_registration.opd_code == Session["opd_code"].ToString()); Label78.Text = por.consultant_doctor_name; palm_department pd = new palm_department(); pd = rt.palm_departments.Single(palm_department => palm_department.department_code == por.department_code); Label79.Text = pd.department_desc; ppm = rt.palm_pateint_masters.Single(palm_pateint_master => palm_pateint_master.pateint_code == Session["pateint_code"].ToString()); Label77.Text = ppm.pateient_title + " ." + ppm.pateient_last_name + " " + ppm.pateient_first_name + " " + ppm.pateient_middle_name; Label84.Text = ppm.gender; ppp = rt.palm_pateints_profiles.Single(palm_pateints_profile => palm_pateints_profile.pateint_code == Session["pateint_code"].ToString()); Label80.Text = ppp.ref_doc; Label83.Text = ppp.age; Label82.Text = Convert.ToString(DateTime.Now); palm_opd_complain poc = new palm_opd_complain(); poh = rt.palm_opd_histories.Single(palm_opd_history => palm_opd_history.opd_code == Session["opd_code"].ToString()); Label96.Text = poh.past_medical_history; MultiView1.ActiveViewIndex = 1; }
protected void Button2_Click(object sender, EventArgs e) { objp.built = TextBox2.Text; objp.pulse = TextBox26.Text; objp.bp = TextBox5.Text; objp.rr = TextBox3.Text; objp.pallor = TextBox27.Text; objp.cyanosis = TextBox2.Text; objp.clubing = TextBox4.Text; objp.peripheral_pulse = TextBox28.Text; objp.jvp = TextBox2.Text; objp.hjr = TextBox29.Text; objp.oedema = TextBox32.Text; objp.adenopathy = TextBox2.Text; objp.icterus = TextBox30.Text; objp.erruptions = TextBox33.Text; objp.other = TextBox47.Text; objp.cvs = TextBox36.Text; objp.r_s = TextBox42.Text; objp.p_a = TextBox43.Text; objp.cns = TextBox44.Text; objp.ps_pv = TextBox45.Text; objp.opd_code = Session["opd_code"].ToString();; objp.ref_doctor = TextBox25.Text; objp.department = DropDownList5.SelectedValue; objp.doctor_id = DropDownList3.SelectedValue; objp.con_doctor = DropDownList3.SelectedItem.Text; objp.pateint_code = Session["pateint_code"].ToString(); objp.emp_code = Session["emp_code"].ToString(); objp.is_check_in = "1"; obj.opdreg(objp); int cashmemo = obj.getcashmemo(); por = df.palm_opd_registrations.Single(palm_opd_registration => palm_opd_registration.opd_code == TextBox21.Text); bill_master.cash_memo = cashmemo; bill_master.pateint_code = por.pateint_code; bill_master.opd_code = TextBox21.Text; bill_master.cash_memo = cashmemo; bill_master.emp_id = por.emp_code; bill_master.inserted_by = Session["emp_code"].ToString(); bill_master.inserted_on = DateTime.Now; df.palm_opd_Bill_masters.InsertOnSubmit(bill_master); df.SubmitChanges(); bill_master = df.palm_opd_Bill_masters.Single(palm_opd_Bill_master => palm_opd_Bill_master.cash_memo == cashmemo); pde = df.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == bill_master.emp_id); bill_slave.opd_bill_id = bill_master.cash_memo; bill_slave.charge_name = "Consulting"; bill_slave.description = "Consulting"; bill_slave.units = 1; bill_slave.amount = pde.consulting_fees; df.palm_opd_Bill_slaves.InsertOnSubmit(bill_slave); df.SubmitChanges(); Label00.Text = Convert.ToString(bill_master.cash_memo); Label81.Text = bill_master.opd_code; palm_department pd = new palm_department(); pd = df.palm_departments.Single(palm_department => palm_department.department_code == pde.department); Label02.Text = pde.doctor_name; Label006.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); MultiView1.ActiveViewIndex = 3; }