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);
}