private void button1_Click(object sender, EventArgs e) { try { con1.OpenConection(); if (textBox1.Text == "") { MessageBox.Show(" ادخل اسم الدكتور المسئول عن الالغاء"); } else { //create procedure select_doc_details(@d nvarchar(50),@s nvarchar(50),@endo nvarchar(50)) // as // delete from doctor_operation where op_id in(select id from setescope_operation where start_time=@s and Datee=@d and EndoscopeCode in(select EndoscopeCode from Endoscope_settings_data where EndoscopeName=@endo)) //peration where id_op in(select id from setescope_operation where start_time=@s and Datee=@d and EndoscopeCode in(select EndoscopeCode from Endoscope_settings_data where EndoscopeName=@endo)) //cmd = new SqlCommand("select_doc_details", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@d", الصفحه_الرئيسيه_للمنظار.d); //cmd.Parameters.AddWithValue("@s", الصفحه_الرئيسيه_للمنظار.start); //cmd.Parameters.AddWithValue("@endo", الصفحه_الرئيسيه_للمنظار.endo); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@d", "@s", "@endo" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.d, الصفحه_الرئيسيه_للمنظار.start, الصفحه_الرئيسيه_للمنظار.endo }; con1.ExecuteNonQueryProcedure("select_doc_details", name_input, values, types); // create procedure select_delete_setescope(@d nvarchar(50),@s nvarchar(50),@id int) //as //delete from setescope_operation where id=@id and Datee=@d and start_time=@s //cmd = new SqlCommand("select_delete_setescope", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@d", الصفحه_الرئيسيه_للمنظار.d); //cmd.Parameters.AddWithValue("@s", الصفحه_الرئيسيه_للمنظار.start); //cmd.Parameters.AddWithValue("@id", الصفحه_الرئيسيه_للمنظار.opid); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int }; name_input = new string[] { "@d", "@s", "@id" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.d, الصفحه_الرئيسيه_للمنظار.start, الصفحه_الرئيسيه_للمنظار.opid }; con1.ExecuteNonQueryProcedure("select_delete_setescope", name_input, values, types); this.Close(); MessageBox.Show("لقد تم الغاء الحجز "); } } catch (Exception c) { MessageBox.Show(c.Message); } finally { con1.CloseConnection(); } }
private void button1_Click_1(object sender, EventArgs e) { try { end = textBox2.Text; con1.OpenConection(); //create procedure setescope_flag_finish(@end nvarchar(50),@d nvarchar(50),@s nvarchar(50),@id int) //as //update setescope_operation set flag='finish',end_time=@end where Datee =@d and start_time=@s and id=@id types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int }; name_input = new string[] { "@end", "@d", "@s", "@id" }; values = new string[] { end, الصفحه_الرئيسيه_للمنظار.d, الصفحه_الرئيسيه_للمنظار.start, الصفحه_الرئيسيه_للمنظار.opid }; con1.ExecuteNonQueryProcedure("setescope_flag_finish", name_input, values, types); الصفحه_الرئيسيه_للمنظار.flag = "finish"; الصفحه_الرئيسيه_للمنظار ff6 = new الصفحه_الرئيسيه_للمنظار(); ff6.Focus(); this.DialogResult = DialogResult.OK; ff6.Focus(); } catch (Exception v) { MessageBox.Show(v.Message); } finally { con1.CloseConnection(); } }
private void button1_Click(object sender, EventArgs e) { string g_n = الجهه_الخاص_بالمريض_الخارجى.v1; string g_f_n = الجهه_الخاص_بالمريض_الخارجى.x3; string f = الجهه_الخاص_بالمريض_الخارجى.x5; int p_id = int.Parse(محرك_البحث1.xx1); // SqlCommand cmd = new SqlCommand("update patient set Institution='" + g_n + "',sub_Institution='" + g_f_n + "',family='" + f + "' where patient_id=" + p_id + " ", con); //SqlCommand cmd = new SqlCommand("clinic_update_p_family", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@g_n", g_n); //cmd.Parameters.AddWithValue("@g_f_n", g_f_n); //cmd.Parameters.AddWithValue("@f", f); //cmd.Parameters.AddWithValue("@p_id", p_id); //cmd.ExecuteNonQuery(); //create procedure clinic_update_p_family(@g_n int,@g_f_n int,@f nvarchar(10),@p_id int) //as //update Registeration_patientRegisteration set catogrical_code=@g_n,sub_Institution=@g_f_n,family=@f where patient_id=@p_id ; con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.Int }; name_input = new string[] { "@g_n", "@g_f_n", "@f", "@p_id" }; values = new string[] { g_n, g_f_n, f, p_id.ToString() }; con1.ExecuteNonQueryProcedure("clinic_update_p_family", name_input, values, types); con1.CloseConnection(); this.Close(); }
private void button2_Click(object sender, EventArgs e) { //cmd = new SqlCommand("update patient_visit set service_name="+service+" where num_of_visit=" + count + " and p_id=select patient_id from patient where fname=" + p_name + "and lname= " + p_name2 + " ", con); //con1.ExecuteQueries("update patient_visit set service_name="+service+" where num_of_visit=" + count + " and p_id=select patient_id from patient where fname=" + p_name + "and lname= " + p_name2 ); //create procedure update_service_to_patient(@ser nvarchar(60),@count int,@name varchar(50)) // as // begin // update entranceoffice_visit set service_name=N'%'+@ser+'%' where visit_id=@count and pat_id=(select patient_id from Registeration_patientRegisteration where patient_name like N'%' + @name +'%') // end string f_name = p_name + "" + p_name2; con1.OpenConection(); name_input = new string[] { "@ser", "@count", "@name" }; types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.VarChar }; values = new string[] { service, Convert.ToString(count), f_name }; con1.ExecuteNonQueryProcedure("update_service_to_patient", name_input, values, types); try { // cmd.ExecuteNonQuery(); MessageBox.Show("تم اضافه الخدمه "); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { con1.CloseConnection(); } }
private void button2_Click(object sender, EventArgs e) { try { t1 = textBox2.Text; t2 = textBox1.Text; الصفحه_الرئيسيه_للمنظار f = new الصفحه_الرئيسيه_للمنظار(); con1.OpenConection(); //create procedure update_time(@s nvarchar(50),@end nvarchar(50) ,@d nvarchar(50),@ss nvarchar(50),@n nvarchar(50)) // as // update setescope_operation set start_time=@s,end_time=@end where Datee=@d and start_time=@ss and EndoscopeCode // in(select EndoscopeCode from Endoscope_settings_data where EndoscopeName=@n ); //cmd = new SqlCommand("update_time", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@end", t2); //cmd.Parameters.AddWithValue("@d", الصفحه_الرئيسيه_للمنظار.d); //cmd.Parameters.AddWithValue("@s", t1); //cmd.Parameters.AddWithValue("@ss", الصفحه_الرئيسيه_للمنظار.start); //cmd.Parameters.AddWithValue("@n", الصفحه_الرئيسيه_للمنظار.endo); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@end", "@d", "@s", "@ss", "@n" }; values = new string[] { t2, الصفحه_الرئيسيه_للمنظار.d, t1, الصفحه_الرئيسيه_للمنظار.start, الصفحه_الرئيسيه_للمنظار.endo }; con1.ExecuteNonQueryProcedure("update_time", name_input, values, types); الصفحه_الرئيسيه_للمنظار ff6 = new الصفحه_الرئيسيه_للمنظار(); ff6.Focus(); this.DialogResult = DialogResult.OK; ff6.Focus(); } catch (Exception v) { MessageBox.Show(v.Message); } finally { con1.CloseConnection(); } }
private void حفظToolStripMenuItem_Click(object sender, EventArgs e) { try { //create PROCEDURE setescope_rooms_update_inventory_and_dep (@code1 int,@code2 int,@roomcode int) // as // begin // update Endoscope_room set code1 =@code1 , code2 =@code2 where RoomCode= @roomcode // end con1.OpenConection(); // cmd = new SqlCommand("update Endoscope_room set code1 = " + Convert.ToInt32(textBox6.Text) + ", code2 = " + Convert.ToInt32(textBox8.Text) + " where RoomCode=" + code + ";", con); //cmd = new SqlCommand("setescope_rooms_update_inventory_and_dep", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@roomcode", Convert.ToInt32(code)); //cmd.Parameters.AddWithValue("@code2", Convert.ToInt32(textBox6.Text)); //cmd.Parameters.AddWithValue("@code1", Convert.ToInt32(textBox8.Text)); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@roomcode", "@code2", "@code1" }; values = new string[] { Convert.ToString(code), textBox6.Text, textBox8.Text }; con1.ExecuteNonQueryProcedure("setescope_rooms_update_inventory_and_dep", name_input, values, types); MessageBox.Show("تم الحفظ"); con1.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//////////////////////////////////save///////////////////////////// private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (dateTimePicker2.Value.Date >= dateTimePicker1.Value.Date) { if (tableLayoutPanel1.RowCount > 1) { l1.Add(t1.Text); l1.Add(dtp1.Value.ToString()); l1.Add(dtp2.Value.ToString()); } if (l1.Count == 0) { l1.Add(textBox1.Text); l1.Add(dateTimePicker1.Value.ToString()); l1.Add(dateTimePicker2.Value.ToString()); } for (int i = 0; i < l1.Count; i += 3) { /* * * create procedure clinic_اعداد_عطلات_العيادات_clinic_rest_insert(@c nvarchar(50),@s_time nvarchar(100),@e_time nvarchar(100)) * as * begin * insert into clinic_rest values(@c,@s_time,@e_time) * end * * */ //con.Open(); //cmd.Connection = con; ////cmd.CommandText = "insert into clinic_rest values('" + l1[i] + "','" + l1[i + 1] + "','" + l1[i + 2] + "')"; //cmd.CommandText = "clinic_اعداد_عطلات_العيادات_clinic_rest_insert"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@c",l1[i]); //cmd.Parameters.AddWithValue("@s_time", l1[i + 1]); //cmd.Parameters.AddWithValue("e_time",l1[i + 2]); //cmd.ExecuteNonQuery(); //con.Close(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@c", "@s_time", "@e_time" }; values = new string[] { l1[i], l1[i + 1], l1[i + 2] }; con1.ExecuteNonQueryProcedure("clinic_اعداد_عطلات_العيادات_clinic_rest_insert", name_input, values, types); con1.CloseConnection(); } MessageBox.Show("تم الحفظ"); l1.Clear(); } else { MessageBox.Show("من فضلك قم بتعديل التاريخ"); } }
private void label15_Click(object sender, EventArgs e) { if (flag == "7agz") { p1.Controls[6].BackColor = Color.Green; try { con1.OpenConection(); // create procedure updat(@f nvarchar(50),@d nvarchar(50),@s nvarchar(50) ,@n nvarchar(50)) // as // update setescope_operation set flag= @f where Datee = @d and start_time=@s and EndoscopeCode in(select EndoscopeCode from Endoscope_settings_data where EndoscopeName=@n ); //escope_operation set flag= @f where Datee = @d and start_time=@s and EndoscopeCode in(select EndoscopeCode from Endoscope_settings_data where EndoscopeName=@n ); //cmd = new SqlCommand("updat", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@f", "taked"); //cmd.Parameters.AddWithValue("@d", d); //cmd.Parameters.AddWithValue("@s",start); //cmd.Parameters.AddWithValue("@n",endo); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@f", "@d", "@s", "@n" }; values = new string[] { "taked", d, start, endo }; con1.ExecuteNonQueryProcedure("updat", name_input, values, types); flag = "taked"; } catch (Exception v) { MessageBox.Show(v.Message); } finally { con1.CloseConnection(); } } else if (flag == "start") { MessageBox.Show("لا يمكن تاكيد الحجز لقد تم بدء العمليه "); } else if (flag == "finish") { MessageBox.Show("لا يمكن تاكيد الحجز لقد تم انهاء العمليه"); } else if (flag == "taked") { MessageBox.Show("لقد تم التأكيد مسبقا"); } }
private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { /* * create procedure clinic_خدمات_clinic_service_insert(@c nvarchar(50),@arabic nvarchar(100),@english nvarchar(100),@co nvarchar(50),@degree nvarchar(100)) * as * begin * insert into clinic_service values(@c,@arabic,@english,@co,@degree) * end */ if (textBox1.Text == "" || textBox4.Text == "" || textBox5.Text == "" || textBox9.Text == "") { MessageBox.Show("من فضلك قم بادخال البيانات"); } else { l1.Add(textBox1.Text); l1.Add(textBox4.Text); l1.Add(textBox5.Text); l1.Add(textBox9.Text); l1.Add(comboBox2.Text); for (int i = 0; i < l1.Count; i += 5) { //class_con.OpenConection(); //cmd.Connection = con; //cmd.CommandText = "clinic_خدمات_clinic_service_insert"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@c", l1[i]); //cmd.Parameters.AddWithValue("@arabic", l1[i+1]); //cmd.Parameters.AddWithValue("@english", l1[i+2]); //cmd.Parameters.AddWithValue("@co", l1[i+3]); //cmd.Parameters.AddWithValue("@degree", l1[i+4]); ////cmd.CommandText = "insert into clinic_service values('" + l1[i] + "','" + l1[i + 1] + "','" + l1[i + 2] + "','" + l1[i + 3] + "','" + l1[i + 4] + "')"; //cmd.ExecuteNonQuery(); //class_con.CloseConnection(); ////con.Close(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@c", "@arabic", "@english", "@co", "@degree" }; values = new string[] { l1[i], l1[i + 1], l1[i + 2], l1[i + 3], l1[i + 4] }; con1.ExecuteNonQueryProcedure("clinic_خدمات_clinic_service_insert", name_input, values, types); con1.CloseConnection(); } MessageBox.Show("تم الحفظ"); textBox1.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox9.Text = ""; textBox10.Text = ""; comboBox2.Text = ""; l1.Clear(); } }
//////////////////////////////////save///////////////////////////// private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (tableLayoutPanel1.RowCount > 1) { l1.Add(t1.Text); l1.Add(t2.Text); l1.Add(t3.Text); l1.Add(t4.Text); l1.Add(check.Checked.ToString()); } if (tableLayoutPanel1.RowCount == 1) { l1.Add(textBox1.Text); l1.Add(textBox2.Text); l1.Add(textBox3.Text); l1.Add(textBox4.Text); l1.Add(checkBox1.Checked.ToString()); } for (int i = 0; i < l1.Count; i += 5) { //texts[i] = l1[i]; /*create procedure clinic_غرف_العيادات_الخارجية_room_insert(@r int,@arabic nvarchar(100),@english nvarchar(100),@sep nvarchar(100),@main nvarchar(100)) * as * begin * insert into room(r_id,arabic_des,english_des,specialty,maintenance) values(@r,@arabic,@english,@sep,@main) * end */ //con.Open(); //cmd.Connection = con; ////cmd.CommandText = "insert into room(r_id,arabic_des,english_des,specialty,maintenance) values('" + l1[i] + "','" + l1[i + 1] + "','" + l1[i + 2] + "','" + l1[i + 3] + "','" + l1[i + 4] + "')"; //cmd.CommandText = "clinic_غرف_العيادات_الخارجية_room_insert"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@r", SqlDbType.Int).Value = l1[i]; //cmd.Parameters.Add("@arabic", SqlDbType.NVarChar).Value = l1[i + 1]; //cmd.Parameters.Add("@english", SqlDbType.NVarChar).Value = l1[i + 2]; //cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = l1[i + 3]; //cmd.Parameters.Add("@main", SqlDbType.NVarChar).Value = l1[i + 4]; //cmd.ExecuteNonQuery(); //con.Close(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@r", "@arabic", "@english", "@sep", "@main" }; values = new string[] { l1[i], l1[i + 1], l1[i + 2], l1[i + 3], l1[i + 4] }; con1.ExecuteNonQueryProcedure("clinic_غرف_العيادات_الخارجية_room_insert", name_input, values, types); con1.CloseConnection(); } //con.OpenConection(); //con.ShowDataInGridViewUsingStoredProc("clinic_غرف_العيادات_الخارجية_room_insert", inputs, texts, types); MessageBox.Show("تم الحفظ"); l1.Clear(); }
//For insert the new patient in table of patient private void button1_Click(object sender, EventArgs e) { //create procedure clinic_التسجيل_patient_insert(@id int,@fn nvarchar(50),@sn nvarchar(50),@thn nvarchar(50), //@ln nvarchar(50),@gen nvarchar(50),@job nvarchar(50),@ins varchar(50),@ssn int,@date date,@nat nvarchar(50),@ph int,@f_n int,@f_l nvarchar(50)) // as // begin //insert into patient(patient_id,fname,sname,thname,lname,gender,job,institution,ssn,date_of_birth,nationality,phonenumber,file_number,file_location) //values(@id,@fn,@sn,@thn,@ln,@gen,@job,@ins,@ssn,@date,@nat,@ph,@f_n,@f_l) // end //create procedure clinic_التسجيل_patient_insert //(@fn varchar(50),@gen varchar(50),@job varchar(50),@ins int,@ssn int,@date varchar(30), //@nat varchar(50),@address varchar(100),@age int,@emp int,@reg_date varchar(30)) //as //begin //insert into Registeration_patientRegisteration //(patient_name,gender,job,catogrical_code,identity_type,date_of_birth,nationality,address_of_patient,age,employ_code,date_Regist) //values(N''+@fn+'%',N''+@gen+'%',N''+@job+'%',@ins,@ssn,@date,N''+@nat+'%',N''+@address+'%',@age,@emp,@reg_date) // end DateTime datetime = DateTime.Now; string date = datetime.ToString("yyyy-MM-dd HH:mm:ss"); x = textBox2.Text; n = textBox3.Text + " " + textBox4.Text; f_name = textBox2.Text + "" + textBox3.Text + "" + textBox4.Text + "" + textBox5.Text; con1.OpenConection(); types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Date, SqlDbType.VarChar, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.VarChar }; name_input = new string[] { "@fn", "@gen", "@job", "@ins", "@ssn", "@date", "@nat", "@address", "@age", "@emp", "@reg_date" }; values = new string[] { f_name, textBox6.Text, textBox7.Text, textBox8.Text, textBox9.Text, textBox10.Text, textBox11.Text, textBox1.Text, textBox12.Text, textBox13.Text, date }; con1.ExecuteNonQueryProcedure("clinic_التسجيل_patient_insert", name_input, values, types); MessageBox.Show("تم اضافه المريض "); con1.CloseConnection(); }
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { //con.Open(); //string date = dateTimePicker1.Value.ToString("yyyy-MM-dd"); //cmd = new SqlCommand("assigne_to_thetable", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@x", textBox1.Text); //cmd.Parameters.AddWithValue("@y", textBox5.Text); //cmd.Parameters.AddWithValue("@z", textBox3.Text); //cmd.Parameters.AddWithValue("@f",date); /////////////////pro //cmd.ExecuteNonQuery(); // SqlDataReader dr = cmd.ExecuteReader(); //create procedure assigne_to_thetable(@x int,@y int,@z varchar(80) ,@f varchar(40)) //as //insert into user_patient values //(@x,@y,@z,@f); //create procedure insert_user_patient(@x int,@y int,@z datetime,@i varchar(80)) //as //begin // insert into user_patient values(@x,@y,@z,@i) //end string date = dateTimePicker1.Value.ToString("yyyy-MM-dd"); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.DateTime, SqlDbType.DateTime }; name_input = new string[] { "@x", "@y", "@z", "@i" }; values = new string[] { textBox1.Text, textBox5.Text, textBox3.Text, date }; con1.ExecuteNonQueryProcedure("insert_user_patient", name_input, values, types); con1.CloseConnection(); MessageBox.Show("تم الحفظ"); textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = ""; textBox4.Text = ""; textBox5.Text = ""; l1.Clear(); }
private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { l1.Add(textBox1.Text); l1.Add(textBox4.Text); l1.Add(textBox5.Text); l1.Add(textBox9.Text); l1.Add(comboBox2.Text); for (int i = 0; i < l1.Count; i += 5) { /* * create procedure clinic_اضافه_عياده_clinic_insert(@c nvarchar(50),@sep nvarchar(100),@arabic nvarchar(100),@english nvarchar(50),@d nvarchar(50)) * as * begin * insert into clinic values(@c,@sep,@arabic,@english,@d) * end * */ //con.Open(); //cmd.Connection = con; ////cmd.CommandText = "insert into clinic values('" + l1[i] + "','" + l1[i + 4] + "','" + l1[i + 1] + "','" + l1[i + 2] + "','" + l1[i + 3] + "')"; //cmd.CommandText = "clinic_اضافه_عياده_clinic_insert"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.Add("@c", SqlDbType.NVarChar).Value = l1[i]; //cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = l1[i + 4]; //cmd.Parameters.Add("@arabic", SqlDbType.NVarChar).Value = l1[i + 1]; //cmd.Parameters.Add("@english", SqlDbType.NVarChar).Value = l1[i + 2]; //cmd.Parameters.Add("@d", SqlDbType.NVarChar).Value = l1[i + 3]; //cmd.ExecuteNonQuery(); //con.Close(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@c", "@sep", "@arabic", "@english", "@d" }; values = new string[] { l1[i], l1[i + 4], l1[i + 1], l1[i + 2], l1[i + 3] }; con1.ExecuteNonQueryProcedure("clinic_اضافه_عياده_clinic_insert", name_input, values, types); con1.CloseConnection(); } MessageBox.Show("تم الحفظ"); textBox1.Text = ""; textBox4.Text = ""; textBox5.Text = ""; textBox9.Text = ""; textBox10.Text = ""; comboBox2.Text = ""; l1.Clear(); }
private void تأكيدToolStripMenuItem_Click(object sender, EventArgs e) { //create PROCEDURE setescope_receive_request_select_end_time //as //begin //select end_time from setescope_operation where id = ( select max(id) from setescope_operation ) //end con1.OpenConection(); DataTable ddt = new DataTable(); //cmd = new SqlCommand("setescope_receive_request_select_end_time", con); //cmd.CommandType = CommandType.StoredProcedure; //dr = cmd.ExecuteReader(); dr = con1.DataReader("setescope_receive_request_select_end_time"); ddt.Load(dr); string end_time = ddt.Rows[0][0].ToString(); DateTime d = DateTime.Today; string s = d.ToShortDateString() + " " + end_time; DateTime dtt = Convert.ToDateTime(s); con1.CloseConnection(); //create PROCEDURE setescope_confirm_operation_insert_update (@start_time time ,@Datee date ,@end_time time ,@flag varchar(30),@EndoscopeCode int,@patient_id int,@req_id int) //as //begin //insert into setescope_operation (start_time,Datee,end_time,flag,EndoscopeCode,patient_id) values //(@start_time,@Datee,@end_time,@flag,@EndoscopeCode,@patient_id) ; //update receive_request set flag = 'confirm' where req_id = @req_id ; //end con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Time, SqlDbType.Date, SqlDbType.Time, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@start_time", "@Datee", "@end_time", "@flag", "@EndoscopeCode", "@patient_id", "@req_id" }; values = new string[] { end_time, d.ToShortDateString(), Convert.ToString(dtt.AddMinutes(30)), "no", Convert.ToString(endo_id), Convert.ToString(p_id), Convert.ToString(request_id) }; con1.ExecuteNonQueryProcedure("setescope_confirm_operation_insert_update", name_input, values, types); MessageBox.Show("تم تأكيد العمليه"); con1.CloseConnection(); }
private void حفظToolStripMenuItem_Click(object sender, EventArgs e) { int f; if (int.TryParse(textBox3.Text, out f)) { MessageBox.Show("يجب ادخال نص مناسب"); } else { if (textBox3.Text == "" || textBox2.Text == "") { MessageBox.Show("يجب ادخال البيانات الناقصة"); } else { /*create procedure clinic_patient_visit_update_cancel_date(@c_date date,@s int, @s1 int) * as * begin * update patient_visit set cancel_date =@c_date,cancel_type ='canceled' where P_id =@s and num_of_visit =@s1; * end * */ //con.Open(); //cmd = new SqlCommand(); //cmd.Connection = con; ////cmd.CommandText = "update patient_visit set cancel_date = ' " + datet.ToString("yyyy-MM-dd") + " ' where P_id = " + s + " and num_of_visit = " + s1; //cmd.CommandText = "clinic_patient_visit_update_cancel_date"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@s", s); //cmd.Parameters.AddWithValue("@s1", s1); //cmd.Parameters.AddWithValue("@c_date", datet.ToString("yyyy-MM-dd")); //cmd.ExecuteNonQuery(); //con.Close(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.Date }; name_input = new string[] { "@s", "@s1", "@c_date" }; values = new string[] { s.ToString(), s1.ToString(), datet.ToString("yyyy-MM-dd") }; con1.ExecuteNonQueryProcedure("clinic_entranceoffice_visit_update_cancel_date", name_input, values, types); con1.CloseConnection(); MessageBox.Show(" تم عملية الحفظ بنجاح "); } } }
//////////////////////////////save//////////////////////////////// private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (selected == "تخدير") { if (tableLayoutPanel1.RowCount > l1.Count) { if (tableLayoutPanel1.RowCount == 1) { l1.Add(textBox1.Text); } else { l1.Add(t1.Text); } } con1.OpenConection(); //create procedure dele(@p_id int, @type nvarchar(30)) //as //delete from doctor_operation where id_op=@p_id and Do_id in (select d.Do_id from doctors d,doctor_operation o where d.Do_id = o.Do_id and jop=@type) //cmd = new SqlCommand("dele", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@p_id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@type", "Anesthesia"); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar }; name_input = new string[] { "@p_id", "@type" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, "Anesthesia" }; con1.ExecuteNonQueryProcedure("dele", name_input, values, types); for (int i = 0; i < l1.Count; i++) { // create procedure ins(@id1 int,@id2 int) //as //insert into doctor_operation values(@id1,@id2) //cmd = new SqlCommand("ins", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@id1", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@id2", Convert.ToInt32(l1[i])); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@id1", "@id2" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, l1[i] }; con1.ExecuteNonQueryProcedure("ins", name_input, values, types); } con1.CloseConnection(); MessageBox.Show("تم الحفظ"); } if (selected == "جراح مساعد") { if (tableLayoutPanel1.RowCount > l2.Count) { if (tableLayoutPanel1.RowCount == 1) { l2.Add(textBox1.Text); } else { l2.Add(t1.Text); } } con1.OpenConection(); /* * * create procedure procedurselect_doc_details(@id int) * as * select * o.Do_id from doctors d,doctor_operation o where o.id_op=@id and d.Do_id =o.Do_id and jop='surgeon' ORDER BY o.id_op DESC ; * * * * */ //cmd = new SqlCommand("procedurselect_doc_details",con); //cmd.Parameters.AddWithValue("@id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //da2 = new SqlDataAdapter(cmd); types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@id" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid }; dr = con1.ShowDataInGridViewUsingStoredProcDR("procedurselect_doc_details", name_input, values, types); DataTable dt2 = new DataTable(); dt2.Load(dr); //cmd = new SqlCommand("dele", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@p_id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@type", "surgeon"); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar }; name_input = new string[] { "@p_id", "@type" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, "surgeon" }; con1.ExecuteNonQueryProcedure("dele", name_input, values, types); for (int i = 0; i < l2.Count; i++) { //cmd = new SqlCommand("ins", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@id1", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@id2", Convert.ToInt32(l2[i])); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@id1", "@id2" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, l2[i] }; con1.ExecuteNonQueryProcedure("ins", name_input, values, types); } dr.Close(); con1.CloseConnection(); MessageBox.Show("تم الحفظ"); } if (selected == "تمريض") { if (tableLayoutPanel1.RowCount > l3.Count) { if (tableLayoutPanel1.RowCount == 1) { l3.Add(textBox1.Text); } else { l3.Add(t1.Text); } } con1.OpenConection(); //cmd.Connection = con; //cmd = new SqlCommand("dele", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@p_id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@type", "Nursing"); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar }; name_input = new string[] { "@p_id", "@type" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, "Nursing" }; con1.ExecuteNonQueryProcedure("dele", name_input, values, types); for (int i = 0; i < l3.Count; i++) { //cmd = new SqlCommand("ins", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@id1", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@id2", Convert.ToInt32(l3[i])); //cmd.ExecuteNonQuery(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@id1", "@id2" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, l3[i] }; con1.ExecuteNonQueryProcedure("ins", name_input, values, types); } dr.Close(); con1.CloseConnection(); MessageBox.Show("تم الحفظ"); } }
private void button3_Click(object sender, EventArgs e) { // create procedure clinic_محرك_البحث_للحجز_patient_visit_insert(@pid int,@ordere int,@type nvarchar(50),@type2 nvarchar(50),@date nvarchar(100)) //as //begin //declare @i int //set @i=(select count(visit_id)+1 from entranceoffice_visit where pat_id=@pid) //insert into entranceoffice_visit(visit_id,pat_id,ordere,type_of_visit,type_status,entrance_date) values(@i,@pid,@ordere,@type, @type2 , @date) //end //create procedure clinic_محرك_البحث_للحجز_treat_patient_insert(@pid int,@c nvarchar(30)) //as //begin //insert into Treat_Patient(pid,c_code) values(@pid,@c) //end // create procedure clinic_محرك_البحث_للحجز_patient_visit_insert(@pid int,@ordere int,@type nvarchar(50),@type2 nvarchar(50),@date nvarchar(100)) //as //begin //declare @i int //set @i=(select count(visit_id)+1 from entranceoffice_visit where pat_id=@pid) //insert into entranceoffice_visit(visit_id,pat_id,ordere,type_of_visit,Finish_Type,entrance_date) values(@i,@pid,@ordere,@type, @type2 , @date) //endd int order = 1000; string type = "خارجي", type2 = "open"; DateTime dt = DateTime.Now; String date = dt.ToString("yyyy-MM-dd hh:mm:ss"); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar }; name_input = new string[] { "@pid", "@ordere", "@type", "@type2", "@date" }; values = new string[] { x1, order.ToString(), type, type2, date }; con1.ExecuteNonQueryProcedure("clinic_محرك_البحث_للحجز_patient_visit_insert", name_input, values, types); con1.CloseConnection(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.VarChar }; name_input = new string[] { "@pid", "@c" }; values = new string[] { x1, code.ToString() }; con1.ExecuteNonQueryProcedure("clinic_محرك_البحث_للحجز_treat_patient_insert1", name_input, values, types); con1.CloseConnection(); //create procedure clinic_محرك_البحث_للحجز_patient_select1(@pid int) //as //begin //select patient_name, catogrical_code from Registeration_patientRegisteration where patient_id=@pid //end con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@pid" }; values = new string[] { x1 }; SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_البحث_للحجز_patient_select1", name_input, values, types); dr.Read(); MessageBox.Show("لفد تم الادخال بنجاح"); حجز_العياده f = new حجز_العياده(); name1 = dr[0].ToString() + " " + dr[1].ToString(); //name2 = dr[2].ToString(); f.Focus(); this.DialogResult = DialogResult.OK; f.Focus(); con1.CloseConnection(); //insert_into_patient_visit(); //cmd = new SqlCommand("insert into pat_clinic(patient_id,code_clinic) values(" + int.Parse(x1) + "," + code + ");", con); //try //{ // MessageBox.Show("لفد تم الادخال بنجاح"); // cmd = new SqlCommand("select fname,sname,institution from patient where patient_id=" + int.Parse(x1) + "", con); // dr = cmd.ExecuteReader(); // dr.Read(); // حجز_العياده f = new حجز_العياده(); // name1 = dr[0].ToString() +" "+ dr[1].ToString(); // name2 = dr[2].ToString(); // f.Focus(); // this.DialogResult = DialogResult.OK; // f.Focus(); }
private void button1_Click(object sender, EventArgs e) { try { /*create PROCEDURE setescope_rooms_select_for_check (@roomcode int) * as * begin * select RoomCode,ArabicName from Endoscope_room where RoomCode =@roomcode * end * */ //con = new SqlConnection(@"server=ENGY\SQLEXPRESS;database=setescope;Integrated Security=true;"); //con.Open(); ////cmd = new SqlCommand("select RoomCode,ArabicName from Endoscope_room where RoomCode = '"+textBox1.Text+"';", con); //cmd = new SqlCommand("setescope_rooms_select_for_check", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@roomcode", textBox1.Text); //dr = cmd.ExecuteReader(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@roomcode" }; values = new string[] { textBox1.Text }; dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_rooms_select_for_check", name_input, values, types); if (dr.Read()) { MessageBox.Show("هذه الغرفه موجوده بالفعل"); dr.Close(); } else if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("برجاء استكمال بيانات الغرفه"); } else { dr.Close(); //create PROCEDURE setescope_rooms_insert_new_room (@roomcode int,@aname nvarchar(30)) //as //begin //insert into Endoscope_room (RoomCode,ArabicName) values (@roomcode,@aname) //end //// cmd = new SqlCommand("insert into Endoscope_room (RoomCode,ArabicName) values ('" + textBox1.Text + "',N'" + textBox2.Text + "');", con); // cmd = new SqlCommand("setescope_rooms_insert_new_room", con); // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.Add("@aname", SqlDbType.NVarChar).Value = textBox2.Text; // cmd.Parameters.AddWithValue("@roomcode", Convert.ToInt32( textBox1.Text)); // cmd.ExecuteNonQuery(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar }; name_input = new string[] { "@roomcode", "@name" }; values = new string[] { textBox1.Text, textBox2.Text }; con1.ExecuteNonQueryProcedure("setescope_rooms_insert_new_room", name_input, values, types); MessageBox.Show("تم اضافه الغرفه"); } con1.CloseConnection(); con1.OpenConection(); dataGridView1.Visible = true; dataGridView1.DataSource = null; dataGridView1.Rows.Clear(); dataGridView1.Refresh(); dt.Clear(); //create PROCEDURE setescope_rooms_selectall //as //begin //select RoomCode as 'كود الغرفه',ArabicName as 'الاسم عربى' from Endoscope_room; //end //cmd = new SqlCommand("select RoomCode as 'كود الغرفه',ArabicName as 'الاسم عربى' from Endoscope_room;", con); //cmd = new SqlCommand("setescope_rooms_selectall", con); //cmd.CommandType = CommandType.StoredProcedure; //dr = cmd.ExecuteReader(); dr = con1.DataReader("setescope_rooms_selectall"); dt.Load(dr); dataGridView1.DataSource = dt; dr.Close(); con1.CloseConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
//////////////////////////////////save///////////////////////////// private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (dateTimePicker2.Value.Date >= dateTimePicker1.Value.Date) { if (tableLayoutPanel1.RowCount == 1) { l1.Add(textBox3.Text); } if (tableLayoutPanel2.RowCount == 1) { l2.Add(dateTimePicker1.Value.ToString()); l2.Add(dateTimePicker2.Value.ToString()); } if (tableLayoutPanel1.RowCount > 1) { l1.Add(t1.Text); } if (tableLayoutPanel2.RowCount > 1) { l2.Add(dtp1.Value.ToString()); l2.Add(dtp2.Value.ToString()); } for (int i = 0; i < l1.Count; i++) { /* * create procedure clinic_عطلات_الاطباء_doc_rest_insert * (@code int,@s_time datetime,@e_time datetime) * as * begin * insert into doc_rest values(@code,@s_time,@e_time) * end */ for (int j = 0; j < l2.Count; j += 2) { //con.Open(); //cmd.Connection = con; //cmd.CommandText = "clinic_عطلات_الاطباء_doc_rest_insert"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@code", l1[i]); //cmd.Parameters.AddWithValue("@s_time", l2[j]); //cmd.Parameters.AddWithValue("@e_time", l2[j+1]); ////cmd.CommandText = "insert into doc_rest values('" + l1[i] + "','" + l2[j] + "','" + l2[j + 1] + "')"; //cmd.ExecuteNonQuery(); //con.Close(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.DateTime, SqlDbType.DateTime }; name_input = new string[] { "@code", "@s_time", "@e_time" }; values = new string[] { l1[i], l2[j], l2[j + 1] }; con1.ExecuteNonQueryProcedure("clinic_عطلات_الاطباء_doc_rest_insert", name_input, values, types); con1.CloseConnection(); } } MessageBox.Show("تم الحفظ"); l1.Clear(); l2.Clear(); } else { MessageBox.Show("من فضلك قم بتعدل التاريخ"); } }
private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (radioButton3.Checked) { check = "pos"; } if (radioButton4.Checked) { check = "full"; } if (radioButton5.Checked) { check = "half"; } con1.OpenConection(); //create procedure setescope_select_doc_id_doc_name(@op int) //as //select o.Do_id ,d.name from doctor_operation o,doctors d where o.op_id=@op and o.Do_id=d.doc_ssn and type='Anesthesia' //cmd = new SqlCommand("setescope_select_doc_id_doc_name", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@op", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //da1 = new SqlDataAdapter(cmd); types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@op" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid }; dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_select_doc_id_doc_name", name_input, values, types); //DataSet ds1 = new DataSet(); DataTable dt = new DataTable(); dt.Load(dr); if (dt.Rows.Count == 0) { //cmd = new SqlCommand("ins", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@id1", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@id2", Convert.ToInt32(textBox4.Text)); //// cmd.CommandText = "insert into doctor_operation values (" + Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid) + "," + Convert.ToInt32(textBox4.Text) +")"; //cmd.ExecuteNonQuery(); //create procedure ins(@id1 int,@id2 int) // as // insert into doctor_operation values(@id1,@id2) dr.Close(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@id1", "@id2" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, textBox4.Text }; con1.ExecuteNonQueryProcedure("ins", name_input, values, types); //cmd = new SqlCommand("setescope_select_doc_name", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@op", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //da3 = new SqlDataAdapter(cmd); // create procedure setescope_select_doc_name(@op int) //as //select d.name from doctor_operation o,doctors d where o.op_id=@op and o.Do_id=d.doc_ssn and type='Anesthesia' types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@op" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid }; dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_select_doc_name", name_input, values, types); // da3 = new SqlDataAdapter("select d.name from doctor_operation o,doctor d where o.op_id=" + Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid) + " and o.Do_id=d.Do_id and type='Anesthesia';", con); DataTable dt2 = new DataTable(); dt2.Load(dr); panel1.Visible = true; label9.Text = dt2.Rows[0][0].ToString(); label13.Text = dt2.Rows[0][0].ToString(); label12.Text = dateTimePicker1.Value.ToString(); } else { panel1.Visible = true; label9.Text = dt.Rows[0][1].ToString(); //cmd = new SqlCommand("setescope_update_doc_id", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@op", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //cmd.Parameters.AddWithValue("@d_id", Convert.ToInt32(textBox4.Text)); //cmd.Parameters.AddWithValue("@doc", Convert.ToInt32(ds1.Tables[0].Rows[0][0].ToString())); //// cmd.CommandText = "update doctor_operation set Do_id=" + Convert.ToInt32(textBox4.Text) + " where op_id=" + Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid) + " and Do_id=" + Convert.ToInt32(ds1.Tables[0].Rows[0][0].ToString()); //cmd.ExecuteNonQuery(); // create procedure setescope_update_doc_id(@d_id int,@op int ,@doc int) //as //update doctor_operation set Do_id=@d_id where op_id=@op and Do_id=@doc dr.Close(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@d_d1", "@op", "@doc" }; values = new string[] { textBox4.Text, الصفحه_الرئيسيه_للمنظار.opid, dt.Rows[0][0].ToString() }; con1.ExecuteNonQueryProcedure("setescope_update_doc_id", name_input, values, types); //cmd = new SqlCommand("setescope_select_doc_name", con); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@op", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid)); //da2 = new SqlDataAdapter(cmd); types = new SqlDbType[] { SqlDbType.NVarChar }; name_input = new string[] { "@op" }; values = new string[] { الصفحه_الرئيسيه_للمنظار.opid }; dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_select_doc_name", name_input, values, types); // da2 = new SqlDataAdapter("select d.name from doctor_operation o,doctor d where o.op_id=" + Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid) + " and o.Do_id=d.Do_id and type='Anesthesia';", con); //DataSet ds2 = new DataSet(); //da2.Fill(ds2); DataTable dt3 = new DataTable(); label13.Text = dt3.Rows[0][0].ToString(); label12.Text = dateTimePicker1.Value.ToString(); } dr.Close(); con1.CloseConnection(); }
private void حفظToolStripMenuItem_Click(object sender, EventArgs e) { try { con1.OpenConection(); dr = con1.DataReader("setscope_EndoscopeCode_select"); if (textBox1.Text != "") { while (dr.Read()) { if (int.Parse(dr[0].ToString()) == int.Parse(textBox1.Text)) { Code = int.Parse(dr[0].ToString()); isequal = 1; dr.Close(); break; } } } if (isequal == 1) { dr.Close(); types = new SqlDbType[] { SqlDbType.Text, SqlDbType.Text, SqlDbType.Text, SqlDbType.Int }; name_input = new string[] { "@sett_name", "@latin_name", "@bill", "@code" }; values = new string[] { textBox4.Text, textBox5.Text, Convert.ToString(comboBox2.SelectedItem), Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_Endoscope_settings_data_Update1", name_input, values, types); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@do_in_hospital", "@code" }; values = new string[] { Convert.ToString(do_in_hospital), Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_Endoscope_settings_data_Update2", name_input, values, types); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@doctor_feed", "@code" }; values = new string[] { Convert.ToString(doctor_feed), Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_Endoscope_settings_data_Update3", name_input, values, types); /////// if (can_delete_ == 1) { types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@code" }; values = new string[] { Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_Instruments_setescope_delete", name_input, values, types); } for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { string Code_dev = this.dataGridView1.Rows[i].Cells[1].Value.ToString(); string Type = this.dataGridView1.Rows[i].Cells[5].Value.ToString(); double time_use = double.Parse(this.dataGridView1.Rows[i].Cells[3].Value.ToString()); int Time_salhea = int.Parse(this.dataGridView1.Rows[i].Cells[4].Value.ToString()); types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Decimal, SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@Code_dev", "@time_use", "@Type", "@Time_salhea", "@Code_" }; values = new string[] { Code_dev, Convert.ToString(time_use), Type, Convert.ToString(Time_salhea), Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_", name_input, values, types); } if (can_delete == 1) { types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@code" }; values = new string[] { Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_Mostlzmat_operation_delete", name_input, values, types); } for (int i = 0; i < dataGridView2.Rows.Count - 1; i++) { int Mostlzmat_code = int.Parse(this.dataGridView2.Rows[i].Cells[1].Value.ToString()); string Mostlzmat_name = this.dataGridView2.Rows[i].Cells[2].Value.ToString(); int amount = int.Parse(this.dataGridView2.Rows[i].Cells[3].Value.ToString()); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@amount", "@Mostlzmat_code", "@Code" }; values = new string[] { Convert.ToString(amount), Convert.ToString(Mostlzmat_code), Convert.ToString(Code) }; con1.ExecuteNonQueryProcedure("setscope_Mostlzmat", name_input, values, types); } } else { dr.Close(); MessageBox.Show(do_in_hospital + " " + doctor_feed); types = new SqlDbType[] { SqlDbType.Text, SqlDbType.Text, SqlDbType.Int, SqlDbType.Int, SqlDbType.Text }; name_input = new string[] { "@sett_name", "@latin_name", "@do_in_hospital", "@doctor_feed", "@bill" }; values = new string[] { textBox4.Text, textBox5.Text, Convert.ToString(do_in_hospital), Convert.ToString(doctor_feed), Convert.ToString(comboBox2.SelectedItem) }; con1.ExecuteNonQueryProcedure("setscope_Endoscope_settings_data_insert", name_input, values, types); int max_EndoscopeCode; types = new SqlDbType[] { SqlDbType.Int }; name_input = new string[] { "@max_EndoscopeCode" }; values = new string[] { "" }; dr = con1.ShowDataInGridViewUsingStoredProcDR("setscope_Endoscope_settings_data_select_SET_code", name_input, values, types); DataTable dt = new DataTable(); dt.Load(dr); max_EndoscopeCode = Convert.ToInt32(dt); // int max_EndoscopeCode = int.Parse(cmd.ExecuteScalar().ToString()); //////////////////////////////////////////////////////////////// for (int i = 0; i < dataGridView1.Rows.Count - 1; i++) { string Code_dev = this.dataGridView1.Rows[i].Cells[1].Value.ToString(); string Ttype = this.dataGridView1.Rows[i].Cells[5].Value.ToString(); double timee_use = double.Parse(this.dataGridView1.Rows[i].Cells[3].Value.ToString()); int Time_salhea = int.Parse(this.dataGridView1.Rows[i].Cells[4].Value.ToString()); types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Decimal, SqlDbType.VarChar }; name_input = new string[] { "@Code_dev", "@timee_use", "@max_EndoscopeCode", "@Time_salhea", "@Ttype" }; values = new string[] { Code_dev, Convert.ToString(timee_use), Convert.ToString(max_EndoscopeCode), Convert.ToString(Time_salhea), Ttype }; con1.ExecuteNonQueryProcedure("setscope_Instruments_setescope_insert", name_input, values, types); } for (int i = 0; i < dataGridView2.Rows.Count - 1; i++) { int Mount_used = int.Parse(this.dataGridView2.Rows[i].Cells[3].Value.ToString()); string Moztlzm_name = this.dataGridView2.Rows[i].Cells[2].Value.ToString(); int Code_Moz = int.Parse(this.dataGridView2.Rows[i].Cells[1].Value.ToString()); types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int, SqlDbType.Int }; name_input = new string[] { "@max_EndoscopeCode", "@Code_Moz", "@Mount_used" }; values = new string[] { Convert.ToString(max_EndoscopeCode), Convert.ToString(Code_Moz), Convert.ToString(Mount_used) }; con1.ExecuteNonQueryProcedure("setscope_Mostlzmat_operation_insert", name_input, values, types); } } MessageBox.Show(اعدادات_المناظير.set_name); } catch (Exception exp) { MessageBox.Show(exp.Message + " error"); } }
private void حفظToolStripMenuItem_Click(object sender, EventArgs e) { //con = new SqlConnection("server=localhost;database=graduationDB;pwd=root;uid=root"); //cmd = new SqlCommand(); //cmd.Connection = con; //con.Open(); int pid = 0; string query = ""; DateTime dt = DateTime.Now; String date = dt.ToString("yyyy/MM/dd"); for (int i = 0; i < dataGridView1.Rows.Count; ++i) { //cmd = new SqlCommand(); //cmd.Connection = con; DataGridViewRow row = dataGridView1.Rows[i]; try { if ((bool)row.Cells[0].EditedFormattedValue == true) { /* * * * create procedure clinic_patient_visit_update(@pid int, @visit_num int, @e_date date) * as * begin * update Patient_visit set Type2 = 'close', End_date = @e_date where p_id = @pid and num_Of_visit = @visit_num; * end * * */ visit_num = int.Parse(row.Cells[3].Value.ToString()); pid = int.Parse(row.Cells[1].Value.ToString()); // query = "update Patient_visit set Type2 = 'close' where p_id = " + pid + " and num_Of_visit = " + visit_num; //cmd.CommandText = "clinic_patient_visit_update"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@pid", pid); //cmd.Parameters.AddWithValue("@visit_num", visit_num); //cmd.Parameters.AddWithValue("@e_date", date); //cmd.ExecuteNonQuery(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.Date }; name_input = new string[] { "@pid", "@visit_num", "@e_date" }; values = new string[] { pid.ToString(), visit_num.ToString(), date }; con1.ExecuteNonQueryProcedure("clinic_entranceoffice_visit_update", name_input, values, types); con1.CloseConnection(); if (row.Cells[6].Value.ToString() != "") { /*create procedure clinic_patient_visit_update_visit_Result(@pid_ int, @visit_num_ int, @result_visit varchar(50)) * as * begin * update Patient_visit set visit_Result = @result_visit where p_id = @pid_ and num_Of_visit = @visit_num_; * end * * */ result_visit = row.Cells[6].Value.ToString(); // update_ = "update Patient_visit set visit_Result ='" + result_visit + "' where p_id = " + pid + " and num_Of_visit = " + visit_num; //cmd.CommandText = "clinic_patient_visit_update_visit_Result"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@pid_", pid); //cmd.Parameters.AddWithValue("@visit_num_", visit_num); //cmd.Parameters.AddWithValue("@result_visit", result_visit); //cmd.ExecuteNonQuery(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.VarChar }; name_input = new string[] { "@pid_", "@visit_num_", "@result_visit" }; values = new string[] { pid.ToString(), visit_num.ToString(), result_visit }; con1.ExecuteNonQueryProcedure("clinic_entranceoffice_visit_update_visit_Result", name_input, values, types); con1.CloseConnection(); } // result_visit = row.Cells[6].Value.ToString(); if (row.Cells[8].Value.ToString() != "") { /* * create procedure clinic_patient_visit_update_type_status(@_pid int, @_visit_num int, @status_type varchar(50)) * as * begin * update Patient_visit set type_status = @status_type where p_id = @_pid and num_Of_visit =@_visit_num; * end * */ status_type = row.Cells[8].Value.ToString(); //update_ = "update Patient_visit set type_status ='" + status_type + "' where p_id = " + pid + " and num_Of_visit = " + visit_num; //cmd.CommandText = update_; //cmd.CommandText = "clinic_patient_visit_update_type_status"; //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@_pid", pid); //cmd.Parameters.AddWithValue("@_visit_num", visit_num); //cmd.Parameters.AddWithValue("@status_type", status_type); //cmd.ExecuteNonQuery(); con1.OpenConection(); types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.VarChar }; name_input = new string[] { "@_pid", "@_visit_num", "@status_type" }; values = new string[] { pid.ToString(), visit_num.ToString(), status_type }; con1.ExecuteNonQueryProcedure("clinic_entranceoffice_visit_update_type_status", name_input, values, types); con1.CloseConnection(); } //if (row.Cells[11].Value.ToString() != "") //{ // /*create procedure clinic_patient_visit_update_file_location(@_pid_ int, @File_Location nvarchar(50)) // as // begin // update Patient set file_location = @File_Location where patient_id = @_pid_; // end // * // */ // File_Location = row.Cells[11].Value.ToString(); // //cmd.CommandText = "clinic_patient_visit_update_file_location"; // //cmd.CommandType = CommandType.StoredProcedure; // //cmd.Parameters.AddWithValue("@_pid_", pid); // //cmd.Parameters.AddWithValue("@File_Location", File_Location); // ////cmd.CommandText = update_; // //cmd.ExecuteNonQuery(); // con1.OpenConection(); // types = new SqlDbType[] {SqlDbType.Int, SqlDbType.NVarChar }; // name_input = new string[] { "@_pid_", "@File_Location"}; // values = new string[] { pid.ToString(), File_Location }; // con1.ExecuteNonQueryProcedure("clinic_patient_visit_update_file_location", name_input, values, types); // con1.CloseConnection(); //} } } catch (Exception exp) { } } MessageBox.Show(" تم عملية الحفظ بنجاح "); }