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)
{
Response.Redirect("~/home.aspx");
}
if (Session["print"] == null)
{
Label7.Text = Session["pateint_name"].ToString();
Label8.Text = Session["ref_doctor"].ToString();
// Label11.Text = DateTime.Now.ToString();
}
else
{
Session["print"] = null;
palm_doctor_employee pde = new palm_doctor_employee();
try
{
pde = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == Session["ref_doctor"].ToString());
Session["ref_doctor"] = pde.doctor_name;
}catch (InvalidOperationException ioe)
{
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());
Label2.Text = ppp.ref_doc;
}
label.Text = Session["pateint_name"].ToString();
palm_pathology_cbc ppm = new palm_pathology_cbc();
ppm = rt.palm_pathology_cbcs.Single(palm_pathology_cbc => palm_pathology_cbc.slave_id == Convert.ToInt32(Session["slave_id"]));
Label213.Text = ppm.erythrocyte_count.ToString();
Label214.Text = ppm.heamoglobin.ToString();
Label215.Text = ppm.p_c_v.ToString();
Label217.Text = ppm.m_c_v.ToString();
Label218.Text = ppm.m_c_h.ToString();
Label219.Text = ppm.m_c_h_c.ToString();
Label220.Text = ppm.leucocyte_count.ToString();
Label221.Text = ppm.neutrophils.ToString();
Label222.Text = ppm.eosinohils.ToString();
Label223.Text = ppm.basophils.ToString();
Label224.Text = ppm.lymphocytes.ToString();
Label225.Text = ppm.monocytes.ToString();
Label227.Text = ppm.platelete_count.ToString();
Label226.Text = ppm.platelete_on_smear.ToString();
Label228.Text = ppm.rbc_morphology.ToString();
Label229.Text = ppm.wbc_morphology.ToString();
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"]));
Label1.Text = Convert.ToString(pps.date);
MultiView1.ActiveViewIndex = 1;
Session["print"] = null;
}
}
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)
{
Response.Redirect("~/home.aspx");
}
if (Session["print"] == null)
{
Label7.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();
try
{
pde = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == Session["ref_doctor"].ToString());
label2.Text = 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());
label2.Text = ppp.ref_doc;
}
Label249.Text = Session["pateint_name"].ToString();
// label2.Text = Session["ref_doctor"].ToString();
palm_pathology_mp ppm = new palm_pathology_mp();
ppm = rt.palm_pathology_mps.Single(palm_pathology_mp => palm_pathology_mp.slave_id == Session["slave_id"].ToString());
Label263.Text = ppm.malerial_parasite;
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"]));
Label251.Text = Convert.ToString(pps.date);
MultiView1.ActiveViewIndex = 1;
}
}
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.bleeding_timemin = Convert.ToInt32(TextBox3.Text);
ppb.bleeding_timesec = Convert.ToInt32(TextBox1.Text);
ppb.clotting_timemin = Convert.ToInt32(TextBox6.Text);
ppb.clotting_timesec = Convert.ToInt32(TextBox5.Text);
rt.palm_pathology_bt_cts.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_bt_cts.Single(palm_pathology_bt_ct => palm_pathology_bt_ct.slave_id == Session["slave_id"].ToString());
Label250.Text = Session["pateint_name"].ToString();
palm_doctor_employee pde = new palm_doctor_employee();
try
{
pde = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == Session["ref_doctor"].ToString());
Label254.Text = 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());
Label254.Text = ppp.ref_doc;
}
Label252.Text = d.Text;
label21.Text = Convert.ToString(ppb.bleeding_timemin);
label.Text = Convert.ToString(ppb.bleeding_timesec);
label2.Text = Convert.ToString(ppb.clotting_timemin);
Label0.Text = Convert.ToString(ppb.clotting_timesec);
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)
{
Response.Redirect("~/home.aspx");
}
if (Session["print"] == null)
{
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;
}
Label1.Text = Session["pateint_name"].ToString();
// Label8.Text = Session["ref_doctor"].ToString();
//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());
label3.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());
label3.Text = ppp.ref_doc;
Session["ref_doctor"] = ppp.ref_doc;
}
laqbel00.Text = Session["pateint_name"].ToString();
palm_pathology_widal ppm = new palm_pathology_widal();
ppm = rt.palm_pathology_widals.Single(palm_pathology_widal => palm_pathology_widal.slave_id == Convert.ToInt32(Session["slave_id"]).ToString());
label300.Text = Convert.ToString(ppm.s_typhi_antigen_o);
label301.Text = ppm.s_typhi_antigen_h;
label302.Text = ppm.s_paratyphi_a;
label303.Text = ppm.s_paratyphi_b;
Label0.Text = ppm.result;
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"]));
laqbel0.Text = Convert.ToString(pps.date);
MultiView1.ActiveViewIndex = 1;
}
}
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 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)
{
Response.Redirect("~/home.aspx");
}
if (Session["print"] == null)
{
Label7.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());
Label20.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());
Label20.Text = ppp.ref_doc;
Session["ref_doctor"] = ppp.ref_doc;
}
Label2.Text = Session["pateint_name"].ToString();
Label20.Text = Session["ref_doctor"].ToString();
palm_pathology_rft ppm = new palm_pathology_rft();
ppm = rt.palm_pathology_rfts.Single(palm_pathology_rft => palm_pathology_rft.slave_id == Session["slave_id"].ToString());
Label237.Text = ppm.creatinine_serum.ToString();
Label238.Text = ppm.blood_uria_nitrogen.ToString();
Label239.Text = ppm.bun_sr_creatinine_ratio.ToString();
Label240.Text = ppm.uric_acid.ToString();
Label241.Text = ppm.calcium.ToString();
Q.Text = ppm.protine_total.ToString();
Q0.Text = ppm.albumin_serum.ToString();
Q1.Text = ppm.albumin_serum.ToString();
Q2.Text = ppm.a_g.ToString();
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"]));
Label18.Text = Convert.ToString(pps.date);
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)
{
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
{
Session["print"] = null;
palm_doctor_employee pde = new palm_doctor_employee();
String dr = Session["ref_doctor"].ToString();
try
{
pde = rt.palm_doctor_employees.Single(palm_doctor_employee => palm_doctor_employee.emp_code == Session["ref_doctor"].ToString());
Session["ref_doctor"] = pde.doctor_name;
}
catch (Exception er)
{ Session["ref_doctor"] = dr; }
laqbel00.Text = Session["pateint_name"].ToString();
label3.Text = Session["ref_doctor"].ToString();
palm_pathology_rb ppm = new palm_pathology_rb();
String dr1 = Session["slave_id"].ToString();
ppm = rt.palm_pathology_rbs.Single(palm_pathology_rbs => palm_pathology_rbs.slave_id == Session["slave_id"].ToString());
// label300.Text = Convert.ToString(ppm.fbs);
// label301.Text = ppm.usfs.ToString();
// label302.Text = ppm.uafs.ToString();
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"]));
Label2.Text = Convert.ToString(pps.date);
// label305.Text = Convert.ToString(ppm.uapls);
// label304.Text = Convert.ToString(ppm.uspls);
// label303.Text = Convert.ToString(ppb.plbs);
label312.Text = Convert.ToString(ppb.rbs);
MultiView1.ActiveViewIndex = 1;
}
}
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 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)
{
Response.Redirect("~/home.aspx");
}
if (Session["print"] == null)
{
Label7.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());
Label2.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());
Label2.Text = ppp.ref_doc;
Session["ref_doctor"] = ppp.ref_doc;
}
Label1.Text = Session["pateint_name"].ToString();
Label2.Text = Session["ref_doctor"].ToString();
palm_pathology_lft ppm = new palm_pathology_lft();
ppm = rt.palm_pathology_lfts.Single(palm_pathology_lft => palm_pathology_lft.slave_id == Session["slave_id"].ToString());
label669.Text = ppm.bilirubin_total.ToString();
label666.Text = ppm.bilirubin_direct.ToString();
Label146.Text = ppm.bilirubin_indirect.ToString();
labell.Text = ppm.aspartate_amino_transferase.ToString();
Label149.Text = ppm.alanine_transaminase.ToString();
Label150.Text = ppm.alkaline_phosphatease.ToString();
Label151.Text = ppm.protine_toltal.ToString();
Label152.Text = ppm.albumin_serum.ToString();
Label153.Text = ppm.serum_globulin.ToString();
Label154.Text = ppm.albumin_serum.ToString();
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"]));
ARMY.Text = Convert.ToDateTime(pps.date).ToString("dd/MM/yyyy");
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)
{
Response.Redirect("~/home.aspx");
}
if (Session["emp_code"] == null)
{
Response.Redirect("~/pathology/pathology_home.aspx");
}
if (Session["print"] == null)
{
Label7.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());
Label235.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());
Label235.Text = ppp.ref_doc;
Session["ref_doctor"] = ppp.ref_doc;
}
Label231.Text = Session["pateint_name"].ToString();
Label235.Text = Session["ref_doctor"].ToString();
palm_opd_stool_routine ppm = new palm_opd_stool_routine();
ppm = rt.palm_opd_stool_routines.Single(palm_opd_stool_routine => palm_opd_stool_routine.slave_id == Session["slave_id"].ToString());
Label262.Text = ppm.colour.ToString();
Label263.Text = ppm.form_consistency.ToString();
Label264.Text = ppm.mucus.ToString();
Label265.Text = ppm.blood.ToString();
Label266.Text = ppm.parasites.ToString();
Label267.Text = ppm.reaction.ToString();
Label268.Text = ppm.occult_blood.ToString();
Label269.Text = ppm.reducing_substrains.ToString();
Label90.Text = ppm.red_blood_cells.ToString();
Label00.Text = ppm.pus_cells.ToString();
Label000.Text = ppm.epithelial_cells.ToString();
Label666.Text = ppm.macrophages.ToString();
Label0.Text = ppm.fat.ToString();
Label01.Text = ppm.starch.ToString();
Label02.Text = ppm.entamoeba_histolitical.ToString();
label66.Text = ppm.entamba_coli.ToString();
label69.Text = ppm.giardia_lambia.ToString();
Label001.Text = ppm.tricomonas_hominis.ToString();
Label280.Text = ppm.ova_cyst.ToString();
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"]));
Label1.Text = Convert.ToString(pps.date);
Session["print"] = null;
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;
}
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)
{
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());
Label168.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());
Label168.Text = ppp.ref_doc;
Session["ref_doctor"] = ppp.ref_doc;
}
Session["ref_doctor"] = pde.doctor_name;
Label164.Text = Session["pateint_name"].ToString();
// Label168.Text = Session["ref_doctor"].ToString();
palm_pathology_lp ppm = new palm_pathology_lp();
ppm = rt.palm_pathology_lps.Single(palm_pathology_lp => palm_pathology_lp.slave_id == Session["slave_id"].ToString());
Label200.Text = ppm.total_cholestrol.ToString();
Label201.Text = ppm.triglycerides.ToString();
Label202.Text = ppm.hdl_cholestrol.ToString();
Label203.Text = ppm.ldl_cholestrol.ToString();
Label204.Text = ppm.vldl_cholestrol.ToString();
Label205.Text = ppm.tc_hdl_cholestrol_ratio.ToString();
Label206.Text = ppm.ldl_hdl_ratio.ToString();
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"]));
Label166.Text = Convert.ToString(pps.date);
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)
{
Response.Redirect("~/home.aspx");
}
if (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());
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;
}
Label7.Text = Session["pateint_name"].ToString();
// Label8.Text = Session["ref_doctor"].ToString();
// Label11.Text = DateTime.Now.ToString();
}
else
{
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());
Label3.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());
Label3.Text = ppp.ref_doc;
Session["ref_doctor"] = ppp.ref_doc;
}
palm_pathology_urine_routine ppm = new palm_pathology_urine_routine();
ppm = rt.palm_pathology_urine_routines.Single(palm_pathology_urine_routine => palm_pathology_urine_routine.slave_id == Convert.ToInt32(Session["slave_id"]));
Label204.Text = ppm.quantity.ToString();
Label206.Text = ppm.colour.ToString();
Label207.Text = ppm.appearance.ToString();
Label208.Text = ppm.deposit.ToString();
Label209.Text = ppm.reaction.ToString();
Label210.Text = ppm.urine_albumin.ToString();
Label211.Text = ppm.urine_suger.ToString();
Label212.Text = ppm.ketones.ToString();
Label213.Text = ppm.blood_test.ToString();
Label214.Text = ppm.bile_salts.ToString();
Label228.Text = ppm.bile_pigements.ToString();
Label216.Text = ppm.red_blood_cells.ToString();
Label00.Text = ppm.pus_cells.ToString();
Label218.Text = ppm.epithelial_cells.ToString();
Label219.Text = ppm.casts.ToString();
Label220.Text = ppm.crystals.ToString();
Label221.Text = ppm.spermatozoa.ToString();
Label222.Text = ppm.trichomonas_vaginalis.ToString();
Label223.Text = ppm.yeast_cells.ToString();
Label224.Text = ppm.amorphous_deposits.ToString();
Label225.Text = ppm.bacteria.ToString();
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"]));
Label2.Text = Convert.ToString(pps.date);
MultiView1.ActiveViewIndex = 1;
}
}
