private void DeleteBook(int bookId)
{
using (var context = new LibraryEntities())
{
var book = context.Books.FirstOrDefault(b => b.Id == bookId);
context.Books.Remove(book);
context.SaveChanges();
}
}
private bool InventoryNumberUsed(string inventoryNumber)
{
using (var content = new LibraryEntities())
{
var book = content.Books.Where(x => x.InventoryNumber.Equals(inventoryNumber)).ToList();
if (book.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
private void InitializeBookDetails(int bookId)
{
using (var context = new LibraryEntities())
{
var book = context.Books.FirstOrDefault(b => b.Id == bookId);
if (book != null)
{
textBoxInventoryNumber.Text = book.InventoryNumber;
textBoxInventoryNumber.ReadOnly = true;
textBoxTitle.Text = book.Title;
textBoxAuthor.Text = book.Author;
textBoxDescription.Text = book.Description;
}
}
}
private void LoadBooks()
{
using (var context = new LibraryEntities())
{
var books = context.Books.Select(x => new
{
Id = x.Id,
InventoryNumber = x.InventoryNumber,
Title = x.Title,
Author = x.Author,
Description = x.Description
}).ToList();
this.booksGridView.DataSource = books;
}
}
private void button1_Click(object sender, EventArgs e)
{
if (IsValid())
{
using (var connection = new LibraryEntities())
{
try
{
if (!isEditForm)
{
var book = new Books
{
InventoryNumber = textBoxInventoryNumber.Text,
Title = textBoxTitle.Text,
Author = textBoxAuthor.Text,
Description = textBoxDescription.Text
};
connection.Books.Add(book);
connection.SaveChanges();
}
else
{
var book = connection.Books.FirstOrDefault(b => b.Id == _bookId);
if (book == null)
{
MessageBox.Show("An error occured while saving the book");
}
else
{
book.InventoryNumber = textBoxInventoryNumber.Text;
book.Author = textBoxAuthor.Text;
book.Title = textBoxTitle.Text;
book.Description = textBoxDescription.Text;
connection.SaveChanges();
}
}
this.Dispose();
MessageBox.Show("Book was saved successfully");
}
catch (Exception exception)
{
this.Dispose();
MessageBox.Show("An error occured while saving the book");
}
}
}
}
