private void dataGridView1_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
String patient_name = dataGridView1.CurrentRow.Cells[1].Value.ToString();
String emp_name = dataGridView1.CurrentRow.Cells[2].Value.ToString();
عمل_خطة_علاجية_لمريض op = new عمل_خطة_علاجية_لمريض();
op.textBox1.Text = patient_name;
op.textBox2.Text = emp_name;
try
{
con.OpenConection();
cmd = new SqlCommand("select doctors.doc_ssn from doctors,physiotherapy_Reception where doctors.doc_ssn=physiotherapy_Reception.physiotherapy_Employee_code AND doctors.full_name='" + emp_name + "'", con.returnObject());
String x = cmd.ExecuteScalar().ToString();
int emp_code = int.Parse(x);
op.phys_emp_code = emp_code;
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
finally { con.CloseConnection(); }
op.phys_pat_code = int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString());;
op.Show();
}
private void button1_Click(object sender, EventArgs e)
{
try
{
con.OpenConection();
int service_code = int.Parse(comboBox3.SelectedItem.ToString());
int deviceCode = int.Parse(comboBox4.SelectedValue.ToString());
string[] pramname = new string[5];
string[] pramvalue = new string[5];
SqlDbType[] pramtype = new SqlDbType[5];
pramname[0] = "@physiotherapy_patient_code";
pramname[1] = "@Device_code";
pramname[2] = "@plan_start";
pramname[3] = "@plan_end";
pramname[4] = "@session_number";
pramvalue[0] = phys_pat_code.ToString();
pramvalue[1] = deviceCode.ToString();
pramvalue[2] = dateTimePicker1.Value.ToString();
pramvalue[3] = dateTimePicker2.Value.ToString();
pramvalue[4] = numericUpDown1.Value.ToString();
pramtype[0] = SqlDbType.Int;
pramtype[1] = SqlDbType.Int;
pramtype[2] = SqlDbType.Date;
pramtype[3] = SqlDbType.Date;
pramtype[4] = SqlDbType.Int;
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("physiotherapy_physiotherapy_Treatment_Plan", pramname, pramvalue, pramtype);
cmd = new SqlCommand("select plan_code from physiotherapy_Treatment_Plan where physiotherapy_patient_code=" + phys_pat_code, con.returnObject());
String x = cmd.ExecuteScalar().ToString();
int plan_code = int.Parse(x);
string[] pramname1 = new string[2];
string[] pramvalue1 = new string[2];
SqlDbType[] pramtype1 = new SqlDbType[2];
pramname1[0] = "@service_code";
pramname1[1] = "@plan_code";
pramvalue1[0] = service_code.ToString();
pramvalue1[1] = plan_code.ToString();
pramtype1[0] = SqlDbType.Int;
pramtype1[1] = SqlDbType.Int;
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("physiotherapy_physiotherapy_Treatment_Plan2", pramname1, pramvalue1, pramtype1);
string[] pramname2 = new string[2];
string[] pramvalue2 = new string[2];
SqlDbType[] pramtype2 = new SqlDbType[2];
pramname2[0] = "@doc_code";
pramname2[1] = "@plan_code";
pramvalue2[0] = phys_emp_code.ToString();
pramvalue2[1] = plan_code.ToString();
pramtype2[0] = SqlDbType.VarChar;
pramtype2[1] = SqlDbType.Int;
con.ExecuteInsertOrUpdateOrDeleteUsingStoredProc("physiotherapy_physiotherapy_Treatment_Plan3", pramname2, pramvalue2, pramtype2);
MessageBox.Show("تم الحفظ");
}
catch (Exception ex)
{ MessageBox.Show(ex.Message); }
finally { con.CloseConnection(); }
}
