public RegistrationRequest SearchByRegistrationID(int id)
{
using (SqlConnection connection = new SqlConnection(connectionString)) {
connection.Open();
SqlCommand select = new SqlCommand("SELECT * FROM RegistrationRequest " +
"WHERE registrationID=@ID;");
select.Parameters.AddWithValue("@ID", id);
select.Connection = connection;
SqlDataReader reader = select.ExecuteReader();
if (reader.Read())
{
CourseDAO courseDAO = new CourseDAO(connectionString);
UserTableDAO userTableDAO = new UserTableDAO(connectionString);
return(new RegistrationRequest(
Convert.ToInt32(reader["registrationID"]),
// Use the UserTableDAO to retrieve a User object
userTableDAO.SearchByEmail(Convert.ToString(reader["email"])),
// Use the CourseDAO to retrieve a Course object
courseDAO.SearchByCourseCode(Convert.ToString(reader["courseCode"])),
// Create a Status enum
(Status)Convert.ToInt32(reader["statusCode"])
));
}
}
return(null);
}
/// <summary>
/// Retrieves all user requests based on a given user
/// </summary>
/// <param name="username">The username of the user</param>
/// <returns>A list of all the user's request. Returns null if user has no requests, or user does not exist in database</returns>
public List <RegistrationRequest> GetAllUserRequests(string username)
{
List <RegistrationRequest> requests = new List <RegistrationRequest>();
using (SqlConnection connection = new SqlConnection(connectionString)) {
connection.Open();
SqlCommand select = new SqlCommand("SELECT * FROM RegistrationRequest WHERE email=@UEmail;");
select.Parameters.AddWithValue("@UEmail", username);
select.Connection = connection;
SqlDataReader reader = select.ExecuteReader();
while (reader.Read())
{
CourseDAO courseDAO = new CourseDAO(connectionString);
UserTableDAO userTableDAO = new UserTableDAO(connectionString);
requests.Add(new RegistrationRequest(
int.Parse(reader["registrationId"].ToString()),
// Use the UserTableDAO to retrieve a User object
userTableDAO.SearchByEmail(Convert.ToString(reader["email"])),
// Use the CourseDAO to retrieve a Course object
courseDAO.SearchByCourseCode(Convert.ToString(reader["courseCode"])),
// Create a Status enum
(Status)Convert.ToInt32(reader["statusCode"])
));
}
if (requests.Count < 0)
{
return(null);
}
}
return(requests);
}