public void DeleteFor(int vacancyId)
{
var vacancyLocations =
_getOpenConnection.Query <Entities.VacancyLocation>("SELECT * FROM dbo.VacancyLocation WHERE VacancyId = @VacancyId ORDER BY VacancyLocationId DESC",
new { VacancyId = vacancyId });
foreach (var vacancyLocation in vacancyLocations)
{
_getOpenConnection.DeleteSingle(vacancyLocation);
}
}
