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); }