private void docSearch_Load(object sender, EventArgs e)
{
dt = con.ReadData("doc_select");
dv = new DataView(dt);
if (dt.Rows.Count > 0)
{
dgv_doc.DataSource = dv;
}
}
int exp_num;// execption number
public DataTable selct_patient()
{
DataTable dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("p_type", SqlDbType.VarChar, 20);
param[0].Value = "patient";
dt = con.ReadData("sp_select", param);
return(dt);
}
public DataTable select_patient()
{
dt = new DataTable();
param = new SqlParameter[23];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = "select";
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = "";
param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
param[2].Value = "";
param[3] = new SqlParameter("@address", SqlDbType.NVarChar, 100);
param[3].Value = "";
param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14);
param[4].Value = "patient";
param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14);
param[5].Value = "patient";
param[6] = new SqlParameter("@age", SqlDbType.Int);
param[6].Value = 10;
param[7] = new SqlParameter("@job", SqlDbType.NVarChar, 50);
param[7].Value = "";
param[8] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14);
param[8].Value = "patient";
param[9] = new SqlParameter("@address_working", SqlDbType.NVarChar, 100);
param[9].Value = "patient";
param[10] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14);
param[10].Value = "patient";
param[11] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14);
param[11].Value = "patient";
param[12] = new SqlParameter("@married_duration", SqlDbType.Int);
param[12].Value = 10;
param[13] = new SqlParameter("@husband_name", SqlDbType.NVarChar, 100);
param[13].Value = "patient";
param[14] = new SqlParameter("@husband_identity", SqlDbType.NVarChar, 14);
param[14].Value = "patient";
param[15] = new SqlParameter("@patient_Relative_name", SqlDbType.NVarChar, 100);
param[15].Value = "patient";
param[16] = new SqlParameter("@patient_Relative_identity", SqlDbType.NVarChar, 14);
param[16].Value = "patient";
param[17] = new SqlParameter("@patient_Relative_state", SqlDbType.NVarChar, 50);
param[17].Value = "patient";
param[18] = new SqlParameter("@patient_Relative_phone", SqlDbType.NVarChar, 14);
param[18].Value = "patient";
param[19] = new SqlParameter("@patient_Relative_address", SqlDbType.NVarChar, 100);
param[19].Value = "patient";
param[20] = new SqlParameter("@patient_Relative_job", SqlDbType.NVarChar, 50);
param[20].Value = "patient";
param[21] = new SqlParameter("@reg_date", SqlDbType.Date);
param[21].Value = DBNull.Value;
param[22] = new SqlParameter("@user_id", SqlDbType.NVarChar, 50);
param[22].Value = "patient";
dt = con.ReadData("sp_patient", param);
return(dt);
}
public DataTable select_patient()
{
DataTable dt = new DataTable();
param = new SqlParameter[22];
param[0] = new SqlParameter("type", SqlDbType.VarChar, 20);
param[0].Value = "select";
param[1] = new SqlParameter("patient_id", SqlDbType.VarChar, 20);
param[1].Value = "patient";
param[2] = new SqlParameter("patient_name", SqlDbType.VarChar, 70);
param[2].Value = "patient";
param[3] = new SqlParameter("age", SqlDbType.Int);
param[3].Value = 25;
param[4] = new SqlParameter("identity_type", SqlDbType.VarChar, 14);
param[4].Value = "patient";
param[5] = new SqlParameter("identity_side", SqlDbType.VarChar, 20);
param[5].Value = "patient";
param[6] = new SqlParameter("nationality", SqlDbType.VarChar, 40);
param[6].Value = "patient";
param[7] = new SqlParameter("marital_status", SqlDbType.VarChar, 40);
param[7].Value = "patient";
param[8] = new SqlParameter("job", SqlDbType.VarChar, 40);
param[8].Value = "patient";
param[9] = new SqlParameter("phone", SqlDbType.VarChar, 11);
param[9].Value = "patient";
param[10] = new SqlParameter("address_of_patient", SqlDbType.VarChar, 40);
param[10].Value = "patient";
param[11] = new SqlParameter("address_working", SqlDbType.VarChar, 40);
param[11].Value = "patient";
param[12] = new SqlParameter("husband_name", SqlDbType.VarChar, 50);
param[12].Value = "patient";
param[13] = new SqlParameter("husband_identity", SqlDbType.VarChar, 14);
param[13].Value = "patient";
param[14] = new SqlParameter("married_duration", SqlDbType.VarChar, 40);
param[14].Value = "patient";
param[15] = new SqlParameter("patient_Relative_name", SqlDbType.VarChar, 50);
param[15].Value = "patient";
param[16] = new SqlParameter("patient_Relative_state", SqlDbType.VarChar, 14);
param[16].Value = "patient";
param[17] = new SqlParameter("patient_Relative_job", SqlDbType.VarChar, 40);
param[17].Value = "patient";
param[18] = new SqlParameter("patient_Relative_address", SqlDbType.VarChar, 70);
param[18].Value = "patient";
param[19] = new SqlParameter("patient_Relative_identity", SqlDbType.VarChar, 14);
param[19].Value = "patient";
param[20] = new SqlParameter("patient_Relative_phone", SqlDbType.VarChar, 11);
param[20].Value = "patient";
param[21] = new SqlParameter("date_Regist", SqlDbType.VarChar, 225);
param[21].Value = "patient";
dt = con.ReadData("sp_patient", param);
return(dt);
}
private void btn_login_Click(object sender, EventArgs e)
{
Connection con = new Connection();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@user_name", SqlDbType.NVarChar, 50);
param[0].Value = txt_username.Text;
dt = con.ReadData("select_user", param);
if (dt.Rows.Count < 1)
{
MessageBox.Show("اسم المستخدم خطأ رجاء ادخال الاسم الصحيح", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (dt.Rows[0][2].ToString() == txt_password.Text)
{
string emp = "";
emp = (con.selectt("select employee.Name from employee where id='" + dt.Rows[0][3].ToString() + "';")).Rows[0][0].ToString();
curnet_user = dt.Rows[0][0].ToString();
Main_Form frm = new Main_Form(curnet_user, emp);
frm.Show();
this.Hide();
}
else
{
MessageBox.Show("كلمةالمرور خطأ رجاء ادخال كلمة المرور الصحيحة", "تنبيه", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
//if (txt_username.Text == "asd")
//{
// if (txt_password.Text == "asd")
// {
// curnet_user = txt_username.Text;
// Main_Form frm = new Main_Form(curnet_user);
// frm.Show();
// this.Hide();
// }
//}
//else
//{
// MessageBox.Show("اسم المستخدم خطأ رجاء ادخال الاسم الصحيح","تنبيه",MessageBoxButtons.OK,MessageBoxIcon.Error);
//}
}
public DataTable selct_department()
{
con = new Connection();
dt = new DataTable();
param = new SqlParameter[5];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = "select";
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = "select";
param[2] = new SqlParameter("@name", SqlDbType.NVarChar, 25);
param[2].Value = "select";
param[3] = new SqlParameter("@location", SqlDbType.NVarChar, 25);
param[3].Value = "select";
param[4] = new SqlParameter("@note", SqlDbType.NVarChar, 25);
param[4].Value = "select";
dt = con.ReadData("sp_department", param);
return(dt);
}
public DataTable select()
{
con = new Connection();
dt = new DataTable();
param = new SqlParameter[5];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = "select";
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = "select";
param[2] = new SqlParameter("@user_name", SqlDbType.NVarChar, 50);
param[2].Value = "select";
param[3] = new SqlParameter("@password", SqlDbType.NVarChar, 50);
param[3].Value = "select";
param[4] = new SqlParameter("@emp_id", SqlDbType.NVarChar, 25);
param[4].Value = "select";
dt = con.ReadData("sp_users", param);
return(dt);
}
//public DataTable select_emp()
//{
// con = new Connection();
// dt = new DataTable();
// dt = con.ReadData("sp_select_emp");
// return dt;
//}
public DataTable select_employee()
{
con = new Connection();
dt = new DataTable();
param = new SqlParameter[27];
param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25);
param[0].Value = "select";
param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25);
param[1].Value = "";
param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100);
param[2].Value = "";
param[3] = new SqlParameter("@addreess", SqlDbType.NVarChar, 100);
param[3].Value = "";
param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14);
param[4].Value = DBNull.Value;;
param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14);
param[5].Value = DBNull.Value;;
param[6] = new SqlParameter("@email", SqlDbType.NVarChar, 100);
param[6].Value = 10;
param[7] = new SqlParameter("@gender", SqlDbType.NVarChar, 14);
param[7].Value = "";
param[8] = new SqlParameter("@birth_date", SqlDbType.Date);
param[8].Value = DBNull.Value;;
param[9] = new SqlParameter("@religion", SqlDbType.NVarChar, 14);
param[9].Value = DBNull.Value;;
param[10] = new SqlParameter("@birth_place", SqlDbType.NVarChar, 100);
param[10].Value = DBNull.Value;;
param[11] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14);
param[11].Value = DBNull.Value;;
param[12] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14);
param[12].Value = 10;
param[13] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14);
param[13].Value = DBNull.Value;;
param[14] = new SqlParameter("@card_realease_date", SqlDbType.Date);
param[14].Value = DBNull.Value;;
param[15] = new SqlParameter("@qualification", SqlDbType.NVarChar, 100);
param[15].Value = DBNull.Value;;
param[16] = new SqlParameter("@qualification_date", SqlDbType.Date);
param[16].Value = DBNull.Value;;
param[17] = new SqlParameter("@years_of_experience", SqlDbType.Int);
param[17].Value = DBNull.Value;;
param[18] = new SqlParameter("@experience", SqlDbType.NVarChar, 100);
param[18].Value = DBNull.Value;;
param[19] = new SqlParameter("@prevoius_jobs", SqlDbType.NVarChar, 100);
param[19].Value = DBNull.Value;
param[20] = new SqlParameter("@hiring_date", SqlDbType.Date);
param[20].Value = DBNull.Value;;
param[21] = new SqlParameter("@total_salary", SqlDbType.Float);
param[21].Value = DBNull.Value;
param[22] = new SqlParameter("@career_level", SqlDbType.NVarChar, 50);
param[22].Value = DBNull.Value;
param[23] = new SqlParameter("@career_name", SqlDbType.NVarChar, 50);
param[23].Value = DBNull.Value;
param[24] = new SqlParameter("@dep_code", SqlDbType.NVarChar, 25);
param[24].Value = DBNull.Value;
param[25] = new SqlParameter("@Emp_Type", SqlDbType.NVarChar, 25);
param[25].Value = DBNull.Value;
param[26] = new SqlParameter("@blood_type", SqlDbType.NVarChar, 25);
param[26].Value = DBNull.Value;
dt = con.ReadData("sp_employee", param);
return(dt);
}
