public void ShowTable()
{
dataGridViewB.Rows.Clear();
model = new ModelContainer();
List <string[]> data = new List <string[]>();
foreach (Books book in model.BooksSet)
{
data.Add(new string[4]);
data[data.Count - 1][0] = book.Id.ToString();
data[data.Count - 1][1] = book.Name;
data[data.Count - 1][2] = book.Author.Surname + " " + book.Author.Name + " " + book.Author.SecondName;
data[data.Count - 1][3] = book.Genre.Name;
dataGridViewB.Rows.Add(data[data.Count - 1]);
}
}
public void ShowTable()
{
dataGridViewBE.Rows.Clear();
model = new ModelContainer();
List <string[]> data = new List <string[]>();
var bookexemplar = model.BookExemplarSet.Where(x => x.Books.Id == book.Id);
foreach (BookExemplar bookExemplar in bookexemplar)
{
data.Add(new string[7]);
data[data.Count - 1][0] = bookExemplar.Id.ToString();
data[data.Count - 1][1] = bookExemplar.Year.ToString();
data[data.Count - 1][2] = bookExemplar.Series.Name;
data[data.Count - 1][3] = bookExemplar.Series.CoverType;
data[data.Count - 1][4] = bookExemplar.Number.ToString();
data[data.Count - 1][5] = bookExemplar.Store.Name;
data[data.Count - 1][6] = bookExemplar.Store.City.Name + " " + bookExemplar.Store.Address;
dataGridViewBE.Rows.Add(data[data.Count - 1]);
}
}