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