/**
*\brief A function to get the book list
*\return The book list
*/
public static List <Book> GetBookList()
{
SqlCommand sqlSelectCommand = Book.GetSelectCommand();
List <Book> BookList = new List <Book>();
try
{
DatabaseHandler.SQL_CONNECTION.Open();
SqlDataReader reader = sqlSelectCommand.ExecuteReader();
while (reader.HasRows && reader.Read())
{
object[] attributesOfBook = new object[7]; // Book class has 7 attributes.
reader.GetValues(attributesOfBook); // Get the first row.
Book newBook = new Book(0, "a", 0);
newBook.Fill(attributesOfBook);
BookList.Add(newBook);
}
DatabaseHandler.SQL_CONNECTION.Close();
return(BookList);
}
catch (Exception error)
{
MessageBox.Show(error.Message);
return(null);
}
}
/* DATA ADAPTER && DATA SET */
/**
*\brief A function to get the SQL data adapter for the given table name
*\param sourceTableName: Name of the source table
*\return The SQL data adapter
*/
public static SqlDataAdapter GetDataAdapterFor(string sourceTableName)
{
if (sourceTableName == "tblCustomer")
{
return(new SqlDataAdapter(Customer.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
if (sourceTableName == "tblBook")
{
return(new SqlDataAdapter(Book.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
if (sourceTableName == "tblMagazine")
{
return(new SqlDataAdapter(Magazine.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
if (sourceTableName == "tblMusicCD")
{
return(new SqlDataAdapter(MusicCD.GetSelectCommand().CommandText, DatabaseHandler.CONNECTION_STRING));
}
return(null);
}