public static List<Book> GetBooks(bool useDB)
{
DataTable dt;
List<Book> books = new List<Book>();
Book book;
if (useDB)
{
dt = DBBookshop.GetBooks(cs);
} else
{
dt = DBBookshop.GetTestData();
}
foreach (DataRow row in dt.Rows)
{
book = new Book((int)row[0]);
book.Name = row["name"].ToString();
book.Author = row["author"].ToString();
book.Country = row["country"].ToString();
book.Year = (int)row["year"];
books.Add(book);
}
return books;
}
public static int UpdateBook(Book book)
{
try
{
int rows = DBBookshop.UpdateBook(cs, book.ID, book.Name, book.Author, book.Country, book.Year);
return rows;
}
catch (Exception ex)
{
throw ex;
}
}
private void btnNew_Click(object sender, RoutedEventArgs e)
{
if (btnNew.Content.ToString() == "Uusi")
{
Book book = new Book(0);
book.Name = "Anna kirjan nimi";
spRigth.DataContext = book;
btnNew.Content = "Tallenna uusi kirja";
} else
{
Book book = (Book)spRigth.DataContext;
BLBookshop.InsertBook(book);
dataGrid.DataContext = BLBookshop.GetBooks(true);
btnNew.Content = "Uusi";
}
}
public static bool InsertBook(Book book)
{
try
{
int rows = DBBookshop.InsertBook(cs, book.Name, book.Author, book.Country, book.Year);
if (rows > 0) return true;
else return false;
}
catch (Exception ex)
{
throw ex;
}
}
public static bool DeleteBook(Book book)
{
try
{
int rows = DBBookshop.DeleteBook(cs, book.ID);
if (rows > 0) return true;
else return false;
}
catch (Exception ex)
{
throw ex;
}
}
