//public IEnumerable<LocationPropertyData> GetByLocationType(int LocationTypeId)
//{
// CurrentCollection.Clear();
// var MySql = new Sql();
// MySql.Select("*").From<LocationPropertyData>().Where("LocationTypeId = @0", LocationTypeId);
// CurrentCollection.AddRange(Repositories.ThisDb.Fetch<LocationPropertyData>(MySql).ToList());
// FillChildren();
// return CurrentCollection;
//}
public IEnumerable <LocationPropertyData> GetByLocation(Guid LocationKey)
{
List <LocationPropertyData> Result = new List <LocationPropertyData>();
IEnumerable <LocationPropertyDataDto> dtoResults;
CurrentCollection.Clear();
var sql = new Sql();
sql.Select("*").From <LocationPropertyDataDto>().Where("LocationKey = @0", LocationKey);
dtoResults = Repositories.ThisDb.Fetch <LocationPropertyDataDto>(sql).ToList();
var converter = new DtoConverter();
foreach (var result in dtoResults)
{
Result.Add(converter.ToLocationPropertyDataEntity(result));
}
CurrentCollection.AddRange(Result);
//FillChildren();
return(CurrentCollection);
}
protected override IEnumerable <LocationPropertyData> PerformGetAll(params Guid[] Keys)
{
List <LocationPropertyData> Result = new List <LocationPropertyData>();
IEnumerable <LocationPropertyDataDto> dtoResults;
if (Keys.Any())
{
foreach (var key in Keys)
{
Result.Add(Get(key));
}
}
else
{
var sql = new Sql();
sql.Select("*").From <LocationPropertyDataDto>();
dtoResults = Repositories.ThisDb.Fetch <LocationPropertyDataDto>(sql).ToList();
var converter = new DtoConverter();
foreach (var result in dtoResults)
{
Result.Add(converter.ToLocationPropertyDataEntity(result));
}
}
return(Result);
}
public LocationPropertyData GetByAlias(string PropertyAlias, Guid LocationKey)
{
CurrentCollection.Clear();
var sql = new Sql();
sql
.Select("*")
.From <LocationPropertyDataDto>()
.InnerJoin <LocationTypePropertyDto>()
.On <LocationPropertyDataDto, LocationTypePropertyDto>(left => left.LocationTypePropertyKey, right => right.Key)
.Where <LocationTypePropertyDto>(n => n.Alias == PropertyAlias)
.Where <LocationPropertyDataDto>(n => n.LocationKey == LocationKey);
var dtoResult = Repositories.ThisDb.Fetch <LocationPropertyDataDto>(sql).FirstOrDefault();
if (dtoResult == null)
{
return(null);
}
var converter = new DtoConverter();
var entity = converter.ToLocationPropertyDataEntity(dtoResult);
return(entity);
//FillChildren();
//return CurrentCollection[0];
}
protected override LocationPropertyData PerformGet(Guid Key)
{
var sql = new Sql();
sql
.Select("*")
.From <LocationPropertyDataDto>()
.Where <LocationPropertyDataDto>(n => n.Key == Key);
var dtoResult = Repositories.ThisDb.Fetch <LocationPropertyDataDto>(sql).FirstOrDefault();
if (dtoResult == null)
{
return(null);
}
var converter = new DtoConverter();
var entity = converter.ToLocationPropertyDataEntity(dtoResult);
return(entity);
}
