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);
}
