protected void Button2_Click2(object sender, EventArgs e)
{
DataClass.insertRecord("insert into insurance (in_name, co_id) values('" +
TextBox2.Text + "', " + DropDownList4.SelectedValue + ")");
Table1.Rows[8].Visible = false;
Response.Redirect(Request.RawUrl);
}
protected void Button4_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into reason_icuadmission (re_description) values('" +
reasonText.Text + "')");
Table2.Rows[3].Visible = false;
Response.Redirect(Request.RawUrl);
}
protected void addRecord(object sender, EventArgs e)
{
string j;
if (referDistrHosp.SelectedValue == "N")
{
j = "null";
}
else
{
j = distrHospitals.SelectedValue;
}
HttpCookie cookie = Request.Cookies["userInfo"];
string ee = DataClass.SelectRecord("select em_id from employee where em_login='******'", "em_id");
if (Request.RawUrl.Contains("field"))
{
DataClass.insertRecord(
"update patient set pa_fname='" + fname.Text + "', pa_lname='" + lname.Text + "', pa_mhr='" + mhr.Text + "', pa_gender='" + DropDownList5.SelectedValue +
"', pa_age=" + age.Text + ", pa_birth='" + birth.Text + "', pa__address='" + TextBox1.Text + "', pa_province=" + DropDownList6.SelectedValue +
", pa_district=" + DropDownList3.SelectedValue + " where pa_id=" + Convert.ToInt32(Request.QueryString["field1"]) + "");
DataClass.insertRecord(
"update hospital_admission set ho_id=" + Convert.ToInt32(hospitalBox.SelectedValue) + ", ha_icu_hdu=" + Convert.ToInt32(icuHdu.SelectedValue) + ", ha_date='" + adDate.Text + " " + adTime.Text +
"', ha_ICU_HDU_date='" + icuhdudatebox.Text + "', ha_type=" + Convert.ToInt32(DropDownList1.SelectedValue) +
", ha_ref_district_hospital='" + referDistrHosp.SelectedValue + "', ha_district_hospital=" + j + ", in_id=" + Convert.ToInt32(DropDownList2.SelectedValue) +
", ha_1sequence=" + Convert.ToInt32(ee) + " where ha_id=" + Convert.ToInt32(Request.QueryString["field2"]) + "");
}
else
{
if (GridView1.Rows.Count > 0)
{
s = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text);
DataClass.insertRecord(
"insert into hospital_admission (ho_id, pa_id, ha_icu_hdu, ha_date, ha_ICU_HDU_date, ha_type, ha_ref_district_hospital, ha_district_hospital, in_id, em_id, ha_patient_age, ha_1sequence) values("
+ Convert.ToInt32(hospitalBox.SelectedValue) + ", "
+ Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text) + ", " + Convert.ToInt32(icuHdu.SelectedValue) + ", '"
+ adDate.Text + " " + adTime.Text + "', '" + icuhdudatebox.Text + "', " + Convert.ToInt32(DropDownList1.SelectedValue) + ", '" + referDistrHosp.SelectedValue + "', " + j + ", " + Convert.ToInt32(DropDownList2.SelectedValue) + ", " + Convert.ToInt32(ee) + ", " + Convert.ToInt32(age.Text) + ", " + Convert.ToInt32(ee) + ")");
}
else
{
DataClass.insertRecord(
"insert into patient (pa_fname, pa_lname, pa_mhr, pa_gender, pa_age, pa_birth, pa__address, pa_province, pa_district) values('" +
fname.Text + "', '" + lname.Text + "', '" + mhr.Text + "', '" + DropDownList5.SelectedValue + "', " + age.Text + ", '" + birth.Text + "', '" + TextBox1.Text + "', " + Convert.ToInt32(DropDownList6.SelectedValue) + ", " + Convert.ToInt32(DropDownList3.SelectedValue) + ")");
s = Convert.ToInt32(DataClass.SelectRecord("select max(pa_id) as pa from patient", "pa"));
DataClass.insertRecord(
"insert into hospital_admission (ho_id, pa_id, ha_icu_hdu, ha_date, ha_ICU_HDU_date, ha_type, ha_ref_district_hospital, ha_district_hospital, in_id, em_id, ha_patient_age, ha_1sequence) values("
+ Convert.ToInt32(hospitalBox.SelectedValue) + ", " + s + ", " + Convert.ToInt32(icuHdu.SelectedValue) + ", '"
+ adDate.Text + " " + adTime.Text + "', '" + icuhdudatebox.Text + "', " + Convert.ToInt32(DropDownList1.SelectedValue) + ", '" + referDistrHosp.SelectedValue + "', " + j + ", " + Convert.ToInt32(DropDownList2.SelectedValue) + ", " + Convert.ToInt32(ee) + ", " + Convert.ToInt32(age.Text) + ", " + Convert.ToInt32(ee) + ")");
}
}
}
protected void addingRecord(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["userInfo"];
string ee = DataClass.SelectRecord("select em_id from employee where em_login='******'", "em_id");
DataClass.insertRecord("update hospital_admission set ha_sepsis_body_temp='" + bodytemp.SelectedValue +
"', ha_sepsis_hr='" + heartRateSep.SelectedValue +
"', ha_sepsis_resp_rate='" + respRateSep.SelectedValue +
"', ha_sepsis_wbc='" + wbcSep.SelectedValue +
"', ha_sepsis_infection='" + suspinfection.SelectedValue +
"', is_id=" + infection.SelectedValue +
", ha_3sequence=" + ee + " where ha_id=" + Convert.ToInt32(Request.QueryString["field2"]) + "");
}
protected void Button1_Click(object sender, EventArgs e)
{
if (Convert.ToInt16(DataClass.SelectRecord("SELECT EXISTS(SELECT * FROM employee WHERE em_login='******') as expr", "expr")) == 1)
{
Label1.Visible = true;
}
else
{
DataClass.insertRecord("insert into employee (em_fname, em_lname, em_login, em_pwd, jo_id, em_mobile, em_status, eg_id, hosp) values('" +
firstName.Text + "', '" + lastName.Text + "', '" + loginName.Text + "', '" + pwd.Text + "', " + DropDownList1.SelectedValue + ", '" +
mobile.Text + "', " + DropDownList3.SelectedValue + ", " + DropDownList2.SelectedValue + ", " + DropDownList4.SelectedValue + ")");
Response.Redirect("~/adminPanel.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int z; int r;
if (die.SelectedValue == "N" & referred.SelectedValue == "No")
{
z = 1;
}
else
{
z = 0;
}
if (referred.SelectedValue != "No")
{
r = 1;
}
else
{
r = 0;
}
HttpCookie cookie = Request.Cookies["userInfo"];
string ee = DataClass.SelectRecord("select em_id from employee where em_login='******'", "em_id");
DataClass.insertRecord("update hospital_admission set ha_interv_surgery='" +
surgery.SelectedValue + "', ha_interv_ventilation='" + ventilation.SelectedValue +
"', ha_interv_vasopressors='" + vasopressor.SelectedValue + "', ha_interv_inv_monitoring='" +
invmonitoring.SelectedValue + "', ha_interv_hemodyalis='" + hemodyalisis.SelectedValue +
"', ha_interv_tpn='" + tpn.SelectedValue + "', ha_qi_new_bed='" + newbed.SelectedValue +
"', ha_qi_have_bed='" + havebed.SelectedValue + "', ha_qi_fever='" + fever.SelectedValue +
"', ha_qi_culture='" + culture.SelectedValue + "', ha_dis_date='" + disDate.Text +
"', ha_dis_die='" + die.SelectedValue + "', ha_dis_referred='" + referred.SelectedValue +
"', ha_dis_diagnosis='" + diagnosis.Text + "', ha_4sequence=" + ee + ", ha_disch=" + z + ", ha_ref=" + r + " where ha_id=" +
Convert.ToInt32(Request.QueryString["field2"]) + "");
Response.Redirect("~/hospitalAdmission.aspx");
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into types (type) values('" + TextBox1.Text + "')");
Response.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into infection_site (is_desc) values('" + infsite.Text + "')");
Table1.Rows[6].Visible = false;
Response.Redirect(Request.RawUrl);
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into province (co_id, pr_name) values(1, '" + TextBox1.Text + "')");
}
protected void addRecording(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["userInfo"];
string ee = DataClass.SelectRecord("select em_id from employee where em_login='******'", "em_id");
string temperature; string heartr; string systol; string diasto; string resp; string oxy;
if (temperatureBox.Text.Length < 1)
{
temperature = "0";
}
else
{
temperature = temperatureBox.Text.Replace(',', '.');
}
if (heartRate.Text.Length < 1)
{
heartr = "0";
}
else
{
heartr = heartRate.Text.Replace(',', '.');
}
if (systolic.Text.Length < 1)
{
systol = "0";
}
else
{
systol = systolic.Text.Replace(',', '.');
}
if (diastolic.Text.Length < 1)
{
diasto = "0";
}
else
{
diasto = diastolic.Text.Replace(',', '.');
}
if (respRate.Text.Length < 1)
{
resp = "0";
}
else
{
resp = respRate.Text.Replace(',', '.');
}
if (oxigen.Text.Length < 1)
{
oxy = "0";
}
else
{
oxy = oxigen.Text.Replace(',', '.');
}
DataClass.insertRecord("update hospital_admission set be_id=" + Convert.ToInt32(befoicu.SelectedValue) +
", re_id=" + Convert.ToInt32(reason.SelectedValue) +
", ha_vitals_temp=" + temperature + ", ha_vitals_heartrate=" + heartr +
", ha_vitals_sys_bp=" + systol + ", ha_vitals_dia_bp=" + diasto +
", ha_vitals_rr=" + resp + ", ha_vitals_oxy_sat=" + oxy +
", ha_receiv_oxy='" + oxydrop.SelectedValue +
"', ha_receive_oxy_type='" + OxyVent.SelectedValue +
"', ha_gcs='" + glasgow.SelectedValue + "', ha_gcs_score = '" +
gcs.SelectedValue + "', ha_gsc_scoreT='" + gcst.SelectedValue +
"', ha_2sequence=" + ee + " where ha_id=" + Convert.ToInt32(Request.QueryString["field2"]) + "");
}
protected void Button3_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into before_icu (be_desc) values('" + beicutext.Text + "')");
Table2.Rows[1].Visible = false;
Response.Redirect(Request.RawUrl);
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into reason_icuadmission (re_description) values('" + TextBox1.Text + "')");
Response.Close();
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into insurance (in_name, co_id) values('" + TextBox1.Text + "', " + DropDownList1.SelectedValue + ")");
Response.Redirect(Request.RawUrl);
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into infection_site (is_desc) values('" + TextBox1.Text + "')");
ClientScript.RegisterStartupScript(typeof(Page), "closePage", "window.close();", true);
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into district (di_province, di_district) values(" + DropDownList2.SelectedValue + ", '" + distr.Text + "')");
Response.Redirect(Request.RawUrl);
}