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); }