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();
}
}
