public static RepoAukcijaEntity FetchRepoAukcija(DataAccessAdapterBase adapter, PrefetchPath2 prefetchPath, DateTime datumAukcije)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(RepoAukcijaFields.DatumAukcije == datumAukcije);
return FetchRepoAukcijaCollection(adapter, bucket, prefetchPath).SingleOrDefault();
}
public static IEnumerable<ArtworkEntity> GetToDownload()
{
var bucket = new RelationPredicateBucket();
bucket.Relations.Add(ArtworkEntity.Relations.ArtworkToEpisodeEntityUsingArtworkId, JoinHint.Left);
bucket.Relations.Add(ArtworkToEpisodeEntity.Relations.EpisodeEntityUsingEpisodeId, JoinHint.Left);
bucket.Relations.Add(EpisodeEntity.Relations.SeasonEntityUsingSeasonId,JoinHint.Left);
bucket.Relations.Add(SeasonEntity.Relations.SeriesEntityUsingSeriesId, JoinHint.Left);
bucket.Relations.Add(ArtworkEntity.Relations.ArtworkToPersonEntityUsingArtworkId, JoinHint.Left);
bucket.Relations.Add(ArtworkEntity.Relations.ArtworkToRoleEntityUsingArtworkId, JoinHint.Left);
bucket.Relations.Add(ArtworkToRoleEntity.Relations.RoleEntityUsingRoleId, JoinHint.Left);
bucket.Relations.Add(RoleEntity.Relations.RoleToSeriesEntityUsingRoleId, JoinHint.Left);
bucket.Relations.Add(RoleToSeriesEntity.Relations.SeriesEntityUsingSeriesId, JoinHint.Left);
bucket.Relations.Add(ArtworkEntity.Relations.ArtworkToSeasonEntityUsingArtworkId, JoinHint.Left);
bucket.Relations.Add(ArtworkToSeasonEntity.Relations.SeasonEntityUsingSeasonId, JoinHint.Left);
bucket.Relations.Add(SeasonEntity.Relations.SeriesEntityUsingSeriesId, JoinHint.Left);
bucket.Relations.Add(ArtworkEntity.Relations.ArtworkToSeriesEntityUsingArtworkId, JoinHint.Left);
bucket.Relations.Add(ArtworkToSeriesEntity.Relations.SeriesEntityUsingSeriesId, JoinHint.Left);
bucket.PredicateExpression.Add(ArtworkFields.IsDownloadedOnMaster == false);
var prefetchPath = new PrefetchPath2(EntityType.ArtworkEntity);
prefetchPath.Add(ArtworkEntity.PrefetchPathArtworkToEpisodes).SubPath.Add(ArtworkToEpisodeEntity.PrefetchPathEpisode).SubPath.Add(EpisodeEntity.PrefetchPathSeason).SubPath.Add(SeasonEntity.PrefetchPathSeries);
prefetchPath.Add(ArtworkEntity.PrefetchPathArtworkToPeople);
prefetchPath.Add(ArtworkEntity.PrefetchPathArtworkToRoles).SubPath.Add(ArtworkToRoleEntity.PrefetchPathRole).SubPath.Add(RoleEntity.PrefetchPathRoleToSeries).SubPath.Add(RoleToSeriesEntity.PrefetchPathSeries);
prefetchPath.Add(ArtworkEntity.PrefetchPathArtworkToSeasons).SubPath.Add(ArtworkToSeasonEntity.PrefetchPathSeason).SubPath.Add(SeasonEntity.PrefetchPathSeries);
prefetchPath.Add(ArtworkEntity.PrefetchPathArtworkToSeries).SubPath.Add(ArtworkToSeriesEntity.PrefetchPathSeries);
return Database.GetEntityCollection<ArtworkEntity>(bucket, prefetchPath);
}
public EntityCollection<CatalogsEntity> GetAllParent(SortExpression sort)
{
EntityCollection<CatalogsEntity> cats = new EntityCollection<CatalogsEntity>();
SortExpression _sort = new SortExpression();
if (sort != null)
{
_sort = sort;
}
else
{
_sort.Add(CatalogsFields.CatalogName | SortOperator.Ascending);
}
IPredicateExpression predicate = new PredicateExpression();
predicate.Add(CatalogsFields.ParentId == 0);
predicate.AddWithAnd(CatalogsFields.IsVisible == true);
RelationPredicateBucket filter = new RelationPredicateBucket();
filter.PredicateExpression.Add(predicate);
using (DataAccessAdapterBase adapter = new DataAccessAdapterFactory().CreateAdapter())
{
adapter.FetchEntityCollection(cats, filter, 0, _sort);
}
return cats;
}
/// <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<ArtiklEntity> FetchArtiklCollectionForPaging(DataAccessAdapterBase adapter,
RelationPredicateBucket bucket,
PrefetchPath2 prefetchPath,
int pageNumber,
int pageSize,
string sortField,
bool isSortAscending)
{
string sortDirection = isSortAscending ? "asc" : "desc";
Type sortEntityFieldType = typeof(ArtiklFields);
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<ArtiklEntity> toReturn = new EntityCollection<ArtiklEntity>(new ArtiklEntityFactory());
adapter.FetchEntityCollection(toReturn, bucket, pageSize, sort, prefetchPath, pageNumber, pageSize);
return toReturn;
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'Test' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoTestCollectionViaInventoryItemTest()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("TestCollectionViaInventoryItemTest"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(InventoryItemFields.InventoryItemId, null, ComparisonOperator.Equal, this.InventoryItemId, "InventoryItemEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'SalesOrderDetail' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoSalesOrderDetails()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(SalesOrderDetailFields.ProductId, null, ComparisonOperator.Equal, this.ProductId));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(SalesOrderDetailFields.SpecialOfferId, null, ComparisonOperator.Equal, this.SpecialOfferId));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'OrganizationRoleUser' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoOrganizationRoleUserCollectionViaExportableReportsQueue()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("OrganizationRoleUserCollectionViaExportableReportsQueue"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(ExportableReportsFields.Id, null, ComparisonOperator.Equal, this.Id, "ExportableReportsEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'Encounter' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoEncounterCollectionViaClaim()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("EncounterCollectionViaClaim"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(InsurancePaymentFields.InsurancePaymentId, null, ComparisonOperator.Equal, this.InsurancePaymentId, "InsurancePaymentEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'Employees' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoEmployeesCollectionViaOrders()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("EmployeesCollectionViaOrders"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(CustomersFields.CustomerId, null, ComparisonOperator.Equal, this.CustomerId, "CustomersEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'Order' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoOrdersCollectionViaOrderDetails()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("OrdersCollectionViaOrderDetails"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(ProductFields.ProductId, null, ComparisonOperator.Equal, this.ProductId, "ProductEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'OrganizationRoleUser' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoOrganizationRoleUserCollectionViaAfcampaign()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("OrganizationRoleUserCollectionViaAfcampaign"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(AfadvertiserFields.AdvertiserId, null, ComparisonOperator.Equal, this.AdvertiserId, "AfadvertiserEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'MessageDetails' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoMessageDetailsCollectionViaMessageDetails()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("MessageDetailsCollectionViaMessageDetails"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(ItemDetailsFields.ItemId, null, ComparisonOperator.Equal, this.ItemId, "ItemDetailsEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'ProspectContact' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoProspectContactCollectionViaProspectContactRoleMapping()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("ProspectContactCollectionViaProspectContactRoleMapping"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(ProspectContactRoleFields.ProspectContactRoleId, null, ComparisonOperator.Equal, this.ProspectContactRoleId, "ProspectContactRoleEntity__"));
return(bucket);
}
public IEnumerable <CallQueue> GetAll(bool isManual = true, bool isHealthPlan = false)
{
var relationPredicateBucket = new RelationPredicateBucket(CallQueueFields.IsActive == true);
relationPredicateBucket.PredicateExpression.AddWithAnd(CallQueueFields.IsManual == isManual);
relationPredicateBucket.PredicateExpression.AddWithAnd(CallQueueFields.IsHealthPlan == isHealthPlan);
return(Get(relationPredicateBucket));
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'CustomerEventTestIncidentalFinding' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoCustomerEventTestIncidentalFindingCollectionViaCustomerEventTestIncidentalFindingDetail()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("CustomerEventTestIncidentalFindingCollectionViaCustomerEventTestIncidentalFindingDetail"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(IncidentalFindingReadingGroupItemFields.GroupItemId, null, ComparisonOperator.Equal, this.GroupItemId, "IncidentalFindingReadingGroupItemEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'Lookup' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoLookupCollectionViaCustomerUnsubscribedSmsNotification()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("LookupCollectionViaCustomerUnsubscribedSmsNotification"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(SmsReceivedFields.Id, null, ComparisonOperator.Equal, this.Id, "SmsReceivedEntity__"));
return(bucket);
}
public CorporateCustomerCustomTag GetByCustomerAndTag(long customerId, string tag)
{
var expresion = new RelationPredicateBucket(CustomerTagFields.CustomerId == customerId);
expresion.PredicateExpression.AddWithAnd(CustomerTagFields.Tag == tag);
return(Get(expresion).SingleOrDefault());
}
public void DeleteEventZipByEventId(long eventId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var bucket = new RelationPredicateBucket(EventZipFields.EventId == eventId);
adapter.DeleteEntitiesDirectly(typeof(EventZipEntity), bucket);
}
}
public RelationPredicateBucket GetActiveCategoriesBucket()
{
var bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(CategoryFields.IsDeleted == false);
bucket.PredicateExpression.Add(CategoryFields.IsActive == true);
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'User' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoUserCollectionViaAuditInfo()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("UserCollectionViaAuditInfo"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(AuditActionTypeFields.AuditActionTypeId, null, ComparisonOperator.Equal, this.AuditActionTypeId, "AuditActionTypeEntity__"));
return(bucket);
}
public IEnumerable <CampaignActivity> GetDirectMailActivityByCampaignId(long campaignId)
{
var relationPredicateBucket = new RelationPredicateBucket(CampaignActivityFields.CampaignId == campaignId);
relationPredicateBucket.PredicateExpression.AddWithAnd(CampaignActivityAssignmentFields.CampaignActivityId == (long)CampaignActivityType.DirectMail);
return(Get(relationPredicateBucket).ToArray());
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'Customer' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoCustomersCollectionViaCustomerCustomerDemo()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("CustomersCollectionViaCustomerCustomerDemo"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(CustomerDemographyFields.CustomerTypeId, null, ComparisonOperator.Equal, this.CustomerTypeId, "CustomerDemographyEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'Group' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoGroupCollectionViaUserGroup()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("GroupCollectionViaUserGroup"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(UserFields.UserId, null, ComparisonOperator.Equal, this.UserId, "UserEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'ServiceLocation' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoServiceLocationCollectionViaServiceLocationAssetTypeId()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("ServiceLocationCollectionViaServiceLocationAssetTypeId"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(AssetTypeFields.AssetTypeId, null, ComparisonOperator.Equal, this.AssetTypeId, "AssetTypeEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'Category' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoCategoriesCollectionViaProducts()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("CategoriesCollectionViaProducts"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(SupplierFields.SupplierId, null, ComparisonOperator.Equal, this.SupplierId, "SupplierEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'CustomerProfile' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoCustomerProfileCollectionViaCustomerChaseChannel()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("CustomerProfileCollectionViaCustomerChaseChannel"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(ChaseChannelLevelFields.ChaseChannelLevelId, null, ComparisonOperator.Equal, this.ChaseChannelLevelId, "ChaseChannelLevelEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'Events' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoEventsCollectionViaAfmarketingMaterial()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("EventsCollectionViaAfmarketingMaterial"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(AfmarketingMaterialTypeFields.MarketingMaterialTypeId, null, ComparisonOperator.Equal, this.MarketingMaterialTypeId, "AfmarketingMaterialTypeEntity__"));
return(bucket);
}
private void DeletePreQualificationTemplateQuestion(long templateId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var relationPredicateBucket = new RelationPredicateBucket(PreQualificationTemplateQuestionFields.TemplateId == templateId);
adapter.DeleteEntitiesDirectly(typeof(PreQualificationTemplateQuestionEntity), relationPredicateBucket);
}
}
public void DeleteTemplateQuestions(long templateId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var relationPredicateBucket = new RelationPredicateBucket(FluConsentTemplateQuestionFields.TemplateId == templateId);
adapter.DeleteEntitiesDirectly(typeof(FluConsentTemplateQuestionEntity), relationPredicateBucket);
}
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch the related entities of type 'Employee' to this entity.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoEmployeeCollectionViaEmployeeTerritory()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("EmployeeCollectionViaEmployeeTerritory"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(TerritoryFields.TerritoryId, null, ComparisonOperator.Equal, this.TerritoryId, "TerritoryEntity__"));
return(bucket);
}
public List <EventTest> GetByEventAndTestIds(long eventId, IEnumerable <long> testIds)
{
var bucket =
new RelationPredicateBucket(EventTestFields.EventId == eventId);
bucket.PredicateExpression.AddWithAnd(EventTestFields.TestId == testIds.ToArray());
return(Get(bucket).ToList());
}
private void DeleteCallQueueAssignment(long callQueueId)
{
using (var adapter = PersistenceLayer.GetDataAccessAdapter())
{
var relationPredicateBucket = new RelationPredicateBucket(CallQueueAssignmentFields.CallQueueId == callQueueId);
adapter.DeleteEntitiesDirectly(typeof(CallQueueAssignmentEntity), relationPredicateBucket);
}
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'RecycleType' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoRecycleTypeCollectionViaBale()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("RecycleTypeCollectionViaBale"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(DockFields.DockId, null, ComparisonOperator.Equal, this.DockId, "DockEntity__"));
return(bucket);
}
/// <summary> Creates a new IRelationPredicateBucket object which contains the predicate expression and relation collection to fetch
/// the related entities of type 'MvuserEventTestLock' to this entity. Use DataAccessAdapter.FetchEntityCollection() to fetch these related entities.</summary>
/// <returns></returns>
public virtual IRelationPredicateBucket GetRelationInfoMvuserEventTestLockCollectionViaMvpaymentInfo()
{
IRelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.Relations.AddRange(GetRelationsForFieldOfType("MvuserEventTestLockCollectionViaMvpaymentInfo"));
bucket.PredicateExpression.Add(new FieldCompareValuePredicate(MedicalVendorPaymentAccruedFields.MedicalVendorPayAccrId, null, ComparisonOperator.Equal, this.MedicalVendorPayAccrId, "MedicalVendorPaymentAccruedEntity__"));
return(bucket);
}
public static UserEntity FetchUser(DataAccessAdapterBase adapter, string userName, string passwordHash)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(UserFields.Username == userName);
bucket.PredicateExpression.Add(UserFields.Password == passwordHash);
return FetchUserCollection(adapter, bucket, null).SingleOrDefault();
}
public static bool Exists(int seriesId, int seasonNumber, int episodeNumber)
{
var bucket = new RelationPredicateBucket();
bucket.Relations.Add(Relations.SeasonEntityUsingSeasonId);
bucket.PredicateExpression.Add(SeasonFields.SeasonNumber == seasonNumber);
bucket.PredicateExpression.Add(SeasonFields.SeriesId == seriesId);
bucket.PredicateExpression.Add(EpisodeFields.EpisodeNumber == episodeNumber);
return Database.GetEntityCollection<EpisodeEntity>(bucket).Any();
}
/// <summary>
/// Retrieves a list of groups matching the criteria specified via method parameters.
/// </summary>
/// <param name="category">Category name.</param>
/// <param name="categoryId">Category Id</param>
/// <param name="pageNumber">Page number.</param>
/// <param name="pageSize">Page size.</param>
/// <param name="recordCount">Record count.</param>
/// <returns>List of groups.</returns>
public List<MonoSoftware.MonoX.Repositories.SnGroupDTO> GetPopularGroups(string category, Guid categoryId, int pageNumber, int pageSize, out int recordCount)
{
RelationPredicateBucket filter = new RelationPredicateBucket();
//introduced to filter out groups by languages and applications
filter.Relations.Add(SnGroupEntity.Relations.SnGroupCategoryEntityUsingGroupCategoryId, JoinHint.Left);
//Note: MonoX supports the multi application environment so general filter for all DB access calls should contain the application id filter
filter.PredicateExpression.Add(SnGroupCategoryFields.ApplicationId == MonoSoftware.MonoX.Repositories.MembershipRepository.GetInstance().GetApplicationId());
//Note: MonoX in supports the multi language environment so general filter for all DB access calls should contain the language id filter
filter.PredicateExpression.Add(SnGroupCategoryFields.LanguageId == LocalizationUtility.GetCurrentLanguageId());
//Filter groups by category
if (categoryId != Guid.Empty)
{
filter.PredicateExpression.Add(SnGroupFields.GroupCategoryId == categoryId);
}
if (!String.IsNullOrEmpty(category))
{
filter.PredicateExpression.Add(SnGroupCategoryFields.Slug == category);
}
IPrefetchPath2 prefetch = new PrefetchPath2((int)EntityType.SnGroupEntity);
prefetch.Add(SnGroupEntity.PrefetchPathSnGroupCategory);
//Fetch a record from the members table only for the current user so his status could be read
Guid uid = SecurityUtility.GetUserId();
if (!Guid.Empty.Equals(uid))
{
PredicateExpression memberFilter = new PredicateExpression(SnGroupMemberFields.UserId == uid);
prefetch.Add(SnGroupEntity.PrefetchPathSnGroupMembers, 1, memberFilter);
}
#region Popular groups sorter
const string memberCountField = "MemberCountField";
const string memberCountTableName = "MemberCountTable";
EntityFields2 memberFields = new EntityFields2(2);
memberFields.DefineField(SnGroupMemberFields.GroupId, 0);
memberFields.DefineField(SnGroupMemberFields.Id, 1, memberCountField, AggregateFunction.Count);
DerivedTableDefinition memberCountTable = new DerivedTableDefinition(memberFields, memberCountTableName, null, new GroupByCollection(memberFields[0]));
IDynamicRelation memberCountRelation = new DynamicRelation(memberCountTable, JoinHint.Right, MonoSoftware.MonoX.DAL.EntityType.SnGroupEntity, String.Empty, SnGroupMemberFields.GroupId.SetObjectAlias(memberCountTable.Alias) == SnGroupFields.Id);
filter.Relations.Add(memberCountRelation);
ISortExpression sorter = new SortExpression(new SortClause(new EntityField2(memberCountField, null).SetObjectAlias(memberCountTableName), null, SortOperator.Descending));
#endregion
EntityCollection<SnGroupEntity> groups = new EntityCollection<SnGroupEntity>();
//Fetch the group collection
FetchEntityCollection(groups, filter, 0, sorter, prefetch, pageNumber, pageSize);
//Fetch the group total count used by paging
recordCount = GetDbCount(groups, filter);
//Transfer group entities to the DTO
List<MonoSoftware.MonoX.Repositories.SnGroupDTO> toReturn = groups.Select(group => new MonoSoftware.MonoX.Repositories.SnGroupDTO(group)).ToList<MonoSoftware.MonoX.Repositories.SnGroupDTO>();
return toReturn;
}
public static EntityCollection<TrgovanjeGlavaHnbEntity> FetchTrgovanjeGlavaHnbCollection(DataAccessAdapterBase adapter,
DateTime startDate,
DateTime endDate)
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
bucket.PredicateExpression.Add(PredicateHelper.FilterValidEntities(startDate, endDate, TrgovanjeGlavaHnbFields.Datum));
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.TrgovanjeGlavaHnbEntity);
prefetchPath.Add(TrgovanjeGlavaHnbEntity.PrefetchPathTrgovanjeStavkaHnbCollection);
return FetchTrgovanjeGlavaHnbCollection(adapter, bucket, prefetchPath);
}
public int DeleteByDescription(string Description)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(ProductSubFields.Description == Description);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("ProductSubEntity", filter);
}
return toReturn;
}
public int DeleteByFeature(string Feature)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AspnetSchemaVersionsFields.Feature == Feature);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AspnetSchemaVersionsEntity", filter);
}
return toReturn;
}
public int DeleteByPropertyNames(string PropertyNames)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AspnetProfileFields.PropertyNames == PropertyNames);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AspnetProfileEntity", filter);
}
return toReturn;
}
public int DeleteByAdvertPositionId(Guid AdvertPositionId)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AdvertsGroupFields.AdvertPositionId == AdvertPositionId);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AdvertsGroupEntity", filter);
}
return toReturn;
}
public int DeleteByAddress(string Address)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(SupplierRegisterFields.Address == Address);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("SupplierRegisterEntity", filter);
}
return toReturn;
}
public int DeleteByCreatedBy(string CreatedBy)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(OrdersFields.CreatedBy == CreatedBy);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("OrdersEntity", filter);
}
return toReturn;
}
public int DeleteByCommissionPercent(double CommissionPercent)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(ProductInfoFields.CommissionPercent == CommissionPercent);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("ProductInfoEntity", filter);
}
return toReturn;
}
public int DeleteByAmount(int Amount)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(ShippingDetailFields.Amount == Amount);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("ShippingDetailEntity", filter);
}
return toReturn;
}
public int DeleteByActionDate(DateTime ActionDate)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(HistoryOrdersFields.ActionDate == ActionDate);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("HistoryOrdersEntity", filter);
}
return toReturn;
}
public int DeleteByCatalogId(int CatalogId)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(VideosFields.CatalogId == CatalogId);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("VideosEntity", filter);
}
return toReturn;
}
public int DeleteByIsAnonymous(bool IsAnonymous)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AspnetUsersFields.IsAnonymous == IsAnonymous);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AspnetUsersEntity", filter);
}
return toReturn;
}
public int DeleteByIsActive(bool IsActive)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(PromotionsFields.IsActive == IsActive);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("PromotionsEntity", filter);
}
return toReturn;
}
public int DeleteByCost(decimal Cost)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(MarkTransferFields.Cost == Cost);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("MarkTransferEntity", filter);
}
return toReturn;
}
public int DeleteByCountDown(int CountDown)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(DocumentFields.CountDown == CountDown);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("DocumentEntity", filter);
}
return toReturn;
}
public int DeleteByDiscountName(string DiscountName)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(DiscountFields.DiscountName == DiscountName);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("DiscountEntity", filter);
}
return toReturn;
}
public int DeleteByOrderIndex(int OrderIndex)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(PositionFields.OrderIndex == OrderIndex);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("PositionEntity", filter);
}
return toReturn;
}
public int DeleteByApplicationVirtualPath(string ApplicationVirtualPath)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AspnetWebEventEventsFields.ApplicationVirtualPath == ApplicationVirtualPath);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AspnetWebEventEventsEntity", filter);
}
return toReturn;
}
public int DeleteByUserId(Guid UserId)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AspnetUsersInRolesFields.UserId == UserId);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AspnetUsersInRolesEntity", filter);
}
return toReturn;
}
public int DeleteByLastUpdatedDate(DateTime LastUpdatedDate)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(AspnetProfileFields.LastUpdatedDate == LastUpdatedDate);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("AspnetProfileEntity", filter);
}
return toReturn;
}
public int DeleteById(Guid Id)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(FeedBackFields.Id == Id);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("FeedBackEntity", filter);
}
return toReturn;
}
public int DeleteByNewsletterId(Guid NewsletterId)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(NewsletterInProductFields.NewsletterId == NewsletterId);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("NewsletterInProductEntity", filter);
}
return toReturn;
}
public int DeleteByApproved(bool Approved)
{
int toReturn = 0;
RelationPredicateBucket filter = new RelationPredicateBucket();
IPredicateExpression _PredicateExpression = new PredicateExpression();
_PredicateExpression.Add(EventsFields.Approved == Approved);
filter.PredicateExpression.Add(_PredicateExpression);
using (DataAccessAdapterBase adapter = (new DataAccessAdapterFactory()).CreateAdapter())
{
toReturn = adapter.DeleteEntitiesDirectly("EventsEntity", filter);
}
return toReturn;
}
