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;
}
