public static List<ProgrammeDetails> getAllProgrammeDetails()
{
try
{
List<ProgrammeDetails> allProgrammeDetails = new List<ProgrammeDetails>();
string command = "SELECT * FROM ProgrammeDetails;";
SqlCommand sqlCommand = new SqlCommand(command, DBConnection.getInstance().Conn);
DBConnection.getInstance().Conn.Open();
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
int programmeID = reader.GetInt32(reader.GetOrdinal("ProgrammeID"));
string programmeName = reader.GetString(reader.GetOrdinal("Name"));
ProgrammeDetails pd = new ProgrammeDetails(programmeID, programmeName);
allProgrammeDetails.Add(pd);
}
}
return allProgrammeDetails;
}
catch (ArgumentOutOfRangeException aoorex)
{
return null;
}
catch (Exception ex)
{
return null;
}
finally
{
DBConnection.getInstance().Conn.Close();
}
}
public static List <ProgrammeDetails> getAllProgrammeDetails()
{
try
{
List <ProgrammeDetails> allProgrammeDetails = new List <ProgrammeDetails>();
string command = "SELECT * FROM ProgrammeDetails;";
SqlCommand sqlCommand = new SqlCommand(command, DBConnection.getInstance().Conn);
DBConnection.getInstance().Conn.Open();
using (SqlDataReader reader = sqlCommand.ExecuteReader())
{
while (reader.Read())
{
int programmeID = reader.GetInt32(reader.GetOrdinal("ProgrammeID"));
string programmeName = reader.GetString(reader.GetOrdinal("Name"));
ProgrammeDetails pd = new ProgrammeDetails(programmeID, programmeName);
allProgrammeDetails.Add(pd);
}
}
return(allProgrammeDetails);
}
catch (ArgumentOutOfRangeException aoorex)
{
return(null);
}
catch (Exception ex)
{
return(null);
}
finally
{
DBConnection.getInstance().Conn.Close();
}
}