public static void returnBook(BookReturned book)
{
MySqlConnection con = DBConnection.getConnection();
if (con == null)
{
throw new Exception("Nu s-a putut realiza conexiunea");
}
MySqlCommand cmd = con.CreateCommand();
cmd.CommandText = "INSERT INTO booksreturned(`Nume Prenume`,Autor,`Titlu Carte`,`Data Publicare`,Limba,`Nr Pagini`,`Data Imprumut`,`Data Returnare`) VALUES(@numeprenume,@autor,@titlucarte,@datapublicare,@limba,@nrpagini,@dataimprumut,@datareturnare)";
cmd.Parameters.AddWithValue("@numeprenume", book.Fullname);
cmd.Parameters.AddWithValue("@autor", book.Author);
cmd.Parameters.AddWithValue("@titlucarte", book.BookName);
cmd.Parameters.AddWithValue("@datapublicare", book.DateAdded);
cmd.Parameters.AddWithValue("@limba", book.Language);
cmd.Parameters.AddWithValue("@nrpagini", book.NumberOfPages);
cmd.Parameters.AddWithValue("dataimprumut", book.DateIssued);
cmd.Parameters.AddWithValue("@datareturnare", book.DateReturned);
if (cmd.ExecuteNonQuery() != 1)
{
MessageBox.Show("Nu s-a putut returna cartea", "Atentionare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
GUIController.checkBookReturnedSuccess = true;
MessageBox.Show("Cartea a fost returnata", "Mesaj", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
con.Close();
}
private async void ReturnBorrowedBook_Click(object sender, RoutedEventArgs e)
{
var borrowing = await ApplicationDbContext.Instance.Borrowings.FindAsync(Borrowing.Id);
borrowing.ReturnDate = Calendar.SelectedDate;
await ApplicationDbContext.Instance.SaveChangesAsync();
BookReturned?.Invoke(this, new BookReturnedEventArgs(borrowing));
this.Close();
}
private void btn_returnBook_Click(object sender, EventArgs e)
{
BookReturned bookReturned = new BookReturned();
Book book = new Book();
bookReturned.Fullname = bookIssued.Fullname;
bookReturned.Author = bookIssued.Author;
bookReturned.BookName = bookIssued.BookName;
bookReturned.DateAdded = bookIssued.DateAdded;
bookReturned.DateIssued = bookIssued.DateIssued;
bookReturned.Language = bookIssued.Language;
bookReturned.NumberOfPages = bookIssued.NumberOfPages;
var date = DateTime.Now.ToString("yyyy.MM.dd");
bookReturned.DateReturned = Convert.ToDateTime(date);
try
{
BooksDao.returnBook(bookReturned);
}
catch (Exception exp)
{
MessageBox.Show("Nu ati selectat nicio carte", "Atentionare", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
if (GUIController.checkBookReturnedSuccess == true)
{
BooksDao.deleteIssuedBook(bookIssued);
if (GUIController.checkDeleteIssuedBookSuccess == true)
{
book.Author = bookReturned.Author;
book.BookName = bookReturned.BookName;
book.DateAdded = bookReturned.DateAdded;
book.Language = bookReturned.Language;
book.NumberOfPages = bookReturned.NumberOfPages;
BooksDao.insertBook(book);
returnBooksGridView.DataSource = BooksDao.issuedBooksTable();
}
}
}
private void Apply(BookReturned e)
{
_maybeBorrowerId = None;
}
