// add new patient #region add_patient public bool insertdata (string id, string name, string gender, string birth_date, string status, string reg_date, string address, string phone1, string phone2, string email) { asd : try { SqlParameter[] param = new SqlParameter[13]; param[0] = new SqlParameter("stype", SqlDbType.VarChar, 20); param[0].Value = "patient"; param[1] = new SqlParameter("sid", SqlDbType.VarChar, 20); param[1].Value = id; param[2] = new SqlParameter("sname", SqlDbType.VarChar, 50); param[2].Value = name; param[3] = new SqlParameter("sgender", SqlDbType.VarChar, 10); param[3].Value = gender; param[4] = new SqlParameter("sbirth_date", SqlDbType.Date); param[4].Value = birth_date; param[5] = new SqlParameter("sstatus", SqlDbType.VarChar, 10); param[5].Value = status; param[6] = new SqlParameter("sreg_date", SqlDbType.Date); param[6].Value = reg_date; param[7] = new SqlParameter("saddress", SqlDbType.VarChar, 100); param[7].Value = address; param[8] = new SqlParameter("sphone1", SqlDbType.VarChar, 20); param[8].Value = phone1; param[9] = new SqlParameter("sphone2", SqlDbType.VarChar, 20); param[9].Value = phone2; param[10] = new SqlParameter("semail", SqlDbType.VarChar, 20); param[10].Value = email; param[11] = new SqlParameter("sposition", SqlDbType.VarChar, 10); param[11].Value = DBNull.Value; param[12] = new SqlParameter("snat_id", SqlDbType.VarChar, 14); param[12].Value = DBNull.Value; exp_num = con.Exacute_procdure("sp_add", param); if (exp_num == 1) { return(true); } else { if (exp_num == 1062) { id = increasekey(id); goto asd; } MessageBox.Show(exp_num.ToString()); return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
/* public DataTable select_visit() * { * dt = new DataTable(); * param = new SqlParameter[16]; * param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); * param[0].Value = "select"; * param[1] = new SqlParameter("@visit_id", SqlDbType.NVarChar, 25); * param[1].Value = ""; * param[2] = new SqlParameter("@entry_date", SqlDbType.DateTime); * param[2].Value = ""; * param[3] = new SqlParameter("@entry_time", SqlDbType.DateTime); * param[3].Value =""; * param[4] = new SqlParameter("@entry_state", SqlDbType.NVarChar,100); * param[4].Value = "patient"; * param[5] = new SqlParameter("@exit_date", SqlDbType.DateTime); * param[5].Value = "patient"; * param[6] = new SqlParameter("@exit_Status", SqlDbType.NVarChar, 100); * param[6].Value = 10; * param[7] = new SqlParameter("@Initial_diagnosis", SqlDbType.NVarChar, 100); * param[7].Value = ""; * param[8] = new SqlParameter("@Final_diagnosis", SqlDbType.NVarChar,100); * param[8].Value = "patient"; * param[9] = new SqlParameter("@recommendation", SqlDbType.NVarChar, 1000); * param[9].Value = "patient"; * param[10] = new SqlParameter("@send_side_name", SqlDbType.NVarChar, 50); * param[10].Value = "patient"; * param[11] = new SqlParameter("@Visit_type", SqlDbType.NVarChar, 50); * param[11].Value = "patient"; * param[12] = new SqlParameter("@Visit_state", SqlDbType.Bit); * param[12].Value = 10; * param[13] = new SqlParameter("@entry_doc_id", SqlDbType.NVarChar, 25); * param[13].Value = "patient"; * param[14] = new SqlParameter("@entry_emp_id", SqlDbType.NVarChar, 25); * param[14].Value = "patient"; * param[15] = new SqlParameter("@pat_id", SqlDbType.NVarChar, 25); * param[15].Value = "patient"; * * dt = con.ReadData("sp_visit", param); * return dt; * } */ // add new visit #region add_visit public bool insertdata (string visit_id, string entry_date, string entry_time, string Initial_diagnos, string send_side_name, string Visit_type , string entry_doc_name, string entry_empUser_id, string pat_id, string pat_name) { try { param = new SqlParameter[10]; param[0] = new SqlParameter("@visit_id", SqlDbType.NVarChar, 25); param[0].Value = visit_id; param[1] = new SqlParameter("@entry_date", SqlDbType.Date); // entry_date = entry_date.ToString("yyyy-MM-dd"); param[1].Value = entry_date; param[2] = new SqlParameter("@entry_time", SqlDbType.NVarChar, 20); param[2].Value = entry_time; param[3] = new SqlParameter("@Initial_diagnosis", SqlDbType.NVarChar, 100); param[3].Value = Initial_diagnos; param[4] = new SqlParameter("@send_side_name", SqlDbType.NVarChar, 50); param[4].Value = send_side_name; param[5] = new SqlParameter("@Visit_type", SqlDbType.NVarChar, 50); param[5].Value = Visit_type; param[6] = new SqlParameter("@entry_empUser_id", SqlDbType.NVarChar, 25); param[6].Value = entry_empUser_id; param[7] = new SqlParameter("@pat_id", SqlDbType.NVarChar, 25); param[7].Value = pat_id; param[8] = new SqlParameter("@pat_name", SqlDbType.NVarChar, 100); param[8].Value = pat_name; param[9] = new SqlParameter("@entry_doc_name", SqlDbType.NVarChar, 50); param[9].Value = entry_doc_name; ////////////////////////////////// int exp_num; exp_num = con.Exacute_procdure("insert_visit", param); if ((exp_num == 1)) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool updatedata (string type, string dep_id, string dep_name, string dep_location, string notes) { try { int exp_num; con = new Connection(); param = new SqlParameter[5]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = dep_id; param[2] = new SqlParameter("@name", SqlDbType.NVarChar, 100); param[2].Value = dep_name; param[3] = new SqlParameter("@location", SqlDbType.NVarChar, 100); param[3].Value = dep_location; param[4] = new SqlParameter("note", SqlDbType.NVarChar, 255); param[4].Value = notes; exp_num = con.Exacute_procdure("sp_department", param); if (exp_num == 1) { return(true); } else { MessageBox.Show(exp_num.ToString()); return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool updatedata(string type, string id, string user_name, string password, string emp_id) { try { int exp_num; con = new Connection(); param = new SqlParameter[5]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = id; param[2] = new SqlParameter("@user_name", SqlDbType.NVarChar, 50); param[2].Value = user_name; param[3] = new SqlParameter("@password", SqlDbType.NVarChar, 50); param[3].Value = password; param[4] = new SqlParameter("@emp_id", SqlDbType.NVarChar, 25); param[4].Value = emp_id; exp_num = con.Exacute_procdure("sp_users", param); if (exp_num == 1) { return(true); } else { MessageBox.Show(exp_num.ToString()); return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool insertdata (string type, string id, string user_name, string password, string emp_id) { asd : try { int exp_num; con = new Connection(); param = new SqlParameter[5]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = id; param[2] = new SqlParameter("@user_name", SqlDbType.NVarChar, 50); param[2].Value = user_name; param[3] = new SqlParameter("@password", SqlDbType.NVarChar, 50); param[3].Value = password; param[4] = new SqlParameter("@emp_id", SqlDbType.NVarChar, 25); param[4].Value = emp_id; exp_num = con.Exacute_procdure("sp_users", param); if (exp_num == 1) { return(true); } else { if (exp_num == 1062) { id = cls_validate.increasekey(id, 5); goto asd; } else if (exp_num == 2627) { MessageBox.Show("اسم المستخدم موجود مسبقا الرجاءادخال اسم مستخدم جديد"); } //MessageBox.Show(exp_num.ToString()); return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool delete_patient(string type, string dep_id) { try { int exp_num; con = new Connection(); param = new SqlParameter[5]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = dep_id; param[2] = new SqlParameter("@name", SqlDbType.NVarChar, 100); param[2].Value = ""; param[3] = new SqlParameter("@location", SqlDbType.NVarChar, 100); param[3].Value = ""; param[4] = new SqlParameter("note", SqlDbType.NVarChar, 255); param[4].Value = ""; exp_num = con.Exacute_procdure("sp_department", param); if (exp_num == 1) { return(true); } else if (exp_num == 547) { MessageBox.Show("عفوا لا يمكن حذف هذا القسم لانه مرتبط ببيانات اخرى داخل النظام ", "تنبيه ", MessageBoxButtons.OK, MessageBoxIcon.Error); return(false); } else { MessageBox.Show(exp_num.ToString()); return(false); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
// add new patient #region add_patient public bool insertdata (string type, string id, string name, string address, string phone, string status, string age, string job, string nationality, string address_woking, string card_id, string card_realease_place, string married_duration, string husband_name, string husband_identity, string patient_Relative_name, string patient_Relative_state, string patient_Relative_job, string patient_Relative_address, string patient_Relative_identity, string patient_Relative_phone, string date_Regist, string user_id) { try { param = new SqlParameter[23]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = id; param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); param[2].Value = name; param[3] = new SqlParameter("@address", SqlDbType.NVarChar, 100); param[3].Value = address; param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14); param[4].Value = phone; param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14); param[5].Value = status; param[6] = new SqlParameter("@age", SqlDbType.Int); param[6].Value = int.Parse(age); param[7] = new SqlParameter("@job", SqlDbType.NVarChar, 50); param[7].Value = job; param[8] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14); param[8].Value = nationality; param[9] = new SqlParameter("@address_working", SqlDbType.NVarChar, 100); param[9].Value = address_woking; param[10] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14); param[10].Value = card_id; param[11] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14); param[11].Value = card_realease_place; param[12] = new SqlParameter("@married_duration", SqlDbType.Int); param[12].Value = int.Parse(married_duration); param[13] = new SqlParameter("@husband_name", SqlDbType.NVarChar, 100); param[13].Value = husband_name; param[14] = new SqlParameter("@husband_identity", SqlDbType.NVarChar, 14); param[14].Value = husband_identity; param[15] = new SqlParameter("@patient_Relative_name", SqlDbType.NVarChar, 100); param[15].Value = patient_Relative_name; param[16] = new SqlParameter("@patient_Relative_identity", SqlDbType.NVarChar, 14); param[16].Value = patient_Relative_identity; param[17] = new SqlParameter("@patient_Relative_state", SqlDbType.NVarChar, 50); param[17].Value = patient_Relative_state; param[18] = new SqlParameter("@patient_Relative_phone", SqlDbType.NVarChar, 14); param[18].Value = patient_Relative_phone; param[19] = new SqlParameter("@patient_Relative_address", SqlDbType.NVarChar, 100); param[19].Value = patient_Relative_address; param[20] = new SqlParameter("@patient_Relative_job", SqlDbType.NVarChar, 50); param[20].Value = patient_Relative_job; param[21] = new SqlParameter("@reg_date", SqlDbType.Date); param[21].Value = date_Regist; param[22] = new SqlParameter("@user_id", SqlDbType.NVarChar, 50); param[22].Value = user_id; ///////////////////////////////////// con.Exacute_procdure("sp_patient", param); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool insertdata (string type, string id, string name, string address, string phone, string status, string email, string gender, string birth_date, string religion, string birth_place, string nationality, string card_id, string card_realease_place, string card_realease_date, string qualification, string qualification_date, string years_of_experience, string experience, string prevoius_jobs, string hiring_date, string total_salary, string career_level , string career_name, string dep_code, string Emp_Type, string blood_type) { try { con = new Connection(); param = new SqlParameter[27]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = id; param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); param[2].Value = name; param[3] = new SqlParameter("@addreess", SqlDbType.NVarChar, 100); param[3].Value = address; param[4] = new SqlParameter("@phone", SqlDbType.NVarChar, 14); param[4].Value = phone; param[5] = new SqlParameter("@status", SqlDbType.NVarChar, 14); param[5].Value = status; param[6] = new SqlParameter("@email", SqlDbType.NVarChar, 100); param[6].Value = email; param[7] = new SqlParameter("@gender", SqlDbType.NVarChar, 14); param[7].Value = gender; param[8] = new SqlParameter("@birth_date", SqlDbType.Date); param[8].Value = birth_date; param[9] = new SqlParameter("@religion", SqlDbType.NVarChar, 14); param[9].Value = religion;; param[10] = new SqlParameter("@birth_place", SqlDbType.NVarChar, 100); param[10].Value = birth_place; param[11] = new SqlParameter("@nationality", SqlDbType.NVarChar, 14); param[11].Value = nationality; param[12] = new SqlParameter("@card_id", SqlDbType.NVarChar, 14); param[12].Value = card_id; param[13] = new SqlParameter("@card_realease_place", SqlDbType.NVarChar, 14); param[13].Value = card_realease_place;; param[14] = new SqlParameter("@card_realease_date", SqlDbType.Date); param[14].Value = card_realease_date;; param[15] = new SqlParameter("@qualification", SqlDbType.NVarChar, 100); param[15].Value = qualification;; param[16] = new SqlParameter("@qualification_date", SqlDbType.Date); param[16].Value = qualification_date;; param[17] = new SqlParameter("@years_of_experience", SqlDbType.Int); param[17].Value = years_of_experience;; param[18] = new SqlParameter("@experience", SqlDbType.NVarChar, 100); param[18].Value = experience;; param[19] = new SqlParameter("@prevoius_jobs", SqlDbType.NVarChar, 100); param[19].Value = prevoius_jobs; param[20] = new SqlParameter("@hiring_date", SqlDbType.Date); param[20].Value = hiring_date;; param[21] = new SqlParameter("@total_salary", SqlDbType.Float); param[21].Value = float.Parse(total_salary); param[22] = new SqlParameter("@career_level", SqlDbType.NVarChar, 50); param[22].Value = career_level; param[23] = new SqlParameter("@career_name", SqlDbType.NVarChar, 50); param[23].Value = career_name; param[24] = new SqlParameter("@dep_code", SqlDbType.NVarChar, 25); param[24].Value = dep_code; param[25] = new SqlParameter("@Emp_Type", SqlDbType.NVarChar, 25); param[25].Value = Emp_Type; param[26] = new SqlParameter("@blood_type", SqlDbType.NVarChar, 25); param[26].Value = blood_type; ///////////////////////////////////// con.Exacute_procdure("sp_employee", param); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
public bool deletedata (string type, string id) { try { con = new Connection(); param = new SqlParameter[27]; param[0] = new SqlParameter("@type", SqlDbType.NVarChar, 25); param[0].Value = type; param[1] = new SqlParameter("@id", SqlDbType.NVarChar, 25); param[1].Value = id; param[2] = new SqlParameter("@Name", SqlDbType.NVarChar, 100); param[2].Value = DBNull.Value; param[3] = new SqlParameter("@addreess", SqlDbType.NVarChar, 100); param[3].Value = DBNull.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 = DBNull.Value; param[7] = new SqlParameter("@gender", SqlDbType.NVarChar, 14); param[7].Value = DBNull.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 = DBNull.Value; 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; ///////////////////////////////////// con.Exacute_procdure("sp_employee", param); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }
// add new patient #region add_patient public bool insertdata (string type, string patient_id, string patient_name, string age, string identity_type, string identity_side, string nationality, string marital_status, string job, string phone, string address_of_patient, string address_working, string husband_name, string husband_identity, string married_duration, string patient_Relative_name, string patient_Relative_state, string patient_Relative_job, string patient_Relative_address, string patient_Relative_identity, string patient_Relative_phone, string date_Regist) { try { param = new SqlParameter[22]; param[0] = new SqlParameter("type", SqlDbType.VarChar, 20); param[0].Value = type; param[1] = new SqlParameter("patient_id", SqlDbType.VarChar, 20); param[1].Value = patient_id; param[2] = new SqlParameter("patient_name", SqlDbType.VarChar, 70); param[2].Value = patient_name; param[3] = new SqlParameter("age", SqlDbType.Int); param[3].Value = age; param[4] = new SqlParameter("identity_type", SqlDbType.VarChar, 14); param[4].Value = identity_type; param[5] = new SqlParameter("identity_side", SqlDbType.VarChar, 20); param[5].Value = identity_side; param[6] = new SqlParameter("nationality", SqlDbType.VarChar, 40); param[6].Value = nationality; param[7] = new SqlParameter("marital_status", SqlDbType.VarChar, 40); param[7].Value = marital_status; param[8] = new SqlParameter("job", SqlDbType.VarChar, 40); param[8].Value = job; param[9] = new SqlParameter("phone", SqlDbType.VarChar, 11); param[9].Value = phone; param[10] = new SqlParameter("address_of_patient", SqlDbType.VarChar, 40); param[10].Value = address_of_patient; param[11] = new SqlParameter("address_working", SqlDbType.VarChar, 40); param[11].Value = address_working; param[12] = new SqlParameter("husband_name", SqlDbType.VarChar, 50); param[12].Value = husband_name; param[13] = new SqlParameter("husband_identity", SqlDbType.VarChar, 14); param[13].Value = husband_identity; param[14] = new SqlParameter("married_duration", SqlDbType.VarChar, 40); param[14].Value = married_duration; param[15] = new SqlParameter("patient_Relative_name", SqlDbType.VarChar, 50); param[15].Value = patient_Relative_name; param[16] = new SqlParameter("patient_Relative_state", SqlDbType.VarChar, 14); param[16].Value = patient_Relative_state; param[17] = new SqlParameter("patient_Relative_job", SqlDbType.VarChar, 40); param[17].Value = patient_Relative_job; param[18] = new SqlParameter("patient_Relative_address", SqlDbType.VarChar, 70); param[18].Value = patient_Relative_address; param[19] = new SqlParameter("patient_Relative_identity", SqlDbType.VarChar, 14); param[19].Value = patient_Relative_identity; param[20] = new SqlParameter("patient_Relative_phone", SqlDbType.VarChar, 11); param[20].Value = patient_Relative_phone; param[21] = new SqlParameter("date_Regist", SqlDbType.VarChar, 225); param[21].Value = date_Regist; ///////////////////////////////////// con.Exacute_procdure("sp_patient", param); return(true); } catch (Exception ex) { MessageBox.Show(ex.ToString()); return(false); } }