/************************************************************ Book Passers *****/
public Book InsertBook(string title, string authF, string authL, int type)
{
try
{
BookType bookType = typeSql.FindTypeById(type);
log.Debug("Book_" + title + "-" + authL + "_Inserted");
return(bookSql.InsertBook(title, authF, authL, bookType, typeSql));
}
catch (Exception e)
{
log.Error("Insert Book(title,authF,authL,type,typeSql) Butler Failure", e);
return(bookSql.FailedBookQuery());
}
}
public List <Book> GetAllBooks(TypeSql typeSql)
{
List <Book> matchedBooks = new List <Book>();
try
{
con.Open();
cmd.CommandText = "SELECT * FROM book";
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Book book = new Book();
book.Id = rdr.GetInt32(0);
book.Title = rdr.GetString(1);
book.AuthL = rdr.GetString(2);
book.AuthF = rdr.GetString(3);
book.TomeType = typeSql.FindTypeById(rdr.GetInt32(4));
matchedBooks.Add(book);
}
}
catch (MySqlException e)
{
Book book = new Book()
{
Title = e.ToString()
};
matchedBooks.Add(book);
log.Error("Get Book(id, typeSql) Query Failure", e);
}
finally
{
con.Close();
}
return(matchedBooks);
}
public List <Book> GetBookByAuthL(string authL, TypeSql typeSql)
{
List <Book> matchedBooks = new List <Book>();
if (authL != null)
{
try
{
con.Open();
cmd.CommandText = "SELECT * FROM book WHERE book_auth_last=@AUTHL";
cmd.Parameters.AddWithValue("@AUTHL", authL);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Book book = new Book();
book.Id = rdr.GetInt32(0);
book.Title = rdr.GetString(1);
book.AuthL = rdr.GetString(2);
book.AuthF = rdr.GetString(3);
book.TomeType = typeSql.FindTypeById(rdr.GetInt32(4));
matchedBooks.Add(book);
}
}
catch (MySqlException e)
{
Book book = new Book()
{
Title = e.ToString()
};
matchedBooks.Add(book);
log.Error("Get Book(authL, typeSql) Query Failure", e);
}
finally
{
con.Close();
}
}
else
{
Book book = new Book()
{
Title = "Missing Parameter"
};
matchedBooks.Add(book);
}
return(matchedBooks);
}
public List <Book> GetBooksByType(BookType type, TypeSql typeSql)
{
List <Book> matchedBooks = new List <Book>();
con.Open();
cmd.CommandText = "SELECT * FROM book WHERE book_type=@TYPE";
cmd.Parameters.AddWithValue("@TYPE", type.Id);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Book book = new Book();
book.Id = rdr.GetInt32(0);
book.Title = rdr.GetString(1);
book.AuthL = rdr.GetString(2);
book.AuthF = rdr.GetString(3);
book.TomeType = typeSql.FindTypeById(rdr.GetInt32(4));
matchedBooks.Add(book);
}
con.Close();
return(matchedBooks);
}
/************************************************************ Book Setters **/
public Book FindBookById(int bookId, TypeSql typeSql)
{
Book book = new Book();
if (bookId != 0)
{
try
{
con.Open();
cmd.CommandText = "SELECT * FROM book WHERE book_id=" + bookId;
//cmd.Parameters.AddWithValue("@BookID", bookId);
rdr = cmd.ExecuteReader();
while (rdr.Read())
{
book.Id = rdr.GetInt32(0);
book.Title = rdr.GetString(1);
book.AuthL = rdr.GetString(2);
book.AuthF = rdr.GetString(3);
book.TomeType = typeSql.FindTypeById(rdr.GetInt32(4));
}
}
catch (MySqlException e)
{
book.Title = e.ToString();
log.Error("Find Book(bookId, typeSql) Query Failure", e);
}
finally
{
con.Close();
}
}
else
{
book.Title = "Missing Parameter";
}
return(book);
}
