protected override IEnumerable <LocationType> PerformGetAll(params Guid[] Keys)
{
List <LocationType> Result = new List <LocationType>();
IEnumerable <LocationTypeDto> dtoResults;
if (Keys.Any())
{
foreach (var key in Keys)
{
Result.Add(Get(key));
}
}
else
{
var sql = new Sql();
sql.Select("*").From <LocationTypeDto>();
dtoResults = Repositories.ThisDb.Fetch <LocationTypeDto>(sql).ToList();
var converter = new DtoConverter();
foreach (var result in dtoResults)
{
Result.Add(converter.ToLocationTypeEntity(result));
}
}
return(Result);
}
public IEnumerable <LocationType> GetByName(string LocationTypeName)
{
CurrentCollection.Clear();
var sql = new Sql();
sql.Select("*")
.From <LocationTypeDto>()
.Where <LocationTypeDto>(n => n.Name == LocationTypeName);
var dtoResult = Repositories.ThisDb.Fetch <LocationTypeDto>(sql).ToList();
var converter = new DtoConverter();
CurrentCollection.AddRange(converter.ToLocationTypeEntity(dtoResult));
FillChildren();
return(CurrentCollection);
}
protected override LocationType PerformGet(Guid Key)
{
var sql = new Sql();
sql
.Select("*")
.From <LocationTypeDto>()
.Where <LocationTypeDto>(n => n.Key == Key);
var dtoResult = Repositories.ThisDb.Fetch <LocationTypeDto>(sql).FirstOrDefault();
if (dtoResult == null)
{
return(null);
}
var converter = new DtoConverter();
var entity = converter.ToLocationTypeEntity(dtoResult);
return(entity);
}
