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(); }