protected override IEnumerable <LocationTypeProperty> PerformGetAll(params Guid[] Keys) { List <LocationTypeProperty> Result = new List <LocationTypeProperty>(); IEnumerable <LocationTypePropertyDto> dtoResults; if (Keys.Any()) { foreach (var key in Keys) { Result.Add(Get(key)); } } else { var sql = new Sql(); sql.Select("*") .From <LocationTypePropertyDto>(); dtoResults = Repositories.ThisDb.Fetch <LocationTypePropertyDto>(sql).ToList(); var converter = new DtoConverter(); foreach (var result in dtoResults) { Result.Add(converter.ToLocationTypePropertyEntity(result)); } } return(Result); }
public IEnumerable <LocationTypeProperty> GetByLocationType(Guid LocationTypeKey) { CurrentCollection.Clear(); var sql = new Sql(); sql.Select("*") .From <LocationTypePropertyDto>() .Where <LocationTypePropertyDto>(n => n.LocationTypeKey == LocationTypeKey); var dtoResultList = Repositories.ThisDb.Fetch <LocationTypePropertyDto>(sql); if (dtoResultList != null) { foreach (var dtoResult in dtoResultList) { var converter = new DtoConverter(); var entity = converter.ToLocationTypePropertyEntity(dtoResult); CurrentCollection.Add(entity); FillChildren(); } } return(CurrentCollection); }
protected override LocationTypeProperty PerformGet(Guid Key) { var sql = new Sql(); sql .Select("*") .From <LocationTypePropertyDto>() .Where <LocationTypePropertyDto>(n => n.Key == Key); var dtoResult = Repositories.ThisDb.Fetch <LocationTypePropertyDto>(sql).FirstOrDefault(); if (dtoResult == null) { return(null); } var converter = new DtoConverter(); var entity = converter.ToLocationTypePropertyEntity(dtoResult); return(entity); }
public LocationTypeProperty GetByAlias(string PropertyAlias) { CurrentCollection.Clear(); var sql = new Sql(); sql.Select("*") .From <LocationTypePropertyDto>() .Where <LocationTypePropertyDto>(n => n.Alias == PropertyAlias); var dtoResultList = Repositories.ThisDb.Fetch <LocationTypePropertyDto>(sql); if (dtoResultList != null) { foreach (var dtoResult in dtoResultList) { var converter = new DtoConverter(); var entity = converter.ToLocationTypePropertyEntity(dtoResult); CurrentCollection.Add(entity); } } return(CurrentCollection[0]); }