protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
rm = rt.room_masters.Single(room_master => room_master.room_no == Convert.ToInt32(GridView2.SelectedRow.Cells[1].Text));
Response.Write("<script>alert('" + GridView2.SelectedRow.Cells[0] + "')</script>");
Session["room_no"] = GridView2.SelectedRow.Cells[1].Text;
Session["bed_no"] = GridView2.SelectedRow.Cells[0].Text;
Session["room_type"] = rm.room_type;
MultiView1.ActiveViewIndex = 1;
}
protected void Add_click(object sender, EventArgs e)
{
RoomClass rc = new RoomClass();
room_master r = new room_master();
r.roomtype = type_tb.Text;
r.roomcost = Int32.Parse(Cost_tb.Text);
rc.addRoom(r);
Response.Redirect("AdminViewRoom.aspx");
}
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) { }*/
}
public bool addRoom(room_master r)
{
dc.room_masters.InsertOnSubmit(r);
dc.SubmitChanges();
return(true);
}
