public DataTable Get_Patient_Appointment() { DataTable dt = new DataTable(); dt = Dal.SelectDate("Names_Paient", null); Dal.Close(); return(dt); }
public DataTable Get_All_Patient() { DataTable dt = new DataTable(); dt = Dal.SelectDate("All_Patient", null); Dal.Close(); return(dt); }
public DataTable Old_Visits1(int ID_P) { Dal.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID_P", SqlDbType.Int); param[0].Value = ID_P; DataTable dt = Dal.SelectDate("Old_Visit1", param); Dal.Close(); return(dt); }
public DataTable Get_All_Doctors() { DataTable dt = new DataTable(); dt = Dal.SelectDate("All_Doctor", null); Dal.Close(); return(dt); }
public DataTable AllUser() { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); // DAL.Open(); DataTable dt = new DataTable(); dt = DAL.SelectDate("AllUser", null); DAL.Close(); return(dt); }
public DataTable Details_Paient(int ID_P) { Dal.Open(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID_P", SqlDbType.Int); param[0].Value = ID_P; DataTable dt = Dal.SelectDate("Details_Paients", param); Dal.Close(); return(dt); }
public DataTable Check_Appintment(int Id_P) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[1]; param[0] = new SqlParameter("@ID_P", SqlDbType.Int); param[0].Value = Id_P; // DAL.Open(); DataTable dt = new DataTable(); dt = DAL.SelectDate("Check_Appointment", param); DAL.Close(); return(dt); }
public DataTable Login(string Name, string PWD) { DAL.DataAccessLayer DAL = new DAL.DataAccessLayer(); SqlParameter[] param = new SqlParameter[2]; param[0] = new SqlParameter("@Name", SqlDbType.NVarChar, 50); param[0].Value = Name; param[1] = new SqlParameter("@PWD", SqlDbType.NVarChar, 50); param[1].Value = PWD; // DAL.Open(); DataTable dt = new DataTable(); dt = DAL.SelectDate("SP_LOGIN", param); DAL.Close(); return(dt); }