private void InitEasyQuery()
{
var options = new EasyQueryOptions();
EqManager = new EasyQueryManagerSql(options);
using (var dbContext = ApplicationDbContext.Create())
EqManager.Model.LoadFromDbContext(dbContext);
// EasyQueryManagerSql.RegisterDbGate<SqlServerGate>();
// EqManager.Model.LoadFromConnection(ApplicationDbContext.Create().Database.GetConnection);
//saving the reference to Customer Country attribute in our model (will be used on RequestList processing)
_countryAttr = EqManager.Model.EntityRoot.FindAttributeById("Customers.Country");
//assign query to all visual controls.
QPanel.Query = EqManager.Query;
CPanel.Query = EqManager.Query;
SPanel.Query = EqManager.Query;
EntPanel.Query = EqManager.Query;
//setting differnt properties of EasyQuery visual controls
CPanel.AllowEditCaptions = true;
CPanel.AllowSorting = true;
EntPanel.ShowFilter = true;
}
private void InitEasyQuery()
{
var options = new EasyQueryOptions();
EqManager = new EasyQueryManagerSql(options);
using (var dbContext = ApplicationDbContext.Create())
EqManager.Model.LoadFromDbContext(dbContext);
// How to load from connection
// EasyQueryManagerSql.RegisterDbGate<SqlServerGate>();
// EqManager.Model.LoadFromConnection(ApplicationDbContext.Create().Database.GetConnection());
//query initialization
EqManager.Query.ConditionsChanged += query_ConditionsChanged;
EqManager.Query.ColumnsChanged += query_ColumnsChanged;
//add handlers for ListRequest and ValueRequest events
AddHandler(ListXElement.ListRequestEvent, new ListXElement.ListRequestEventHandler(queryPanel_ListRequest));
AddHandler(SimpleConditionRow.ValueRequestEvent, new ValueRequestEventHandler(queryPanel_CustomValueRequest));
//some additional configuration of EasyQuery visual controls
queryPanel.SortEntities = XSortOrder.Ascending;
columnsPanel.SortEntities = XSortOrder.Ascending;
columnsPanel.ShowCheckBoxes = true;
sortingPanel.SortEntities = XSortOrder.Ascending;
entitiesPanel.SortEntities = XSortOrder.Ascending;
PanelExport.Visibility = Visibility.Collapsed;
textBoxEntityFilter.TextChanged += TextBoxEntityFilter_TextChanged;
entitiesPanel.ItemAdding += EntitiesPanel_ItemAdding;
}
private void InitEasyQuery()
{
var options = new EasyQueryOptions();
EqManager = new EasyQueryManagerSql(options);
// loads model from DbContext
EqManager.Model.LoadFromDbContext(ApplicationDbContext.Create());
// intialize the data model and load it from XML (or JSON) file
// EqManager.Model.LoadFromJsonFile("Your path");
// intialize the data model and load it from connection
// DbGate.Register<SqlServerGate>();
// EqManager.Model.LoadFromConnection(ApplicationDbContext.Create().Database.Connection);
//saving the reference to Customer Country attribute in our model (will be used on RequestList processing)
_countryAttr = EqManager.Model.EntityRoot.FindAttributeById("Customers.Country");
//assign query to all visual controls.
QPanel.Query = EqManager.Query;
CPanel.Query = EqManager.Query;
SPanel.Query = EqManager.Query;
EntPanel.Query = EqManager.Query;
//setting differnt properties of EasyQuery visual controls
this.CPanel.AllowEditCaptions = true;
this.CPanel.AllowSorting = true;
this.EntPanel.ShowFilter = true;
}
public static void Register(HttpConfiguration config)
{
// Web API configuration and services
var httpControllerRouteHandler = typeof(System.Web.Http.WebHost.HttpControllerRouteHandler).GetField("_instance",
System.Reflection.BindingFlags.Static | System.Reflection.BindingFlags.NonPublic);
// To support Session in WebAPI
if (httpControllerRouteHandler != null)
{
httpControllerRouteHandler.SetValue(null,
new Lazy <System.Web.Http.WebHost.HttpControllerRouteHandler>(() => new SessionHttpControllerRouteHandler(), true));
}
// Web API routes
config.MapHttpAttributeRoutes(new WebApiCustomDirectRouteProvider());
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
// Register you exportes here
// to make export works
EasyQueryManager.RegisterExporter("csv", new CsvDataExporter());
EasyQueryManager.RegisterExporter("excel", new ExcelDataExporter());
EasyQueryManager.RegisterExporter("pdf", new PdfDataExporter());
// Allows to use DbConnectionModelLoader
EasyQueryManagerSql.RegisterDbGate <Korzh.EasyQuery.DbGates.SqlServerGate>();
}
public static void Register(HttpConfiguration config)
{
// Web API configuration and services
// Web API routes
config.MapHttpAttributeRoutes(new WebApiCustomDirectRouteProvider());
config.Routes.MapHttpRoute(
name: "DefaultApi",
routeTemplate: "api/{controller}/{id}",
defaults: new { id = RouteParameter.Optional }
);
// Register you exportes here
// to make export works
EasyQueryManager.RegisterExporter("csv", new CsvDataExporter());
EasyQueryManager.RegisterExporter("excel", new ExcelDataExporter());
EasyQueryManager.RegisterExporter("pdf", new PdfDataExporter());
EasyQueryManagerSql.RegisterDbGate <Korzh.EasyQuery.DbGates.SqlClientGate>();
}
