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 Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into province (co_id, pr_name) values(1, '" + TextBox1.Text + "')");
}
protected void Button1_Click(object sender, EventArgs e)
{
DataClass.insertRecord("insert into reason_icuadmission (re_description) values('" + TextBox1.Text + "')");
Response.Close();
}
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 insurance (in_name, co_id) values('" + TextBox1.Text + "', " + DropDownList1.SelectedValue + ")");
Response.Redirect(Request.RawUrl);
}
protected void Button1_Click(object sender, EventArgs e)
{
string i = DataClass.SelectRecord("select pa_id from hospital_admission where ha_id=" + GridView1.SelectedRow.Cells[1].Text + "", "pa_id");
Response.Redirect("~/PatientInformation.aspx?pp=" + i + "&hh=" + GridView1.SelectedRow.Cells[1].Text + "");
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["userInfo"];
if (cookie != null)
{
if (Convert.ToInt32(cookie["group"]) > 4)
{
Response.Redirect("~/Default.aspx");
}
}
else
{
Response.Redirect("~/Default.aspx");
}
int x = Convert.ToInt16(cookie["group"]);
int j = Convert.ToInt16(cookie["hosp"]);
if (x > 1)
{
SqlDataSource1.FilterExpression = "ho_id = " + j + "";
}
if (referDistrHosp.SelectedValue == "Y")
{
distrHospitals.Visible = true;
}
else
{
distrHospitals.Visible = false;
}
//this.adDate.Text = DateTime.Today.ToString("MM/dd/yyyy");
adDate.Text = System.DateTime.Today.ToString("yyyy-MM-dd");
adTime.Text = DateTime.Now.ToString("HH:mm");
icuhdudatebox.Text = System.DateTime.Today.ToString("yyyy-MM-dd");
if (!IsPostBack)
{
SqlDataSource5.FilterExpression = "pa_lname like 'cccccccccccccccccccccc'";
SqlDataSource5.FilterExpression = "pa_mhr like 'ccccccccccccc'";
}
//birth.Text = Server.HtmlEncode("" + (Convert.ToInt16(DateTime.Now.Year) - Convert.ToInt16(age.Text)).ToString() + "-01-01");
try
{
int pid = Convert.ToInt32(Request.QueryString["field1"]);
int hid = Convert.ToInt32(Request.QueryString["field2"]);
if (Request.QueryString["field1"].Length > 0)
{
SqlDataSource5.FilterExpression = "pa_id=" + pid + "";
fname.Text = DataClass.SelectRecord("select pa_fname from patient where pa_id=" + pid + "", "pa_fname");
lname.Text = DataClass.SelectRecord("select pa_lname from patient where pa_id=" + pid + "", "pa_lname");
mhr.Text = DataClass.SelectRecord("select pa_mhr from patient where pa_id=" + pid + "", "pa_mhr");
DropDownList5.SelectedValue = DataClass.SelectRecord("select pa_gender from patient where pa_id=" + pid + "", "pa_gender");
age.Text = DataClass.SelectRecord("select pa_age from patient where pa_id=" + pid + "", "pa_age");
birth.Text = Convert.ToDateTime(DataClass.SelectRecord("select pa_birth from patient where pa_id=" + pid + "", "pa_birth")).ToString("yyyy-MM-dd");
TextBox1.Text = DataClass.SelectRecord("select pa__address from patient where pa_id=" + pid + "", "pa__address");
DropDownList6.SelectedValue = DataClass.SelectRecord("select pa_province from patient where pa_id=" + pid + "", "pa_province");
DropDownList3.SelectedValue = DataClass.SelectRecord("select pa_district from patient where pa_id=" + pid + "", "pa_district");
hospitalBox.SelectedValue = DataClass.SelectRecord("select ho_id from hospital_admission where ha_id=" + hid + "", "ho_id");
icuHdu.SelectedValue = DataClass.SelectRecord("select ha_icu_hdu from hospital_admission where ha_id=" + hid + "", "ha_icu_hdu");
adDate.Text = Convert.ToDateTime(DataClass.SelectRecord("select ha_date from hospital_admission where ha_id=" + hid + "", "ha_date")).ToString("yyyy-MM-dd");
adTime.Text = Convert.ToDateTime(DataClass.SelectRecord("select ha_date from hospital_admission where ha_id=" + hid + "", "ha_date")).ToString("HH:mm");
icuhdudatebox.Text = Convert.ToDateTime(DataClass.SelectRecord("select ha_ICU_HDU_date from hospital_admission where ha_id=" + hid + "", "ha_ICU_HDU_date")).ToString("yyyy-MM-dd");
DropDownList1.SelectedValue = DataClass.SelectRecord("select ha_type from hospital_admission where ha_id=" + hid + "", "ha_type");
//if (referDistrHosp.AutoPostBack) { }
//else
//{
if (!IsPostBack)
{
if (DataClass.SelectRecord("select ha_ref_district_hospital from hospital_admission where ha_id=" + hid + "", "ha_ref_district_hospital") == "Y")
{
referDistrHosp.SelectedValue = DataClass.SelectRecord("select ha_ref_district_hospital from hospital_admission where ha_id=" + hid + "", "ha_ref_district_hospital");
distrHospitals.Visible = true;
distrHospitals.SelectedValue = DataClass.SelectRecord("select ha_district_hospital from hospital_admission where ha_id=" + hid + "", "ha_district_hospital");
}
else
{
distrHospitals.Visible = false;
}
}
}
DropDownList2.SelectedValue = DataClass.SelectRecord("select in_id from hospital_admission where ha_id=" + hid + "", "in_id");
//}
//else { }
}
catch (NullReferenceException) { }
}
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);
}