public static async Task DeleteRelatedOrganisation(string connectionString, RelatedOrganisation relatedOrganisation) { var query = "DELETE FROM dbo.RelatedOrganisations WHERE OrganisationId = @organisationId AND RelatedOrganisationId = @relatedOrganisationId;"; await SqlExecutor.ExecuteAsync <RelatedOrganisation>(connectionString, query, new { organisationId = relatedOrganisation.OrganisationId, relatedOrganisationId = relatedOrganisation.RelatedOrganisationId }); }
public static async Task AddRelatedOrganisation(string connectionString, RelatedOrganisation relatedOrganisation) { var query = "INSERT INTO dbo.RelatedOrganisations (OrganisationId, RelatedOrganisationId) VALUES (@organisationId, @relatedOrganisationId);"; await SqlExecutor.ExecuteAsync <RelatedOrganisation>(connectionString, query, new { organisationId = relatedOrganisation.OrganisationId, relatedOrganisationId = relatedOrganisation.RelatedOrganisationId }); }