private WhereCondition GetInStockWhereCondition() { var where = new WhereCondition(); if (mBrewerFilterViewModel.OnlyInStock) { where.WhereGreaterThan("SKUAvailableItems", 0).Or().WhereNull("SKUAvailableItems"); } return(where); }
/// <summary> /// Adds user condition to given <see paramref="whereCondition"/>. /// </summary> private void AddUserCondition(WhereCondition whereCondition, int siteID) { whereCondition.WhereGreaterThan("UserID", 0); if (siteID > 0) { whereCondition.WhereIn("UserID", UserSiteInfoProvider.GetUserSites() .Column("UserID") .WhereEquals("SiteID", siteID)); } if (chkDisplayHidden.Visible && !chkDisplayHidden.Checked) { whereCondition.WhereIn("UserID", UserInfoProvider.GetUsers() .Column("UserID") .WhereEquals("UserIsHidden", 0) .Or() .WhereNull("UserIsHidden")); } }
/// <summary> /// Adds session condition to given <see paramref="whereCondition"/>. /// </summary> private void AddSessionCondition(WhereCondition whereCondition, int siteID) { if (siteID > 0) { whereCondition.WhereEquals("SessionSiteID", siteID); } if (!DisplayGuests) { whereCondition.WhereGreaterThan("SessionUserID", 0); } if (chkDisplayHidden.Visible && !chkDisplayHidden.Checked) { whereCondition.Where(new WhereCondition() .WhereEquals("SessionUserIsHidden", 0) .Or() .WhereNull("SessionUserID")); } }
/// <summary> /// Adds session condition to given <see paramref="whereCondition"/>. /// </summary> private void AddSessionCondition(ref WhereCondition whereCondition) { var sessionCondition = new WhereCondition(); if (SelectedSite > 0 && IncludeSiteCondition()) { sessionCondition.WhereEquals("SessionSiteID", SelectedSite); } if (!DisplayGuests) { sessionCondition.WhereGreaterThan("SessionUserID", 0); } if (chkDisplayHidden.Visible && !chkDisplayHidden.Checked) { sessionCondition.Where(new WhereCondition() .WhereEquals("SessionUserIsHidden", 0) .Or() .WhereNull("SessionUserID")); } whereCondition = new WhereCondition(whereCondition, sessionCondition); }