public DataTable Get_All_Supervisor()
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_All_Supervisor", null);
DAL.Clsoe();
return(Dt);
}
public DataTable Get_Fees_Stauts()
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
DataTable Dt = new DataTable();
Dt = DAL.SelectData("Get_Fees_Stauts", null);
DAL.Clsoe();
return(Dt);
}
public DataTable VerfiyStudentID(int ID)
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
DataTable Dt = new DataTable();
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@ID", SqlDbType.Int);
param[0].Value = ID;
Dt = DAL.SelectData("VerfiyStudentID", param);
DAL.Clsoe();
return(Dt);
}
public DataTable LOGIN(string ID, String PASSWORD)
{
Data_Access_Layer.DataAccessLayer DAL = new Data_Access_Layer.DataAccessLayer();
SqlParameter[] param = new SqlParameter[2];
param[0] = new SqlParameter("@USERNAME", SqlDbType.VarChar, 25);
param[0].Value = ID;
param[1] = new SqlParameter("@PASSWORD", SqlDbType.VarChar, 25);
param[1].Value = PASSWORD;
DataTable Dt = new DataTable();
Dt = DAL.SelectData("SP_LOGIN", param);
DAL.Clsoe();
return(Dt);
}
