//send to form6
private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
xx1 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
//create procedure clinic_select_nationality_gender_name(@x int)
// as
// select nationality,gender,patient_name as 'اسم المريض' from Registeration_patientRegisteration where patient_id =@x;
// select CE_AName from tb_Contracting_Entities,Registeration_patientRegisteration where tb_Contracting_Entities.CE_Id=Registeration_patientRegisteration.catogrical_code and patient_id=@x;
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@x" };
values = new string[] { xx1 };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_select_nationality_gender_name", name_input, values, types);
dr.Read();
xx6 = dr[0].ToString();
xx5 = dr[1].ToString();
xx2 = dr[2].ToString();
dr.NextResult(); dr.Read();
xx4 = dr[0].ToString();
dr.Close();
تعديل_الفئه_الماليه_للمريض_الخارجى f6 = new تعديل_الفئه_الماليه_للمريض_الخارجى(xx1, xx2, xx4, xx5, xx6);
f6.Show();
this.Close();
con1.CloseConnection();
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
/*
* create procedure [dbo].[clinic_حجز_العياده_clinic_service](@c int)
* as
* begin
* select SLS_Aname from tb_Second_Level_Service where [SLS_Service_Category]='Outer_Clinic' and [SLS_Status]=1 and c_code=@c
* end
*
*/
names = listBox1.Text;
con1.OpenConection();
// types = new SqlDbType[] {SqlDbType.NVarChar };
//name_input = new string[] { "@ser" };
//values = new string[] { names };
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@c" };
values = new string[] { code.ToString() };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_حجز_العياده_clinic_service", name_input, values, types);
//con = new SqlConnection(@"server=SANDRA-PC\SQLEXPRESS;database=project_db; Integrated Security=true;");
//con.Open();
//cmd = new SqlCommand("select clinic_code from clinic where arabic_name like'" + names + "%'"+"select arabic_des from clinic_service where ccode=" + code + "" , con);
while (dr.Read())
{
listBox3.Items.Clear();
service = dr[0].ToString();
listBox3.Items.Add(service);
}
MessageBox.Show("انت قمت باختيار عيادة " + " " + names);
dr.Close();
con1.CloseConnection();
}
private void button2_Click(object sender, EventArgs e)
{
if (can_selest__ == 1)
{
can_selest__ = 0;
textBox1.Text = "";
try
{
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Text };
name_input = new string[] { "@set_name" };
values = new string[] { set_name };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setscope_Endoscope_settings_data_select", name_input, values, types);
while (dr.Read())
{
textBox1.Text = dr[0].ToString();
textBox4.Text = dr[1].ToString();
textBox5.Text = dr[2].ToString();
comboBox2.SelectedItem = dr[5].ToString();
if (int.Parse(dr[3].ToString()) == 1)
{
checkBox1.Checked = true;
}
if (int.Parse(dr[4].ToString()) == 1)
{
radioButton1.Checked = true;
}
else
{
radioButton2.Checked = true;
}
}
dr.Close();
con1.CloseConnection();
}
catch (Exception exp)
{
MessageBox.Show(exp.Message + " error");
}
}
اضافةToolStripMenuItem.Visible = true;
if (panel2.Visible == true)
{
panel2.Visible = false;
}
if (panel3.Visible == true)
{
panel3.Visible = false;
}
panel1.Visible = true;
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
try
{
string time1 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString();
id_d = Convert.ToInt32(dataGridView1.Rows[e.RowIndex].Cells[4].Value.ToString());
end_name = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString();
//.Show(time);
//MessageBox.Show(id_d.ToString());
con.CloseConnection();
con.OpenConection();
string[] pramname = new string[1];
string[] pramvalue = new string[1];
SqlDbType[] pramtype = new SqlDbType[1];
pramname[0] = "@name";
pramvalue[0] = end_name;
pramtype[0] = SqlDbType.NVarChar;
SqlDataReader dr = con.ShowDataInGridViewUsingStoredProcDR("setescope_Endoscope_settings_data_select_id", pramname, pramvalue, pramtype);
int end_id = 0;
while (dr.Read())
{
end_id = Convert.ToInt32(dr[0].ToString());
}
string[] pramnam = new string[3];
string[] pramvalu = new string[3];
SqlDbType[] pramtyp = new SqlDbType[3];
pramnam[0] = "@dt";
pramnam[1] = "@st";
pramnam[2] = "@endo";
pramvalu[0] = d;
pramvalu[1] = time1;
pramvalu[2] = end_id.ToString();
pramtyp[0] = SqlDbType.NVarChar;
pramtyp[1] = SqlDbType.NVarChar;
pramtyp[2] = SqlDbType.Int;
dr.Close();
dr = con.ShowDataInGridViewUsingStoredProcDR("setescope_setescope_operation_select_id", pramnam, pramvalu, pramtyp);
//cmd = new SqlCommand("setescope_setescope_operation_select_id", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@dt", d);
//cmd.Parameters.AddWithValue("@st", time);
//cmd.Parameters.AddWithValue("@endo", textBox2.Text);
//SqlDataReader dr = cmd.ExecuteReader();-
while (dr.Read())
{
id_op = Convert.ToInt32(dr[0].ToString());
// MessageBox.Show(id_op.ToString());
}
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Form2_Load(object sender, EventArgs e)
{
try
{
con1.OpenConection();
//create PROCEDURE setescope_rooms_select_name_and_code (@code int)
//as
//begin
//select RoomCode,ArabicName from Endoscope_room where RoomCode= @code
//end
//cmd = new SqlCommand("select RoomCode,ArabicName from Endoscope_room where RoomCode=" + code + ";", con);
//cmd = new SqlCommand("setescope_rooms_select_name_and_code", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@code", Convert.ToInt32(code));
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@code" };
values = new string[] { Convert.ToString(code) };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_rooms_select_name_and_code", name_input, values, types);
dt.Load(dr);
textBox1.Text = dt.Rows[0][0].ToString();
textBox5.Text = dt.Rows[0][1].ToString();
textBox6.Text = اداره.code3.ToString();
textBox7.Text = اداره.name1;
textBox8.Text = مخزن_مستلزمات_المنظار.code2.ToString();
textBox9.Text = مخزن_مستلزمات_المنظار.name;
con1.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
if (dateTimePicker1.Value.Date < dateTimePicker2.Value.Date)
{
// create PROCEDURE setescope_receive_request_select (@d1 date ,@d2 date)
//as
//begin
//select req_id as 'رقم الطلب', req_date as 'تاريخ الطلب' ,pid as 'كودالمريض' , patient_endo.name as 'اسم المريض',
//doctors.name as 'اسم الطبيب' ,EndoscopeCode as 'كود العمليه',EndoscopeName as 'العمليه' , ArabicName as 'غرفه العمليه',accept_date as 'تاريخ الموافقه' ,commentes as 'ملاحظات'
//from receive_request ,patient_endo ,doctors ,Endoscope_settings_data as s ,Endoscope_room as e
//where patient_endo.id = receive_request.pid
//and doctors.Do_id = did
//and s.EndoscopeCode = endo_id
//and e.RoomCode = rid
//and receive_request.flag like 'no'
//and req_date between @d1 and @d2
//end
//con.Open();
//cmd = new SqlCommand("setescope_receive_request_select", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@d1", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@d2", dateTimePicker2.Text);
string d1 = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string d2 = dateTimePicker2.Value.ToString("yyyy-MM-dd");
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Date, SqlDbType.Date };
name_input = new string[] { "@d1", "@d2" };
values = new string[] { d1, d2 };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_receive_request_select", name_input, values, types);
DataTable dt = new DataTable();
dataGridView1.Visible = true;
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
//dt.Clear();
dt.Load(dr);
dataGridView1.DataSource = dt;
dr.Close();
con1.CloseConnection();
}
else
{
MessageBox.Show("برجاء ادخال تاريخ مناسب");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
string Arabicname = comboBox2.Text;
try
{
//create procedure setescope_Endoscope_room_select_code(@arb_name nvarchar(30))
//as
//begin
//select RoomCode from Endoscope_room where ArabicName=@arb_name;
//end
con.OpenConection();
string[] pramname = new string[1];
string[] pramvalue = new string[1];
SqlDbType[] pramtype = new SqlDbType[1];
pramname[0] = "@arb_name";
pramvalue[0] = Arabicname;
pramtype[0] = SqlDbType.NVarChar;
SqlDataReader dr = con.ShowDataInGridViewUsingStoredProcDR("setescope_Endoscope_room_select_code", pramname, pramvalue, pramtype);
c = Convert.ToInt32(dr["RoomCode"]);
roomflag(c);
dr.Close();
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//For add patient to clinic
private void button2_Click(object sender, EventArgs e)
{
//create procedure clinic_محرك_البحث_للحجز_treat_patient_insert(@fn varchar(50),@c varchar(30))
//as
//begin
//declare @pid int
//set @pid=(select patient_id from Registeration_patientRegisteration where patient_name like N'%'+@fn+'%')
//insert into Treat_Patient(pid,c_code) values(@pid,@c)
//end
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar };
name_input = new string[] { "@fn", "@c" };
values = new string[] { f_name, clinic_name.ToString() };
con1.ExecuteNonQueryProcedure("clinic_محرك_البحث_للحجز_treat_patient_insert", name_input, values, types);
con1.CloseConnection();
//create procedure clinic_محرك_البحث_للحجز_patient_select(@fn varchar(50))
//as
//begin
//select patient_name, catogrical_code from Registeration_patientRegisteration where patient_name like N'%'+@fn+'%'
//end
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.VarChar };
name_input = new string[] { "@fn" };
values = new string[] { f_name };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_البحث_للحجز_patient_select", name_input, values, types);
dr.Read();
MessageBox.Show("لفد تم الادخال بنجاح");
حجز_العياده f = new حجز_العياده();
f.Focus();
this.DialogResult = DialogResult.OK;
f.Focus();
dr.Close();
con1.CloseConnection();
}
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);
}
}
private void كتابة_اقرار_المنظار_Load(object sender, EventArgs e)
{
try
{
con1.OpenConection();
/*
* create PROCEDURE setescope_approval_select_patienName_and_id (@id int)
* as
* select name , type_of_visit from patient_endo where id=@id
*/
//cmd = new SqlCommand("setescope_approval_select_patienName_and_id", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@id", كتابه_اقرار_مناظير.c);
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@id" };
values = new string[] { Convert.ToString(كتابه_اقرار_مناظير.c) };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_approval_select_patienName_and_id", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
textBox1.Text = كتابه_اقرار_مناظير.c.ToString();
textBox2.Text = dt.Rows[0][0].ToString();
textBox11.Text = dt.Rows[0][1].ToString();
dr.Close();
con1.CloseConnection();
con1.OpenConection();
//cmd = new SqlCommand("setescope_approval_select_doctorName", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@doctorName", كتابه_اقرار_مناظير.dn);
//dr = cmd.ExecuteReader();
//create PROCEDURE setescope_approval_select_doctorName (@doctorName nvarchar(30))
//as
//select Do_id from doctors where name = @doctorName
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@doctorName" };
values = new string[] { Convert.ToString(كتابه_اقرار_مناظير.dn) };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_approval_select_doctorName", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
textBox5.Text = كتابه_اقرار_مناظير.dn.ToString();
textBox6.Text = dt.Rows[0][0].ToString();
dr.Close();
con1.CloseConnection();
con1.OpenConection();
//cmd = new SqlCommand("setescope_approval_select_EndoscopeName", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@EndoscopeName", كتابه_اقرار_مناظير.opn);
//dr = cmd.ExecuteReader();
//create PROCEDURE setescope_approval_select_EndoscopeName (@EndoscopeName nvarchar(50))
//as
//select EndoscopeCode from Endoscope_settings_data where EndoscopeName = @EndoscopeName
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@EndoscopeName" };
values = new string[] { Convert.ToString(كتابه_اقرار_مناظير.opn) };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_approval_select_EndoscopeName", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
textBox3.Text = كتابه_اقرار_مناظير.opn.ToString();
textBox4.Text = dt.Rows[0][0].ToString();
dr.Close();
con1.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button1_Click_1(object sender, EventArgs e)
{
dataGridView1.Visible = true;
try
{
con1.OpenConection();
if (textBox1.Text != "" && textBox2.Text != "")
{
//create PROCEDURE setescope_departement_select_name_and_code (@aname nvarchar(30),@code int)
//as
//begin
//select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart where aname like N'%'+@aname+'%' and code2 = @code ;
//end
//cmd = new SqlCommand("select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart where code2 = '" + textBox1.Text + "' or aname like '" + textBox2.Text + "%';", con);
//cmd = new SqlCommand("setescope_departement_select_name_and_code", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@aname", SqlDbType.NVarChar).Value = textBox2.Text;
//cmd.Parameters.AddWithValue("@code", Convert.ToInt32(textBox1.Text));
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.Int };
name_input = new string[] { "@aname", "@code" };
values = new string[] { textBox2.Text, textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_departement_select_name_and_code", name_input, values, types);
}
else if (textBox1.Text != "")
{
//create PROCEDURE setescope_departement_select_code (@code int)
//as
//begin
//select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart where code2 = @code ;
//end
//cmd = new SqlCommand("select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart where code2 = '" + textBox1.Text + "';", con);
//cmd = new SqlCommand("setescope_departement_select_code", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@code", Convert.ToInt32(textBox1.Text));
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@code" };
values = new string[] { textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_departement_select_code", name_input, values, types);
}
else if (textBox2.Text != "")
{
//create PROCEDURE setescope_departement_select_name (@aname nvarchar(30))
//as
//begin
//select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart where aname like N'%'+@aname+'%' ;
//end
//cmd = new SqlCommand("select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart where aname like '" + textBox2.Text + "%';", con);
//cmd = new SqlCommand("setescope_departement_select_name", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@aname", SqlDbType.NVarChar).Value = textBox2.Text;
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@aname" };
values = new string[] { textBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_departement_select_name", name_input, values, types);
}
else
{
//create PROCEDURE setescope_departement_selectall
//as
//begin
//select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart ;
//end
//cmd = new SqlCommand("select code2 as 'الكود',aname as 'الاسم عربى',lname as 'الاسم انجليزى' from depart ;", con);
//cmd = new SqlCommand("setescope_departement_selectall", con);
//cmd.CommandType = CommandType.StoredProcedure;
dr = con1.DataReader("setescope_departement_selectall");
}
dataGridView1.DataSource = null;
DataTable dt = new DataTable();
dt.Load(dr);
dataGridView1.DataSource = dt;
con1.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void button3_Click(object sender, EventArgs e)
{
dataGridView1.Columns.Clear();
//con = new SqlConnection("server=localhost;database=graduationDB;uid=root;pwd=root");
//con.Open();
string begin = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string end = dateTimePicker2.Value.ToString("yyyy-MM-dd");
if (dateTimePicker1.Value.Date > dateTimePicker2.Value.Date)
{
MessageBox.Show("التاريخ الاول يجب ان يكون اقل من التاريخ الثاني ");
}
else
{
if (textBox2.Text == "" && textBox3.Text == "" && textBox5.Text == "" && textBox6.Text == "")
{
/*create procedure clinic_search_patient_visit_select(@pid int , @begin date, @end date)
* as
* begin
* select num_of_visit , start_date ,service_name from patient_visit where p_id = @pid and start_date between @begin and @end
* end
*
*/
int y = Convert.ToInt32(textBox1.Text);
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Date, SqlDbType.Date };
name_input = new string[] { "@pid", "@begin", "@end" };
values = new string[] { y.ToString(), begin, end };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_search_patient_visit_select", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
dataGridView1.Visible = true;
// con1.CloseConnection();
DataGridViewTextBoxColumn tex1 = new DataGridViewTextBoxColumn();
tex1.HeaderText = "كود_المريض";
dataGridView1.Columns.Add(tex1);
DataGridViewTextBoxColumn tex2 = new DataGridViewTextBoxColumn();
tex2.HeaderText = "اسم_المريض";
dataGridView1.Columns.Add(tex2);
dataGridView1.DataSource = dt;
dr.Close();
DateTime begin1 = dateTimePicker1.Value;
DateTime end1 = dateTimePicker2.Value;
// cmd.CommandText = "select english_name as اسم_العيادة ,doc_name as اسم_الدكتور from clinic,doctor, shift_time"
//+ " where clinic_code=shift_time.c_code and doctor_id = d_id and CAST(Start_Time AS DATE ) between '"
//+ begin1 + "' and '" + end1 + "' and shift_time.c_code = any(select c_code from Treat_Patient where PId = "
//+ int.Parse(textBox1.Text) + " ) and start_time = any(select start_date from patient_visit where p_id ="
//+ int.Parse(textBox1.Text) + " )";
/*
*
*
*
* create procedure clinic_search_patient_visit_select_1(@begin1 datetime, @end1 datetime, @pid int)
* as
* begin
* select english_name ,doc_name from clinic,doctor, shift_time
* where clinic_code=shift_time.c_code and doctor_id = d_id and CAST(Start_Time AS DATE ) between
* @begin1 and @end1 and shift_time.c_code = any(select c_code from Treat_Patient where PId =@pid) and start_time = any(select start_date from patient_visit where p_id = @pid);
*
* end
*
*
*/
y = Convert.ToInt32(textBox1.Text);
types = new SqlDbType[] { SqlDbType.DateTime, SqlDbType.DateTime, SqlDbType.Int };
name_input = new string[] { "@begin1", "@end1", "@pid" };
values = new string[] { begin1.ToString(), end1.ToString(), y.ToString() };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_search_patient_visit_select_1", name_input, values, types);
int i = 0;
DataGridViewTextBoxColumn tbc = new DataGridViewTextBoxColumn();
tbc.HeaderText = "اسم_العيادة";
dataGridView1.Columns.Add(tbc);
DataGridViewTextBoxColumn tbc2 = new DataGridViewTextBoxColumn();
tbc2.HeaderText = "اسم_الدكتور";
dataGridView1.Columns.Add(tbc2);
//after reading datareader have exception
try
{
while (dr.Read())
{
dataGridView1.Rows[i].Cells[0].Value = textBox1.Text;
dataGridView1.Rows[i].Cells[1].Value = textBox4.Text;
dataGridView1.Rows[i].Cells[5].Value = dr[0].ToString();
dataGridView1.Rows[i].Cells[6].Value = dr[1].ToString();
i++;
}
}
catch (Exception ex) { }
dr.Close();
con1.CloseConnection();
}
else if (textBox6.Text == "" && textBox3.Text == "")
{
/*
* create procedure clinic_search_patient_visit_select_2(@begin date, @end date, @pid int, @c_code int)
* as
* begin
* select distinct num_of_visit, start_date,service_name ,english_name, doc_name
* from clinic, doctor, patient_visit,treat_patient,shift_time
* where clinic_code = shift_time.c_code and doctor_id = d_id and shift_time.c_code = treat_patient.c_code
* and p_id = pid and p_id =pid and start_date between @begin and @end and treat_patient.c_code = @c_code and start_date = start_time;
* end
*
*/
con1.OpenConection();
int y = Convert.ToInt32(textBox1.Text);
int y1 = Convert.ToInt32(textBox2.Text);
types = new SqlDbType[] { SqlDbType.Date, SqlDbType.Date, SqlDbType.Int, SqlDbType.Int };
name_input = new string[] { "@begin", "@end", "@pid", "@c_code" };
values = new string[] { begin, end, y.ToString(), y1.ToString() };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_search_patient_visit_select_2", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
dataGridView1.Visible = true;
con1.CloseConnection();
DataGridViewTextBoxColumn tex1 = new DataGridViewTextBoxColumn();
tex1.HeaderText = "كود_المريض";
dataGridView1.Columns.Add(tex1);
DataGridViewTextBoxColumn tex2 = new DataGridViewTextBoxColumn();
tex2.HeaderText = "اسم_المريض";
dataGridView1.Columns.Add(tex2);
dataGridView1.DataSource = dt;
dr.Close();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = textBox1.Text;
dataGridView1.Rows[i].Cells[1].Value = textBox4.Text;
}
}
else if (textBox2.Text == "" && textBox5.Text == "")
{
/*create procedure clinic_search_patient_visit_select_3(@begin date, @end date, @pid int, @d_code int)
* as
* begin
* select distinct num_of_visit, start_date,service_name,english_name, doc_name
* from clinic, doctor, patient_visit,treat_patient,shift_time
* where clinic_code = shift_time.c_code and doctor_id = d_id and shift_time.c_code = treat_patient.c_code
* and p_id = pid and p_id = pid and start_date between @begin and @end and d_id = @d_code and start_date = start_time;
* end
*
*/
con1.OpenConection();
int y = Convert.ToInt32(textBox1.Text);
int y1 = Convert.ToInt32(textBox3.Text);
types = new SqlDbType[] { SqlDbType.Date, SqlDbType.Date, SqlDbType.Int, SqlDbType.Int };
name_input = new string[] { "@pid", "@begin", "@end", "@d_code" };
values = new string[] { y.ToString(), begin, end, y1.ToString() };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_search_patient_visit_select_3", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
dataGridView1.Visible = true;
con1.CloseConnection();
DataGridViewTextBoxColumn tex1 = new DataGridViewTextBoxColumn();
tex1.HeaderText = "كود_المريض";
dataGridView1.Columns.Add(tex1);
DataGridViewTextBoxColumn tex2 = new DataGridViewTextBoxColumn();
tex2.HeaderText = "اسم_المريض";
dataGridView1.Columns.Add(tex2);
dataGridView1.DataSource = dt;
dr.Close();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = textBox1.Text;
dataGridView1.Rows[i].Cells[1].Value = textBox4.Text;
}
}
else
{
/*create procedure clinic_search_patient_visit_select_4(@begin date, @end date, @pid int, @d_code int, @c_code int)
* as
* begin
* select distinct num_of_visit, start_date ,service_name ,english_name , doc_name
* from clinic, doctor, patient_visit,treat_patient,shift_time
* where clinic_code = shift_time.c_code and doctor_id = d_id and shift_time.c_code = treat_patient.c_code
* and p_id = pid and p_id = pid and start_date between @begin and @end and d_id =@d_code and treat_patient.c_code = @c_code and start_date = start_time;
* end
*
*
*/
//cmd = new SqlCommand();
//cmd.Connection = con;
////cmd.CommandText = "select distinct num_of_visit as رقم_الزيارة, start_date as تاريخ_الخدمة ,service_name as اسم_الخدمة ,english_name as اسم_العيادة, doc_name as اسم_الدكتور from clinic, doctor, patient_visit,treat_patient,shift_time where clinic_code = shift_time.c_code and doctor_id = d_id and shift_time.c_code = treat_patient.c_code and p_id = pid and p_id = " + int.Parse(textBox1.Text) + " and start_date between '" + begin + "' and '" + end + "' and d_id = " + int.Parse(textBox3.Text) + " and treat_patient.c_code = " + int.Parse(textBox2.Text) + " and start_date = start_time;";
//cmd.CommandText = "clinic_search_patient_visit_select_4";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@pid", int.Parse(textBox1.Text));
//cmd.Parameters.AddWithValue("@begin", begin);
//cmd.Parameters.AddWithValue("@end", end);
//cmd.Parameters.AddWithValue("@d_code", int.Parse(textBox3.Text));
//cmd.Parameters.AddWithValue("@c_code", int.Parse(textBox2.Text));
//dr = cmd.ExecuteReader();
//cmd.Parameters.RemoveAt("@pid");
//cmd.Parameters.RemoveAt("@begin");
//cmd.Parameters.RemoveAt("@end");
//cmd.Parameters.RemoveAt("@d_code");
//cmd.Parameters.RemoveAt("@c_code");
con1.OpenConection();
int y = Convert.ToInt32(textBox1.Text);
int y2 = Convert.ToInt32(textBox2.Text);
int y3 = Convert.ToInt32(textBox3.Text);
types = new SqlDbType[] { SqlDbType.Date, SqlDbType.Date, SqlDbType.Int, SqlDbType.Int };
name_input = new string[] { "@pid", "@begin", "@end", "@d_code", "@c_code" };
values = new string[] { y.ToString(), begin, end, y3.ToString(), y2.ToString() };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_search_patient_visit_select_4", name_input, values, types);
dt = new DataTable();
dt.Load(dr);
//dataGridView1.ColumnHeadersVisible = false;
dataGridView1.Visible = true;
con1.CloseConnection();
DataGridViewTextBoxColumn tex1 = new DataGridViewTextBoxColumn();
tex1.HeaderText = "كود_المريض";
dataGridView1.Columns.Add(tex1);
DataGridViewTextBoxColumn tex2 = new DataGridViewTextBoxColumn();
tex2.HeaderText = "اسم_المريض";
dataGridView1.Columns.Add(tex2);
dataGridView1.DataSource = dt;
dr.Close();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
dataGridView1.Rows[i].Cells[0].Value = textBox1.Text;
dataGridView1.Rows[i].Cells[1].Value = textBox4.Text;
}
}
}
}
private void حفظ_Click(object sender, EventArgs e)
{
label11.Visible = true;
label11.Text = textBox2.Text;
label12.Visible = true;
label12.Text = textBox6.Text;
label13.Visible = true;
label13.Text = dateTimePicker1.Text;
label14.Visible = true;
label14.Text = textBox3.Text;
con.OpenConection();
DateTime tm1 = dateTimePicker2.Value;
string t1 = tm1.Hour.ToString() + ':' + tm1.Minute.ToString();
DateTime dt = dateTimePicker1.Value;
string d = dateTimePicker1.Value.ToString("yyyy-MM-dd");
DateTime tm2 = dateTimePicker3.Value;
string t2 = tm2.Hour.ToString() + ':' + tm2.Minute.ToString();
try
{
//create procedure setescope_setescope_operation_select_id(@dt nvarchar(30),@st nvarchar(30),@endo int)
//as
//begin
//select id from setescope_operation where Datee=@dt and start_time=@st and EndoscopeCode=@endo;
//end
con.CloseConnection();
string[] pramnam = new string[3];
string[] pramvalu = new string[3];
SqlDbType[] pramtyp = new SqlDbType[3];
pramnam[0] = "@dt";
pramnam[1] = "@st";
pramnam[2] = "@endo";
pramvalu[0] = d;
pramvalu[1] = t1;
pramvalu[2] = textBox2.Text;
pramtyp[0] = SqlDbType.VarChar;
pramtyp[1] = SqlDbType.VarChar;
pramtyp[2] = SqlDbType.Int;
con.OpenConection();
SqlDataReader dr = con.ShowDataInGridViewUsingStoredProcDR("setescope_setescope_operation_select_id", pramnam, pramvalu, pramtyp);
while (dr.Read())
{
int id_op_prev = Convert.ToInt32(dr[0].ToString());
}
if (!dr.HasRows)
{
con.CloseConnection();
con.OpenConection();
string[] pramname = new string[6];
string[] pramvalue = new string[6];
SqlDbType[] pramtype = new SqlDbType[6];
pramname[0] = "@st";
pramname[1] = "@dt";
pramname[2] = "@et";
pramname[3] = "@p";
pramname[4] = "@endc";
pramname[5] = "@p_id";
pramvalue[0] = t1;
pramvalue[1] = d;
pramvalue[2] = t2;
pramvalue[3] = s;
pramvalue[4] = textBox2.Text;
pramvalue[5] = طلب_حجز_منظار.c.ToString();
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
pramtype[2] = SqlDbType.VarChar;
pramtype[3] = SqlDbType.VarChar;
pramtype[4] = SqlDbType.Int;
pramtype[5] = SqlDbType.Int;
//create procedure setescope_setescope_operation_insert(@st nvarchar(30),@dt nvarchar(30),@et nvarchar(30),@p nvarchar(30),@endc int,@p_id int)
// as
// begin
// insert into setescope_operation(start_time,Datee,end_time,piroirty_order,EndoscopeCode,patient_id) values(@st,@dt,@et,@p,@endc,@p_id);
// end
con.OpenConection();
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("setescope_setescope_operation_insert", pramname, pramvalue, pramtype);
con.CloseConnection();
//create procedure setescope_setescope_operation_select_id(@dt nvarchar(30),@st nvarchar(30),@endo int)
// as
// begin
// select id from setescope_operation where Datee=@dt and start_time=@st and EndoscopeCode=@endo;
// end
con.OpenConection();
dr = con.ShowDataInGridViewUsingStoredProcDR("setescope_setescope_operation_select_id", pramnam, pramvalu, pramtyp);
int id_op = 0;
while (dr.Read())
{
id_op = Convert.ToInt32(dr[0].ToString());
}
con.CloseConnection();
con.OpenConection();
string[] pramna = new string[2];
string[] pramval = new string[2];
SqlDbType[] pramty = new SqlDbType[2];
pramna[0] = "@oper_id";
pramna[1] = "@doctor_id";
pramval[0] = id_op.ToString();
pramval[1] = textBox4.Text;
pramty[0] = SqlDbType.Int;
pramty[1] = SqlDbType.Int;
//create procedure setescope_doctor_operation_insert(@oper_id int,@doctor_id int)
// as
// begin
// insert into doctor_operation(id_op,Do_id) values(@oper_id,@doctor_id);
// end
int rfd = con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("setescope_doctor_operation_insert", pramna, pramval, pramty);
MessageBox.Show("تمت العملية بنجاح");
con.CloseConnection();
}
else
{
MessageBox.Show("توجد عملية في هذا الوقت");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// send details about the visit of patient
private void visit_details(object sender, DataGridViewCellEventArgs e)
{
string n = dataGridView2.Rows[e.RowIndex].Cells[0].Value.ToString();
rectangleShape2.Visible = true;
rectangleShape1.Visible = true;
//create procedure visit_detail(@x int,@y int)
// as
// select type_of_visit,ordere,patient_status from entranceoffice_visit where visit_id=@x;
// select CE_AName from tb_Contracting_Entities ,Registeration_patientRegisteration where catogrical_code=CE_Id and patient_id=@y;
// select r_id,degree,floor details from room,entranceoffice_visit where r_id=room_id and visit_id=@x;
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int };
name_input = new string[] { "@x", "@y" };
values = new string[] { n, x1 };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("visit_detail", name_input, values, types);
dr.Read();
string type_visit = dr[0].ToString();
string order = dr[1].ToString();
label31.Text = dr[2].ToString();
dr.NextResult(); dr.Read();
string geha = dr[0].ToString();
dr.NextResult(); dr.Read();
label27.Text = dr[0].ToString() + " /" + dr[2].ToString();
label29.Text = dr[1].ToString();
dr.Close();
label19.Text = order;
label17.Text = type_visit;
label23.Text = geha;
label2.Visible = true;
label17.Visible = true;
label16.Visible = true;
label18.Visible = true;
label19.Visible = true;
label22.Visible = true;
label23.Visible = true;
if (type_visit == "خارجي")
{
label24.Visible = true;
label25.Visible = true;
label26.Visible = false;
label27.Visible = false;
label28.Visible = false;
label29.Visible = false;
label30.Visible = false;
label31.Visible = false;
}
else
{
label24.Visible = false;
label25.Visible = false;
label26.Visible = true;
label27.Visible = true;
label28.Visible = true;
label29.Visible = true;
label30.Visible = true;
label31.Visible = true;
}
}
private void monthCalendar1_DateSelected_1(object sender, DateRangeEventArgs e)
{
int c = 0;
for (int j = 0; j < tableLayoutPanel1.RowCount; j++)
{
for (int i = 0; i < tableLayoutPanel1.ColumnCount; i++)
{
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(i, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(i, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(i, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(i, j));
}
}
date = monthCalendar1.SelectionRange.Start.ToShortDateString();
DateTime dtm = Convert.ToDateTime(date);
d = dtm.Year.ToString() + '-' + dtm.Month.ToString() + '-' + dtm.Day.ToString();
try
{
/*
* create procedure setescope_select_dat(@x nvarchar(50),@end_name nvarchar(50))
*
* as
* begin
* select o.Datee,o.start_time,o.end_time,o.flag
* from setescope_operation o,Endoscope_settings_data e
* where o.Datee = @x and e.EndoscopeCode=o.EndoscopeCode and e.EndoscopeName=@end_name;
*
* select p.id,p.name from
* patient_endo p ,setescope_operation s,Endoscope_settings_data e
* where p.id=s.patient_id and s.Datee = @x and e.EndoscopeCode=s.EndoscopeCode and e.EndoscopeName=@end_name;
*
* select e.EndoscopeName from Endoscope_settings_data e,setescope_operation s
* where e.EndoscopeCode=s.EndoscopeCode and e.EndoscopeName=@end_name;
*
* select d.name
* from doctors d,doctor_operation o,setescope_operation s,Endoscope_settings_data e
* where o.Do_id=d.Do_id and o.id_op=s.id and s.Datee = @x and e.EndoscopeCode=s.EndoscopeCode and e.EndoscopeName=@end_name and d.jop='surgeon' ;
* end
*
*/
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@x", "@end_name", "@s" };
values = new string[] { d, endo, p1.Controls[0].Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_select_dat", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count != 0)
{
c++;
}
for (int i = 0; i < dt.Rows.Count; i += 4)
{
this.tableLayoutPanel1.AutoSize = true;
temp = tableLayoutPanel1.RowStyles[0];
this.tableLayoutPanel1.RowStyles.Add(new RowStyle(temp.SizeType, temp.Height));
tableLayoutPanel1.RowCount++;
}
if (c != 0)
{
tableLayoutPanel1.RowCount--;
}
int n = 0;
for (int j = 0; j < tableLayoutPanel1.RowCount; j++)
{
int i = 0;
for (i = 0; i < tableLayoutPanel1.ColumnCount; i++)
{
if (i + n < dt.Rows.Count)
{
p = new Panel();
p.Click += p_Click;
p.Size = new System.Drawing.Size(149, 101);
p.Location = new Point(250, 9);
p.BorderStyle = BorderStyle.FixedSingle;
p.BackColor = Color.AliceBlue;
p.Visible = true;
this.tableLayoutPanel1.Controls.Add(p, i, j);
l1 = new Label();
l1.Text = dt.Rows[i + n][1].ToString();
l1.AutoSize = false;
l1.Left = 45;
l1.Top = 3;
p.Controls.Add(l1);
l2 = new Label();
l2.Text = dt.Rows[i + n][2].ToString();
l2.AutoSize = false;
l2.Left = -50;
l2.Top = 3;
p.Controls.Add(l2);
l3 = new Label();
l3.Text = dt.Rows[i][0].ToString();
l3.AutoSize = false;
l3.Left = -20;
l3.Top = l1.Height;
p.Controls.Add(l3);
l4 = new Label();
l4.Text = dt.Rows[i][1].ToString();
l4.AutoSize = false;
l4.Left = -10;
l4.Top = l3.Height + 20;
p.Controls.Add(l4);
l5 = new Label();
l5.Text = dt.Rows[i][0].ToString();
l5.AutoSize = false;
l5.Left = 15;
l5.Top = l4.Height + 40;
p.Controls.Add(l5);
l6 = new Label();
l6.Text = dt.Rows[i][0].ToString();
l6.AutoSize = false;
l6.Left = -5;
l6.Top = l5.Height + 60;
doc = l6.Text;
//create procedure setescope_do_id(@x nvarchar(50))
// as
// select doc_ssn from doctors where name=@x
//cmd = new SqlCommand("setescope_do_id ", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@x", l6.Text);
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@x" };
values = new string[] { l6.Text };
SqlDataReader dhr;
dhr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_do_id", name_input, values, types);
dhr.Read();
doc_id = int.Parse(dhr[0].ToString());
dhr.Close();
p.Controls.Add(l6);
flag = dt.Rows[i + n][3].ToString();
lshape = new Label();
lshape.Text = "";
lshape.AutoSize = false;
lshape.Size = new System.Drawing.Size(20, 20);
if (flag == "7agz")
{
lshape.BackColor = Color.Yellow;
}
else if (flag == "taked")
{
lshape.BackColor = Color.Green;
}
else if (flag == "start")
{
lshape.BackColor = Color.Cyan;
}
else if (flag == "finish")
{
lshape.BackColor = Color.Blue;
}
lshape.BorderStyle = BorderStyle.FixedSingle;
lshape.Left = 110;
lshape.Top = l1.Height;
p.Controls.Add(lshape);
}
else
{
break;
}
}
if (i == dt.Rows.Count)
{
break;
}
else
{
n += 4;
}
}
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
dt.Rows.RemoveAt(i);
}
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
dt.Rows.RemoveAt(i);
}
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
dt.Rows.RemoveAt(i);
}
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
dt.Rows.RemoveAt(i);
}
}
catch (Exception v) { MessageBox.Show(v.Message); }
finally
{
con1.CloseConnection();
}
}
// send details about the visit of patient
private void visit_details(object sender, DataGridViewCellEventArgs e)
{
string n = dataGridView2.Rows[e.RowIndex].Cells[0].Value.ToString();
rectangleShape2.Visible = true;
rectangleShape1.Visible = true;
/*
* create procedure visit_detail(@x int,@y int)
* as
* select Type,ordere,patient_status from Patient_visit where num_Of_visit=@x;
* select ins_name from institution ,patient where Institution=ins_code and patient_id=@y;
* select r_id,degree,floor from room,patient_visit where r_id=room_id and num_Of_visit=@x;
*
*/
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int };
name_input = new string[] { "@x", "@y" };
values = new string[] { n, x1 };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("visit_detail", name_input, values, types);
dr.Read();
string type_visit = dr[0].ToString();
string order = dr[1].ToString();
label31.Text = dr[2].ToString();
dr.NextResult(); dr.Read();
string geha = dr[0].ToString();
dr.NextResult(); dr.Read();
label27.Text = dr[0].ToString() + " /" + dr[2].ToString();
label29.Text = dr[1].ToString();
dr.Close();
label19.Text = order;
label17.Text = type_visit;
label23.Text = geha;
label2.Visible = true;
label17.Visible = true;
label16.Visible = true;
label18.Visible = true;
label19.Visible = true;
label22.Visible = true;
label23.Visible = true;
if (type_visit == "خارجي")
{
label24.Visible = true;
label25.Visible = true;
label26.Visible = false;
label27.Visible = false;
label28.Visible = false;
label29.Visible = false;
label30.Visible = false;
label31.Visible = false;
}
else
{
label24.Visible = false;
label25.Visible = false;
label26.Visible = true;
label27.Visible = true;
label28.Visible = true;
label29.Visible = true;
label30.Visible = true;
label31.Visible = true;
}
}
private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
selected = listBox1.SelectedItem.ToString();
if (selected == "تخدير")
{
if (tableLayoutPanel1.RowCount > 1)
{
for (int j = tableLayoutPanel1.RowCount - 1; j > 0; j--)
{
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(0, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(1, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(2, j));
tableLayoutPanel1.RowStyles.RemoveAt(j);
tableLayoutPanel1.RowCount--;
}
}
con1.OpenConection();
//create procedure select_docs(@id int,@type nvarchar(50))
//as
//select d.Do_id, d.name from doctor_operation o,doctors d where o.id_op=@id and o.Do_id=d.Do_id and jop=@type;
//cmd = new SqlCommand("select_docs", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid));
//cmd.Parameters.AddWithValue("@type", "Anesthesia");
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar };
name_input = new string[] { "@id", "@type" };
values = new string[] { "Anesthesia", الصفحه_الرئيسيه_للمنظار.opid };
dr = con1.ShowDataInGridViewUsingStoredProcDR("select_docs", name_input, values, types);
DataTable dt1 = new DataTable();
dt1.Load(dr);
int i;
for (i = 0; i < dt1.Rows.Count; i++)
{
if (i == 0)
{
textBox1.Text = dt1.Rows[0][0].ToString();
textBox2.Text = dt1.Rows[0][1].ToString();
l1.Add(textBox1.Text);
}
else
{
t1 = new TextBox();
t2 = new TextBox();
b1 = new Button();
b1.Click += b1_Click;
t1.Size = textBox1.Size;
t1.Location = textBox1.Location;
t1.Font = textBox1.Font;
t2.Size = textBox2.Size;
t2.Location = textBox2.Location;
t2.Font = textBox2.Font;
b1.Size = button1.Size;
b1.Location = button1.Location;
b1.BackgroundImage = button1.BackgroundImage;
b1.Margin = button1.Margin;
this.tableLayoutPanel1.AutoSize = true;
if (tableLayoutPanel1.RowCount > 0)
{
temp = tableLayoutPanel1.RowStyles[0];
}
else
{
temp = temp1;
}
this.tableLayoutPanel1.RowStyles.Add(new RowStyle(temp.SizeType, temp.Height));
tableLayoutPanel1.RowCount++;
this.tableLayoutPanel1.Controls.Add(t1, 2, i);
this.tableLayoutPanel1.Controls.Add(b1, 1, i);
this.tableLayoutPanel1.Controls.Add(t2, 0, i);
t1.Text = dt1.Rows[i][0].ToString();
t2.Text = dt1.Rows[i][1].ToString();
l1.Add(t1.Text);
}
}
rowIndex = i;
dr.Close();
con1.CloseConnection();
}
if (selected == "جراح مساعد")
{
if (tableLayoutPanel1.RowCount > 1)
{
for (int j = tableLayoutPanel1.RowCount - 1; j > 0; j--)
{
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(0, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(1, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(2, j));
tableLayoutPanel1.RowStyles.RemoveAt(j);
tableLayoutPanel1.RowCount--;
}
}
con1.OpenConection();
//create procedure select_docs(@id int,@type nvarchar(50))
//as
//select d.Do_id, d.name from doctor_operation o,doctors d where o.id_op=@id and o.Do_id=d.Do_id and jop=@type;
//cmd = new SqlCommand("select_docs", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid));
//cmd.Parameters.AddWithValue("@type", "surgeon");
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar };
name_input = new string[] { "@id", "@type" };
values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, "surgeon" };
dr = con1.ShowDataInGridViewUsingStoredProcDR("select_docs", name_input, values, types);
DataTable dt2 = new DataTable();
dt2.Load(dr);
int i;
for (i = 1; i < dt2.Rows.Count; i++)
{
if (i == 1)
{
textBox1.Text = dt2.Rows[1][0].ToString();
textBox2.Text = dt2.Rows[1][1].ToString();
l2.Add(textBox1.Text);
}
else
{
t1 = new TextBox();
t2 = new TextBox();
b1 = new Button();
b1.Click += b1_Click;
t1.Size = textBox1.Size;
t1.Location = textBox1.Location;
t1.Font = textBox1.Font;
t2.Size = textBox2.Size;
t2.Location = textBox2.Location;
t2.Font = textBox2.Font;
b1.Size = button1.Size;
b1.Location = button1.Location;
b1.BackgroundImage = button1.BackgroundImage;
b1.Margin = button1.Margin;
this.tableLayoutPanel1.AutoSize = true;
if (tableLayoutPanel1.RowCount > 0)
{
temp = tableLayoutPanel1.RowStyles[0];
}
else
{
temp = temp1;
}
this.tableLayoutPanel1.RowStyles.Add(new RowStyle(temp.SizeType, temp.Height));
tableLayoutPanel1.RowCount++;
this.tableLayoutPanel1.Controls.Add(t1, 2, i - 1);
this.tableLayoutPanel1.Controls.Add(b1, 1, i - 1);
this.tableLayoutPanel1.Controls.Add(t2, 0, i - 1);
t1.Text = dt2.Rows[i][0].ToString();
t2.Text = dt2.Rows[i][1].ToString();
l2.Add(t1.Text);
}
}
rowIndex = i - 1;
dr.Close();
con1.CloseConnection();
}
if (selected == "تمريض")
{
if (tableLayoutPanel1.RowCount > 1)
{
for (int j = tableLayoutPanel1.RowCount - 1; j > 0; j--)
{
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(0, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(1, j));
tableLayoutPanel1.Controls.Remove(tableLayoutPanel1.GetControlFromPosition(2, j));
tableLayoutPanel1.RowStyles.RemoveAt(j);
tableLayoutPanel1.RowCount--;
}
}
con1.OpenConection();
// create procedure select_docs(@id int,@type nvarchar(50))
//as
//select d.Do_id, d.name from doctor_operation o,doctors d where o.id_op=@id and o.Do_id=d.Do_id and jop=@type;
//cmd = new SqlCommand("select_docs", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@id", Convert.ToInt32(الصفحه_الرئيسيه_للمنظار.opid));
//cmd.Parameters.AddWithValue("@type", "Nursing");
//da3= new SqlDataAdapter(cmd);
//DataSet ds3 = new DataSet();
//da3.Fill(ds3);
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar };
name_input = new string[] { "@id", "@type" };
values = new string[] { الصفحه_الرئيسيه_للمنظار.opid, "Nursing" };
dr = con1.ShowDataInGridViewUsingStoredProcDR("select_docs", name_input, values, types);
DataTable dt3 = new DataTable();
dt3.Load(dr);
int i;
for (i = 0; i < dt3.Rows.Count; i++)
{
if (i == 0)
{
textBox1.Text = dt3.Rows[0][0].ToString();
textBox2.Text = dt3.Rows[0][1].ToString();
l3.Add(textBox1.Text);
}
else
{
t1 = new TextBox();
t2 = new TextBox();
b1 = new Button();
b1.Click += b1_Click;
t1.Size = textBox1.Size;
t1.Location = textBox1.Location;
t1.Font = textBox1.Font;
t2.Size = textBox2.Size;
t2.Location = textBox2.Location;
t2.Font = textBox2.Font;
b1.Size = button1.Size;
b1.Location = button1.Location;
b1.BackgroundImage = button1.BackgroundImage;
b1.Margin = button1.Margin;
this.tableLayoutPanel1.AutoSize = true;
if (tableLayoutPanel1.RowCount > 0)
{
temp = tableLayoutPanel1.RowStyles[0];
}
else
{
temp = temp1;
}
this.tableLayoutPanel1.RowStyles.Add(new RowStyle(temp.SizeType, temp.Height));
tableLayoutPanel1.RowCount++;
this.tableLayoutPanel1.Controls.Add(t1, 2, i);
this.tableLayoutPanel1.Controls.Add(b1, 1, i);
this.tableLayoutPanel1.Controls.Add(t2, 0, i);
t1.Text = dt3.Rows[i][0].ToString();
t2.Text = dt3.Rows[i][1].ToString();
l3.Add(t1.Text);
}
}
rowIndex = i;
dr.Close();
con1.CloseConnection();
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_select
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor
* end
* */
//con.Open();
//cmd.Connection = con;
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_select";
//cmd.CommandType = CommandType.StoredProcedure;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor";
//dr = cmd.ExecuteReader();
con1.OpenConection();
dr = con1.DataReader("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_select");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text != "" && (textBox2.Text == "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_id_select(@id int)
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doctor_id=@id
* end
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doctor_id='" + textBox1.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_id_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@id", SqlDbType.Int).Value = textBox1.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@id" };
values = new string[] { textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_id_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox2.Text != "" && (textBox1.Text == "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_select(@name nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%'+@name+'%'
* end
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name='" + textBox2.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@name" };
values = new string[] { textBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox3.Text != "" && (textBox1.Text == "" && (textBox2.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_sepciality_select(@sep nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where specialization like N'%'+@sep+'%'
* end
*
*
* */
// con.Open();
// cmd.Connection = con;
//// cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where specialization='" + textBox3.Text + "'";
// cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_sepciality_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@sep" };
values = new string[] { textBox3.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_sepciality_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (comboBox1.Text != "" && (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && comboBox2.Text == ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_select(@job nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type like N'%'+@job+'%'
* end
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type='" + comboBox1.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@job" };
values = new string[] { comboBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (comboBox2.Text != "" && (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && comboBox1.Text == ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_degree_select(@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where degree like N'%'+@deg+'%'
* end
*
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where degree='" + comboBox2.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_degree_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@deg" };
values = new string[] { comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_degree_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text != "" && (textBox2.Text != "" || (textBox3.Text != "" || (comboBox1.Text != "" || comboBox2.Text != ""))))
{
// con.Open();
// cmd.Connection = con;
//// cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doctor_id='" + textBox1.Text + "'";
// cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_id_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@id", SqlDbType.Int).Value = textBox1.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@id" };
values = new string[] { textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_id_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text != "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_sep_select(@name nvarchar(50),@sep nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%' + @name + '%' and specialization like N'%' + @sep + '%';
* end
*
*/
// con.Open();
// cmd.Connection = con;
//// cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name='" + textBox2.Text + "' and specialization='" + textBox3.Text + "'";
// cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_sep_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
// cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@name", "@sep" };
values = new string[] { textBox2.Text, textBox3.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_sep_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text == "" && (comboBox1.Text != "" && comboBox2.Text == ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_select(@name nvarchar(50),@job nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%'+@name+'%' and job_type like N'%'+@job+'%'
* end
*
*/
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name='" + textBox2.Text + "' and job_type='" + comboBox1.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
//cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@name", "@job" };
values = new string[] { textBox2.Text, comboBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text != ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_degree_select(@name nvarchar(50),@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%'+@name+'%' and degree like N'%'+@deg+'%'
* end
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name='" + textBox1.Text + "' and degree='" + comboBox2.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_degree_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
//cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@name", "@deg" };
values = new string[] { textBox2.Text, comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_degree_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text == ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_sep_select(@job nvarchar(50),@sep nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type like N'%'+@job+'%' and specialization like N'%'+@sep+'%'
* end
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type='" + comboBox1.Text + "' and specialization='" + textBox3.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_sep_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
//cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@job", "@sep" };
values = new string[] { comboBox1.Text, textBox3.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_sep_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_deg_select(@job nvarchar(50),@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type like N'%'+@job+'%' and degree like N'%'+@deg+'%'
* end
*
* */
// con.Open();
// cmd.Connection = con;
//// cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type='" + comboBox1.Text + "' and degree='" + comboBox2.Text + "'";
// cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_deg_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
// cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@job", "@deg" };
values = new string[] { comboBox1.Text, comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_deg_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text != "" && (comboBox1.Text == "" && comboBox2.Text != ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_sep_deg_select(@sep nvarchar(50),@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where specialization like N'%'+@sep+'%' and degree like N'%'+@deg+'%'
* end
*/
// con.Open();
// cmd.Connection = con;
//// cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where specialization='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'";
// cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_sep_deg_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
// cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@sep", "@deg" };
values = new string[] { textBox3.Text, comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_sep_deg_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text == ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_sep_select(@name nvarchar(50),@job nvarchar(50),@sep nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%'+@name+'%' and job_type like N'%'+@job+'%' and specialization like N'%'+@sep+'%'
* end
*
* */
// con.Open();
// cmd.Connection = con;
//// cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name='" + textBox2.Text + "' and job_type='" + comboBox1.Text + "' and specialization='" + textBox3.Text + "'";
// cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_sep_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
// cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
// cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@name", "@job", "@sep" };
values = new string[] { textBox2.Text, comboBox1.Text, textBox3.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_sep_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text == "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
/*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_deg_select(@name nvarchar(50),@job nvarchar(50),@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%'+@name+'%' and job_type like N'%'+@job+'%' and degree like N'%'+@deg+'%'
* end
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name='" + textBox2.Text + "' and job_type='" + comboBox1.Text + "' and degree='" + comboBox2.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_deg_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
//cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
//cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@name", "@job", "@deg" };
values = new string[] { textBox2.Text, comboBox1.Text, comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_deg_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_sep_deg_select(@job nvarchar(50),@sep nvarchar(50),@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type like N'%'+@job+'%' and specialization like N'%'+@sep+'%' and degree like N'%'+@deg+'%'
* end
*
*
*/
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where job_type='" + comboBox1.Text + "' and specialization='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_sep_deg_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
//cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
//cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@job", "@sep", "@deg" };
values = new string[] { comboBox1.Text, textBox3.Text, comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_job_sep_deg_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
/*
*
* create procedure clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_sep_deg_select(@name nvarchar(50),@job nvarchar(50),@sep nvarchar(50),@deg nvarchar(50))
* as
* begin
* select doctor_id as 'الكود', doc_name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , specialization as 'التخصص' from doctor where doc_name like N'%'+@name+'%' and job_type like N'%'+@job+'%' and specialization like N'%'+@sep+'%' and degree like N'%'+@deg+'%'
* end
*
* */
//con.Open();
//cmd.Connection = con;
////cmd.CommandText = "select code as 'الكود', name as 'الاسم' , job_type as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctor where name='" + textBox2.Text + "' and job_type='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'";
//cmd.CommandText = "clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_sep_deg_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@name", SqlDbType.NVarChar).Value = textBox2.Text;
//cmd.Parameters.Add("@job", SqlDbType.NVarChar).Value = comboBox1.Text;
//cmd.Parameters.Add("@sep", SqlDbType.NVarChar).Value = textBox3.Text;
//cmd.Parameters.Add("@deg", SqlDbType.NVarChar).Value = comboBox2.Text;
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@name", "@job", "@sep", "@deg" };
values = new string[] { textBox2.Text, comboBox1.Text, textBox3.Text, comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_بحث_فريق_العمل_الطبى_doctor_name_job_sep_deg_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
}
private void dataGridView3_CellClick(object sender, DataGridViewCellEventArgs e)
{
x5 = dataGridView3.Rows[e.RowIndex].Cells[0].Value.ToString();
x6 = dataGridView3.Rows[e.RowIndex].Cells[1].Value.ToString();
if (x3 == null)
{
x4 = x2;
/*
* create procedure clinic_select_sus(@x nvarchar(20))
* as
* select * from sub_institution where sub_name=@x;
*
*/
//cmd = new SqlCommand("clinic_select_sus", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@x", x4);
// dr = cmd.ExecuteReader();
//create procedure clinic_select_sus(@x nvarchar(20))
// as
// select * from tb_Entities_Branches where EB_Aname=@x;
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@x" };
values = new string[] { x4 };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_select_sus", name_input, values, types);
while (dr.Read())
{
x3 = dr["sub_code"].ToString();
}
}
/*create procedure clinic_select_current_date
* as
* select GETDATE() ;
* exec clinic_select_current_date;
*
*/
//cmd.Connection = con;
//con.Open();
//cmd = new SqlCommand("clinic_select_current_date", con);
//cmd.CommandType = CommandType.StoredProcedure;
//drr2 = cmd.ExecuteReader();
//drr2.Read();
//dt = drr2[0].ToString();
//drr2.Close();
con1.OpenConection();
drr2 = con1.DataReader("clinic_select_current_date");
drr2.Read();
dt = drr2[0].ToString();
drr2.Close();
تعديل_الفئه_الماليه_للمريض_الخارجى ff6 = new تعديل_الفئه_الماليه_للمريض_الخارجى();
ff6.Focus();
this.DialogResult = DialogResult.OK;
ff6.Focus();
}
private void button1_Click_1(object sender, EventArgs e)
{
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
con1.OpenConection();
/*
* create procedure doc_detail1
* as
* select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo
*
*
*/
//cmd = new SqlCommand("doc_detail1", con);
//cmd.CommandType = CommandType.StoredProcedure;
//dr = cmd.ExecuteReader();
dr = con1.DataReader("doc_detail1");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text != "" && (textBox2.Text == "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
con1.OpenConection();
/*
* create procedure doc_detail3(@id int)
* as
* select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo where Do_id=@id
*
*
*/
//cmd = new SqlCommand("doc_detail3", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@id", Convert.ToInt32(textBox1.Text));
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@id" };
values = new string[] { textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_detail3", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox2.Text != "" && (textBox1.Text == "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
con1.OpenConection();
/*
* create procedure doc_detail(@n nvarchar(50))
* as
* select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo where name like N''+@n+'%'
*
*
*/
//cmd = new SqlCommand("doc_detail", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@n", textBox2.Text);
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@n" };
values = new string[] { textBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_detail", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox3.Text != "" && (textBox1.Text == "" && (textBox2.Text == "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
con1.OpenConection();
// create procedure doc_special(@spec nvarchar(50))
//as
//select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo where speciality like N''+@spec+'%'
//cmd = new SqlCommand("doc_special", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@spec", textBox3.Text);
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@spec" };
values = new string[] { textBox3.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_special", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (comboBox1.Text != "" && (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && comboBox2.Text == ""))))
{
con1.OpenConection();
/*
* create procedure doc_jop(@jop nvarchar(50))
* as
* select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo where jop =@jop
*
*
*/
//cmd = new SqlCommand("doc_jop", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@jop", comboBox1.Text);
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@jop" };
values = new string[] { comboBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_jop", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (comboBox2.Text != "" && (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && comboBox1.Text == ""))))
{
con1.OpenConection();
//create procedure doc_degree(@deg nvarchar(50))
//as
//select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo where degree=@deg
//cmd = new SqlCommand("doc_degree", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@deg", comboBox2.Text);
// dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@deg" };
values = new string[] { comboBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_degree", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text != "" && (textBox2.Text != "" || (textBox3.Text != "" || (comboBox1.Text != "" || comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd = new SqlCommand("doc_detail3", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@id", Convert.ToInt32(textBox1.Text));
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@id" };
values = new string[] { comboBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_detail3", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text != "" && (comboBox1.Text == "" && comboBox2.Text == ""))))
{
con1.OpenConection();
/*
* create procedure doc_spe_name(@spec nvarchar(50),@n nvarchar(50))
* as
* select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors s_endo where name=@n and speciality=@spec
*
*
*/
//cmd = new SqlCommand("doc_spe_name, con",con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@n",textBox2.Text );
//cmd.Parameters.AddWithValue("@spec", textBox3.Text);
//dr = cmd.ExecuteReader();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@n", "@spec" };
values = new string[] { textBox2.Text, textBox3.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("doc_spe_name", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text == "" && (comboBox1.Text != "" && comboBox2.Text == ""))))
{
//con.Open();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text == "" && (comboBox1.Text == "" && comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox1.Text + "' and degree='" + comboBox2.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox1.Text + "' and degree='" + comboBox2.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text == ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text == "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where jop='" + comboBox1.Text + "' and degree='" + comboBox2.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where jop='" + comboBox1.Text + "' and degree='" + comboBox2.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text != "" && (comboBox1.Text == "" && comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text == ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text == "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "' and degree='" + comboBox2.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "' and degree='" + comboBox2.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text == "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && (textBox2.Text != "" && (textBox3.Text != "" && (comboBox1.Text != "" && comboBox2.Text != ""))))
{
con1.OpenConection();
//cmd.Connection = con;
//cmd.CommandText = "select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select Do_id as 'الكود', name as 'الاسم' , jop as 'نوع العمل' , degree as 'الفئة' , speciality as 'التخصص' from doctors where name='" + textBox2.Text + "' and jop='" + comboBox1.Text + "' and speciality='" + textBox3.Text + "' and degree='" + comboBox2.Text + "'");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
}
private void Form6_Load(object sender, EventArgs e)
{
//create procedure clinic_select_job_ins(@x int)
// as
// select job from Registeration_patientRegisteration where patient_id=@x ;
// select CE_Id ,CE_AName from tb_Contracting_Entities,Registeration_patientRegisteration where tb_Contracting_Entities.CE_Id=Registeration_patientRegisteration.catogrical_code and patient_id=@x;
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@x" };
values = new string[] { label10.Text };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_select_job_ins", name_input, values, types);
dr.Read();
label11.Text = dr[0].ToString();
dr.NextResult(); dr.Read();
s1 = dr[0].ToString();
s2 = dr[1].ToString();
dr.Close();
con1.CloseConnection();
// create procedure clinic_select_sub_family(@x int)
//as
//select EB_id ,EB_Aname from tab_Entities_Branches,Registeration_patientRegisteration where sub_institution=tb_Entities_Branches. EB_id and patient_id=@x ;
//select PC_id ,PC_Aname from tb_Patients_Categories,Registeration_patientRegisteration where family= PC_id and patient_id=@x;
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@x" };
values = new string[] { label10.Text };
SqlDataReader ddr2 = con1.ShowDataInGridViewUsingStoredProcDR("clinic_select_sub_family", name_input, values, types);
ddr2.Read();
s4 = ddr2[0].ToString();
s3 = ddr2[1].ToString();
ddr2.NextResult();
ddr2.Read(); s6 = ddr2[0].ToString();
s5 = ddr2[1].ToString();
ddr2.Close();
textBox1.Text = s1;
textBox2.Text = s2;
textBox3.Text = s3;
textBox4.Text = s4;
if (textBox4.Text == "0")
{
textBox4.Text = "";
}
textBox5.Text = s5;
textBox6.Text = s6;
label29.Visible = false;
label30.Visible = false;
label31.Visible = false;
label32.Visible = false;
label33.Visible = false;
label34.Visible = false;
label35.Visible = false;
}
private void button1_Click(object sender, EventArgs e)
{
//MessageBox.Show(code.ToString());
dataGridView1.Visible = true;
con1.OpenConection();
if (textBox1.Text == "" && textBox2.Text == "")
{
//create PROCEDURE setescope_search_operation_select_all
//as
//select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data ;
//cmd = new SqlCommand("select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data ;",con);
//cmd = new SqlCommand("setescope_search_operation_select_all", con);
//cmd.CommandType = CommandType.StoredProcedure;
dr = con1.DataReader("setescope_search_operation_select_all");
}
else
{
if (textBox1.Text != "")
{
// cmd = new SqlCommand("select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data where EndoscopeCode=" + textBox1.Text,con);
//cmd = new SqlCommand("setescope_search_operation_select_endosopecode", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@code", Convert.ToInt32(textBox1.Text));
//create PROCEDURE setescope_search_operation_select_endosopecode (@code int)
//as
//select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data where EndoscopeCode=@code ;
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@code" };
values = new string[] { textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_search_operation_select_endosopecode", name_input, values, types);
}
else if (textBox2.Text != "")
{
//cmd = new SqlCommand("select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data where EndoscopeName='" + textBox2.Text+"'",con);
//cmd = new SqlCommand("setescope_search_operation_select_aname", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@aname", SqlDbType.NVarChar).Value = textBox2.Text;
//create PROCEDURE setescope_search_operation_select_aname (@aname nvarchar(30))
//as
//select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data where EndoscopeName=@aname ;
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@aname" };
values = new string[] { textBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_search_operation_select_aname", name_input, values, types);
}
else
{
//cmd = new SqlCommand("select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data where EndoscopeCode=" + textBox1.Text + "and EndoscopeName=" + textBox2.Text, con);
//cmd = new SqlCommand("setescope_search_operation_select_endosopecode_and_aname", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.Add("@aname", SqlDbType.NVarChar).Value = textBox2.Text;
//cmd.Parameters.AddWithValue("@code", Convert.ToInt32(textBox1.Text));
//create PROCEDURE setescope_search_operation_select_endosopecode_and_aname (@code int,@aname nvarchar(30))
//as
//select EndoscopeCode as 'كود العمليه',EndoscopeName as 'اسم العمليه عربى',DescriptionLatino as 'اسم العمليه لاتينى' from Endoscope_settings_data where EndoscopeCode=@code and EndoscopeName=@aname ;
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.Int };
name_input = new string[] { "@aname", "@code" };
values = new string[] { textBox2.Text, textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("setescope_search_operation_select_endosopecode_and_aname", name_input, values, types);
}
}
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
dt = new DataTable();
dt.Load(dr);
dataGridView1.DataSource = dt;
dr.Close();
con1.CloseConnection();
}
//SqlConnection con;
//SqlCommand cmd;
private void حفظ_Click(object sender, EventArgs e)
{
DateTime tm1 = dateTimePicker2.Value;
string t1 = tm1.Hour.ToString() + ':' + tm1.Minute.ToString();
//MessageBox.Show(t);
DateTime dt = dateTimePicker1.Value;
string modifiedd = dt.Date.ToString("yyyy-MM-dd");
DateTime dnow = DateTime.Now.Date;
DateTime tm2 = dateTimePicker3.Value;
string t2 = tm2.Hour.ToString() + ':' + tm2.Minute.ToString();
if (textBox2.Text == "")
{
MessageBox.Show("يجب اختيار عملية");
}
else if (textBox4.Text == "")
{
MessageBox.Show("يجب اختيار طبيب");
}
//MessageBox.Show(بحث_عن_عملية_في_تاريخ_معين.id_op.ToString());
//MessageBox.Show(t);
else
{
if (بحث_عن_عملية_في_تاريخ_معين.id_op != 0)
{
if (dt >= dnow)
{
string[] pramname = new string[3];
string[] pramvalue = new string[3];
SqlDbType[] pramtype = new SqlDbType[3];
pramname[0] = "@dt";
pramname[1] = "@st";
pramname[2] = "@endo";
pramvalue[0] = modifiedd;
pramvalue[1] = t1;
pramvalue[2] = textBox2.Text;
pramtype[0] = SqlDbType.NVarChar;
pramtype[1] = SqlDbType.NVarChar;
pramtype[2] = SqlDbType.NVarChar;
con.OpenConection();
dr = con.ShowDataInGridViewUsingStoredProcDR("setescope_setescope_operation_select_id", pramname, pramvalue, pramtype);
//con.Open();
//cmd = new SqlCommand("setescope_setescope_operation_select_id", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@dt", modifiedd);
//cmd.Parameters.AddWithValue("@st", modifiedt);
//cmd.Parameters.AddWithValue("@ endo",textBox2.Text);
//dr = cmd.ExecuteReader();
while (dr.Read())
{
int id_op_prev = Convert.ToInt32(dr[0].ToString());
}
if (tm1 <= tm2)
{
if (!dr.HasRows)
{
dr.Close();
con.CloseConnection();
بحث_عن_عملية_في_تاريخ_معين f = new بحث_عن_عملية_في_تاريخ_معين();
con.OpenConection();
string[] pramna = new string[6];
string[] pramv = new string[6];
SqlDbType[] pramt = new SqlDbType[6];
pramna[0] = "@st";
pramna[1] = "@et";
pramna[2] = "@dt";
pramna[3] = "@endc";
pramna[4] = "@id_oper";
pramna[5] = "@d_id";
pramv[0] = t1;
pramv[1] = t2;
pramv[2] = modifiedd;
pramv[3] = textBox2.Text;
pramv[4] = بحث_عن_عملية_في_تاريخ_معين.id_op.ToString();
pramv[5] = بحث_عن_عملية_في_تاريخ_معين.id_d.ToString();
pramt[0] = SqlDbType.NVarChar;
pramt[1] = SqlDbType.NVarChar;
pramt[2] = SqlDbType.NVarChar;
pramt[3] = SqlDbType.NVarChar;
pramt[4] = SqlDbType.Int;
pramt[5] = SqlDbType.Int;
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("setescope_setescope_operation_update", pramna, pramv, pramt);
//cmd = new SqlCommand("setescope_setescope_operation_update", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@st", modifiedt);
//cmd.Parameters.AddWithValue("@dt", modifiedd);
//cmd.Parameters.AddWithValue("@endc", textBox2.Text);
//cmd.Parameters.AddWithValue("@id_oper", بحث_عن_عملية_في_تاريخ_معين.id_op);
//cmd.Parameters.AddWithValue("@d_id", بحث_عن_عملية_في_تاريخ_معين.id_d);
//cmd.ExecuteNonQuery();
con.CloseConnection();
MessageBox.Show("تمت العملية بنجاح");
}
else
{
MessageBox.Show("توجد عملية في هذ الوقت");
}
}
else
{
MessageBox.Show("يجب اختيار وقت النهاية اكبر من وقت البداية بنصف ساعة");
}
}
else
{
MessageBox.Show("لا يجب اختيار تاريخ ايام سابقة");
}
}
else
{
MessageBox.Show("لا يمكن التعديل قبل اختيار عملية للتعديل");
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
if (textBox1.Text == "" && textBox2.Text == "")
{
/*
*
* create procedure clinic_العياده_clinic_select
* as
* begin
* select Clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic
* end
* */
// con.Open();
// cmd.Connection = con;
//// class_con.OpenConection();
// cmd.CommandText = "clinic_العياده_clinic_select";
// cmd.CommandType = CommandType.StoredProcedure;
// //cmd.CommandText = "select Clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic";
// dr = cmd.ExecuteReader();
con1.OpenConection();
dr = con1.DataReader("clinic_العياده_clinic_select");
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text != "" && textBox2.Text == "")
{
/* create procedure clinic_العياده_clinic_code_select(@c nvarchar(50))
* as
* begin
* select clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic where clinic_code=@c
* end
*
*/
//con.Open();
//cmd.Connection = con;
////class_con.OpenConection();
//cmd.CommandText = "clinic_العياده_clinic_code_select";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@c", textBox1.Text);
////cmd.CommandText = "select clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic where clinic_code='" + textBox1.Text + "'";
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@c" };
values = new string[] { textBox1.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_العياده_clinic_code_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox1.Text == "" && textBox2.Text != "")
{
/*
*
* create procedure clinic_العياده_clinic_name_select(@arabic nvarchar(50))
* as
* begin
*
* select clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic where Arabic_name like N'%'+@arabic+'%'
* end
*/
// con.Open();
// cmd.Connection = con;
// //class_con.OpenConection();
// cmd.CommandText = "clinic_العياده_clinic_name_select";
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@arabic", SqlDbType.NVarChar).Value = textBox2.Text;
//// cmd.CommandText = "select clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic where Arabic_name='" + textBox2.Text + "'";
// dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar };
name_input = new string[] { "@arabic" };
values = new string[] { textBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_العياده_clinic_name_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
if (textBox2.Text != "" && textBox1.Text != "")
{
/*create procedure clinic_العياده_clinic_All_select(@c nvarchar(50),@arabic nvarchar(50))
* as
* begin
* select
* clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic where
* clinic_code=@c and Arabic_name like N'%'+@arabic+'%'
* end
*
*/
//con.Open();
//cmd.Connection = con;
////class_con.OpenConection();
//cmd.CommandText = "select clinic_code as 'الكود', Arabic_name as 'الاسم العربى' , english_name as 'الاسم الانجليزى' from clinic where clinic_code='" + textBox1.Text + "' and Arabic_name='" + textBox2.Text + "'";
//dr = cmd.ExecuteReader();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@c", "@arabic" };
values = new string[] { textBox1.Text, textBox2.Text };
dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_العياده_clinic_All_select", name_input, values, types);
DataTable dt = new DataTable();
dt.Load(dr);
if (dt.Rows.Count > 0)
{
dataGridView2.DataSource = dt;
}
else
{
MessageBox.Show("لا توجد نتائج بحث");
}
dr.Close();
con1.CloseConnection();
}
}
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();
}
