public void AddBook(Book newBook) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO checkouts (patron_id, book_id, checkout_date, due_date, returned) VALUES (@PatronId, @BookId, @TodayDate, @DueDate, @Returned);"; cmd.Parameters.Add(new MySqlParameter("@PatronId", _patronId)); cmd.Parameters.Add(new MySqlParameter("@BookId", newBook.GetBookId())); cmd.Parameters.Add(new MySqlParameter("@TodayDate", DateTime.Now.Date.ToString("yyyy-MM-dd"))); TimeSpan fourWeeks = new TimeSpan(28, 0, 0, 0); cmd.Parameters.Add(new MySqlParameter("@DueDate", DateTime.Now.Add(fourWeeks).Date.ToString("yyyy-MM-dd"))); cmd.Parameters.Add(new MySqlParameter("@Returned", false)); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }
public override bool Equals(System.Object otherBook) { if (!(otherBook is Book)) { return(false); } else { Book newBook = (Book)otherBook; bool idEquality = this.GetBookId().Equals(newBook.GetBookId()); bool titleEquality = this.GetTitle().Equals(newBook.GetTitle()); bool copiesEquality = this.GetCopies().Equals(newBook.GetCopies()); return(idEquality && titleEquality && copiesEquality); } }
public void AddBook(Book newBook) { MySqlConnection conn = DB.Connection(); conn.Open(); var cmd = conn.CreateCommand() as MySqlCommand; cmd.CommandText = @"INSERT INTO authors_books (author_id, book_id) VALUES (@AuthorId, @BookId);"; cmd.Parameters.Add(new MySqlParameter("@AuthorId", _authorId)); cmd.Parameters.Add(new MySqlParameter("@BookId", newBook.GetBookId())); cmd.ExecuteNonQuery(); conn.Close(); if (conn != null) { conn.Dispose(); } }