private void bbEditBook_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (_libraryDataAccess == null) { MessageBox.Show("Load data first"); } else { LibraryDataSet.BookRow bookRow = viewBooks.GetFocusedDataRow() as LibraryDataSet.BookRow; if (bookRow == null) { return; } LibraryDataSet libraryDSCopy = libraryDS.Copy() as LibraryDataSet; bookRow = libraryDSCopy.Book.FindById(bookRow.Id); if (bookRow == null) { return; } using (FrmEditBook showEdit = new FrmEditBook(libraryDSCopy, bookRow)) { showEdit.ShowInTaskbar = false; DialogResult result = showEdit.ShowDialog(); if (result == DialogResult.OK) { libraryDS.Merge(libraryDSCopy); } } } }
private LibraryDataSet.BookRow AddBookRow() { LibraryDataSet.BookRow bookRow = lds.Book.NewBookRow(); bookRow.Title = txtTitle.Text; bookRow.Publisher = txtPublisher.Text; bookRow.Year = Int32.Parse(txtYear.EditValue.ToString()); bookRow.IdAuthor = (int)lookUpAuthor.EditValue; lds.Book.AddBookRow(bookRow); return(bookRow); }
private void bbShowBook_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (_libraryDataAccess == null) { MessageBox.Show("Load data first"); } else { LibraryDataSet.BookRow bookRow = viewBooks.GetFocusedDataRow() as LibraryDataSet.BookRow; using (FrmShowBook show = new FrmShowBook(libraryDS, bookRow)) { show.ShowInTaskbar = false; show.ShowDialog(); } } }
private void mainViewBooks_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e) { if (_libraryDataAccess == null) { MessageBox.Show("Load data first"); } else { LibraryDataSet.BookRow bookRow = viewBooks.GetDataRow(e.RowHandle) as LibraryDataSet.BookRow; if (bookRow == null) { return; } e.Value = bookRow.AuthorRow.FirstName + " " + bookRow.AuthorRow.LastName; } }
public FrmEditBook(LibraryDataSet _libraryDS, LibraryDataSet.BookRow bookRow) { InitializeComponent(); libraryDS = _libraryDS; bkr = bookRow; if (bookRow != null) { txtTitle.EditValue = bookRow.Title; txtYear.EditValue = bookRow.Year.ToString(); txtPublisher.EditValue = bookRow.Publisher; lookUpAuthor.Properties.DataSource = libraryDS.Author; lookUpAuthor.EditValue = bookRow.AuthorRow.Id; int bookId = bookRow.Id; gridChapters.DataSource = libraryDS.Chapter.Where(row => row.IdBook == bookId).AsDataView(); } }
private void Ok_Click_1(object sender, EventArgs e) { if (!CheckData.checkBookData(txtTitle.Text, txtPublisher.Text, txtYear.Text, lookUpAuthor.Text)) { return; } else { LibraryDataSet.BookRow bookRow = AddBookRow(); foreach (LibraryDataSet.ChapterRow chr in ds.Chapter.Rows) { if (CheckData.checkChapterData(chr)) { LibraryDataSet.ChapterRow nchr = MakeChapterRow(chr, bookRow.Id); lds.Chapter.AddChapterRow(nchr); } } } this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); }
public FrmShowBook(LibraryDataSet bookSet, LibraryDataSet.BookRow bookRow) { InitializeComponent(); if (bookRow != null) { txtTitle.EditValue = bookRow.Title; txtYear.EditValue = bookRow.Year.ToString(); txtPublisher.EditValue = bookRow.Publisher; String author = "none"; foreach (LibraryDataSet.AuthorRow authrow in bookSet.Author) { if (authrow.Id == bookRow.IdAuthor) { author = authrow.FirstName + " " + authrow.LastName; } } txtAuthor.EditValue = author; int bookId = bookRow.Id; gridShowChapter.DataSource = bookSet.Chapter.Where(row => row.IdBook == bookId).AsDataView(); } }