private void Add_Reader(object sender, RoutedEventArgs e) { try { using (DataBase.Context db = new DataBase.Context()) { var reader = db.Readers.Where(p => p.Name == Name_Reader.Text); if (reader.Count() == 0) { DataBase.Reader r = new DataBase.Reader { Name = Name_Reader.Text }; db.Readers.Add(r); db.SaveChanges(); ReadersLoad(); } else { MessageBox.Show("Данный читатель уже существует"); } } } catch (Exception e1) { MessageBox.Show("Данные введены не верно"); } }
private void Add_Book(object sender, RoutedEventArgs e) { try { using (DataBase.Context db = new DataBase.Context()) { var book = db.Books.Where(p => p.Name == Name_Book.Text && p.Author.Name == ListAuthors.SelectedItem.ToString()); var genre = db.Genres.Where(p => p.Name == Genre.SelectedItem.ToString()); var a = db.Authors.Where(p => p.Name == ListAuthors.SelectedItem.ToString()); if (book.Count() == 0) { DataBase.Book b = new DataBase.Book { Name = Name_Book.Text, Year = Convert.ToInt32(Year.Text), Description = Description.Text, Genre = genre.FirstOrDefault(), Quantity = Convert.ToInt32(Quantity.Text), Author = a.FirstOrDefault() }; db.Books.Add(b); db.SaveChanges(); BooksLoad(); } else { MessageBox.Show("Данная книга уже существует"); } } } catch (Exception e1) { MessageBox.Show("Данные введены не верно"); } }
private void Add_Author(object sender, RoutedEventArgs e) { try { using (DataBase.Context db = new DataBase.Context()) { var author = db.Authors.Where(p => p.Name == Name_Author.Text); if (author.Count() == 0) { DataBase.Author a = new DataBase.Author { Name = Name_Author.Text }; db.Authors.Add(a); db.SaveChanges(); AuthorsLoad(); } else { MessageBox.Show("Данный автор уже существует"); } } } catch (Exception e1) { MessageBox.Show("Данные введены не верно"); } }
private void LibraryLoad() { using (DataBase.Context db = new DataBase.Context()) { //db = new DataBase.Context(); //db.Libraries.Load(); // загружаем данные //LibraryGrid.ItemsSource = db.Libraries.Local.ToBindingList(); var libraries = db.Libraries.Select(p => new { Id = p.Id, NameReader = p.Reader.Name, NameBook = p.Book.Name, DateOfTook = p.DateOfTook, DateOfReturn = p.DateOfReturn, Author = p.Book.Author.Name }); LibraryGrid.ItemsSource = libraries.ToList(); var reader = db.Readers.Select(p => p.Name); Reader.ItemsSource = reader.ToList(); var book = db.Books.Select(p => p.Name); Book.ItemsSource = book.ToList(); db.Dispose(); } }
private void ReadersLoad() { using (DataBase.Context db = new DataBase.Context()) { var readers = db.Readers.Select(p => new { Id = p.Id, Name = p.Name }); ReadersGrid.ItemsSource = readers.ToList(); } }
private void AuthorsLoad() { using (DataBase.Context db = new DataBase.Context()) { var authors = db.Authors.Select(p => new { Id = p.Id, Name = p.Name }); AuthorsGrid.ItemsSource = authors.ToList(); } }
private void BooksLoad() { using (DataBase.Context db = new DataBase.Context()) { var books = db.Books.Select(p => new { Id = p.Id, Name = p.Name, Year = p.Year, Description = p.Description, Genre = p.Genre.Name, Quantity = p.Quantity, Author = p.Author.Name }); BooksGrid.ItemsSource = books.ToList(); var author = db.Authors.Select(p => p.Name); ListAuthors.ItemsSource = author.ToList(); var genre = db.Genres.Select(p => p.Name); Genre.ItemsSource = genre.ToList(); } }
private void Add_Took(object sender, RoutedEventArgs e) { try { using (DataBase.Context db = new DataBase.Context()) { var reader = db.Readers.Where(p => p.Name == Reader.Text); var book = db.Books.Where(p => p.Name == Book.Text); var libr = db.Libraries.Where(p => p.Book.Name == Book.Text && p.Reader.Name == Reader.Text); DateTime d1 = DateTime.Today; if (libr.Count() == 0) { DataBase.Library l = new DataBase.Library { DateOfTook = d1, DateOfReturn = d1.AddMonths(2), Book = book.FirstOrDefault(), Reader = reader.FirstOrDefault() }; db.Libraries.Add(l); db.SaveChanges(); LibraryLoad(); MessageBox.Show("Книга выдана на 2 месяца"); } else { MessageBox.Show("Данная запись уже существует"); } } db.Dispose(); } catch (Exception e1) { MessageBox.Show("Данные введены не верно"); } }
public MainWindow() { InitializeComponent(); db = new DataBase.Context(); LibraryLoad(); }