public void RemoveKlantFromDag(int KlantID, int DagID)
{
string sql = @"DELETE FROM [dbo].[dagpersooninfo]
WHERE [dagID] = @DagID AND [persoonInfoID] = @KlantID";
var dictionary = new Dictionary <string, object>
{
{ "@KlantID", KlantID },
{ "@DagID", DagID }
};
var parameters = new DynamicParameters(dictionary);
DataBaseAccess.DeleteData <DagDTO>(sql, parameters);
}
public void DagDelete(int ID)
{
string sql = @"DELETE FROM [dbo].[dag]
WHERE [dagID] = @ID";
var dictionary = new Dictionary <string, object>
{
{ "@ID", ID }
};
var parameters = new DynamicParameters(dictionary);
DataBaseAccess.DeleteData <DagDTO>(sql, parameters);
sql = @"DELETE FROM [dbo].[dagpersooninfo]
WHERE [dagID] = @ID";
DataBaseAccess.DeleteData <DagDTO>(sql, parameters);
}
