//Search Method private void BtnSearch_Click(object sender, EventArgs e) { CmbCombobox select = CmbGenre.SelectedItem as CmbCombobox; if (string.IsNullOrEmpty(TxtBookName.Text) && string.IsNullOrEmpty(TxtAuthor.Text) && CmbGenre.SelectedItem != null) { MessageBox.Show("Please fill at least one field"); return; } var book = _context.Books .Where(b => (TxtBookName.Text != string.Empty ? b.Name.Contains(TxtBookName.Text) : false)) .OrderBy(b => b.Name) .ToList(); DgvAddBooks.Rows.Clear(); foreach (var item in book) { DgvAddBooks.Rows.Add(item.Id, item.Name, item.Author, item.Genre.Name, item.RentalPrice, item.Count); } Clear(); }
//Create and Read private void BtnBookAdd_Click(object sender, EventArgs e) { CmbCombobox select = CmbGenre.SelectedItem as CmbCombobox; if (!string.IsNullOrEmpty(TxtBookName.Text) || !string.IsNullOrEmpty(TxtAuthor.Text) || !string.IsNullOrEmpty(CmbGenre.Text) || !string.IsNullOrEmpty(TxtRentalPrice.Text) || !string.IsNullOrEmpty(TxtCount.Text)) { Book book = new Book//add book to database { Name = TxtBookName.Text, Author = TxtAuthor.Text, GenreId = select.Id, RentalPrice = Convert.ToDouble(TxtRentalPrice.Text), Count = Convert.ToInt32(TxtCount.Text), }; _context.Books.Add(book); _context.SaveChanges(); Clear(); } else { MessageBox.Show("Add,please"); } FillBooks(); }
// Book Create Event// private void BtnSave_Click(object sender, EventArgs e) { //Book Update Event// CmbCombobox select = CmbGenre.SelectedItem as CmbCombobox; if (_isUpdate) { _book.Name = TxtBookName.Text; _book.Price = Convert.ToDecimal(TxtPrice.Text); _book.Count = Convert.ToInt32(TxtCount.Text); _book.GenreId = select.Id; _bookDal.Update(_book); AddBook?.Invoke(_book, new EventArgs()); MessageBox.Show("Melumat Deisildi"); } else { if (!this.CheckInput() || CmbGenre.SelectedItem == null) { MessageBox.Show("Xanalari doldurun"); return; } Book book = new Book { Name = TxtBookName.Text, Price = Convert.ToDecimal(TxtPrice.Text), Count = Convert.ToInt32(TxtCount.Text), GenreId = select.Id }; _bookDal.Create(book); MessageBox.Show("Melumat elave edildi"); AddBook?.Invoke(book, new EventArgs()); } this.Close(); }
private void FillDataGenre() { List <Genre> genres = _context.Genres.ToList(); foreach (Genre item in genres) { CmbCombobox combobox = new CmbCombobox { Id = item.Id, Name = item.Name }; CmbGenre.Items.Add(combobox); } }
//Combobox Add Genres public void FillGenreAdd() { List <Genre> genres = _genreDal.GetGenreList(); foreach (Genre item in genres) { CmbCombobox combobox = new CmbCombobox { Id = item.Id, Name = item.Name }; CmbGenre.Items.Add(combobox); } }
//Update Method private void BtnUpdate_Click(object sender, EventArgs e) { CmbCombobox select = CmbGenre.SelectedItem as CmbCombobox; Book book = _context.Books.Find(_book.Id); book.Name = TxtBookName.Text; book.Author = TxtAuthor.Text; book.Count = Convert.ToInt32(TxtCount.Text); book.RentalPrice = Convert.ToDouble(TxtRentalPrice.Text); book.GenreId = select.Id; _context.SaveChanges(); FillBooks(); Clear(); }
private void DgvAddBooks_RowHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { CmbCombobox select = CmbGenre.SelectedItem as CmbCombobox; TxtBookName.Text = _book.Name; TxtAuthor.Text = _book.Author; TxtCount.Text = _book.Count.ToString(); TxtRentalPrice.Text = _book.RentalPrice.ToString(); Genre genre = _context.Genres.Find(_book.GenreId); CmbGenre.SelectedItem = new CmbCombobox { Id = genre.Id, Name = genre.Name }; CmbGenre.Text = genre.Name; }