private void button4_Click(object sender, EventArgs e)
{
Connection con = new Connection();
con.OpenConection();
string[] param_names = new string[] {
"@doc_code" // كود الدكتور فورن كي من الدكتور
, "@inventry_id " // كود الزياره من جدول الزياره
, "@follow_up_sheet_date " // تاريخ الروشته
, "@observer_doctor" // اسم الدكتور اللي كتب الروشته
, "@examination_notes" // الملاحظات الطبيه في الروشته
, "@medicin " // الادويه
, "@sol " // التحاليل
, "@investigation" // التشخيص // المنظار مش عارفه فين
, "@operations " // العمليات
, "@rays" // الاشعه
}; // الامراض الوراثسيه والعائليه للمريض
//@doc_code @age اسم الدكتور @name اسمالمريض @iventry id @date @present @past @family
string[] param_values = new string[] { textBox3.Text, textBox4.Text, dateTimePicker1.Value.ToString("yyyy-MM-dd"), comboBox7.SelectedItem.ToString(), textBox1.Text, listBox3.Items.ToString(), listBox4.Items.ToString(), listBox6.Items.ToString(), listBox5.Items.ToString(), listBox1.Items.ToString() };
SqlDbType[] param_types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_follow_up_sheet", param_names, param_values, param_types);
validation v = new validation();
}
private void textBox30_TextChanged(object sender, EventArgs e)
{
validation v = new validation();
v.stringvalidation(textBox30, "this value");
//
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
validation v = new validation();
v.numbervalidation(textBox3, "this value");
// textBox3.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
Connection con = new Connection();
con.OpenConection();
string[] param_names = new string[] {
"@doc_code"
, "@age" // دا اسم الدكتور بس مش عاوز اغير الاسم في الداتا بيز
, "@name"
, "@inventry_id"
, "@admission_Date" // تاريخ كتابة الحاله الصحيه للمريض
, "@present_history" // الحاله الصحيه الحاليه للمريض
, "@past_history " // التاريخ المرضي للمريض
, "@familay_history"
}; // الامراض الوراثسيه والعائليه للمريض
s = comboBox1.SelectedItem.ToString();
textBox6.Text = s;
//@doc_code @age اسم الدكتور @name اسمالمريض @iventry id @date @present @past @family
string[] param_values = new string[] { textBox3.Text, comboBox2.SelectedItem.ToString(), comboBox1.SelectedItem.ToString(), textBox2.Text, dateTimePicker1.Value.ToString("yyyy-MM-dd"), textBox4.Text, textBox5.Text, textBox6.Text };
SqlDbType[] param_types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_case_sheet", param_names, param_values, param_types);
validation v = new validation();
v.stringvalidation(textBox4, "this value ");
v.stringvalidation(textBox5, "this value ");
v.stringvalidation(textBox6, "this value ");
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
Connection con = new Connection();
con.OpenConection();
string[] param_names = new string[] {
"@intial_assesment_date"
, "@inventry_id"
, "@doc_code"
, "@weightt"
, "@head"
, "@lenght"
, "@abdominalc"
, "@void_urine "
, "@tempreture "
, "@heart_rate"
, "@respiratory"
, "@pass_stool"
, "@physical_examination_color"
, "@physical_examination_head"
, "@physical_examination_fontanels"
, "@physical_examination_eyes"
, "@physical_examination_ears"
, "@physical_examination_nose"
, "@physical_examination_mouth"
, "@physical_examination_neck"
, "@physical_examination_calavicles "
, "@physical_examination_breast "
, "@physical_examination_thorax "
, "@physical_examination_activity"
, "@physical_examination_heart "
, "@physical_examination_abdomen"
, "@physical_examination_liver "
, "@physical_examination_spleen "
, "@physical_examination_lungs "
, "@physical_examination_hernia "
, "@physical_examination_umbilicus "
, "@physical_examination_genitilia "
, "@physical_examination_anus "
, "@physical_examination_deformit"
, "@physical_examination_skin "
, "@physical_examination_extemities"
, "@physical_examination_solo_crease "
, "@physical_examination_reflexes "
, "@physical_examination_moro "
, "@physical_examination_grasp "
, "@physical_examination_light "
, "@physical_examination_glabellar"
, "@physical_examination_rooting "
, "@physical_examination_suckling "
, "@immpression_tatitional_age "
, "@immpression_weeks "
, "@immpression_provisional_diagnosis "
, "@immpression_date"
}; // الامراض الوراثسيه والعائليه للمريض
//@doc_code @age اسم الدكتور @name اسمالمريض @iventry id @date @present @past @family
string[] param_values = new string[]
{
dateTimePicker1.Value.ToString("yyyy-MM-dd"),
textBox45.Text, // "@initial_assessment_date" ,
textBox46.Text, // "@doc_code" , // weight ,
textBox15.Text, // head
textBox1.Text,
textBox14.Text, // length
textBox2.Text, // "@patient_id" ,
textBox7.Text, // "@general_apperance_age" ,
textBox8.Text, // "@general_apperance_conscious_level" ,
textBox3.Text, // "@general_apperance_glass_coma_score" ,
textBox4.Text, // "@general_apperance_h_r" ,
textBox6.Text, // "@general_apperance_r_r" ,
textBox5.Text, // "@general_apperance_tempreture" ,
textBox17.Text, // "@general_apperance_blood_pressure" ,
textBox16.Text, // "@general_apperance_color" ,
textBox11.Text, // "@general_apperance_turgor",
textBox9.Text, // "@general_apperance_eruption" ,
textBox10.Text, // "@head_neck_fascies" ,
textBox18.Text, // "@head_neck_eyes" ,
textBox12.Text, // "@head_neck_mouth_tongue" ,
textBox13.Text, // "@head_neck_pharynx" ,
textBox19.Text, // "@head_neck_lymph_nodes" ,
textBox40.Text, // "@head_neck_oters" ,
textBox29.Text, // "@heart_precordial_bulge" ,
textBox27.Text, // "@heart_apex_beat" ,
textBox28.Text, // "@heart_thrill",
textBox26.Text, // "@heart_heart_sound" ,
textBox24.Text, // "@heart_murmurs",
textBox25.Text, // "@heart_others" ,
textBox21.Text, // "@chest_shape" ,
textBox22.Text, // "@chest_movement" ,
textBox20.Text,
textBox23.Text, // "@chest_reactions" ,
textBox39.Text, // "@chest_air_entry" ,
textBox37.Text, // "@chest_breath_sounds" ,
textBox38.Text, // "@chest_adventure_sounds" ,
textBox36.Text, // "@abdomen_liver",
textBox34.Text, // "@abdomen_spleen" ,
textBox35.Text, // "@abdomen_kidneys" ,
textBox33.Text, // "@abdomen_ascites" ,
textBox31.Text, // "@abdomen_others" ,
textBox32.Text, // "@back_spine_deformity" ,
textBox30.Text, // "@back_spine_sweling" ,
textBox43.Text, // "@neurological_examination_mentality" ,
textBox44.Text,
textBox42.Text,
textBox41.Text,
dateTimePicker2.Value.ToString("yyyy-MM-dd")
// "@neurological_examination_cranial_nerves"
};
SqlDbType[] param_types = new SqlDbType[]
{
SqlDbType.Date,
SqlDbType.Int,
SqlDbType.VarChar,
SqlDbType.Float,
SqlDbType.VarChar,
SqlDbType.Float,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.Float,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.Date
};
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_initial_assessment", param_names, param_values, param_types);
validation v = new validation();
v.numbervalidation(textBox15, "this value");
v.numbervalidation(textBox8, "this value");
v.numbervalidation(textBox1, "this value");
v.numbervalidation(textBox3, "this value");
v.numbervalidation(textBox6, "this value");
v.numbervalidation(textBox14, "this value");
v.numbervalidation(textBox4, "this value");
v.numbervalidation(textBox2, "this value");
v.numbervalidation(textBox6, "this value");
v.numbervalidation(textBox7, "this value");
v.stringvalidation(textBox5, "this value");
v.stringvalidation(textBox17, "this value");
v.stringvalidation(textBox16, "this value");
v.stringvalidation(textBox11, "this value");
v.stringvalidation(textBox9, "this value");
v.stringvalidation(textBox10, "this value");
v.stringvalidation(textBox18, "this value");
v.stringvalidation(textBox12, "this value");
v.stringvalidation(textBox13, "this value");
v.stringvalidation(textBox19, "this value");
v.stringvalidation(textBox40, "this value");
v.stringvalidation(textBox23, "this value");
v.stringvalidation(textBox20, "this value");
v.stringvalidation(textBox22, "this value");
v.stringvalidation(textBox21, "this value");
v.stringvalidation(textBox25, "this value");
v.stringvalidation(textBox24, "this value");
v.stringvalidation(textBox23, "this value");
v.stringvalidation(textBox24, "this value");
v.stringvalidation(textBox27, "this value");
v.stringvalidation(textBox28, "this value");
v.stringvalidation(textBox29, "this value");
v.stringvalidation(textBox30, "this value");
v.stringvalidation(textBox31, "this value");
v.stringvalidation(textBox32, "this value");
v.stringvalidation(textBox33, "this value");
v.stringvalidation(textBox34, "this value");
v.stringvalidation(textBox35, "this value");
v.stringvalidation(textBox36, "this value");
v.stringvalidation(textBox37, "this value");
v.stringvalidation(textBox38, "this value");
v.stringvalidation(textBox39, "this value");
v.stringvalidation(textBox40, "this value");
v.stringvalidation(textBox41, "this value");
v.stringvalidation(textBox42, "this value");
v.stringvalidation(textBox43, "this value");
v.stringvalidation(textBox44, "this value");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = "";
textBox19.Text = "";
textBox20.Text = "";
textBox21.Text = "";
textBox22.Text = "";
textBox23.Text = "";
textBox24.Text = "";
textBox25.Text = "";
textBox26.Text = "";
textBox27.Text = "";
textBox28.Text = "";
textBox29.Text = "";
textBox30.Text = "";
textBox31.Text = "";
textBox32.Text = "";
textBox33.Text = "";
textBox34.Text = "";
textBox35.Text = "";
textBox36.Text = "";
textBox37.Text = "";
textBox38.Text = "";
textBox39.Text = "";
textBox40.Text = "";
textBox41.Text = "";
textBox42.Text = "";
textBox43.Text = "";
textBox44.Text = "";
}
private void button1_Click(object sender, EventArgs e)
{
Connection con = new Connection();
con.OpenConection();
string[] param_names = new string[] {
"@doc_code"
, "@inventry_id "
, "@examination "
, "@examination_weight "
, "@examination_cosiciouslevl "
, "@vitalsign_hr "
, "@vitalsign_rr "
, "@vitalsign_tempreture "
, "@vitalsign_blood_pressure "
, "@progress_note_date "
, "@head_neck "
, "@chest "
, "@heart "
, "@abdomen"
, "@upper_and_lower_limbs "
, "@current_medicine "
, "@observer_doctor "
}; // الامراض الوراثسيه والعائليه للمريض
// @doc_code1 @iventry id2 @examonation3 @weight4 @cosiciouslevl5 @hr 6 @rr 7 @tempreture 8 @blood pressure 9 @date10 @head_neck11 @chest 12 @heart13 @abdomen 14 @limbs15 @current_medicine16 @DOCTOR17
string[] param_values = new string[] { textBox16.Text, textBox17.Text, textBox1.Text, textBox6.Text, textBox8.Text, textBox2.Text, textBox5.Text, textBox3.Text, textBox4.Text, dateTimePicker1.Value.ToString("yyyy-MM-dd"), textBox9.Text, textBox10.Text, textBox11.Text, textBox12.Text, textBox13.Text, textBox14.Text, comboBox2.SelectedItem.ToString() };
SqlDbType[] param_types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_progress_notes", param_names, param_values, param_types);
validation v = new validation();
v.stringvalidation(textBox1, "this value ");
v.numbervalidation(textBox2, "this value");
v.numbervalidation(textBox3, "this value");
v.numbervalidation(textBox4, "this value");
v.numbervalidation(textBox5, "this value");
v.numbervalidation(textBox6, "this value");
v.numbervalidation(textBox8, "this value");
v.stringvalidation(textBox9, "this value");
v.stringvalidation(textBox10, "this value");
v.stringvalidation(textBox11, "this value");
v.stringvalidation(textBox12, "this value");
v.stringvalidation(textBox14, "this value");
v.stringvalidation(textBox13, "this value");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox13.Text = "";
textBox14.Text = "";
}