/************************************************************ 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); }