public void GetProjectionProjectionCriterionThrowsIfNodeTypeIsInvalid() { Assert .That ( () => { RestrictionHelper.GetProjectionProjectionCriterion(null, null, ExpressionType.Block); }, Throws.InstanceOf <NotSupportedException>() ); }
/// <inheritdoc /> public virtual TQuery Where(Expression <Func <TSource, WhereDelegate, bool> > expression) { ICriterion filter = RestrictionHelper .GetCriterion ( expression, new HelperContext(Data, expression, HelperType.Filter) ); return(Where(filter)); }
protected void Page_Load(object sender, EventArgs e) { bool logged = (System.Web.HttpContext.Current.User != null) && System.Web.HttpContext.Current.User.Identity.IsAuthenticated; if (!logged) { Response.Redirect("/Client/Login.aspx"); } Admin = RestrictionHelper.CheckUser(); }
/// <inheritdoc /> public override IProjection Project(Expression expression, HelperContext context) { var condition = (ConditionalExpression)expression; return(Projections .Conditional ( RestrictionHelper.GetCriterion(condition.Test, context), ProjectionHelper.GetProjection(condition.IfTrue, context), ProjectionHelper.GetProjection(condition.IfFalse, context) )); }
/// <inheritdoc /> public override IProjection Project ( Expression expression, HelperContext context ) { return(Projections .Conditional ( RestrictionHelper.GetCriterion(expression, context), Projections.Constant(true), Projections.Constant(false) )); }
/// <inheritdoc /> protected override IProjection ProjectCore ( MethodCallExpression expression, Expression subExpression, IProjection projection, HelperContext context ) { ICriterion criterion = RestrictionHelper.GetCriterionForMethodCall(expression, context); return(Projections .Conditional ( criterion, Projections.Constant(true, NHibernateUtil.Boolean), Projections.Constant(false, NHibernateUtil.Boolean) )); }
public void GetProjectionValueCriterionThrowsIfNodeTypeIsInvalid() { var data = new QueryHelperData(new Dictionary <string, string>(), new List <Join>()); var context = new HelperContext(data, (string)null, HelperType.Filter); Assert .That ( () => { RestrictionHelper .GetProjectionValueCriterion ( Expression.Equal(Expression.Constant(true), Expression.Constant(true)), true, ExpressionType.ListInit, context, false ); }, Throws.InstanceOf <NotSupportedException>() ); }
protected void Page_Load(object sender, EventArgs e) { var isAdmin = RestrictionHelper.CheckUser(); if (isAdmin == null) { Response.Redirect("/Client/Login.aspx"); } Admin = isAdmin.Value; using (var db = new MLEEntities()) { var user_project = db.UserProject.Where(x => x.UserId == UserID).Select(x => x.ProjectId).ToList(); var projects = db.Project.Where(x => user_project.Contains(x.Id)).ToList(); if (Request.QueryString["unfinished"] != null) { bool.TryParse(Request.QueryString["unfinished"].ToString(), out show_only_unfinished); cbUnfinishedOnly.Checked = show_only_unfinished; } if (Request.QueryString["project"] != null) { var _pID = Convert.ToInt32(Request.QueryString["project"].ToString()); First_Project = _pID != 0 ? db.Project.FirstOrDefault(x => x.Id == _pID) : First_Project; ddlProject.SelectedValue = First_Project.Id.ToString(); } else { First_Project = projects.First(); check_page = false; } if (!IsPostBack) { BindDropDown(projects); } else { if (hfProjectID.Value != "") { if (pID != Convert.ToInt32(hfProjectID.Value)) { pID = Convert.ToInt32(hfProjectID.Value); First_Project = pID != 0 ? db.Project.FirstOrDefault(x => x.Id == pID) : First_Project; ddlProject.SelectedValue = First_Project.Id.ToString(); check_page = false; } } } // checkbox if (hfUnfinished.Value != "") { bool.TryParse(hfUnfinished.Value, out bool isChecked); cbUnfinishedOnly.Checked = isChecked; show_only_unfinished = isChecked; } var all_examples = db.Example.Where(x => x.ProjectId == First_Project.Id && (x.StatusId == 3 || x.StatusId == 2)); NotFinishedExamples = all_examples.Where(x => x.StatusId == 3).ToList().Count; FinishedExamples = all_examples.Where(x => x.StatusId == 2).ToList().Count; var eCount = NotFinishedExamples + FinishedExamples; //var examples = db.Example.Where(x => x.ProjectId == First_Project.Id && x.StatusId == 3).Include(x => x.Category.Subcategory).Include(x => x.Type).Include(x => x.ExampleCategory).OrderBy(x => x.ProjectId).ThenBy(x => x.DateCreated); var default_by_page = 50; Examples_by_page = First_Project.PerPage != 0 && First_Project.PerPage != null ? (int)First_Project.PerPage : default_by_page; current_page = 1; if (check_page) { if (Request.QueryString["page"] != null) { int.TryParse(Request.QueryString["page"].ToString(), out current_page); } } ProjectID = First_Project.Id; var number_of_examples = eCount; Pages = (int)Math.Ceiling((double)number_of_examples / (double)Examples_by_page); current_page = current_page > Pages ? Pages : current_page; Skip = (current_page - 1) * Examples_by_page; CreatePager(Pages, current_page); if (show_only_unfinished) { Examples_NotFinished = db.Example.Where(x => x.ProjectId == First_Project.Id && x.StatusId == 3).Include(x => x.Category.Subcategory).Include(x => x.Type).Include(x => x.ExampleCategory).OrderBy(x => x.ProjectId).ThenBy(x => x.DateCreated).Skip(Skip).Take(Examples_by_page).ToList(); } else { Examples_NotFinished = db.Example.Where(x => x.ProjectId == First_Project.Id && (x.StatusId == 3 || x.StatusId == 2)).Include(x => x.Category.Subcategory).Include(x => x.Type).Include(x => x.ExampleCategory).OrderBy(x => x.ProjectId).ThenBy(x => x.DateCreated).Skip(Skip).Take(Examples_by_page).ToList(); } var marked = Examples_NotFinished.Select(y => y.Marked.Select(x => new { EntityId = x.EntityId, ExampleId = x.ExampleId, SentenceId = x.SentenceId, Color = x.Subcategory != null ? x.Subcategory.Color : null, SubCategoryId = x.SubcategoryId, Text = x.Text }).ToList()).ToList(); MarkedJSON = JsonConvert.SerializeObject(marked); Example_Details = JsonConvert.SerializeObject(Examples_NotFinished.Select(x => new { x.Id, x.FileName, x.DateCreated }).ToList()); } }