public IList <IncidentModel> GetFireIncidents() { string connectionString = ShardManagmentConfig.GetCredentialsConnectionString(); Shard shard = _shardMap.Value.GetMappingForKey((int)DepartmentType.Fire).Shard; return(QueryHelper.ExecuteMultiShardQuery(connectionString, IncidentQuery, shard)); }
public IList <IncidentModel> GetAmbulanceIncidents(int cityId) { string connectionString = ShardManagmentConfig.GetCredentialsConnectionString(); Shard shard = _shardMap.Value.GetMappingForKey((int)DepartmentType.Ambulance).Shard; return(QueryHelper.ExecuteMultiShardQuery(connectionString, GetIncidentsQuery(cityId), shard)); }
public IList <IncidentModel> GetAllIncidents() { string connectionString = ShardManagmentConfig.GetCredentialsConnectionString(); Shard[] shards = _shardMap.Value.GetShards().ToArray(); return(QueryHelper.ExecuteMultiShardQuery(connectionString, IncidentQuery, shards)); }
public IEnumerable <IncidentModel> GetIncidents(int cityId) { string connectionString = ShardManagmentConfig.GetCredentialsConnectionString(); Shard[] shards = _shardMap.Value.GetShards().ToArray(); var query = GetIncidentsQuery(cityId); var incidents = QueryHelper.ExecuteMultiShardQuery(connectionString, query, shards); return(incidents); }
public IncidentModel GetIncident(int city, int incidentId) { string connectionString = ShardManagmentConfig.GetCredentialsConnectionString(); Shard[] shards = _shardMap.Value.GetShards().ToArray(); var query = IncidentQuery + $@"WHERE i.Id = {incidentId} AND i.CityId = {city};"; var incidents = QueryHelper.ExecuteMultiShardQuery(connectionString, query, shards); var incident = incidents.FirstOrDefault(i => i.CityId == city && i.Id == incidentId); return(incident); }