protected void eds_QueryCreated(object sender, QueryCreatedEventArgs e)
{
if (!string.IsNullOrWhiteSpace(this.descriptionFilter.Text))
{
e.Query = e.Query.OfType<job>().Where(x => x.job_desc.Contains(this.descriptionFilter.Text));
}
}
// Method that selects, from the database, which category (for which user) to list
protected void EntityDataSourceGeneral_QueryCreated(object sender, QueryCreatedEventArgs e)
{
int usrnID = int.Parse(Session["usrnid"].ToString());
var mediaitms = e.Query.Cast<arcencase_itms>();
e.Query = from mi in mediaitms
where mi.arcencase_ctgrys.aenc_ctgrys_ctgrysname == this.Ctgry
&& mi.aenc_itms_itmsusrsid == usrnID
select mi;
}
protected virtual void OnQueryCreated(QueryCreatedEventArgs e)
{
EventHandler <QueryCreatedEventArgs> handler = (EventHandler <QueryCreatedEventArgs>)Events[EventQueryCreated];
if (handler != null)
{
handler(this, e);
}
}
protected void entyPlayer_QueryCreated(object sender, QueryCreatedEventArgs e)
{
string strid = Request.QueryString["teamId"];
Guid teamGuid = new Guid(strid);
if (teamGuid != Guid.Empty)
{
var playersQuery = e.Query.OfType<player>();
e.Query = playersQuery.Where(c => c.teamId == teamGuid);
}
}
protected virtual void OnQueryCreated(QueryCreatedEventArgs e) {
EventHandler<QueryCreatedEventArgs> handler = (EventHandler<QueryCreatedEventArgs>)Events[EventQueryCreated];
if (handler != null) {
handler(this, e);
}
}
protected IQueryable ExecuteQueryExpressions(IQueryable source, QueryContext context) {
if (source != null) {
QueryCreatedEventArgs queryArgs = new QueryCreatedEventArgs(source);
OnQueryCreated(queryArgs);
source = queryArgs.Query ?? source;
// Support the Dynamic Expression language used by LinqDataSource
if (AutoGenerateWhereClause) {
if (!String.IsNullOrEmpty(Where)) {
throw new InvalidOperationException(String.Format(CultureInfo.InvariantCulture,
AtlasWeb.LinqDataSourceView_WhereAlreadySpecified, _owner.ID));
}
source = QueryableDataSourceHelper.CreateWhereExpression(context.WhereParameters, source, _queryable);
}
else if (!String.IsNullOrEmpty(Where)) {
source = _queryable.Where(source, Where, context.WhereParameters.ToEscapedParameterKeys(_owner));
}
if (AutoGenerateOrderByClause) {
if (!String.IsNullOrEmpty(OrderBy)) {
throw new InvalidOperationException(String.Format(CultureInfo.InvariantCulture,
AtlasWeb.LinqDataSourceView_OrderByAlreadySpecified, _owner.ID));
}
source = QueryableDataSourceHelper.CreateOrderByExpression(context.OrderByParameters, source, _queryable);
}
else if (!String.IsNullOrEmpty(OrderBy)) {
source = _queryable.OrderBy(source, OrderBy, context.OrderByParameters.ToEscapedParameterKeys(_owner));
}
string groupBy = GroupBy;
if (String.IsNullOrEmpty(groupBy)) {
if (!String.IsNullOrEmpty(OrderGroupsBy)) {
throw new InvalidOperationException(String.Format(CultureInfo.InvariantCulture,
AtlasWeb.LinqDataSourceView_OrderGroupsByRequiresGroupBy, _owner.ID));
}
}
else {
source = _queryable.GroupBy(source, groupBy, "it", context.GroupByParameters.ToEscapedParameterKeys(_owner));
if (!String.IsNullOrEmpty(OrderGroupsBy)) {
source = _queryable.OrderBy(source, OrderGroupsBy, context.OrderGroupsByParameters.ToEscapedParameterKeys(_owner));
}
}
if (!String.IsNullOrEmpty(SelectNew)) {
source = _queryable.Select(source, SelectNew, context.SelectParameters.ToEscapedParameterKeys(_owner));
}
return source;
}
return source;
}
protected IQueryable ExecuteQueryExpressions(IQueryable source, QueryContext context)
{
if (source != null)
{
QueryCreatedEventArgs queryArgs = new QueryCreatedEventArgs(source);
OnQueryCreated(queryArgs);
source = queryArgs.Query ?? source;
// Support the Dynamic Expression language used by LinqDataSource
if (AutoGenerateWhereClause)
{
if (!String.IsNullOrEmpty(Where))
{
throw new InvalidOperationException(String.Format(CultureInfo.InvariantCulture,
AtlasWeb.LinqDataSourceView_WhereAlreadySpecified, _owner.ID));
}
source = QueryableDataSourceHelper.CreateWhereExpression(context.WhereParameters, source, _queryable);
}
else if (!String.IsNullOrEmpty(Where))
{
source = _queryable.Where(source, Where, context.WhereParameters.ToEscapedParameterKeys(_owner));
}
if (AutoGenerateOrderByClause)
{
if (!String.IsNullOrEmpty(OrderBy))
{
throw new InvalidOperationException(String.Format(CultureInfo.InvariantCulture,
AtlasWeb.LinqDataSourceView_OrderByAlreadySpecified, _owner.ID));
}
source = QueryableDataSourceHelper.CreateOrderByExpression(context.OrderByParameters, source, _queryable);
}
else if (!String.IsNullOrEmpty(OrderBy))
{
source = _queryable.OrderBy(source, OrderBy, context.OrderByParameters.ToEscapedParameterKeys(_owner));
}
string groupBy = GroupBy;
if (String.IsNullOrEmpty(groupBy))
{
if (!String.IsNullOrEmpty(OrderGroupsBy))
{
throw new InvalidOperationException(String.Format(CultureInfo.InvariantCulture,
AtlasWeb.LinqDataSourceView_OrderGroupsByRequiresGroupBy, _owner.ID));
}
}
else
{
source = _queryable.GroupBy(source, groupBy, "it", context.GroupByParameters.ToEscapedParameterKeys(_owner));
if (!String.IsNullOrEmpty(OrderGroupsBy))
{
source = _queryable.OrderBy(source, OrderGroupsBy, context.OrderGroupsByParameters.ToEscapedParameterKeys(_owner));
}
}
if (!String.IsNullOrEmpty(SelectNew))
{
source = _queryable.Select(source, SelectNew, context.SelectParameters.ToEscapedParameterKeys(_owner));
}
return(source);
}
return(source);
}
//-------------------------------------------------------------------------------------------
void List_QueryCreated(object sender, QueryCreatedEventArgs e)
{
if (export)
{
Response.Clear();
//XmlSerializer serializer = new XmlSerializer(typeof(Logistics_Products));
//TextWriter writer = new StreamWriter(Response.OutputStream);
Response.AddHeader("Content-Disposition", "attachment; filename=Data.csv");
Response.ContentType = "text/plain";
var query = (ObjectQuery)e.Query;
bool outputHeader = true;
foreach (var res in query)
{
//serializer.Serialize(writer, rec);
PropertyInfo[] props = res.GetType().GetProperties();
if (outputHeader)
{
for (int i = 0; i < props.Length; i++)
{
PropertyInfo Prop = props[i];
Response.Write("\"" + Prop.Name + "\",");
}
outputHeader = false;
Response.Write("\r\n");
}
for (int i = 0; i < props.Length; i++)
{
PropertyInfo Prop = props[i];
object propValue = Prop.GetValue(res, null);
//Response.Write(Prop.Name);
if (propValue != null)
{
string val = propValue.ToString();
val = val.Replace("\"", "\"\"");
Response.Write("\"" + val + "\"");
}
Response.Write(",");
}
Response.Write("\r\n");
}
Response.End();
}
}
private void OnDataSourceQueryCreated(object sender, QueryCreatedEventArgs e)
{
e.Query = Query.GetQueryable(e.Query);
}
private void OnDataSourceQueryCreated(object sender, QueryCreatedEventArgs e) {
e.Query = Query.GetQueryable(e.Query);
}
