/// <summary>
/// Bestellingsregel verwijderen
/// </summary>
/// <param name="data">data = object van entity class bestellingsregel</param>
/// <returns></returns>
public static void verwijderen(Bestellingregel data)
{
DatabaseCon.CONN.Open();
cmd = DatabaseCon.CONN.CreateCommand();
cmd.CommandText = "DELETE FROM dbo.Bestellingregel WHERE bestelling_id =" + data.bestelling_id;
cmd.ExecuteNonQuery();
DatabaseCon.CONN.Close();
}
/// <summary>
/// Bestellingsregel aanmaken
/// </summary>
/// <param name="data">data = object van entity bestellingregel</param>
public static void aanmaken(Bestellingregel data)
{
DatabaseCon.CONN.Open();
cmd = DatabaseCon.CONN.CreateCommand();
cmd.CommandText = "INSERT INTO dbo.Bestellingregel VALUES(@boek_isbn_nummer, @bestelling_id, @aantal)";
cmd.Parameters.AddWithValue("@boek_isbn_nummer", data.boek_isbn_nummer);
cmd.Parameters.AddWithValue("@bestelling_id", data.bestelling_id);
cmd.Parameters.AddWithValue("@aantal", data.aantal);
cmd.ExecuteNonQuery();
DatabaseCon.CONN.Close();
}
/// <summary>
/// overzciht van alle bestelregels van een bestelling
/// </summary>
/// <param name="data">data = object van entity bestelregels</param>
/// <returns>datatable waar de bestellingregels van de bestelling inzitten</returns>
public static DataTable overzichtBestelling(Bestellingregel data)
{
DatabaseCon.CONN.Open();
DataTable table = new DataTable();
cmd = DatabaseCon.CONN.CreateCommand();
String selectCommand1 = "SELECT b.isbn_nummer, b.Titel, b.Auteur, bv.aantal as Voorraad, b.Prijs as Prijs_Een FROM dbo.Boek b JOIN dbo.Boekvoorraad bv ON bv.boek_isbn_nummer = b.isbn_nummer WHERE b.zichtbaar = 1 and b.isbn_nummer ='" + data.boek_isbn_nummer + "'";
SqlDataAdapter dataAdapter1 = new SqlDataAdapter(selectCommand1, DatabaseCon.CONNSTRING);
SqlCommandBuilder commandBuilder1 = new SqlCommandBuilder(dataAdapter1);
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter1.Fill(table);
DatabaseCon.CONN.Close();
return(table);
}
/// <summary>
/// overzicht van alle bestelregels
/// </summary>
/// <param name="data">data = object van entity class bestellingregels</param>
/// <returns>datatable waar alle bestellingen inzitten</returns>
public static DataTable overzicht(Bestellingregel data)
{
DatabaseCon.CONN.Open();
DataTable table = new DataTable();
cmd = DatabaseCon.CONN.CreateCommand();
String selectCommand1 = "SELECT * FROM dbo.Bestellingregel WHERE bestelling_id =" + data.bestelling_id;
SqlDataAdapter dataAdapter1 = new SqlDataAdapter(selectCommand1, DatabaseCon.CONNSTRING);
SqlCommandBuilder commandBuilder1 = new SqlCommandBuilder(dataAdapter1);
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapter1.Fill(table);
DatabaseCon.CONN.Close();
return(table);
}
