public void add_result(int reservation_id, string name_en, string result, string normal, string comment, string other) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@reservation_id", SqlDbType.Int); param[0].Value = reservation_id; param[1] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100); param[1].Value = name_en; param[2] = new SqlParameter("@result", SqlDbType.NVarChar, 100); param[2].Value = result; param[3] = new SqlParameter("@normal", SqlDbType.NVarChar, 100); param[3].Value = normal; param[4] = new SqlParameter("@comment", SqlDbType.NVarChar, 100); param[4].Value = comment; param[5] = new SqlParameter("@other", SqlDbType.NVarChar, 100); param[5].Value = other; dal.executeCommand("add_result", param); dal.close(); }
//***********************************تعديل ********************************* public void edit_patient(string pat_name, string pat_phone, string pat_address, int pat_age, string unit, string pat_emile, int id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100); param[0].Value = pat_name; param[1] = new SqlParameter("@phone", SqlDbType.NVarChar, 100); param[1].Value = pat_phone; param[2] = new SqlParameter("@address", SqlDbType.NVarChar, 100); param[2].Value = pat_address; param[3] = new SqlParameter("@age", SqlDbType.Int); param[3].Value = pat_age; param[4] = new SqlParameter("@unit", SqlDbType.NVarChar, 50); param[4].Value = unit; param[5] = new SqlParameter("@email", SqlDbType.NVarChar, 100); param[5].Value = pat_emile; param[6] = new SqlParameter("@id", SqlDbType.Int, 100); param[6].Value = id; dal.executeCommand("edit_patient", param); dal.close(); }
//***********************************تعديل ******************************** public void UpDate_CONTRACT(string con_name, string con_specialization, string con_add, string con_phone, string con_mail, string con_dis, int id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@contractor_name", SqlDbType.NVarChar, 100); param[0].Value = con_name; param[1] = new SqlParameter("@con_specialization", SqlDbType.NVarChar, 100); param[1].Value = con_specialization; param[2] = new SqlParameter("@contractor_address", SqlDbType.NVarChar, 100); param[2].Value = con_add; param[3] = new SqlParameter("@contractor_phone", SqlDbType.VarChar, 50); param[3].Value = con_phone; param[4] = new SqlParameter("@contractor_email", SqlDbType.NVarChar, 50); param[4].Value = con_mail; param[5] = new SqlParameter("@con_discount", SqlDbType.VarChar, 50); param[5].Value = con_dis; param[6] = new SqlParameter("@contractor_id", SqlDbType.Int); param[6].Value = id; dal.executeCommand("UpDate_CONTRACT", param); dal.close(); }
public void add_reservation(string reservation_date, int patient_id, string doctor_name, double price, double discount, double total, double paid, double rest) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@reservation_date", SqlDbType.Date); param[0].Value = reservation_date; param[1] = new SqlParameter("@patient_id", SqlDbType.Int); param[1].Value = patient_id; param[2] = new SqlParameter("@doctor_name", SqlDbType.NVarChar, 100); param[2].Value = doctor_name; param[3] = new SqlParameter("@price", SqlDbType.Float); param[3].Value = price; param[4] = new SqlParameter("@discount", SqlDbType.Float); param[4].Value = discount; param[5] = new SqlParameter("@total", SqlDbType.Float); param[5].Value = total; param[6] = new SqlParameter("@paid", SqlDbType.Float); param[6].Value = paid; param[7] = new SqlParameter("@rest", SqlDbType.Float); param[7].Value = rest; dal.executeCommand("add_reservation", param); dal.close(); }
public void Add_analysis(string name_en, string analysis_price, string how_to_analysis, string analysis_time, string result, string notes) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100); param[0].Value = name_en; param[1] = new SqlParameter("@analysis_price", SqlDbType.VarChar, 50); param[1].Value = analysis_price; param[2] = new SqlParameter("@how_to_analysis", SqlDbType.NVarChar, 100); param[2].Value = how_to_analysis; param[3] = new SqlParameter("@analysis_time", SqlDbType.NVarChar, 100); param[3].Value = analysis_time; param[4] = new SqlParameter("@result", SqlDbType.NVarChar, 100); param[4].Value = result; param[5] = new SqlParameter("@notes", SqlDbType.NVarChar, 200); param[5].Value = notes; dal.executeCommand("Add_analysis", param); dal.close(); }
public void Update_ExLab(int ExLid, string Exlname, string ExLaddress, string ExLphone, string ExLemail, string ExLdiscount) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@EXLid", SqlDbType.Int); param[0].Value = ExLid; param[1] = new SqlParameter("@EXLname", SqlDbType.NVarChar, 100); param[1].Value = Exlname; param[2] = new SqlParameter("@EXLaddress", SqlDbType.NVarChar, 100); param[2].Value = ExLaddress; param[3] = new SqlParameter("@EXLphone", SqlDbType.VarChar, 50); param[3].Value = ExLphone; param[4] = new SqlParameter("@EXLemail", SqlDbType.NVarChar, 100); param[4].Value = ExLemail; param[5] = new SqlParameter("@EXLdiscount", SqlDbType.VarChar, 50); param[5].Value = ExLdiscount; dal.executeCommand("UpdatingExLab", param); dal.close(); }
public void UpDate_Supplier(int id, string name, string specialization, string address, string phone, string email) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@supp_id", SqlDbType.Int); param[0].Value = id; param[1] = new SqlParameter("@supp_name", SqlDbType.NVarChar, 100); param[1].Value = name; param[2] = new SqlParameter("@supp_specialization", SqlDbType.NVarChar, 100); param[2].Value = specialization; param[3] = new SqlParameter("@supp_address", SqlDbType.NVarChar, 100); param[3].Value = address; param[4] = new SqlParameter("@supp_phone", SqlDbType.NVarChar, 50); param[4].Value = phone; param[5] = new SqlParameter("supp_email", SqlDbType.NVarChar, 100); param[5].Value = email; dal.executeCommand("UpDateSupp", param); dal.close(); }
public void Update_Doctor(int Did, string Dname, string Dspecialization, string Daddress, string Dphone, string Demail, string Ddiscount) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[7]; param[0] = new SqlParameter("@Did", SqlDbType.Int); param[0].Value = Did; param[1] = new SqlParameter("@Dname", SqlDbType.NVarChar, 100); param[1].Value = Dname; param[2] = new SqlParameter("@Dspecialization", SqlDbType.NVarChar, 100); param[2].Value = Dspecialization; param[3] = new SqlParameter("@Daddress", SqlDbType.NVarChar, 100); param[3].Value = Daddress; param[4] = new SqlParameter("@Dphone", SqlDbType.VarChar, 50); param[4].Value = Dphone; param[5] = new SqlParameter("@Demail", SqlDbType.VarChar, 50); param[5].Value = Demail; param[6] = new SqlParameter("@Ddiscount", SqlDbType.VarChar, 50); param[6].Value = Ddiscount; dal.executeCommand("UpdatingDoctor", param); dal.close(); }
public void Add_normal(string name_en, int age_from, string unit_from, int age_to, string unit_to, string gender, string normal, string normal_unit) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[8]; param[0] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100); param[0].Value = name_en; param[1] = new SqlParameter("@age_from", SqlDbType.Int); param[1].Value = age_from; param[2] = new SqlParameter("@unit_from", SqlDbType.NVarChar, 100); param[2].Value = unit_from; param[3] = new SqlParameter("@age_to", SqlDbType.Int); param[3].Value = age_to; param[4] = new SqlParameter("@unit_to", SqlDbType.NVarChar, 100); param[4].Value = unit_to; param[5] = new SqlParameter("@gender", SqlDbType.NVarChar, 50); param[5].Value = gender; param[6] = new SqlParameter("@normal", SqlDbType.NVarChar, 50); param[6].Value = normal; param[7] = new SqlParameter("@normal_unit", SqlDbType.NVarChar, 50); param[7].Value = normal_unit; dal.executeCommand("Add_normal", param); dal.close(); }
//********************عرض كل التعاقدات *********************************** public DataTable GET_ALL_CONTRACT() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetContractors", null); dal.close(); return(dt); }
//****************AnalysisPrice***************************** public DataTable GetAnalysisPrice() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAnalysisPrice", null); dal.close(); return(dt); }
public DataTable Get_All_Supplier() { DAL.DBL dl = new DAL.DBL(); DataTable dt = new DataTable(); dt = dl.SelectData("SelectSup", null); dl.close(); return(dt); }
//********************عرض*********************** public DataTable GET_ALL_PATIENT() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllPatients1", null); dal.close(); return(dt); }
public DataTable Get_All_USER() { DAL.DBL dl = new DAL.DBL(); DataTable dt = new DataTable(); dt = dl.SelectData("SelectUser", null); dl.close(); return(dt); }
public DataTable Get_All_EXLab() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllLab", null); dal.close(); return(dt); }
public DataTable Get_All_Doctors() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllDoctors", null); dal.close(); return(dt); }
//********************عرض*********************** public DataTable GET_List_PATIENT() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("get_list_patient", null); dal.close(); return(dt); }
// DELETE USER public void Delete_User(int id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@UserId", SqlDbType.Int); param[0].Value = id; dal.executeCommand("DeleteUser", param); dal.close(); }
public void Delete_analysis(int analysis_id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@analysis_id", SqlDbType.Int); param[0].Value = analysis_id; dal.executeCommand("Delete_analysis", param); dal.close(); }
public void Delete_group(int group_id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@group_id", SqlDbType.Int); param[0].Value = group_id; dal.executeCommand("Delete_group", param); dal.close(); }
public DataTable Get_all_groups() { DAL.DBL dal = new DAL.DBL(); dal.open(); DataTable dt = new DataTable(); dt = dal.SelectData("Get_all_groups", null); dal.close(); return(dt); }
public DataTable GetAllNormals() { DAL.DBL dal = new DAL.DBL(); dal.open(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllNormals", null); dal.close(); return(dt); }
public void Delete_Doctor(int ID) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Did", SqlDbType.Int); param[0].Value = ID; dal.executeCommand("DeleteDoctor", param); dal.close(); }
public void Delete_normal(int normal_id) { DAL.DBL dal = new DAL.DBL(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@normal_id", SqlDbType.Int); param[0].Value = normal_id; dal.executeCommand("Delete_normal", param); dal.close(); }
public DataTable SearchDoctorBySpecialization(string specialization) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Dspecialization", SqlDbType.NVarChar, 100); param[0].Value = specialization; dt = dal.SelectData("SearchDoctorBySpecialization", param); dal.close(); return(dt); }
public DataTable SearchDoctorByName(string name) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@Dname", SqlDbType.NVarChar, 100); param[0].Value = name; dt = dal.SelectData("SearchDoctorByName", param); dal.close(); return(dt); }
//**************************************************************************************** //For Ex_Lab: //**********************عرض كل المعامل الخارجية ************************* public DataTable Get_All_EXLab(int sign) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@sign", SqlDbType.Int); param[0].Value = sign; dt = dal.SelectData("GetAllLab", param); dal.close(); return(dt); }
//*************************البحث ****************************** public DataTable SEARCH_PATIENT(string name) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@name", SqlDbType.NVarChar, 100); param[0].Value = name; dt = dal.SelectData("SearchPatient", param); dal.close(); return(dt); }
public DataTable Attendance(string id) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 100); param[0].Value = id; dt = dal.SelectData("SearchAttendance", param); dal.close(); return(dt); }
public DataTable Search_normal(string name_en) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@name_en", SqlDbType.NVarChar, 100); param[0].Value = name_en; dt = dal.SelectData("Search_normal", param); dal.close(); return(dt); }