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