/// <summary>
/// Efficient pageing for grid.
/// </summary>
/// <param name="pageNumber">Must be greater than zero.</param>
/// <param name="sortDirection">Validne vrijednosti su 'asc' i 'desc'.</param>
public static EntityCollection <PartnerEntity> FetchPartnerCollectionForPaging(DataAccessAdapterBase adapter,
RelationPredicateBucket bucket,
PrefetchPath2 prefetchPath,
int pageNumber,
int pageSize,
string sortField,
bool isSortAscending)
{
string sortDirection = isSortAscending ? "asc" : "desc";
Type sortEntityFieldType = typeof(PartnerFields);
string sortEntityFieldTypeName = SortHelper.GetEntityFieldTypeNameForSorting(sortField, sortEntityFieldType);
if (!string.IsNullOrWhiteSpace(sortEntityFieldTypeName))
{
sortEntityFieldType = Type.GetType(sortEntityFieldTypeName);
}
sortField = SortHelper.GetSortField(sortField);
SortExpression sort = SortHelper.GetSortExpression(sortField, sortDirection, sortEntityFieldType);
EntityCollection <PartnerEntity> toReturn = new EntityCollection <PartnerEntity>(new PartnerEntityFactory());
adapter.FetchEntityCollection(toReturn, bucket, pageSize, sort, prefetchPath, pageNumber, pageSize);
return(toReturn);
}
public static TrgovanjeGlavaEntity FetchTrgovanjeGlavaForGuiDisplay(DataAccessAdapterBase adapter, DateTime date)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(TrgovanjeGlavaFields.Datum <= date.Date);
SortExpression sort = new SortExpression(TrgovanjeGlavaFields.Datum | SortOperator.Descending);
EntityCollection<TrgovanjeGlavaEntity> trgovanjeGlavaCollection = new EntityCollection<TrgovanjeGlavaEntity>(new TrgovanjeGlavaEntityFactory());
adapter.FetchEntityCollection(trgovanjeGlavaCollection, bucket, 1, sort);
if (0 == trgovanjeGlavaCollection.Count)
{
sort = new SortExpression(TrgovanjeGlavaFields.Datum | SortOperator.Ascending);
adapter.FetchEntityCollection(trgovanjeGlavaCollection, null, 1, sort);
}
return FetchTrgovanjeGlavaForGuiDisplay(adapter, trgovanjeGlavaCollection.Single().TrgovanjeGlavaId);
}
public static EntityCollection <PartnerEntity> FetchPartnerCollection(DataAccessAdapterBase adapter,
IRelationPredicateBucket filterBucket,
PrefetchPath2 prefetchPath)
{
EntityCollection <PartnerEntity> toReturn = new EntityCollection <PartnerEntity>(new PartnerEntityFactory());
adapter.FetchEntityCollection(toReturn, filterBucket, prefetchPath);
return(toReturn);
}
public static EntityCollection <AuditInfoActionTypeRoEntity> FetchAuditInfoActionTypeRoCollection(DataAccessAdapterBase adapter,
IRelationPredicateBucket filterBucket,
PrefetchPath2 prefetchPath)
{
EntityCollection <AuditInfoActionTypeRoEntity> toReturn = new EntityCollection <AuditInfoActionTypeRoEntity>(new AuditInfoActionTypeRoEntityFactory());
adapter.FetchEntityCollection(toReturn, filterBucket, prefetchPath);
return(toReturn);
}
public static List<DateTime> FetchRepoAukcijaDateCollection(DataAccessAdapterBase adapter)
{
if (null == _repoAukcijaDateCollection)
{
EntityCollection<RepoAukcijaEntity> repoAukcijaEntityCollection = new EntityCollection<RepoAukcijaEntity>(new RepoAukcijaEntityFactory());
ExcludeIncludeFieldsList includeFieldList = new ExcludeIncludeFieldsList(false);
includeFieldList.Add(RepoAukcijaFields.DatumAukcije);
adapter.FetchEntityCollection(repoAukcijaEntityCollection, includeFieldList, null);
_repoAukcijaDateCollection = repoAukcijaEntityCollection.OrderByDescending(ra => ra.DatumAukcije).Select(ra => ra.DatumAukcije).ToList();
}
return _repoAukcijaDateCollection;
}
/// <summary>
/// Efficient pageing for grid.
/// </summary>
/// <param name="pageNumber">Must be greater than zero.</param>
/// <param name="sortDirection">Validne vrijednosti su 'asc' i 'desc'.</param>
public static EntityCollection<ErrorEntity> FetchErrorCollectionForPaging(DataAccessAdapterBase adapter,
RelationPredicateBucket bucket,
PrefetchPath2 prefetchPath,
int pageNumber,
int pageSize,
string sortField,
bool isSortAscending)
{
string sortDirection = isSortAscending ? "asc" : "desc";
Type sortEntityFieldType = typeof(ErrorFields);
string sortEntityFieldTypeName = SortHelper.GetEntityFieldTypeNameForSorting(sortField, sortEntityFieldType);
if (!string.IsNullOrWhiteSpace(sortEntityFieldTypeName))
{
sortEntityFieldType = Type.GetType(sortEntityFieldTypeName);
}
sortField = SortHelper.GetSortField(sortField);
SortExpression sort = SortHelper.GetSortExpression(sortField, sortDirection, sortEntityFieldType);
EntityCollection<ErrorEntity> toReturn = new EntityCollection<ErrorEntity>(new ErrorEntityFactory());
adapter.FetchEntityCollection(toReturn, bucket, pageSize, sort, prefetchPath, pageNumber, pageSize);
return toReturn;
}
public static EntityCollection<ErrorEntity> FetchErrorCollection(DataAccessAdapterBase adapter,
IRelationPredicateBucket filterBucket,
PrefetchPath2 prefetchPath)
{
EntityCollection<ErrorEntity> toReturn = new EntityCollection<ErrorEntity>(new ErrorEntityFactory());
adapter.FetchEntityCollection(toReturn, filterBucket, prefetchPath);
return toReturn;
}
public static EntityCollection<SistemskaInstancaPodatakaRoEntity> FetchSistemskaInstancaPodatakaRoCollection(DataAccessAdapterBase adapter,
IRelationPredicateBucket filterBucket,
PrefetchPath2 prefetchPath)
{
EntityCollection<SistemskaInstancaPodatakaRoEntity> toReturn = new EntityCollection<SistemskaInstancaPodatakaRoEntity>(new SistemskaInstancaPodatakaRoEntityFactory());
adapter.FetchEntityCollection(toReturn, filterBucket, prefetchPath);
return toReturn;
}
private static void LoadTrgovanjeGodinaList(DataAccessAdapterBase adapter)
{
EntityCollection<TrgovanjeGlavaEntity> trgovanjeGlavaCollection = new EntityCollection<TrgovanjeGlavaEntity>(new TrgovanjeGlavaEntityFactory());
ExcludeIncludeFieldsList includeFieldList = new ExcludeIncludeFieldsList(false);
includeFieldList.Add(TrgovanjeGlavaFields.Datum);
adapter.FetchEntityCollection(trgovanjeGlavaCollection, includeFieldList, null);
_godinaTrgovanjaCollection = trgovanjeGlavaCollection.Select(tg => tg.Datum.Year).Distinct().ToList();
_godinaTrgovanjaCollection.Sort();
}
public void LoadTrgovanjeGlavaPrethodniDan(DataAccessAdapterBase adapter)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(TrgovanjeGlavaFields.Datum < this.Datum);
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.TrgovanjeGlavaEntity);
prefetchPath.Add(TrgovanjeGlavaEntity.PrefetchPathTrgovanjeStavkaCollection);
SortExpression sort = new SortExpression(TrgovanjeGlavaFields.Datum | SortOperator.Descending);
EntityCollection<TrgovanjeGlavaEntity> trgovanjeGlavaCollection = new EntityCollection<TrgovanjeGlavaEntity>(new TrgovanjeGlavaEntityFactory());
adapter.FetchEntityCollection(trgovanjeGlavaCollection, bucket, 1, sort, prefetchPath);
_trgovanjeGlavaPrethodniDan = trgovanjeGlavaCollection.SingleOrDefault();
}
