//********************عرض*********************** public DataTable GET_ALL_PATIENT() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllPatients1", 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_EXLab() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllLab", null); dal.close(); return(dt); }
//********************عرض كل التعاقدات *********************************** public DataTable GET_ALL_CONTRACT() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetContractors", 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_Doctors() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("GetAllDoctors", 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_List_PATIENT() { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dt = dal.SelectData("get_list_patient", null); dal.close(); return(dt); }
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 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 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 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 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); }
public DataTable select_group(string group_name) { DAL.DBL dal = new DAL.DBL(); dal.open(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("group_name", SqlDbType.NVarChar, 100); param[0].Value = group_name; dt = dal.SelectData("select_group", param); dal.close(); return(dt); }
public DataTable get_patient(string patient_name) { DAL.DBL dal = new DAL.DBL(); dal.open(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@patient_name", SqlDbType.NVarChar, 100); param[0].Value = patient_name; dt = dal.SelectData("get_patient", 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 dismisal(string id, DateTime date) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@id", SqlDbType.NVarChar, 100); param[0].Value = id; param[1] = new SqlParameter("@date", SqlDbType.Date, 100); param[1].Value = date; dt = dal.SelectData("getdismsal", param); dal.close(); return(dt); }
//********************البحث باسم المعمل ************************************ public DataTable SearchExLabByName(string name, int sgin) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@Exname", SqlDbType.NVarChar, 100); param[0].Value = name; param[1] = new SqlParameter("@sign", SqlDbType.Int); param[1].Value = sgin; dt = dal.SelectData("SearchExLabByName", param); dal.close(); return(dt); }
public DataTable select_group_patient(int reservation_id) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dal.open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@reservation_id", SqlDbType.Int); param[0].Value = reservation_id; dt = dal.SelectData("select_group_patient", param); dal.close(); return(dt); }
public DataTable LogIN(int ID, string pwd, string Ujob) { DAL.DBL dal = new DAL.DBL(); SqlParameter[] param = new SqlParameter[3]; param[0] = new SqlParameter("@ID", SqlDbType.Int); param[0].Value = ID; param[1] = new SqlParameter("@Pwd", SqlDbType.NVarChar, 50); param[1].Value = pwd; param[2] = new SqlParameter("@Ujob", SqlDbType.NVarChar, 50); param[2].Value = Ujob; dal.open(); DataTable dt = new DataTable(); dt = dal.SelectData("UserLogIn", param); dal.close(); return(dt); }
public DataTable select_group_analysis_normal(string group_name, int reservation_id) { DAL.DBL dal = new DAL.DBL(); DataTable dt = new DataTable(); dal.open(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@group_name", SqlDbType.NVarChar, 100); param[0].Value = group_name; param[1] = new SqlParameter("@reservation_id", SqlDbType.Int); param[1].Value = reservation_id; dt = dal.SelectData("select_group_analysis_normal", param); dal.close(); return(dt); }