//For حجز عياده خارجيه
private void حجزالعياداتالخارجيةToolStripMenuItem_Click(object sender, EventArgs e)
{
حجز_العياده f = new حجز_العياده();
f.MdiParent = this;
f.Show();
}
//For add patient to clinic
private void button2_Click(object sender, EventArgs e)
{
//create procedure clinic_محرك_البحث_للحجز_treat_patient_insert(@fn varchar(50),@c varchar(30))
//as
//begin
//declare @pid int
//set @pid=(select patient_id from Registeration_patientRegisteration where patient_name like N'%'+@fn+'%')
//insert into Treat_Patient(pid,c_code) values(@pid,@c)
//end
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.VarChar, SqlDbType.VarChar };
name_input = new string[] { "@fn", "@c" };
values = new string[] { f_name, clinic_name.ToString() };
con1.ExecuteNonQueryProcedure("clinic_محرك_البحث_للحجز_treat_patient_insert", name_input, values, types);
con1.CloseConnection();
//create procedure clinic_محرك_البحث_للحجز_patient_select(@fn varchar(50))
//as
//begin
//select patient_name, catogrical_code from Registeration_patientRegisteration where patient_name like N'%'+@fn+'%'
//end
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.VarChar };
name_input = new string[] { "@fn" };
values = new string[] { f_name };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_البحث_للحجز_patient_select", name_input, values, types);
dr.Read();
MessageBox.Show("لفد تم الادخال بنجاح");
حجز_العياده f = new حجز_العياده();
f.Focus();
this.DialogResult = DialogResult.OK;
f.Focus();
dr.Close();
con1.CloseConnection();
}
private void button3_Click(object sender, EventArgs e)
{
// create procedure clinic_محرك_البحث_للحجز_patient_visit_insert(@pid int,@ordere int,@type nvarchar(50),@type2 nvarchar(50),@date nvarchar(100))
//as
//begin
//declare @i int
//set @i=(select count(visit_id)+1 from entranceoffice_visit where pat_id=@pid)
//insert into entranceoffice_visit(visit_id,pat_id,ordere,type_of_visit,type_status,entrance_date) values(@i,@pid,@ordere,@type, @type2 , @date)
//end
//create procedure clinic_محرك_البحث_للحجز_treat_patient_insert(@pid int,@c nvarchar(30))
//as
//begin
//insert into Treat_Patient(pid,c_code) values(@pid,@c)
//end
// create procedure clinic_محرك_البحث_للحجز_patient_visit_insert(@pid int,@ordere int,@type nvarchar(50),@type2 nvarchar(50),@date nvarchar(100))
//as
//begin
//declare @i int
//set @i=(select count(visit_id)+1 from entranceoffice_visit where pat_id=@pid)
//insert into entranceoffice_visit(visit_id,pat_id,ordere,type_of_visit,Finish_Type,entrance_date) values(@i,@pid,@ordere,@type, @type2 , @date)
//endd
int order = 1000;
string type = "خارجي", type2 = "open";
DateTime dt = DateTime.Now;
String date = dt.ToString("yyyy-MM-dd hh:mm:ss");
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.NVarChar };
name_input = new string[] { "@pid", "@ordere", "@type", "@type2", "@date" };
values = new string[] { x1, order.ToString(), type, type2, date };
con1.ExecuteNonQueryProcedure("clinic_محرك_البحث_للحجز_patient_visit_insert", name_input, values, types);
con1.CloseConnection();
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int, SqlDbType.VarChar };
name_input = new string[] { "@pid", "@c" };
values = new string[] { x1, code.ToString() };
con1.ExecuteNonQueryProcedure("clinic_محرك_البحث_للحجز_treat_patient_insert1", name_input, values, types);
con1.CloseConnection();
//create procedure clinic_محرك_البحث_للحجز_patient_select1(@pid int)
//as
//begin
//select patient_name, catogrical_code from Registeration_patientRegisteration where patient_id=@pid
//end
con1.OpenConection();
types = new SqlDbType[] { SqlDbType.Int };
name_input = new string[] { "@pid" };
values = new string[] { x1 };
SqlDataReader dr = con1.ShowDataInGridViewUsingStoredProcDR("clinic_محرك_البحث_للحجز_patient_select1", name_input, values, types);
dr.Read();
MessageBox.Show("لفد تم الادخال بنجاح");
حجز_العياده f = new حجز_العياده();
name1 = dr[0].ToString() + " " + dr[1].ToString();
//name2 = dr[2].ToString();
f.Focus();
this.DialogResult = DialogResult.OK;
f.Focus();
con1.CloseConnection();
//insert_into_patient_visit();
//cmd = new SqlCommand("insert into pat_clinic(patient_id,code_clinic) values(" + int.Parse(x1) + "," + code + ");", con);
//try
//{
// MessageBox.Show("لفد تم الادخال بنجاح");
// cmd = new SqlCommand("select fname,sname,institution from patient where patient_id=" + int.Parse(x1) + "", con);
// dr = cmd.ExecuteReader();
// dr.Read();
// حجز_العياده f = new حجز_العياده();
// name1 = dr[0].ToString() +" "+ dr[1].ToString();
// name2 = dr[2].ToString();
// f.Focus();
// this.DialogResult = DialogResult.OK;
// f.Focus();
}
