public DataTable GetNotification(NotificationBLL objNBLL)
{
query = "select * from Notification order by NotificationID DESC";
return(objDBManager.ExecuteDataTable(query));
}
public DataTable GetSupervisors(DashboardBLL objDBLL)
{
query = " SELECT Users.UserID,Users.FirstName,Users.LastName,Users.Email,Users.UserName,Users.Password,Users.UserType,Users.Gender,Supervisors.SupervisorID,Supervisors.ContactNo,Supervisors.Department,Supervisors.Info FROM Users FULL OUTER JOIN Supervisors ON Users.UserID=Supervisors.SupervisorID where Users.UserType='Supervisor'";
return(objDBManager.ExecuteDataTable(query));
}
/*---------------------------------------------------------------Login Page-------------------------------------------------------------------*/
public DataTable GetUsers(UserBLL regbll)
{
query = "select * from Users where UserName='******'AND Password='******'";
return(objDBManager.ExecuteDataTable(query));
}
