//********************عرض***********************
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);
}
