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; }
public IList<Auction.Domain.Raffle> GetByEvent(long eventId, ref IAuctionTransaction trans) { using (var records = new RaffleCollection()) { var filter = new PredicateExpression(RaffleFields.EventId == eventId); if (trans != null) { trans.Add(records); } records.GetMulti(filter); return records.Select( r => new Raffle() { CreatedBy = r.CreatedBy, EventId = r.EventId, Id = r.Id, Name = r.Name, Revenue = r.Total, UpdatedBy = (long) r.UpdatedBy }).ToList(); } }
public Event Get(long Id, ref IAuctionTransaction trans) { using (var records = new AuctionEventCollection()) { var filter = new PredicateExpression(AuctionEventFields.Id == Id); if (trans != null) { trans.Add(records); } records.GetMulti(filter, 1); var b = records.ToList().FirstOrDefault(); return new Event() { Id = Id, Date = b.Date, Name = b.Name, AccountId = b.AccountId, CreatedBy = b.CreatedBy, Locked = b.Locked, Notes = b.Notes, UpdatedBy = b.UpdatedBy }; } }
public IList<Auction.Domain.Event> GetByAccount(long accountId, ref IAuctionTransaction trans) { using (var records = new AuctionEventCollection()) { var filter = new PredicateExpression(AuctionEventFields.AccountId == accountId); if (trans != null) { trans.Add(records); } records.GetMulti(filter, 0); return records.Select( b => new Event() { Id = b.Id, Date = b.Date, Name = b.Name, AccountId = b.AccountId, CreatedBy = b.CreatedBy, Locked = b.Locked, Notes = b.Notes, UpdatedBy = b.UpdatedBy }).ToList(); } }
public ProviderQueryExpression( IEnumerable<ProviderPropertyExpression> providerProperties, ProjectionExpression projection, PredicateExpression predicate, SortExpressionCollectionExpression sort) : this(new ProviderPropertiesExpression(providerProperties), projection, predicate, sort) { }
public Auction.Domain.Package Get(long Id, ref IAuctionTransaction trans) { using (var records = new PackageCollection()) { var filter = new PredicateExpression(PackageFields.Id == Id); if (trans != null) { trans.Add(records); } records.GetMulti(filter, 1); var r = records.FirstOrDefault(); return new Package() { BidderId = r.BidderId, CategoryId = r.CategoryId, ClosedOutBy = r.ClosedOutBy, Code = r.Code, CreatedBy = r.CreatedBy, EndingBid = r.EndingBid, EventId = r.EventId, Id = r.Id, Name = r.Name, Notes = r.Notes, Paid = (bool) r.Paid, StartingBid = r.StartingBid, UpdatedBy = r.UpdatedBy }; } }
public static int Add(int seriesId, int season) { var entity = new SeasonEntity { SeasonNumber = season, SeriesId = seriesId }; var filter = new PredicateExpression { SeasonFields.SeriesId == seriesId, SeasonFields.SeasonNumber == season }; return Database.AddOrUpdateEntity(entity, filter, false).SeasonId; }
public IList<Auction.Domain.Package> GetByCategory(long categoryId, ref IAuctionTransaction trans) { using (var records = new PackageCollection()) { var filter = new PredicateExpression(PackageFields.CategoryId == categoryId); if (trans != null) { trans.Add(records); } records.GetMulti(filter); return records.Select(r => new Package() { BidderId = r.BidderId, CategoryId = r.CategoryId, ClosedOutBy = r.ClosedOutBy, Code = r.Code, CreatedBy = r.CreatedBy, EndingBid = r.EndingBid, EventId = r.EventId, Id = r.Id, Name = r.Name, Notes = r.Notes, Paid = (bool)r.Paid, StartingBid = r.StartingBid, UpdatedBy = r.UpdatedBy }).ToList(); } }
public static bool HasEpisodeAttached(int fileId) { var filter = new PredicateExpression { EpisodeToFileFields.FileId == fileId }; var entity = Database.GetEntityCollection<EpisodeToFileEntity>(new RelationPredicateBucket(filter)); return entity.Any(); }
public static bool HasStream(int fileId) { var filter = new PredicateExpression { FileVideoStreamFields.FileId == fileId }; var entity = Database.GetEntityCollection<FileVideoStreamEntity>(new RelationPredicateBucket(filter)); return entity.Any(); }
public ProviderQueryExpression( ProviderPropertiesExpression providerPropertiesExpression, ProjectionExpression projection, PredicateExpression predicate) : this(providerPropertiesExpression, projection, predicate, null) { }
public string GetTodayVisit() { WebTrackerCollection trackers = new WebTrackerCollection(); PredicateExpression filter = new PredicateExpression(); filter.Add(WebTrackerFields.VisitTime == DateTime.Parse(DateTime.Now.ToShortDateString())); trackers.GetMulti(filter); return trackers.Count.ToString(); }
public ProviderQueryExpression( IEnumerable<ProviderPropertyExpression> providerProperties, ProjectionExpression projection, PredicateExpression predicate) : this(providerProperties, projection, predicate, null) { }
/// <summary> /// Does the search using MS Full text search /// </summary> /// <param name="searchString">Search string.</param> /// <param name="forumIDs">Forum Ids of forums to search into.</param> /// <param name="orderFirstElement">Order first element setting.</param> /// <param name="orderSecondElement">Order second element setting.</param> /// <param name="forumsWithThreadsFromOthers">The forums with threads from others.</param> /// <param name="userID">The userid of the calling user.</param> /// <param name="targetToSearch">The target to search.</param> /// <returns> /// TypedList filled with threads matching the query. /// </returns> public static SearchResultTypedList DoSearch(string searchString, List<int> forumIDs, SearchResultsOrderSetting orderFirstElement, SearchResultsOrderSetting orderSecondElement, List<int> forumsWithThreadsFromOthers, int userID, SearchTarget targetToSearch) { // the search utilizes full text search. It performs a CONTAINS upon the MessageText field of the Message entity. string searchTerms = PrepareSearchTerms(searchString); bool searchMessageText = (targetToSearch == SearchTarget.MessageText) || (targetToSearch == SearchTarget.MessageTextAndThreadSubject); bool searchSubject = (targetToSearch == SearchTarget.ThreadSubject) || (targetToSearch == SearchTarget.MessageTextAndThreadSubject); if(!(searchSubject || searchMessageText)) { // no target specified, select message searchMessageText = true; } PredicateExpression searchTermFilter = new PredicateExpression(); if(searchMessageText) { // Message contents filter searchTermFilter.Add(new FieldCompareSetPredicate(ThreadFields.ThreadID, MessageFields.ThreadID, SetOperator.In, new FieldFullTextSearchPredicate(MessageFields.MessageText, FullTextSearchOperator.Contains, searchTerms))); } if(searchSubject) { // Thread subject filter if(searchMessageText) { searchTermFilter.AddWithOr(new FieldFullTextSearchPredicate(ThreadFields.Subject, FullTextSearchOperator.Contains, searchTerms)); } else { searchTermFilter.Add(new FieldFullTextSearchPredicate(ThreadFields.Subject, FullTextSearchOperator.Contains, searchTerms)); } } IPredicateExpression mainFilter = searchTermFilter .And(ForumFields.ForumID == forumIDs) .And(ThreadGuiHelper.CreateThreadFilter(forumsWithThreadsFromOthers, userID)); ISortExpression sorter = new SortExpression(); // add first element sorter.Add(CreateSearchSortClause(orderFirstElement)); if(orderSecondElement != orderFirstElement) { sorter.Add(CreateSearchSortClause(orderSecondElement)); } SearchResultTypedList results = new SearchResultTypedList(false); try { // get the data from the db. results.Fill(500, sorter, false, mainFilter); } catch { // probably an error with the search words / user error. Swallow for now, which will result in an empty resultset. } return results; }
public ProviderQueryExpression( ProviderPropertiesExpression providerPropertiesExpression, ProjectionExpression projection, PredicateExpression predicate, SortExpressionCollectionExpression sort) : base(projection, predicate, sort) { _providerPropertiesExpression = providerPropertiesExpression; }
public CategoryCollection GetMainCategories() { CategoryCollection categories = new CategoryCollection(); PredicateExpression filter = new PredicateExpression(); filter.Add(new FieldCompareNullPredicate(CategoryFields.BaseCategoryId)); categories.GetMulti(filter); return categories; }
/// <summary>Retrieves in the calling AuditActionCollection object all AuditActionEntity objects which are related via a relation of type 'm:n' with the passed in RoleEntity.</summary> /// <param name="containingTransaction">A containing transaction, if caller is added to a transaction, or null if not.</param> /// <param name="collectionToFill">Collection to fill with the entity objects retrieved</param> /// <param name="maxNumberOfItemsToReturn"> The maximum number of items to return with this retrieval query. When set to 0, no limitations are specified.</param> /// <param name="sortClauses">The order by specifications for the sorting of the resultset. When not specified, no sorting is applied.</param> /// <param name="entityFactoryToUse">The EntityFactory to use when creating entity objects during a GetMulti() call.</param> /// <param name="roleInstance">RoleEntity object to be used as a filter in the m:n relation</param> /// <param name="prefetchPathToUse">the PrefetchPath which defines the graph of objects to fetch.</param> /// <param name="pageNumber">The page number to retrieve.</param> /// <param name="pageSize">The page size of the page to retrieve.</param> /// <returns>true if succeeded, false otherwise</returns> public bool GetMultiUsingRolesWithAuditAction(ITransaction containingTransaction, IEntityCollection collectionToFill, long maxNumberOfItemsToReturn, ISortExpression sortClauses, IEntityFactory entityFactoryToUse, IEntity roleInstance, IPrefetchPath prefetchPathToUse, int pageNumber, int pageSize) { RelationCollection relations = new RelationCollection(); relations.Add(AuditActionEntity.Relations.RoleAuditActionEntityUsingAuditActionID, "RoleAuditAction_"); relations.Add(RoleAuditActionEntity.Relations.RoleEntityUsingRoleID, "RoleAuditAction_", string.Empty, JoinHint.None); IPredicateExpression selectFilter = new PredicateExpression(); selectFilter.Add(new FieldCompareValuePredicate(roleInstance.Fields[(int)RoleFieldIndex.RoleID], ComparisonOperator.Equal)); return this.GetMulti(containingTransaction, collectionToFill, maxNumberOfItemsToReturn, sortClauses, entityFactoryToUse, selectFilter, relations, prefetchPathToUse, pageNumber, pageSize); }
/// <summary> /// Returns valid entities which are valid for given moment in time. /// Valid entities have: /// 1. Begining is not NULL AND is LESS than given moment in time. /// 2. End is NULL OR is GREATER OR EQUAL than given moment in time. /// </summary> public static PredicateExpression FilterValidEntities(DateTime momentInTime, EntityField2 validFromDateTimeField, EntityField2 validToDateTimeField) { PredicateExpression predicateExpression = new PredicateExpression(); predicateExpression.Add(validFromDateTimeField != DBNull.Value & validFromDateTimeField <= momentInTime); predicateExpression.AddWithAnd(validToDateTimeField == DBNull.Value | validToDateTimeField >= momentInTime); return predicateExpression; }
public static void Add(int artworkId, int roleId) { var entity = new ArtworkToRoleEntity(); entity.ArtworkId = artworkId; entity.RoleId = roleId; var filter = new PredicateExpression(); filter.Add(ArtworkToRoleFields.ArtworkId == artworkId); filter.Add(ArtworkToRoleFields.RoleId == roleId); Database.AddOrUpdateEntity(entity, filter, false); }
public void Delete(long Id, ref IAuctionTransaction trans) { using (var records = new CategoryCollection()) { var filter = new PredicateExpression(CategoryFields.Id == Id); if (trans != null) { trans.Add(records); } records.DeleteMulti(filter); } }
public bool EventExists(long id, ref IAuctionTransaction trans) { using (var records = new AuctionEventCollection()) { var filter = new PredicateExpression(AuctionEventFields.Id == id); if (trans != null) { trans.Add(records); } return records.GetDbCount(filter) > 0; } }
public MembershipEntity GetMember(string uName, string password) { MembershipCollection memberships = new MembershipCollection(); PredicateExpression filter = new PredicateExpression(); filter.AddWithAnd(MembershipFields.UserName == uName); filter.AddWithAnd(MembershipFields.Password == Business.Encryption.SHA1Encryption.EncryptMessage(password)); filter.AddWithAnd(MembershipFields.Status == true); memberships.GetMulti(filter); if (memberships.Count > 0) return memberships.FirstOrDefault(); else return null; }
public int GetAllowableEventCount(long accountId, ref IAuctionTransaction trans) { using (var records = new AccountCollection()) { var filter = new PredicateExpression(AccountFields.Id == accountId); if (trans != null) { trans.Add(records); } records.GetMulti(filter, 1); return records.ToList().First().AllowableEvents; } }
public static int GetId(int importPathId, string relativeFileName) { var filter = new PredicateExpression { FileFields.ImportPathId == importPathId, FileFields.RelativeFileName == relativeFileName }; var entity = Database.GetUniqueEntity<FileEntity>(filter); if (entity.IsNew) { entity.ImportPathId = importPathId; entity.RelativeFileName = relativeFileName; entity.FileExtension = Path.GetExtension(relativeFileName); entity = Database.AddEntity(entity, false); } return entity.FileId; }
public IList<Category> GetByAccount(long accountId, ref IAuctionTransaction trans) { using (var records = new CategoryCollection()) { var filter = new PredicateExpression(CategoryFields.AccountId == accountId); if (trans != null) { trans.Add(records); } records.GetMulti(filter, 0); return records.ToList().Select(c => new Category() { Id = c.Id, Name = c.Name, AccountId = c.AccountId }).ToList(); } }
public SelectList subjectAttributes(object selObjId) { if (m_subjectAttributes == null) { m_subjectAttributes = new AttributeCollection(); RelationCollection rels = new RelationCollection(AttributeEntity.Relations.ContextEntityUsingContextId); PredicateExpression pe = new PredicateExpression(ContextFields.Name == "subject"); SortExpression se = new SortExpression(AttributeFields.Name | SortOperator.Ascending); m_subjectAttributes.GetMulti(pe, 0, se, rels); } SelectList selList = new SelectList(m_subjectAttributes, "Id", "Name", selObjId); return selList; }
public SelectList subjectAttributes(object selObjId) { if (m_subjectAttributes == null) { m_subjectAttributes = new AttributeCollection(); RelationCollection rels = new RelationCollection(AttributeEntity.Relations.ContextEntityUsingContextId); PredicateExpression pe = new PredicateExpression(ContextFields.Name == "subject"); SortExpression se = new SortExpression(AttributeFields.Name | SortOperator.Ascending); m_subjectAttributes.GetMulti(pe, 0, se, rels); } SelectList selList = new SelectList(m_subjectAttributes, "Id", "Name", selObjId); return(selList); }
public static int GetDaysSupportRequests() { SupportIssueCollection supportIssueCollection = new SupportIssueCollection(); try { PredicateExpression filter = new PredicateExpression(SupportIssueFields.CreateTime >= DateTime.Now.Date); filter.AddWithAnd(SupportIssueFields.CreateTime < DateTime.Now.Date.AddDays(1)); return(supportIssueCollection.GetDbCount(filter)); } catch { return(0); } }
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 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 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 static int GetActiveDevices() { DeviceCollection ecDeviceCollection = new DeviceCollection(); try { PredicateExpression filter = new PredicateExpression(DeviceFields.LastReportTime >= DateTime.Now.Date); filter.AddWithAnd(DeviceFields.LastReportTime < DateTime.Now.Date.AddDays(1)); return(ecDeviceCollection.GetDbCount(filter)); } catch { return(0); } }
/// <summary> Retrieves all related entities of type 'CustomerEntity' using a relation of type 'm:n'.</summary> /// <param name="forceFetch">if true, it will discard any changes currently in the collection and will rerun the complete query instead</param> /// <param name="entityFactoryToUse">The entity factory to use for the GetMultiManyToMany() routine.</param> /// <returns>Filled collection with all related entities of the type constructed by the passed in entity factory</returns> public SD.LLBLGen.Pro.Examples.Auditing.CollectionClasses.CustomerCollection GetMultiCustomersCollectionViaCustomerCustomerDemo(bool forceFetch, IEntityFactory entityFactoryToUse) { if ((!_alreadyFetchedCustomersCollectionViaCustomerCustomerDemo || forceFetch || _alwaysFetchCustomersCollectionViaCustomerCustomerDemo) && !this.IsSerializing && !this.IsDeserializing && !this.InDesignMode) { AddToTransactionIfNecessary(_customersCollectionViaCustomerCustomerDemo); IPredicateExpression filter = new PredicateExpression(); filter.Add(new FieldCompareValuePredicate(CustomerDemographyFields.CustomerTypeId, ComparisonOperator.Equal, this.CustomerTypeId, "CustomerDemographyEntity__")); _customersCollectionViaCustomerCustomerDemo.SuppressClearInGetMulti = !forceFetch; _customersCollectionViaCustomerCustomerDemo.EntityFactoryToUse = entityFactoryToUse; _customersCollectionViaCustomerCustomerDemo.GetMulti(filter, GetRelationsForField("CustomersCollectionViaCustomerCustomerDemo")); _customersCollectionViaCustomerCustomerDemo.SuppressClearInGetMulti = false; _alreadyFetchedCustomersCollectionViaCustomerCustomerDemo = true; } return(_customersCollectionViaCustomerCustomerDemo); }
/// <summary> Retrieves all related entities of type 'AuditActionTypeEntity' using a relation of type 'm:n'.</summary> /// <param name="forceFetch">if true, it will discard any changes currently in the collection and will rerun the complete query instead</param> /// <param name="entityFactoryToUse">The entity factory to use for the GetMultiManyToMany() routine.</param> /// <returns>Filled collection with all related entities of the type constructed by the passed in entity factory</returns> public SD.LLBLGen.Pro.Examples.Auditing.CollectionClasses.AuditActionTypeCollection GetMultiAuditActionTypeCollectionViaAuditInfo(bool forceFetch, IEntityFactory entityFactoryToUse) { if ((!_alreadyFetchedAuditActionTypeCollectionViaAuditInfo || forceFetch || _alwaysFetchAuditActionTypeCollectionViaAuditInfo) && !this.IsSerializing && !this.IsDeserializing && !this.InDesignMode) { AddToTransactionIfNecessary(_auditActionTypeCollectionViaAuditInfo); IPredicateExpression filter = new PredicateExpression(); filter.Add(new FieldCompareValuePredicate(UserFields.UserId, ComparisonOperator.Equal, this.UserId, "UserEntity__")); _auditActionTypeCollectionViaAuditInfo.SuppressClearInGetMulti = !forceFetch; _auditActionTypeCollectionViaAuditInfo.EntityFactoryToUse = entityFactoryToUse; _auditActionTypeCollectionViaAuditInfo.GetMulti(filter, GetRelationsForField("AuditActionTypeCollectionViaAuditInfo")); _auditActionTypeCollectionViaAuditInfo.SuppressClearInGetMulti = false; _alreadyFetchedAuditActionTypeCollectionViaAuditInfo = true; } return(_auditActionTypeCollectionViaAuditInfo); }
public static Int64 GetDaysExceptions() { ExceptionLogCollection exceptionLogCollection = new ExceptionLogCollection(); try { PredicateExpression filter = new PredicateExpression(ExceptionLogFields.ReceivedTime >= DateTime.Now.Date); filter.AddWithAnd(ExceptionLogFields.ReceivedTime < DateTime.Now.Date.AddDays(1)); return(exceptionLogCollection.GetDbCount(filter)); } catch { return(0L); } }
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; }
/// <summary> Retrieves all related entities of type 'SupplierEntity' using a relation of type 'm:n'.</summary> /// <param name="forceFetch">if true, it will discard any changes currently in the collection and will rerun the complete query instead</param> /// <param name="entityFactoryToUse">The entity factory to use for the GetMultiManyToMany() routine.</param> /// <returns>Filled collection with all related entities of the type constructed by the passed in entity factory</returns> public SD.LLBLGen.Pro.Examples.Auditing.CollectionClasses.SupplierCollection GetMultiSuppliersCollectionViaProducts(bool forceFetch, IEntityFactory entityFactoryToUse) { if ((!_alreadyFetchedSuppliersCollectionViaProducts || forceFetch || _alwaysFetchSuppliersCollectionViaProducts) && !this.IsSerializing && !this.IsDeserializing && !this.InDesignMode) { AddToTransactionIfNecessary(_suppliersCollectionViaProducts); IPredicateExpression filter = new PredicateExpression(); filter.Add(new FieldCompareValuePredicate(CategoryFields.CategoryId, ComparisonOperator.Equal, this.CategoryId, "CategoryEntity__")); _suppliersCollectionViaProducts.SuppressClearInGetMulti = !forceFetch; _suppliersCollectionViaProducts.EntityFactoryToUse = entityFactoryToUse; _suppliersCollectionViaProducts.GetMulti(filter, GetRelationsForField("SuppliersCollectionViaProducts")); _suppliersCollectionViaProducts.SuppressClearInGetMulti = false; _alreadyFetchedSuppliersCollectionViaProducts = true; } return(_suppliersCollectionViaProducts); }
/// <summary> Retrieves all related entities of type 'EmployeeEntity' using a relation of type 'm:n'.</summary> /// <param name="forceFetch">if true, it will discard any changes currently in the collection and will rerun the complete query instead</param> /// <param name="entityFactoryToUse">The entity factory to use for the GetMultiManyToMany() routine.</param> /// <returns>Filled collection with all related entities of the type constructed by the passed in entity factory</returns> public SD.LLBLGen.Pro.Examples.Auditing.CollectionClasses.EmployeeCollection GetMultiEmployeesCollectionViaOrders(bool forceFetch, IEntityFactory entityFactoryToUse) { if ((!_alreadyFetchedEmployeesCollectionViaOrders || forceFetch || _alwaysFetchEmployeesCollectionViaOrders) && !this.IsSerializing && !this.IsDeserializing && !this.InDesignMode) { AddToTransactionIfNecessary(_employeesCollectionViaOrders); IPredicateExpression filter = new PredicateExpression(); filter.Add(new FieldCompareValuePredicate(ShipperFields.ShipperId, ComparisonOperator.Equal, this.ShipperId, "ShipperEntity__")); _employeesCollectionViaOrders.SuppressClearInGetMulti = !forceFetch; _employeesCollectionViaOrders.EntityFactoryToUse = entityFactoryToUse; _employeesCollectionViaOrders.GetMulti(filter, GetRelationsForField("EmployeesCollectionViaOrders")); _employeesCollectionViaOrders.SuppressClearInGetMulti = false; _alreadyFetchedEmployeesCollectionViaOrders = true; } return(_employeesCollectionViaOrders); }
/// <summary> /// Handles the Click event of the btnSearchSubSet control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnSearchSubSet_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } _filter = new PredicateExpression(); IPredicate toAdd = null; if (chkEnableShipperId.Checked) { string fromValueAsString = tbxShipperIdMiFrom.Text; string toValueAsString = tbxShipperIdMiTo.Text; toAdd = GeneralUtils.CreatePredicate(ShipperFields.ShipperId, Convert.ToInt32(opShipperId.SelectedValue), chkNotShipperId.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (chkEnableCompanyName.Checked) { string fromValueAsString = tbxCompanyNameMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(ShipperFields.CompanyName, Convert.ToInt32(opCompanyName.SelectedValue), chkNotCompanyName.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (chkEnablePhone.Checked) { string fromValueAsString = tbxPhoneMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(ShipperFields.Phone, Convert.ToInt32(opPhone.SelectedValue), chkNotPhone.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (SearchClicked != null) { SearchClicked(this, new EventArgs()); } }
public ActionResult DecisionNodeOrder(policyData vData, int id, int id2, int linkId, FormCollection collection) { DecisionNodeEntity match = new DecisionNodeEntity(id2); DecisionNodeCollection coll = new DecisionNodeCollection(); PredicateExpression pe = new PredicateExpression(DecisionNodeFields.Id != match.Id); pe.Add(DecisionNodeFields.ParentId == id); SortExpression se = null; if (collection["up"] != null) { // Find all categories with display index less than ours. pe.Add(DecisionNodeFields.Order <= match.Order); // Order by display index, highest first. se = new SortExpression(DecisionNodeFields.Order | SortOperator.Descending); } else { // Find all categories with display index greater than ours. pe.Add(DecisionNodeFields.Order >= match.Order); // Order by display index, lowest first. se = new SortExpression(DecisionNodeFields.Order | SortOperator.Ascending); } // Swap with closest one. if (coll.GetMulti(pe, 1, se) && coll.Count > 0) { int temp = coll[0].Order; coll[0].Order = match.Order; match.Order = temp; match.Save(); coll.SaveMulti(); } string action = collection["backTo"]; if (action == "EditRule") { vData.Condition = new DecisionNodeEntity(id); id = vData.Condition.Rule[0].Id; } return(RedirectToAction(action, new { id = id, linkId = linkId })); }
/// <summary> /// Handles the Click event of the btnSearchSubSet control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnSearchSubSet_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } _filter = new PredicateExpression(); IPredicate toAdd = null; if (chkEnableCategoryId.Checked) { string fromValueAsString = tbxCategoryIdMiFrom.Text; string toValueAsString = tbxCategoryIdMiTo.Text; toAdd = GeneralUtils.CreatePredicate(CategoryFields.CategoryId, Convert.ToInt32(opCategoryId.SelectedValue), chkNotCategoryId.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (chkEnableCategoryName.Checked) { string fromValueAsString = tbxCategoryNameMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(CategoryFields.CategoryName, Convert.ToInt32(opCategoryName.SelectedValue), chkNotCategoryName.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (chkEnableDescription.Checked) { string fromValueAsString = tbxDescriptionMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(CategoryFields.Description, Convert.ToInt32(opDescription.SelectedValue), chkNotDescription.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (SearchClicked != null) { SearchClicked(this, new EventArgs()); } }
/// <summary> /// Handles the Click event of the btnSearchSubSet control. /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="System.EventArgs"/> instance containing the event data.</param> protected void btnSearchSubSet_Click(object sender, EventArgs e) { if (!Page.IsValid) { return; } _filter = new PredicateExpression(); IPredicate toAdd = null; if (chkEnableUserId.Checked) { string fromValueAsString = tbxUserIdMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(UserFields.UserId, Convert.ToInt32(opUserId.SelectedValue), chkNotUserId.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (chkEnablePassword.Checked) { string fromValueAsString = tbxPasswordMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(UserFields.Password, Convert.ToInt32(opPassword.SelectedValue), chkNotPassword.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (chkEnableFullName.Checked) { string fromValueAsString = tbxFullNameMiFrom.Text; string toValueAsString = string.Empty; toAdd = GeneralUtils.CreatePredicate(UserFields.FullName, Convert.ToInt32(opFullName.SelectedValue), chkNotFullName.Checked, fromValueAsString, toValueAsString); if (toAdd != null) { _filter.Add(toAdd); } } if (SearchClicked != null) { SearchClicked(this, new EventArgs()); } }
public ProductCollection GetRelatedProducts(int pid) { ProductEntity product = new ProductEntity(pid); ProductKeywordCollection productKeywords = new ProductKeywordCollection(); productKeywords.GetMulti(null); List <int> keywordIds = new List <int>(); foreach (ProductKeywordEntity item in product.ProductKeywords) { keywordIds.Add(item.KeywordId); } //var relatedProductIds = from rp in productKeywords // group rp by new { ProductID = rp.ProductId, KeywordID = rp.KeywordId } into g // where keywordIds.Contains(g.Key.KeywordID) && g.Key.KeywordID != 2 // select new // { // Key = g.Key // , // Count = g.Select(p => p.ProductId).Count() // }; // into g //select new {RCount=g.Key //where keywordIds.Contains(rp.KeywordId) && rp.ProductId != 2 select new { rp.ProductId }; var relatedProductIds = productKeywords.Where(p => keywordIds.Contains(p.KeywordId) && p.ProductId != pid).GroupBy(g => g.ProductId).Select(gr => new { ProductId = gr.Key, RelatedKeywordCount = gr.Count() }).OrderByDescending(f => f.RelatedKeywordCount).Take(5); ArrayList ids = new ArrayList(); foreach (var item in relatedProductIds) { ids.Add(item.ProductId); } //Related Products ProductCollection productList = new ProductCollection(); PredicateExpression filter = new PredicateExpression(); filter.Add(new FieldCompareRangePredicate(ProductFields.Id, ids)); filter.Add(ProductFields.Status == true); productList.GetMulti(filter); return(productList); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="isreadonly">The Is Read Only Flag of the requested entity.</param> /// <returns>EntityCollection<ModuleInstanceEntity></returns> public static EntityCollection <ModuleInstanceEntity> SelectByIsReadOnly(System.Boolean isreadonly) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleInstanceFields.IsReadOnly == isreadonly); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleInstanceEntity> modulesinstances = new EntityCollection <ModuleInstanceEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(modulesinstances, bucket); return(modulesinstances); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="nametag">The Name Tag of the requested entity.</param> /// <returns>EntityCollection<ModuleInstanceEntity></returns> public static EntityCollection <ModuleInstanceEntity> SelectByNameTag(System.String nametag) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleInstanceFields.NameTag == nametag); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleInstanceEntity> modulesinstances = new EntityCollection <ModuleInstanceEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(modulesinstances, bucket); return(modulesinstances); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="name">The name of the requested action entity.</param> /// <returns>EntityCollection<ActionEntity></returns> public static EntityCollection <ActionEntity> SelectByName(string name) { PredicateExpression filter = new PredicateExpression(); filter.Add(ActionFields.Name == name); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ActionEntity> actions = new EntityCollection <ActionEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(actions, bucket); return(actions); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="instancesallowed">The Instances Allowed of the requested entity.</param> /// <returns>EntityCollection<ModuleSetModuleEntity></returns> public static EntityCollection <ModuleSetModuleEntity> SelectByInstancesAllowed(System.Int32 instancesallowed) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleSetModuleFields.InstancesAllowed == instancesallowed); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleSetModuleEntity> mse = new EntityCollection <ModuleSetModuleEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(mse, bucket); return(mse); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="name">The Name of the requested entity.</param> /// <returns>EntityCollection<ModuleSetEntity></returns> public static EntityCollection <ModuleSetEntity> SelectByName(System.String name) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleSetFields.Name == name); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleSetEntity> mse = new EntityCollection <ModuleSetEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(mse, bucket); return(mse); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="isbuiltin">The IsBuiltin Flag of the requested entity.</param> /// <returns>EntityCollection<ModuleSetEntity></returns> public static EntityCollection <ModuleSetEntity> SelectByIsBuiltin(System.Boolean isbuiltin) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleSetFields.IsBuiltIn == isbuiltin); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleSetEntity> mse = new EntityCollection <ModuleSetEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(mse, bucket); return(mse); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="name">The Name of the requested entity.</param> /// <returns>EntityCollection<SiteTypeEntity></returns> public static EntityCollection <SiteTypeEntity> SelectByName(System.String name) { PredicateExpression filter = new PredicateExpression(); filter.Add(SiteTypeFields.Name == name); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <SiteTypeEntity> sitestype = new EntityCollection <SiteTypeEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(sitestype, bucket); return(sitestype); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="guid">The TemplateGUID of the requested entity.</param> /// <returns>EntityCollection<TemplateChunksEntity></returns> public static EntityCollection <TemplateChunksEntity> SelectByTemplateGUID(Guid guid) { PredicateExpression filter = new PredicateExpression(); filter.Add(TemplateChunksFields.TemplateGUID == guid); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <TemplateChunksEntity> templatechunks = new EntityCollection <TemplateChunksEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(templatechunks, bucket); return(templatechunks); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="currentsubsitecount">The CurrentSubSiteCount of the requested entity.</param> /// <returns>EntityCollection<SiteSubSiteInfoEntity></returns> public static EntityCollection <SiteSubSiteInfoEntity> SelectByCurrentSubSiteCount(int currentsubsitecount) { PredicateExpression filter = new PredicateExpression(); filter.Add(SiteSubSiteInfoFields.CurrentSubSiteCount == currentsubsitecount); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <SiteSubSiteInfoEntity> sitenetinfo = new EntityCollection <SiteSubSiteInfoEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(sitenetinfo, bucket); return(sitenetinfo); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="siteuid">The SiteUID of the requested entity.</param> /// <returns>EntityCollection<SiteSubSiteInfoEntity></returns> public static EntityCollection <SiteSubSiteInfoEntity> SelectBySiteUID(int siteuid) { PredicateExpression filter = new PredicateExpression(); filter.Add(SiteSubSiteInfoFields.SiteUID == siteuid); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <SiteSubSiteInfoEntity> sitenetinfo = new EntityCollection <SiteSubSiteInfoEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(sitenetinfo, bucket); return(sitenetinfo); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="etguid">The Entity Type GUID of the requested entity.</param> /// <returns>EntityCollection<GroupEntityPermissionEntity></returns> public static EntityCollection <GroupEntityPermissionEntity> SelectByEntityTypeGUID(System.Guid etguid) { PredicateExpression filter = new PredicateExpression(); filter.Add(GroupEntityPermissionFields.EntityTypeGUID == etguid); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <GroupEntityPermissionEntity> permissions = new EntityCollection <GroupEntityPermissionEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(permissions, bucket); return(permissions); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="allow">The Allow flag of the requested entity.</param> /// <returns>EntityCollection<GroupEntityPermissionEntity></returns> public static EntityCollection <GroupEntityPermissionEntity> SelectByAllow(System.Boolean allow) { PredicateExpression filter = new PredicateExpression(); filter.Add(GroupEntityPermissionFields.Allow == allow); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <GroupEntityPermissionEntity> permissions = new EntityCollection <GroupEntityPermissionEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(permissions, bucket); return(permissions); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="dt">The Edit Time of the requested entity.</param> /// <returns>EntityCollection<ModuleInstanceEntity></returns> public static EntityCollection <ModuleInstanceEntity> SelectByEditTime(System.DateTime dt) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleInstanceFields.EditTime == dt); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleInstanceEntity> modulesinstances = new EntityCollection <ModuleInstanceEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(modulesinstances, bucket); return(modulesinstances); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="edittime">The Edit Time of the requested entity.</param> /// <returns>EntityCollection<TemplateEntity></returns> public static EntityCollection <TemplateEntity> SelectByEditTime(System.DateTime edittime) { PredicateExpression filter = new PredicateExpression(); filter.Add(TemplateFields.EditTime == edittime); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <TemplateEntity> templates = new EntityCollection <TemplateEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(templates, bucket); return(templates); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="ouid">The Owner UID of the requested entity.</param> /// <returns>EntityCollection<TemplateEntity></returns> public static EntityCollection <TemplateEntity> SelectByOwnerUID(System.Int32 ouid) { PredicateExpression filter = new PredicateExpression(); filter.Add(TemplateFields.OwnerUID == ouid); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <TemplateEntity> templates = new EntityCollection <TemplateEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(templates, bucket); return(templates); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="suid">The Site UID of the requested entity.</param> /// <returns>EntityCollection<ModuleInstanceEntity></returns> public static EntityCollection <ModuleInstanceEntity> SelectBySiteUID(System.Int32 suid) { PredicateExpression filter = new PredicateExpression(); filter.Add(ModuleInstanceFields.SiteUID == suid); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <ModuleInstanceEntity> modulesinstances = new EntityCollection <ModuleInstanceEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(modulesinstances, bucket); return(modulesinstances); }
/// <summary> /// This function is used to query the data source for records. /// </summary> /// <param name="flag">The Is Builtin Flag of the requested entity.</param> /// <returns>EntityCollection<TemplateEntity></returns> public static EntityCollection <TemplateEntity> SelectByIsBuiltin(System.Boolean flag) { PredicateExpression filter = new PredicateExpression(); filter.Add(TemplateFields.IsBuiltin == flag); RelationPredicateBucket bucket = new RelationPredicateBucket(); bucket.PredicateExpression.Add(filter); EntityCollection <TemplateEntity> templates = new EntityCollection <TemplateEntity>(); DataAccessAdapter ds = new DataAccessAdapter(); ds.FetchEntityCollection(templates, bucket); return(templates); }