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