private void button6_Click(object sender, EventArgs e)
{
try
{
con.OpenConection();
dr = con.DataReader("MedicalSheet_BodyComponentPhoto_select_Muscular");
dt.Clear();
dt.Load(dr);
count = 0;
textBox1.Text = dt.Rows[count][0].ToString();
pictureBox1.Image = Image.FromFile((string)dt.Rows[count][1]);
richTextBox1.Text = (string)dt.Rows[count][2];
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show("لاتوجد صور");
}
}
private void TRAINING_FRM_JOBS_Load(object sender, EventArgs e)
{
connect.OpenConection();
}
private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
// op = new OpenFileDialog();
if (listBox1.SelectedIndex < 0)
{
MessageBox.Show("الرجاء اختيار اسم العضو");
}
else if (op.FileName.ToString() == "")
{
MessageBox.Show("الرجاء ادخال الصوره");
}
else
{
listitem = listBox1.SelectedItem.ToString();
if (listitem == "عضل")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (listitem == "وعاء لنفاوى")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_lymphatic_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "العين")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_eye_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "الاذن")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_ear_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "هضمى ")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_digestive_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "وعائى")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_cardiovascular_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "الفم")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_mouth_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "بولى")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_urinary_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "هيكلى")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_skeletal_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "جهاز التنفس")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_respiratory_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "تناسلى")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_reproductive_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "اعصاب")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_nervous_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "الرأس والرقبة")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_neck_and_head_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "Rhinology")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_rhinology_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
if (listitem == "otology")
{
try
{
con.OpenConection();
string[] pramname = new string[2];
string[] pramvalue = new string[2];
SqlDbType[] pramtype = new SqlDbType[2];
pramname[0] = "@x";
pramname[1] = "@y";
pramvalue[0] = op.FileName;
pramvalue[1] = richTextBox1.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
object x = new object();
con.ShowDataInGridViewUsingStoredProc("MedicalSheet_BodyComponentphoto_otology_insert", pramname, pramvalue, pramtype);
MessageBox.Show("تم ادخال البيانات بنجاح");
con.CloseConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
}
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();
}
}
private void تخصصات_Load(object sender, EventArgs e)
{
con.OpenConection();
dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("spec");
con.CloseConnection();
}
private void اذونات_تأخير_Load(object sender, EventArgs e)
{
con.OpenConection();
}
private void فئة_المريض_Load(object sender, EventArgs e)
{
con.OpenConection();
}
private void fill_data()
{
if (VISIT_ID == "" || VISIT_ID == null)
{
return;
}
try
{
dataGridView2.Rows.Clear();
conn.OpenConection();
query = @"SELECT Registeration_patientRegisteration.patient_name, entranceoffice_visit.type_of_visit, entranceoffice_visit.entrance_date
FROM entranceoffice_visit INNER JOIN
Registeration_patientRegisteration ON entranceoffice_visit.pat_id = Registeration_patientRegisteration.patient_id
WHERE entranceoffice_visit.visit_id=" + VISIT_ID + "";
dr = conn.DataReader(query);
if (dr.Read())
{
label6.Text = VISIT_ID;
label7.Text = dr[0].ToString();
label12.Text = dr[1].ToString();
label14.Text = dr[2].ToString();
}
dr.Close();
dataGridView2.Rows.Clear();
query = @"SELECT Visit_Residence_Temp.ID, Visit_Residence_Temp.number_of_room, tb_Accommodation_Degrees.AD_Aname, Visit_Residence_Temp.price_before_discount,Visit_Residence_Temp.start_date,
Visit_Residence_Temp.end_date,Visit_Residence_Temp.number_of_days,Visit_Residence_Temp.type,employee.name
FROM Users INNER JOIN
employee ON Users.emp_id = employee.emp_id INNER JOIN
Visit_Residence_Temp ON Users.User_Code = Visit_Residence_Temp.User_code INNER JOIN
tb_Accommodation_Degrees INNER JOIN
rooms ON tb_Accommodation_Degrees.AD_id = rooms.Service_level ON Visit_Residence_Temp.number_of_room = rooms.Room_code
WHERE Visit_Residence_Temp.visit_ID=" + VISIT_ID + "";
dr = conn.DataReader(query);
string type = "";
while (dr.Read())
{
if (dr[7].ToString() == "0")
{
type = "مريض";
}
if (dr[7].ToString() == "1")
{
type = "مرافق على كرسى";
}
if (dr[7].ToString() == "2")
{
type = "مرافق على سرير";
}
dataGridView2.Rows.Add(dr[0], dr[1], dr[2], dr[3], dr[4], dr[5], dr[6], type, dr[8], "حذف");
}
dr.Close();
get_percentage();
calculate();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.CloseConnection();
}
}
public financial_rep()
{
this.WindowState = FormWindowState.Maximized;
con.OpenConection();
InitializeComponent();
}
public totalsalary()
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
con.OpenConection();
}
private void fill_data()
{
if (VISIT_ID == "" || VISIT_ID == null)
{
return;
}
try
{
dataGridView3.Rows.Clear();
conn.OpenConection();
query = @"SELECT Registeration_patientRegisteration.patient_name, entranceoffice_visit.entrance_date, entranceoffice_visit.type_of_visit, tb_Entities_Category.EC_id, tb_Entities_Branches.EB_id, tb_Contracting_Entities.CE_Id
FROM tb_Entities_Branches INNER JOIN
tb_Contracting_Entities ON tb_Entities_Branches.EB_CE_id = tb_Contracting_Entities.CE_Id INNER JOIN
tb_Entities_Category ON tb_Entities_Branches.EB_id = tb_Entities_Category.EC_EB_id INNER JOIN
entranceoffice_visit INNER JOIN
Registeration_patientRegisteration ON entranceoffice_visit.pat_id = Registeration_patientRegisteration.patient_id ON tb_Entities_Category.EC_id = entranceoffice_visit.EC_id
AND entranceoffice_visit.visit_id=" + VISIT_ID + "";
dr = conn.DataReader(query);
if (dr.Read())
{
label7.Text = dr[0].ToString();
label12.Text = dr[2].ToString();
label14.Text = dr[1].ToString();
EntityID = dr[5].ToString(); //كود الجهة
BranchEntityID = dr[4].ToString(); //كود الجهة الفرعية
GroupID = dr[3].ToString(); //كود الفئة
}
dr.Close();
query = "SELECT CE_RP_id FROM tb_Contracting_Entities WHERE CE_Id='" + EntityID + "'";
dr = conn.DataReader(query);
if (dr.Read())
{
RegulationID = dr[0].ToString();
}
dr.Close();
query = @"SELECT EC_Service_Contribution, EC_Drugs_Contribution, EC_Accomodation_Contribution, EC_Service_Disprecent, EC_Drugs_Disprecent, EC_Accomodation_Disprecent
FROM tb_Entities_Category WHERE EC_Id='" + GroupID + "'";
dr = conn.DataReader(query);
if (dr.Read())
{
Patient_service_percentage = Convert.ToInt32(dr[0]);
Patient_medicine_percentage = Convert.ToInt32(dr[1]);
Patient_residence_percentage = Convert.ToInt32(dr[2]);
Entity_service_percentage = Convert.ToInt32(dr[3]);
Entity_medicine_percentage = Convert.ToInt32(dr[4]);
Entity_residence_percentage = Convert.ToInt32(dr[5]);
}
dr.Close();
dataGridView3.Rows.Clear();
query = @"SELECT Visit_Medicine_Temp.ID, med_medicine.medicine_name, Visit_Medicine_Temp.item_quantity, (" + Entity_medicine_percentage + @" * med_medicine.price / 100),Visit_Medicine_Temp.date, employee.name
FROM Visit_Medicine_Temp,med_medicine,employee,Users WHERE
Visit_Medicine_Temp.visit_ID=" + VISIT_ID + @" AND
Visit_Medicine_Temp.item_ID = med_medicine.med_id AND
Users.emp_id = employee.emp_id AND
Visit_Medicine_Temp.User_code=Users.User_Code";
dr = conn.DataReader(query);
while (dr.Read())
{
dataGridView3.Rows.Add(dr[0], dr[1], dr[2], dr[3], dr[4], dr[5], "حذف");
}
dr.Close();
calculate();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
conn.CloseConnection();
}
}
private void فرررريق_العمل_Load(object sender, EventArgs e)
{
con.OpenConection();
dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("team_work");
con.CloseConnection();
}
private void حفظToolStripMenuItem_Click(object sender, EventArgs e)
{
//try
//{
con1.OpenConection();
//cmd.CommandText = "select EndoscopeCode from Endoscope_settings_data";
//dr = cmd.ExecuteReader();
dr = con1.DataReader("select EndoscopeCode from Endoscope_settings_data");
if (textBox1.Text != "")
{
while (dr.Read())
{
//MessageBox.Show(textBox1.Text);
if (int.Parse(dr[0].ToString()) == int.Parse(textBox1.Text))
{
Code = int.Parse(dr[0].ToString());
isequal = 1;
dr.Close();
//MessageBox.Show(isequal.ToString());
break;
}
}
}
//MessageBox.Show(isequal.ToString());
if (isequal == 1)
{
//cmd.CommandText = "update Endoscope_settings_data set EndoscopeName = '" + textBox4.Text + "' , DescriptionLatino = '" + textBox5.Text + "' , Bill = '" + comboBox2.SelectedItem +"' where EndoscopeCode = " + Code;
//cmd.ExecuteNonQuery();
con1.ExecuteQueries("update Endoscope_settings_data set EndoscopeName = '" + textBox4.Text + "' , DescriptionLatino = '" + textBox5.Text + "' , Bill = '" + comboBox2.SelectedItem + "' where EndoscopeCode = " + Code);
if (checkBox1.Checked)
{
//cmd.CommandText = " update Endoscope_settings_data set do_in_hospital = 1 where EndoscopeCode = " + Code;
//cmd.ExecuteNonQuery();
con1.ExecuteQueries(" update Endoscope_settings_data set do_in_hospital = 1 where EndoscopeCode = " + Code);
}
else
{
//cmd.CommandText = " update Endoscope_settings_data set do_in_hospital = 0 where EndoscopeCode = " + Code;
//cmd.ExecuteNonQuery();
con1.ExecuteQueries(" update Endoscope_settings_data set do_in_hospital = 0 where EndoscopeCode = " + Code);
}
if (radioButton1.Checked)
{
//cmd.CommandText = " update Endoscope_settings_data set doctor_fees = 1 where EndoscopeCode = " + Code;
//cmd.ExecuteNonQuery();
con1.ExecuteQueries(" update Endoscope_settings_data set doctor_fees = 1 where EndoscopeCode = " + Code);
}
else if (radioButton2.Checked)
{
//cmd.CommandText = " update Endoscope_settings_data set doctor_fees = 0 where EndoscopeCode = " + Code;
//cmd.ExecuteNonQuery();
con1.ExecuteQueries(" update Endoscope_settings_data set doctor_fees = 0 where EndoscopeCode = " + Code);
}
}
else
{
dr.Close();
if (checkBox1.Checked)
{
do_in_hospital = 1;
}
else
{
do_in_hospital = 0;
}
if (radioButton1.Checked)
{
doctor_feed = 1;
}
else if (radioButton2.Checked)
{
doctor_feed = 0;
}
// cmd.CommandText = "insert into Endoscope_settings_data (EndoscopeName, DescriptionLatino, do_in_hospital, doctor_fees, Bill) values ( '" + textBox4.Text + "' , '" + textBox5.Text + "' , " + do_in_hospital + "," + doctor_feed + ",'" + comboBox2.SelectedItem + "')";
//cmd.ExecuteNonQuery();
con1.ExecuteQueries("insert into Endoscope_settings_data (EndoscopeName, DescriptionLatino, do_in_hospital, doctor_fees, Bill) values ( '" + textBox4.Text + "' , '" + textBox5.Text + "' , " + do_in_hospital + "," + doctor_feed + ",'" + comboBox2.SelectedItem);
}
//MessageBox.Show(اعدادات_المناظير.set_name);
con1.CloseConnection();
}
private void تقرير_قائمة_طبقا_للجنس_Load(object sender, EventArgs e)
{
// con = new MySqlConnection("server=localhost;uid=root;pwd=root;database=hospital");
con.OpenConection();
}
private void button1_Click(object sender, EventArgs e)
{
con.OpenConection();
string[] pramname = new string[1];
string[] pramvalue = new string[1];
SqlDbType[] pramtype = new SqlDbType[1];
pramname[0] = "@id";
pramvalue[0] = textBox2.Text;
pramtype[0] = SqlDbType.VarChar;
if (textBox2.Text == "")
{
MessageBox.Show("من فضلك كود امر التوريد");
}
else
{
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("t1", pramname, pramvalue, pramtype);
con.CloseConnection();
}
//int a;
//if (textBox1.Text == "" && textBox2.Text == "")
//{
// MessageBox.Show("Please Enter values");
//}
//else if (int.Parse(textBox2.Text) < 0)
//{
// MessageBox.Show("Invalid Value");
//}
//else
// if (int.TryParse(textBox2.Text, out a))
// {
// try
// {
// con.Open();
// SqlCommand cmd = new SqlCommand("t1", con);
// cmd.CommandType = CommandType.StoredProcedure;
//cmd = new SqlCommand();
//cmd.Connection = con;
//cmd.CommandText = "select commandsupply_id ,request_date,date,p_parcode,quantity,pname,quality " +
// "from command_supply,product,prod_command_supply where prod_parcode=p_parcode and command_supply_id=commandsupply_id and commandsupply_id=@id ";
//cmd.Prepare();
// cmd.Parameters.AddWithValue("@id", textBox2.Text);
// dr = cmd.ExecuteReader();
// dt = new DataTable();
// dt.Load(dr);
// dataGridView1.DataSource = dt;
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
// finally { con.Close(); }
//}
//else
// MessageBox.Show("Invalid data");
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "")
{
int parsedValue;
if (!int.TryParse(textBox1.Text, out parsedValue))
{
MessageBox.Show("يجب ادخال ارقام فقط");
return;
}
}
if (textBox2.Text != "")
{
int parsedValue;
if (!int.TryParse(textBox2.Text, out parsedValue))
{
MessageBox.Show("يجب ادخال ارقام فقط");
return;
}
}
if (textBox3.Text != "")
{
int parsedValue;
if (int.TryParse(textBox3.Text, out parsedValue))
{
MessageBox.Show("يجب ادخال حروف فقط");
return;
}
}
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
//create procedure setescope_patient_select
//as
//begin
//select id as 'الكود',nickname as 'اللقب/الرتبة',name as'الاسم',bof as 'تاريخ الميلاد',gender as ' النوع',open_file_date as 'تاريخ فتح الملف' from patient_endo;
//end
con.OpenConection();
if (textBox1.Text == "" && textBox2.Text == "" && textBox3.Text == "")
{
dataGridView1.Visible = true;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("setescope_patient_select");
}
else
{
if (textBox1.Text != "")
{
try
{
//create procedure setescope_patient_select_by_id(@id1 int)
//as
//begin
// select id as 'الكود',nickname as 'اللقب/الرتبة',name as'الاسم',bof as 'تاريخ الميلاد',gender as ' النوع',open_file_date as 'تاريخ فتح الملف' from patient_endo where id=@id1;
//end
string[] pramname = new string[1];
string[] pramvalue = new string[1];
SqlDbType[] pramtype = new SqlDbType[1];
pramname[0] = "@id1";
pramvalue[0] = textBox1.Text;
pramtype[0] = SqlDbType.Int;
dataGridView1.Visible = true;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("setescope_patient_select_by_id", pramname, pramvalue, pramtype);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else if (textBox2.Text != "")
{
//create procedure setescope_patient_select_by_ssn(@ssn1 int)
//as
//begin
// select id as 'الكود',nickname as 'اللقب/الرتبة',name as'الاسم',bof as 'تاريخ الميلاد',gender as ' النوع',open_file_date as 'تاريخ فتح الملف' from patient_endo where nss=@ssn1;
//end
string[] pramname = new string[1];
string[] pramvalue = new string[1];
SqlDbType[] pramtype = new SqlDbType[1];
pramname[0] = "@ssn1";
pramvalue[0] = textBox2.Text;
pramtype[0] = SqlDbType.Int;
dataGridView1.Visible = true;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("setescope_patient_select_by_ssn", pramname, pramvalue, pramtype);
}
else if (textBox3.Text != "")
{
//create procedure setescope_patient_select_by_name(@name1 nvarchar(50))
//as
//begin
//select id as 'الكود',nickname as 'اللقب/الرتبة',name as'الاسم',bof as 'تاريخ الميلاد',gender as ' النوع',open_file_date as 'تاريخ فتح الملف' from patient_endo where name=@name1;
//end
string[] pramname = new string[1];
string[] pramvalue = new string[1];
SqlDbType[] pramtype = new SqlDbType[1];
pramname[0] = "@name1";
pramvalue[0] = textBox3.Text;
pramtype[0] = SqlDbType.VarChar;
dataGridView1.Visible = true;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("setescope_patient_select_by_name", pramname, pramvalue, pramtype);
}
}
}
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 Form3_Load(object sender, EventArgs e)
{
try { con.OpenConection(); }
catch (Exception ex) { MessageBox.Show(ex.ToString()); }
}
private void الورديات_Load(object sender, EventArgs e)
{
//(@"server=(local);database=hospital;Integrated Security=true");
con.OpenConection();
}
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 button3_Click(object sender, EventArgs e)
{
if (dateTimePicker1.Value.Date < dateTimePicker2.Value.Date)
{
try
{
con1.OpenConection();
if (textBox3.Text != "")
{
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int };
name_input = new string[] { "@x", "@y", "@z" };
values = new string[] { dateTimePicker1.Text, dateTimePicker2.Text, textBox3.Text };
ob = con1.ShowDataInGridViewUsingStoredProc("setescope_approval_select_withpatientid", name_input, values, types);
//cmd = new SqlCommand("setescope_approval_select_withpatientid", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@x", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@y", dateTimePicker2.Text);
//cmd.Parameters.AddWithValue("@z", Convert.ToInt32(textBox3.Text));
}
else if (textBox4.Text != "")
{
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int };
name_input = new string[] { "@x", "@y", "@z" };
values = new string[] { dateTimePicker1.Text, dateTimePicker2.Text, textBox4.Text };
ob = con1.ShowDataInGridViewUsingStoredProc("setescope_approval_select_withenscopecode", name_input, values, types);
//cmd = new SqlCommand("setescope_approval_select_withenscopecode", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@x", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@y", dateTimePicker2.Text);
//cmd.Parameters.AddWithValue("@z", Convert.ToInt32(textBox4.Text));
}
else if (textBox3.Text != "" && textBox4.Text != "")
{
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int };
name_input = new string[] { "@x", "@y", "@p", "@e" };
values = new string[] { dateTimePicker1.Text, dateTimePicker2.Text, textBox3.Text, textBox4.Text };
ob = con1.ShowDataInGridViewUsingStoredProc("setescope_approval_select_withpatientid_andendoscopecode", name_input, values, types);
//cmd = new SqlCommand("setescope_approval_select_withpatientid_andendoscopecode", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@x", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@y", dateTimePicker2.Text);
//cmd.Parameters.AddWithValue("@p", Convert.ToInt32(textBox3.Text));
//cmd.Parameters.AddWithValue("@e", Convert.ToInt32(textBox4.Text));
}
else
{
types = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@x", "@y" };
values = new string[] { dateTimePicker1.Text, dateTimePicker2.Text };
ob = con1.ShowDataInGridViewUsingStoredProc("setescope_approval_select", name_input, values, types);
//cmd = new SqlCommand("setescope_approval_select", con);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@x", dateTimePicker1.Text);
//cmd.Parameters.AddWithValue("@y", dateTimePicker2.Text);
}
dataGridView1.Visible = true;
dataGridView1.DataSource = null;
dataGridView1.Rows.Clear();
dataGridView1.Refresh();
dataGridView1.DataSource = ob;
con1.CloseConnection();
//dr = cmd.ExecuteReader();
//dt.Load(dr);
//dataGridView1.DataSource = dt;
//dr.Close();
//con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("برجاء ادخال تاريخ مناسب");
}
}
private void button1_Click(object sender, EventArgs e)
{
con.OpenConection();
DataTable dt = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient1");
textBox4.Text = dt.Rows[0][0].ToString();
//SqlCommand cmd = new SqlCommand();
//SqlDataReader reader;
//SqlConnection sql = new SqlConnection(@"Server=.\SQLEXPRESS; DataBase=PHIS; Integrated Security=true;");
//cmd.CommandText = "search_patient1";
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Connection = sql;
//sql.Open();
//reader = cmd.ExecuteReader();
//while (reader.Read())
// textBox4.Text = reader[0].ToString();
//sql.Close();
// =(DataTable)con.ShowDataInGridViewUsingStoredProc("report");
con.CloseConnection();
if (textBox1.Text != "" && textBox3.Text == "")
{
try
{
con.OpenConection();
string[] s = new string[] { "@x" };
string[] s2 = new string[] { textBox1.Text };
SqlDbType[] s3 = new SqlDbType[] { SqlDbType.Int };
dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient2", s, s2, s3);
//string s = "select patient_id,patient_name,job,date_of_birth,gender from Registeration_patientRegisteration where patient_id=@x";
//cmd = new MySqlCommand(s, con);
//cmd.Parameters.AddWithValue("@x", Int32.Parse(textBox1.Text));
//dr = cmd.ExecuteReader();
//dt.Load(dr);
//dataGridView1.DataSource = dt;
//dr.Close();
//string s1 = "select visit_id ,entrance_date from entranceoffice_visit,Registeration_patientRegisteration where pat_id=patient_id and pat_id=@x;";
//MySqlCommand cmd1 = new MySqlCommand(s1, con);
//cmd1.Parameters.AddWithValue("@x", Int32.Parse(textBox1.Text));
//MySqlDataReader dr1 = cmd1.ExecuteReader();
//DataTable dt1 = new DataTable();
//dt1.Load(dr1);
//dataGridView3.DataSource = dt1;
//dr1.Close();
string[] f = new string[] { "@x" };
string[] f2 = new string[] { textBox1.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.Int };
dataGridView3.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient4", s, s2, s3);
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { con.CloseConnection(); }
}
else if (textBox3.Text != "" && textBox1.Text == "")
{
try
{
con.OpenConection();
string[] s = new string[] { "@x" };
string[] s2 = new string[] { textBox3.Text };
SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar };
dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient5", s, s2, s3);
// con.Open();
// string s = "select patient_id,patient_name,job,date_of_birth,gender from Registeration_patientRegisteration where patient_name=@x";
// cmd = new MySqlCommand(s, con);
// cmd.Parameters.AddWithValue("@x", textBox3.Text);
// dr = cmd.ExecuteReader();
// dt.Load(dr);
// dataGridView1.DataSource = dt;
// dr.Close();
//string s1 = "select code,dat from entranceoffice_visit,Registeration_patientRegisteration,patientAndVisit where patt_id=patient_id and code=visit_code and patient_name=@x";
//MySqlCommand cmd1 = new MySqlCommand(s1, con);
//cmd1.Parameters.AddWithValue("@x", textBox3.Text);
//MySqlDataReader dr1 = cmd1.ExecuteReader();
//DataTable dt1 = new DataTable();
//dt1.Load(dr1);
//dataGridView3.DataSource = dt1;
//dr1.Close();
string[] f = new string[] { "@x" };
string[] f2 = new string[] { textBox3.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar };
dataGridView3.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient6", f, f2, f3);
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { con.CloseConnection(); }
}
else if (textBox1.Text != "" && textBox3.Text != "")
{
try
{
con.OpenConection();
string[] s = new string[] { "@x", "@y" };
string[] s2 = new string[] { textBox3.Text, textBox1.Text };
SqlDbType[] s3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int };
dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient7", s, s2, s3);
//con.Open();
//string s = "select patient_id,patient_name,job,date_of_birth,gender from Registeration_patientRegisteration where patient_name=@x and patient_id=@y";
//cmd = new MySqlCommand(s, con);
//cmd.Parameters.AddWithValue("@y", Int32.Parse(textBox1.Text));
//cmd.Parameters.AddWithValue("@x", textBox3.Text);
//dr = cmd.ExecuteReader();
//dt.Load(dr);
//dataGridView1.DataSource = dt
//dr.Close();
//string s1 = "select code,dat from entranceoffice_visit,Registeration_patientRegisteration,patientAndVisit where patt_id=patient_id and code=visit_code and patient_name=@x and patient_id=@y";
//MySqlCommand cmd1 = new MySqlCommand(s1, con);
//cmd1.Parameters.AddWithValue("@y", Int32.Parse(textBox1.Text));
//cmd1.Parameters.AddWithValue("@x", textBox3.Text);
//MySqlDataReader dr1 = cmd1.ExecuteReader();
//DataTable dt1 = new DataTable();
//dt1.Load(dr1);
//dataGridView3.DataSource = dt1;
//dr1.Close();
string[] f = new string[] { "@x", "@y" };
string[] f2 = new string[] { textBox3.Text, textBox1.Text };
SqlDbType[] f3 = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.Int };
dataGridView3.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient8", f, f2, f3);
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { con.CloseConnection(); }
}
else
{
try
{
con.OpenConection();
// con.Open();
// string s = "select patient_id,patient_name,job,date_of_birth,gender from Registeration_patientRegisteration";
// cmd = new MySqlCommand(s, con);
// dr = cmd.ExecuteReader();
// dt.Load(dr);
// dataGridView1.DataSource = dt;
// dr.Close();
dataGridView1.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient10");
dataGridView3.DataSource = (DataTable)con.ShowDataInGridViewUsingStoredProc("search_patient9");
}
catch (Exception ex) { MessageBox.Show(ex.Message); }
finally { con.CloseConnection(); }
}
}
private void label18_Click(object sender, EventArgs e)
{
/*if (String.IsNullOrEmpty(textBox3.Text))
* {
* MessageBox.Show("من فضلك ادخل كود الخصم ");
* textBox3.Focus();
* }
* else
* if (textBox3.Text.Any(c => Char.IsLetter(c)))
* {
* MessageBox.Show("من فضلك ادخل كود الخصم بشكل صحيح");
* textBox3.Focus();
* }
*
* else*/
if (String.IsNullOrEmpty(textBox6.Text))
{
MessageBox.Show("من فضلك ادخل نوع الخصم ");
textBox6.Focus();
}
else
if (textBox6.Text.Any(c => Char.IsNumber(c)))
{
MessageBox.Show("من فضلك ادخل نوع الخصم بشكل صحيح");
textBox6.Focus();
}
else
if (String.IsNullOrEmpty(textBox8.Text))
{
MessageBox.Show("من فضلك عملية الخصم ");
textBox8.Focus();
}
else
if (String.IsNullOrEmpty(textBox1.Text))
{
MessageBox.Show("من فضلك الاجمالى قبل الخصم ");
textBox1.Focus();
}
else
if (textBox1.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل الاجمالى قبل الخصم بشكل صحيح");
textBox1.Focus();
}
else
if (String.IsNullOrEmpty(textBox5.Text))
{
MessageBox.Show("من فضلك نسبه الخصم ");
textBox5.Focus();
}
else
if (textBox5.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل نسبه الخصم بشكل صحيح");
textBox5.Focus();
}
else
if (String.IsNullOrEmpty(textBox7.Text))
{
MessageBox.Show("من فضلك رقم الفاتورة ");
textBox7.Focus();
}
else
if (textBox7.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل رقم الفاتورة بشكل صحيح");
textBox7.Focus();
}
else
if (String.IsNullOrEmpty(textBox2.Text))
{
MessageBox.Show("من فضلك قيمه الخصم ");
textBox2.Focus();
}
else
if (textBox2.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل قيمه الخصم بشكل صحيح");
textBox2.Focus();
}
else
if (String.IsNullOrEmpty(textBox4.Text))
{
MessageBox.Show("من فضلك الاجمالى بعد الخصم ");
textBox4.Focus();
}
else
if (textBox4.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل الاجمالى بعد الخصم بشكل صحيح");
textBox4.Focus();
}
else
{
try
{
con.OpenConection();
string[] pramname = new string[8];
string[] pramvalue = new string[8];
SqlDbType[] pramtype = new SqlDbType[8];
pramname[0] = "@bill_id";
pramname[1] = "@ratio_id";
pramname[2] = "@discount_type";
pramname[3] = "@ratio";
pramname[4] = "@value";
pramname[5] = "@total_before_discount";
pramname[6] = "@total_after_discount";
pramname[7] = "@discount_process";
pramvalue[0] = textBox7.Text;
pramvalue[1] = textBox9.Text;
pramvalue[2] = textBox6.Text;
pramvalue[3] = textBox5.Text;
pramvalue[4] = textBox2.Text;
pramvalue[5] = textBox1.Text;
pramvalue[6] = textBox4.Text;
pramvalue[7] = textBox8.Text;
pramtype[0] = SqlDbType.Int;
pramtype[1] = SqlDbType.Int;
pramtype[2] = SqlDbType.VarChar;
pramtype[3] = SqlDbType.Decimal;
pramtype[4] = SqlDbType.Decimal;
pramtype[5] = SqlDbType.Decimal;
pramtype[6] = SqlDbType.Decimal;
pramtype[7] = SqlDbType.VarChar;
dataGridView1.DataSource = con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("drug_discount_add", pramname, pramvalue, pramtype);
MessageBox.Show("تم الادخال");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally { con.CloseConnection(); }
}
}
private void ShowData()
{
if (String.IsNullOrEmpty(textBox1.Text) && String.IsNullOrEmpty(textBox6.Text) && String.IsNullOrEmpty(textBox3.Text))
{
MessageBox.Show("من فضلك ادخل رقم المخزن و رقم المستخدم ورقم الحركه ");
textBox1.Focus();
}
else
if (String.IsNullOrEmpty(textBox1.Text))
{
MessageBox.Show("من فضلك ادخل رقم المخزن");
textBox1.Focus();
}
else
if (textBox1.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل رقم المخزن بشكل صحيح");
textBox1.Focus();
}
else
if (String.IsNullOrEmpty(textBox6.Text))
{
MessageBox.Show("من فضلك ادخل رقم المستخدم ");
textBox6.Focus();
}
else
if (textBox6.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل رقم المستخدم بشكل صحيح");
textBox6.Focus();
}
else
if (String.IsNullOrEmpty(textBox3.Text))
{
MessageBox.Show("من فضلك ادخل رقم الحركه ");
textBox3.Focus();
}
else
if (textBox3.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل رقم الحركه بشكل صحيح");
textBox3.Focus();
}
else
if (textBox2.Text.Any(c => Char.IsNumber(c)))
{
MessageBox.Show("من فضلك ادخل اسم المخزن بشكل صحيح");
textBox2.Focus();
}
else
if (textBox5.Text.Any(c => Char.IsNumber(c)))
{
MessageBox.Show("من فضلك ادخل اسم المستخدم بشكل صحيح");
textBox5.Focus();
}
else
{
if (comboBox1.Text != null)
{
if (comboBox1.Text == "مراجع")
{
try
{
con.OpenConection();
//not find table [0]
string[] pramname = new string[8];
string[] pramvalue = new string[8];
SqlDbType[] pramtype = new SqlDbType[8];
pramname[0] = "@x1";
pramname[1] = "@x2";
pramname[2] = "@x3";
pramname[3] = "@x4";
pramname[4] = "@x5";
pramname[5] = "@x6";
pramname[6] = "@x7";
pramname[7] = "@x8";
pramvalue[0] = dateTimePicker1.Value.ToString();
pramvalue[1] = dateTimePicker2.Value.ToString();
pramvalue[2] = textBox3.Text;
pramvalue[3] = textBox1.Text;
pramvalue[4] = comboBox1.Text;
pramvalue[5] = textBox2.Text;
pramvalue[6] = comboBox3.Text;
pramvalue[7] = textBox6.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
pramtype[2] = SqlDbType.Int;
pramtype[3] = SqlDbType.VarChar;
pramtype[4] = SqlDbType.Int;
pramtype[5] = SqlDbType.VarChar;
pramtype[6] = SqlDbType.VarChar;
pramtype[7] = SqlDbType.VarChar;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("review_pharmacy_movementT", pramname, pramvalue, pramtype);
//MessageBox.Show("");
con.CloseConnection();
}
catch (Exception)
{
MessageBox.Show("من فضلك ادخل البيانات كاملة ");
}
}
}
else
{
try
{
con.OpenConection();
//not find table [0]
string[] pramname = new string[8];
string[] pramvalue = new string[8];
SqlDbType[] pramtype = new SqlDbType[8];
pramname[0] = "@x1";
pramname[1] = "@x2";
pramname[2] = "@x3";
pramname[3] = "@x4";
pramname[4] = "@x5";
pramname[5] = "@x6";
pramname[6] = "@x7";
pramname[7] = "@x8";
pramvalue[0] = dateTimePicker1.Value.ToString();
pramvalue[1] = dateTimePicker2.Value.ToString();
pramvalue[2] = textBox3.Text;
pramvalue[3] = textBox1.Text;
pramvalue[4] = comboBox1.Text;
pramvalue[5] = textBox2.Text;
pramvalue[6] = comboBox3.Text;
pramvalue[7] = textBox6.Text;
pramtype[0] = SqlDbType.VarChar;
pramtype[1] = SqlDbType.VarChar;
pramtype[2] = SqlDbType.Int;
pramtype[3] = SqlDbType.VarChar;
pramtype[4] = SqlDbType.Int;
pramtype[5] = SqlDbType.VarChar;
pramtype[6] = SqlDbType.VarChar;
pramtype[7] = SqlDbType.VarChar;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("review_pharmacy_movementF", pramname, pramvalue, pramtype);
//MessageBox.Show("");
con.CloseConnection();
}
catch (Exception)
{
MessageBox.Show("من فضلك ادخل البيانات كاملة ");
}
}
}
}
private void patients_visits_Load(object sender, EventArgs e)
{
// con = new MySqlConnection("server=localhost;uid=root;pwd=root;database=hospital1");
con.OpenConection();
}
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 ShowData()
{
if (String.IsNullOrEmpty(CodeTextBox.Text) && String.IsNullOrEmpty(textBox3.Text))
{
MessageBox.Show("من فضلك ادخل كود الجهه و كود الفئه ");
CodeTextBox.Focus();
}
else if (String.IsNullOrEmpty(CodeTextBox.Text))
{
MessageBox.Show("من فضلك ادخل كود الجهه");
CodeTextBox.Focus();
}
else if (CodeTextBox.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل كود الجهه بشكل صحيح");
CodeTextBox.Focus();
}
else if (String.IsNullOrEmpty(textBox3.Text))
{
MessageBox.Show("من فضلك ادخل كود الفئه");
textBox3.Focus();
}
else if (textBox3.Text.Any(c => Char.IsLetter(c)))
{
MessageBox.Show("من فضلك ادخل كود الفئه بشكل صحيح");
textBox3.Focus();
}
else if (textBox2.Text.Any(c => Char.IsNumber(c)))
{
MessageBox.Show("من فضلك ادخل اسم الجهه بشكل صحيح");
textBox2.Focus();
}
else if (textBox4.Text.Any(c => Char.IsNumber(c)))
{
MessageBox.Show("من فضلك ادخل اسم الفئه بشكل صحيح");
textBox4.Focus();
}
else
{
if (comboBox1.Text != null)
{
if (comboBox1.Text == "مراجع")
{
try
{
con.OpenConection();
//not find table [0]
string[] pramname = new string[4];
string[] pramvalue = new string[4];
SqlDbType[] pramtype = new SqlDbType[4];
pramname[0] = "@x1";
pramname[1] = "@x2";
pramname[2] = "@x3";
pramname[3] = "@x4";
pramvalue[0] = CodeTextBox.Text;
pramvalue[1] = textBox3.Text;
pramvalue[2] = dateTimePicker1.Value.ToString();
pramvalue[3] = dateTimePicker2.Value.ToString();
pramtype[0] = SqlDbType.Int;
pramtype[1] = SqlDbType.Int;
pramtype[2] = SqlDbType.VarChar;
pramtype[3] = SqlDbType.VarChar;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("review_bill_patientT", pramname, pramvalue, pramtype);
//MessageBox.Show("");
con.CloseConnection();
}
catch (Exception)
{
MessageBox.Show("من فضلك ادخل البيانات كاملة ");
}
}
}
else
{
try
{
con.OpenConection();
//not find table [0]
string[] pramname = new string[4];
string[] pramvalue = new string[4];
SqlDbType[] pramtype = new SqlDbType[4];
pramname[0] = "@x1";
pramname[1] = "@x2";
pramname[2] = "@x3";
pramname[3] = "@x4";
pramvalue[0] = CodeTextBox.Text;
pramvalue[1] = textBox3.Text;
pramvalue[2] = dateTimePicker1.Value.ToString();
pramvalue[3] = dateTimePicker2.Value.ToString();
pramtype[0] = SqlDbType.Int;
pramtype[1] = SqlDbType.Int;
pramtype[2] = SqlDbType.VarChar;
pramtype[3] = SqlDbType.VarChar;
dataGridView1.DataSource = con.ShowDataInGridViewUsingStoredProc("review_bill_patientF", pramname, pramvalue, pramtype);
//MessageBox.Show("");
con.CloseConnection();
}
catch (Exception)
{
MessageBox.Show("من فضلك ادخل البيانات كاملة ");
}
}
}
}
private void C_Save_Click(object sender, EventArgs e)
{
#region insert
if (valdate())
{
try
{
string[] paramname = new string[17];
string[] paramvalue = new string[17];
SqlDbType[] paramtype = new SqlDbType[17];
paramname[0] = "@id";
paramname[1] = "@Aname";
paramname[2] = "@Ename";
paramname[3] = "@StartDD";
paramname[4] = "@StopDD";
paramname[5] = "@Stopdealing";
paramname[6] = "@EOpenblance";
paramname[7] = "@MOpenblance";
paramname[8] = "@ELimitblance";
paramname[9] = "@MLimitblance";
paramname[10] = "@TE_id";
paramname[11] = "@Employee";
paramname[12] = "@RP_id";
paramname[13] = "@Region_id";
paramname[14] = "@HEmployee_id";
paramname[15] = "@OSD_id";
paramname[16] = "@AD_id";
paramvalue[0] = Txt_id.Text;
paramvalue[1] = Txt_aname.Text;
paramvalue[2] = Txt_Ename.Text;
paramvalue[3] = dtp_start.Value.ToShortDateString();
paramvalue[4] = dtp_stop.Value.ToShortDateString();
paramvalue[5] = stopdealing.ToString();
paramvalue[6] = ELimitb.ToString();
paramvalue[7] = MLimitb.ToString();
paramvalue[8] = Txt_Climitb.Text;
paramvalue[9] = Txt_Mlimitb.Text;
paramvalue[10] = txt_ET_id.Text;
paramvalue[11] = Txt_employee.Text;
paramvalue[12] = txt_RP_id.Text;
paramvalue[13] = txt_Region_id.Text;
paramvalue[14] = Txt_HEid.Text;
paramvalue[15] = txt_OSD_id.Text;
paramvalue[16] = Txt_AD_id.Text;
paramtype[0] = SqlDbType.Int;
paramtype[1] = SqlDbType.NVarChar;
paramtype[2] = SqlDbType.NVarChar;
paramtype[3] = SqlDbType.Date;
paramtype[4] = SqlDbType.Date;
paramtype[5] = SqlDbType.Bit;
paramtype[6] = SqlDbType.Bit;
paramtype[7] = SqlDbType.Bit;
paramtype[8] = SqlDbType.Int;
paramtype[9] = SqlDbType.Int;
paramtype[10] = SqlDbType.Int;
paramtype[11] = SqlDbType.NVarChar;
paramtype[12] = SqlDbType.Int;
paramtype[13] = SqlDbType.Int;
paramtype[14] = SqlDbType.Int;
paramtype[15] = SqlDbType.Int;
paramtype[16] = SqlDbType.Int;
int x;
con.OpenConection();
x = con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("sp_Contracting_Entites_insert", paramname, paramvalue, paramtype);
// con.ExecutenonReturnProcdure("sp_Access_Method_insert", paramname, paramvalue, paramtype);
if (x == 1)
{
MessageBox.Show("تمت الاضافة بنجاح ");
}
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
#endregion insert
}
private void Form13_Load(object sender, EventArgs e)
{
con.OpenConection();
}
private void button1_Click(object sender, EventArgs e)
{
Connection con = new Connection();
con.OpenConection();
string[] param_names = new string[] {
"@intial_assesment_date"
, "@inventry_id"
, "@doc_code"
, "@weightt"
, "@head"
, "@lenght"
, "@abdominalc"
, "@void_urine "
, "@tempreture "
, "@heart_rate"
, "@respiratory"
, "@pass_stool"
, "@physical_examination_color"
, "@physical_examination_head"
, "@physical_examination_fontanels"
, "@physical_examination_eyes"
, "@physical_examination_ears"
, "@physical_examination_nose"
, "@physical_examination_mouth"
, "@physical_examination_neck"
, "@physical_examination_calavicles "
, "@physical_examination_breast "
, "@physical_examination_thorax "
, "@physical_examination_activity"
, "@physical_examination_heart "
, "@physical_examination_abdomen"
, "@physical_examination_liver "
, "@physical_examination_spleen "
, "@physical_examination_lungs "
, "@physical_examination_hernia "
, "@physical_examination_umbilicus "
, "@physical_examination_genitilia "
, "@physical_examination_anus "
, "@physical_examination_deformit"
, "@physical_examination_skin "
, "@physical_examination_extemities"
, "@physical_examination_solo_crease "
, "@physical_examination_reflexes "
, "@physical_examination_moro "
, "@physical_examination_grasp "
, "@physical_examination_light "
, "@physical_examination_glabellar"
, "@physical_examination_rooting "
, "@physical_examination_suckling "
, "@immpression_tatitional_age "
, "@immpression_weeks "
, "@immpression_provisional_diagnosis "
, "@immpression_date"
}; // الامراض الوراثسيه والعائليه للمريض
//@doc_code @age اسم الدكتور @name اسمالمريض @iventry id @date @present @past @family
string[] param_values = new string[]
{
dateTimePicker1.Value.ToString("yyyy-MM-dd"),
textBox45.Text, // "@initial_assessment_date" ,
textBox46.Text, // "@doc_code" , // weight ,
textBox15.Text, // head
textBox1.Text,
textBox14.Text, // length
textBox2.Text, // "@patient_id" ,
textBox7.Text, // "@general_apperance_age" ,
textBox8.Text, // "@general_apperance_conscious_level" ,
textBox3.Text, // "@general_apperance_glass_coma_score" ,
textBox4.Text, // "@general_apperance_h_r" ,
textBox6.Text, // "@general_apperance_r_r" ,
textBox5.Text, // "@general_apperance_tempreture" ,
textBox17.Text, // "@general_apperance_blood_pressure" ,
textBox16.Text, // "@general_apperance_color" ,
textBox11.Text, // "@general_apperance_turgor",
textBox9.Text, // "@general_apperance_eruption" ,
textBox10.Text, // "@head_neck_fascies" ,
textBox18.Text, // "@head_neck_eyes" ,
textBox12.Text, // "@head_neck_mouth_tongue" ,
textBox13.Text, // "@head_neck_pharynx" ,
textBox19.Text, // "@head_neck_lymph_nodes" ,
textBox40.Text, // "@head_neck_oters" ,
textBox29.Text, // "@heart_precordial_bulge" ,
textBox27.Text, // "@heart_apex_beat" ,
textBox28.Text, // "@heart_thrill",
textBox26.Text, // "@heart_heart_sound" ,
textBox24.Text, // "@heart_murmurs",
textBox25.Text, // "@heart_others" ,
textBox21.Text, // "@chest_shape" ,
textBox22.Text, // "@chest_movement" ,
textBox20.Text,
textBox23.Text, // "@chest_reactions" ,
textBox39.Text, // "@chest_air_entry" ,
textBox37.Text, // "@chest_breath_sounds" ,
textBox38.Text, // "@chest_adventure_sounds" ,
textBox36.Text, // "@abdomen_liver",
textBox34.Text, // "@abdomen_spleen" ,
textBox35.Text, // "@abdomen_kidneys" ,
textBox33.Text, // "@abdomen_ascites" ,
textBox31.Text, // "@abdomen_others" ,
textBox32.Text, // "@back_spine_deformity" ,
textBox30.Text, // "@back_spine_sweling" ,
textBox43.Text, // "@neurological_examination_mentality" ,
textBox44.Text,
textBox42.Text,
textBox41.Text,
dateTimePicker2.Value.ToString("yyyy-MM-dd")
// "@neurological_examination_cranial_nerves"
};
SqlDbType[] param_types = new SqlDbType[]
{
SqlDbType.Date,
SqlDbType.Int,
SqlDbType.VarChar,
SqlDbType.Float,
SqlDbType.VarChar,
SqlDbType.Float,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.Float,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.VarChar,
SqlDbType.Date
};
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("insert_initial_assessment", param_names, param_values, param_types);
validation v = new validation();
v.numbervalidation(textBox15, "this value");
v.numbervalidation(textBox8, "this value");
v.numbervalidation(textBox1, "this value");
v.numbervalidation(textBox3, "this value");
v.numbervalidation(textBox6, "this value");
v.numbervalidation(textBox14, "this value");
v.numbervalidation(textBox4, "this value");
v.numbervalidation(textBox2, "this value");
v.numbervalidation(textBox6, "this value");
v.numbervalidation(textBox7, "this value");
v.stringvalidation(textBox5, "this value");
v.stringvalidation(textBox17, "this value");
v.stringvalidation(textBox16, "this value");
v.stringvalidation(textBox11, "this value");
v.stringvalidation(textBox9, "this value");
v.stringvalidation(textBox10, "this value");
v.stringvalidation(textBox18, "this value");
v.stringvalidation(textBox12, "this value");
v.stringvalidation(textBox13, "this value");
v.stringvalidation(textBox19, "this value");
v.stringvalidation(textBox40, "this value");
v.stringvalidation(textBox23, "this value");
v.stringvalidation(textBox20, "this value");
v.stringvalidation(textBox22, "this value");
v.stringvalidation(textBox21, "this value");
v.stringvalidation(textBox25, "this value");
v.stringvalidation(textBox24, "this value");
v.stringvalidation(textBox23, "this value");
v.stringvalidation(textBox24, "this value");
v.stringvalidation(textBox27, "this value");
v.stringvalidation(textBox28, "this value");
v.stringvalidation(textBox29, "this value");
v.stringvalidation(textBox30, "this value");
v.stringvalidation(textBox31, "this value");
v.stringvalidation(textBox32, "this value");
v.stringvalidation(textBox33, "this value");
v.stringvalidation(textBox34, "this value");
v.stringvalidation(textBox35, "this value");
v.stringvalidation(textBox36, "this value");
v.stringvalidation(textBox37, "this value");
v.stringvalidation(textBox38, "this value");
v.stringvalidation(textBox39, "this value");
v.stringvalidation(textBox40, "this value");
v.stringvalidation(textBox41, "this value");
v.stringvalidation(textBox42, "this value");
v.stringvalidation(textBox43, "this value");
v.stringvalidation(textBox44, "this value");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
textBox11.Text = "";
textBox12.Text = "";
textBox13.Text = "";
textBox14.Text = "";
textBox15.Text = "";
textBox16.Text = "";
textBox17.Text = "";
textBox18.Text = "";
textBox19.Text = "";
textBox20.Text = "";
textBox21.Text = "";
textBox22.Text = "";
textBox23.Text = "";
textBox24.Text = "";
textBox25.Text = "";
textBox26.Text = "";
textBox27.Text = "";
textBox28.Text = "";
textBox29.Text = "";
textBox30.Text = "";
textBox31.Text = "";
textBox32.Text = "";
textBox33.Text = "";
textBox34.Text = "";
textBox35.Text = "";
textBox36.Text = "";
textBox37.Text = "";
textBox38.Text = "";
textBox39.Text = "";
textBox40.Text = "";
textBox41.Text = "";
textBox42.Text = "";
textBox43.Text = "";
textBox44.Text = "";
}
