/**
*\brief A function get the magazine list
*\return The magazine list
*/
public static List <Magazine> GetMagazineList()
{
SqlCommand sqlSelectCommand = Magazine.GetSelectCommand();
List <Magazine> MagazineList = new List <Magazine>();
try
{
DatabaseHandler.SQL_CONNECTION.Open();
SqlDataReader reader = sqlSelectCommand.ExecuteReader();
while (reader.HasRows && reader.Read())
{
object[] attributesOfMagazine = new object[5]; // Magazine class has 5 attributes.
reader.GetValues(attributesOfMagazine); // Get the first row.
Magazine newMagazine = new Magazine(0, "a", 0);
newMagazine.Fill(attributesOfMagazine);
MagazineList.Add(newMagazine);
}
DatabaseHandler.SQL_CONNECTION.Close();
return(MagazineList);
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return(null);
}
}
