private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
// con.Open();
con.OpenConection();
try
{
string[] f = new string[] { "@d1", "@d2", "@d", "@v" };
string[] f2 = new string[] { dateTimePicker1.Text, dateTimePicker3.Text, textBox10.Text, textBox18.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("emergency_open_visit2_saves", f, f2, f3))
{
MessageBox.Show(" لم يتم فتح زيارة لهذا المريض من قبل");
return;
}
//string s = "update entranceoffice_visits set entrance_date=@d1,expected_exit_date=@d2,type_of_visit=@v where pat_id=@id;";
//cmd = new MySqlCommand(s, con);
//cmd.Parameters.AddWithValue("@d1", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@d2", dateTimePicker3.Text);
//cmd.Parameters.AddWithValue("@v", textBox18.Text);
//cmd.Parameters.AddWithValue("@id", textBox10.Text);
//cmd.ExecuteNonQuery();
MessageBox.Show("تم تاكيد فتح زيارة خارجى للمريض");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
con.CloseConnection();
}
private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
con.OpenConection();
int pid = 0;
string s = "";
DateTime d = DateTime.Now;
string dat = d.ToString("yyyy/MM/dd");
// cmd1 = new MySqlCommand();
for (int i = 0; i < dataGridView1.Rows.Count; ++i)
{
DataGridViewRow row = dataGridView1.Rows[i];
try
{
if ((bool)row.Cells[0].EditedFormattedValue == true)
{
pid = int.Parse(row.Cells[1].Value.ToString());
string[] f = new string[] { "@d2", "@id" };
string[] f2 = new string[] { dat, pid.ToString() };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("finish_patient_visit_save", f, f2, f3))
{
MessageBox.Show("لم يتم انهاء الزياره");
return;
}
//string s = "update entranceoffice_visits set entrance_date=@d1,expected_exit_date=@d2,type_of_visit=@v where pat_id=@id;";
//cmd = new MySqlCommand(s, con);
//cmd.Parameters.AddWithValue("@d1", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@d2", dateTimePicker3.Text);
//cmd.Parameters.AddWithValue("@v", textBox18.Text);
//cmd.Parameters.AddWithValue("@id", textBox10.Text);
//cmd.ExecuteNonQuery();
//MessageBox.Show("تم تاكيد فتح زيارة خارجى للمريض");
//s = "update entranceoffice_visits set expected_exit_date=@d2 where pat_id =@id ";
//cmd1 = new MySqlCommand(s, con);
//// cmd1.Parameters.AddWithValue("@d1",dateTimePicker1.Text);
//cmd1.Parameters.AddWithValue("@d2", dat);
//cmd1.Parameters.AddWithValue("@id", pid);
//cmd1.ExecuteNonQuery();
MessageBox.Show("تم انهاء زيارة المريض");
}
}
catch (Exception)
{
}
}
con.CloseConnection();
}
private void button4_Click(object sender, EventArgs e)
{
// con.Open();
con.OpenConection();
try
{
if (textBox1.Text != "" && textBox2.Text != "" && textBox3.Text != "" && comboBox1.Text != "" && textBox4.Text != "")
{
//string s1 = "insert into emergency_ambulance_management values(@d1,@d2,@d3,@d4,@d5);";
//cmd1 = new MySqlCommand(s1, con);
//cmd1.Parameters.AddWithValue("@d1", textBox1.Text);
//cmd1.Parameters.AddWithValue("@d2", textBox2.Text);
//cmd1.Parameters.AddWithValue("@d3", textBox3.Text);
//cmd1.Parameters.AddWithValue("@d4", comboBox1.SelectedItem);
//cmd1.Parameters.AddWithValue("@d5", textBox4.Text);
//cmd1.ExecuteNonQuery();
string[] f = new string[] { "@d1", "@d2", "@d3", "@d4", "@d5" };
string[] f2 = new string[] { textBox1.Text, textBox2.Text, textBox3.Text, textBox4.Text, comboBox1.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("adds_emmergency_cars", f, f2, f3))
{
MessageBox.Show("تم اضافة هذه السيارة من قبل");
return;
}
MessageBox.Show("تمت الاضافه بنجاح");
}
else
{
MessageBox.Show("قم بادخال البيانات كامله");
}
}
catch (Exception)
{
MessageBox.Show("تم اضافة هذه السيارة من قبل");
}
con.CloseConnection();
}
private void حفظToolStripMenuItem_Click_1(object sender, EventArgs e)
{
// con.OpenConection();
string[] pName = { "@arName", "@enname" };
string[] Pvalues = { dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[0].Value.ToString(),
dataGridView1.Rows[dataGridView1.Rows.Count - 2].Cells[1].Value.ToString() };
SqlDbType[] Ptype = { SqlDbType.VarChar, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("rewrite_accident2", pName, Pvalues, Ptype))
{
MessageBox.Show("does not update");
return;
}
MessageBox.Show("updated");
con.CloseConnection();
}
private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
con.OpenConection();
try
{
string[] f = new string[] { "@v1", "@v2", "@v3", "@v4" };
string[] f2 = new string[] { textBox3.Text, textBox2.Text, textBox15.Text, textBox1.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("adds_ser_to_emer_patient", f, f2, f3))
{
MessageBox.Show("تمت اضافة هذه الخدمة من قبل ");
return;
}
//string s5 = "insert into emergency_cases_services(serv_co,serv_nam,pati_code,arriv_dat)"
// + "values(@v1,@v2,@v3,@v4)";
//cmd = new MySqlCommand(s5, con);
//cmd.Parameters.AddWithValue("@v1", int.Parse(textBox3.Text));
//cmd.Parameters.AddWithValue("@v2", textBox2.Text);
//cmd.Parameters.AddWithValue("@v3", int.Parse(textBox15.Text));
//cmd.Parameters.AddWithValue("@v4", textBox1.Text);
//cmd.ExecuteNonQuery();
MessageBox.Show("تم الحفظ");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
con.CloseConnection();
}
private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
con.OpenConection();
try
{
if (textBox3.Text != "" && textBox1.Text != "" && comboBox1.Text != "")
{
string[] f = new string[] { "@c", "@n", "@t" };
string[] f2 = new string[] { textBox3.Text, textBox1.Text, comboBox1.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("adds_emergency_services", f, f2, f3))
{
MessageBox.Show("تمت اضافة هذه الخدمة من قبل ");
return;
}
//string s = "insert into emergency_emergency_services values(@c,@n,@t);";
//cmd = new MySqlCommand(s, con);
//cmd.Parameters.AddWithValue("@c", textBox3.Text);
//cmd.Parameters.AddWithValue("@n", textBox1.Text);
//cmd.Parameters.AddWithValue("@t", comboBox1.SelectedItem);
//cmd.ExecuteNonQuery();
MessageBox.Show("تمت الاضافة بنجاح");
}
else
{
MessageBox.Show("قم باكمال البيانات");
}
}
catch (Exception)
{
MessageBox.Show("تمت اضافة هذه الخدمة من قبل");
}
con.CloseConnection();
}
private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
con.OpenConection();
try
{
// con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc();
//string s1 = "yes";
//string s2 = "no";
if (textBox10.Text != "" && textBox15.Text != "" && comboBox1.Text != "")
{
string[] f = new string[] { "@d1", "@d2", "@d3", "@d4", "@d5", "@d6", "@d7", "@d8", "@d9" };
string[] f2 = new string[] { textBox1.Text, textBox10.Text, dateTimePicker2.Text, textBox18.Text, comboBox1.Text,
comboBox3.Text, comboBox4.Text, comboBox2.Text, textBox3.Text, comboBox3.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("blocks_Casess_Accidents1", f, f2, f3))
{
MessageBox.Show("تمت اضافة هذا المريض في هذا اليوم ");
return;
}
//string s3 = "insert into emergency_cases_accident_emergency"
// + "(patients_id,account_number,accident_date,arrival_date,accident_kind,told_police,told_family,required_Told_police,telephone_number)"
// + "values(@d1,@d2,@d3,@d4,@d5,@d6,@d7,@d8,@d9)";
//cmd = new MySqlCommand(s3, con);
//cmd.Prepare();
//cmd.Parameters.AddWithValue("@d1", textBox1.Text);
//cmd.Parameters.AddWithValue("@d2", textBox10.Text);
//cmd.Parameters.AddWithValue("@d3", dateTimePicker2.Text);
//cmd.Parameters.AddWithValue("@d4", textBox18.Text);
//cmd.Parameters.AddWithValue("@d5", comboBox1.SelectedItem);
//cmd.Parameters.AddWithValue("@d6", comboBox3.SelectedItem);
//cmd.Parameters.AddWithValue("@d7", comboBox4.SelectedItem);
//cmd.Parameters.AddWithValue("@d8", comboBox2.SelectedItem);
//cmd.Parameters.AddWithValue("@d9", textBox3.Text);
//cmd.Parameters.AddWithValue("@d6",comboBox3.SelectedItem);
//cmd.ExecuteNonQuery();
//string s4 = "insert into emergency_cases_doctors(doctor_ode, per,ar_day,pati_code,arriv_dat)"
// + "values(@x1,@x2,@x3,@x4,@x5)";
//cmd1 = new MySqlCommand(s4, con);
//cmd1.Parameters.AddWithValue("@x1", doc_code);
//cmd1.Parameters.AddWithValue("@x2", period);
//cmd1.Parameters.AddWithValue("@x3", day_name);
//cmd1.Parameters.AddWithValue("@x4", textBox1.Text);
//cmd1.Parameters.AddWithValue("@x5", textBox18.Text);
//cmd1.ExecuteNonQuery();
/*string s5 = "insert into emergency_cases_services(serv_co,serv_nam,pati_code,arriv_dat)"
+ "values(@v1,@v2,@v3,@v4)";
+
+
+ cmd2 = new MySqlCommand(s5, con);
+ cmd2.Parameters.AddWithValue("@v1", cod_serv);
+ cmd2.Parameters.AddWithValue("@v2", textBox16.Text);
+ cmd2.Parameters.AddWithValue("@v3", textBox1.Text);
+ cmd2.Parameters.AddWithValue("@v4", textBox18.Text);
*
*
* cmd2.ExecuteNonQuery();
*/
/*
* string name = "Qname"
* string[] s = { "@x1", "@x2", "@x3", "@x4","@x5" };
* string[] s2 = {doc_code, period, day_name, textBox1.Text,textBox18.Text};
* SqlDbType[] s3 = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
*
* dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc(name, s, s2, s3);
* //for textBox dt = (DataTable) con.ShowDataInGridViewUsingStoredProc(name, s, s2, s3);
* con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc(name, s, s2, s3);
*
*/
string[] s = { "@x1", "@x2", "@x3", "@x4", "@x5" };
string[] s2 = { doc_code, period, day_name, textBox1.Text, textBox18.Text };
SqlDbType[] s3 = { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("blocks_casesses2_Acciden2", s, s2, s3))
{
// MessageBox.Show("تمت اضافة هذا المريض في هذا اليوم ");
return;
}
int pati_id = int.Parse(textBox1.Text);
string n = textBox2.Text;
int age = int.Parse(textBox5.Text);
int code_dir = int.Parse(textBox12.Text);
string dircto = textBox11.Text;
تاكيد_فتح_زياره_خارجي fr = new تاكيد_فتح_زياره_خارجي(pati_id, n, age, code_dir, dircto);
string[] m = { "@d" };
string[] m2 = { textBox1.Text };
SqlDbType[] m3 = { SqlDbType.Int };
if (-1 == con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc2("emergency_open_visit", m, m2, m3))
{
MessageBox.Show("قم بتسجيل زيارة للمريض اولا ");
return;
}
fr.Show();
}
else
{
MessageBox.Show("قم بادخال البيانات كاملة");
}
}
catch (Exception) {
MessageBox.Show("تمت اضافة هذا المريض في هذا اليوم ");
}
con.CloseConnection();
}
