private ClassISBN GetISBNFromDB(string inID)
{
DataTable dt = DbReturnDataTable($"SELECT * FROM ISBNnr WHERE id = {inID}");
ClassISBN CI = new ClassISBN();
foreach (DataRow row in dt.Rows)
{
CI.id = row["id"].ToString();
CI.ISBN = row["isbnNr"].ToString();
}
return(CI);
}
public ObservableCollection <ClassISBN> GetISBNs()
{
ObservableCollection <ClassISBN> cISBN = new ObservableCollection <ClassISBN>();
string sqlQuery = "SELECT * FROM ISBNnr";
DataTable dataTable = DbReturnDataTable(sqlQuery);
foreach (DataRow row in dataTable.Rows)
{
ClassISBN isbn = new ClassISBN();
isbn.ISBN = row["isbnNr"].ToString();
isbn.id = row["id"].ToString();
cISBN.Add(isbn);
}
return(cISBN);
}
public void UpdateISBNInDB(ClassISBN inISBN)
{
ExecuteNonQuery($"UPDATE ISBNnr SET isbnNr = '{inISBN.ISBN}' WHERE id = {inISBN.id}");
}
public void InsertISBNIntoDB(ClassISBN inISBN)
{
ExecuteNonQuery($"INSERT INTO ISBNnr (isbnNr) VALUES ('{inISBN.ISBN}')");
}
