public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("BootstrapTheming", InitializeQueryBuilder);
return(View(qb));
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(InstanceId, q => q.SyntaxProvider = new GenericSyntaxProvider());
return(View(qb));
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("NoDesignArea", InitializeQueryBuilder);
return(View(qb));
}
public ActionResult WithPartiaView()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(_instanceId, InitializeQueryBuilder);
return(View(qb));
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(InstanceId, InitializeQueryBuilder);
return View(qb);
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("ClientEventHandle", InitializeQueryBuilder);
return(View(qb));
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("MetadataStructure", InitializeQueryBuilder);
return(View(qb));
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("UserDefinedFields", InitializeQueryBuilder);
return(View(qb));
}
protected void Page_Load(object sender, EventArgs e)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("NoDesignArea", InitializeQueryBuilder);
QueryBuilderControl1.QueryBuilder = qb;
ObjectTreeView1.QueryBuilder = qb;
Grid1.QueryBuilder = qb;
SubQueryNavigationBar1.QueryBuilder = qb;
StatusBar1.QueryBuilder = qb;
SqlEditor1.QueryBuilder = qb;
}
protected void Page_Load(object sender, EventArgs e)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(InstanceId, q => q.SyntaxProvider = new GenericSyntaxProvider());
QueryBuilderControl1.QueryBuilder = qb;
ObjectTreeView1.QueryBuilder = qb;
Canvas1.QueryBuilder = qb;
Grid1.QueryBuilder = qb;
SubQueryNavigationBar1.QueryBuilder = qb;
SqlEditor1.QueryBuilder = qb;
StatusBar1.QueryBuilder = qb;
}
/// <summary>
/// Creates and initializes new instance of the QueryBuilder object for the given identifier if it doesn't exist.
/// </summary>
/// <param name="name">Instance identifier of object in the current session.</param>
/// <returns></returns>
public ActionResult CreateQueryBuilder(string name)
{
try
{
// Create an instance of the QueryBuilder object
QueryBuilderStore.GetOrCreate(name);
return(new HttpStatusCodeResult(200));
}
catch (QueryBuilderException e)
{
return(new HttpStatusCodeResult(400, e.Message));
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate("ClientEventHandleUQ", InitializeQueryBuilder);
QueryBuilderControl1.QueryBuilder = qb;
ObjectTreeView1.QueryBuilder = qb;
Canvas1.QueryBuilder = qb;
Grid1.QueryBuilder = qb;
SubQueryNavigationBar1.QueryBuilder = qb;
SqlEditor1.QueryBuilder = qb;
StatusBar1.QueryBuilder = qb;
UserQueries1.QueryBuilder = qb;
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(instanceId, InitializeQueryBuilder);
var qt = QueryTransformerStore.GetOrCreate(instanceId, q =>
{
q.QueryProvider = qb.SQLQuery;
q.AlwaysExpandColumnsInQuery = true;
});
ViewBag.QueryTransformer = qt;
return(View(qb));
}
protected void Page_Load(object sender, EventArgs e)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(InstanceId, InitializeQueryBuilder);
var qt = QueryTransformerStore.GetOrCreate(InstanceId, q =>
{
q.QueryProvider = qb.SQLQuery;
q.AlwaysExpandColumnsInQuery = true;
});
QueryBuilderControl1.QueryBuilder = qb;
ObjectTreeView1.QueryBuilder = qb;
Canvas1.QueryBuilder = qb;
Grid1.QueryBuilder = qb;
SubQueryNavigationBar1.QueryBuilder = qb;
SqlEditor1.QueryBuilder = qb;
StatusBar1.QueryBuilder = qb;
CriteriaBuilder1.QueryTransformer = qt;
}
/// <summary>
/// Creates and initializes new instance of the QueryBuilder object for the given identifier if it doesn't exist.
/// </summary>
/// <param name="name">Instance identifier of object in the current session.</param>
/// <returns></returns>
public ActionResult Create(string name)
{
try
{
// Create an instance of the QueryBuilder object
QueryBuilderStore.GetOrCreate(name, qb => qb.SQL = GetDefaultSql());
// The necessary initialization procedures to setup SQL syntax and the source of metadata will be performed automatically
// according to directives in the special configuration section of 'Web.config' file.
// This behavior is enabled by the QueryBuilderStore.WebConfig() method call in the Application_Start method in Global.asax.cs file.
// See qb.ConfiguredBy to get information about actual default settings
}
catch (Exception e)
{
return(new HttpStatusCodeResult(500, e.Message));
}
return(new EmptyResult());
}
/// <summary>
/// Creates and initializes new instance of the QueryBuilder object if it doesn't exist.
/// </summary>
private void CreateQueryBuilder()
{
// Get an instance of the QueryBuilder object
QueryBuilderStore.GetOrCreate(InstanceId, queryBuilder =>
{
queryBuilder.SyntaxProvider = new MSSQLSyntaxProvider();
// Denies metadata loading requests from the metadata provider
queryBuilder.MetadataLoadingOptions.OfflineMode = true;
// Load MetaData from XML document. File name is stored in the "Web.config" file in [/configuration/appSettings/NorthwindXmlMetaData] key
var path = ConfigurationManager.AppSettings["NorthwindXmlMetaData"];
var xml = Path.Combine(Server.MapPath("~"), path);
queryBuilder.MetadataContainer.ImportFromXML(xml);
//Set default query
queryBuilder.SQL = GetDefaultSql();
});
}
/// <summary>
/// Creates and initializes new instance of the QueryBuilder object for the given identifier if it doesn't exist.
/// </summary>
/// <param name="name">Instance identifier of object in the current session.</param>
/// <returns></returns>
public ActionResult CreateQueryBuilder(string name)
{
// Get an instance of the QueryBuilder object
QueryBuilderStore.GetOrCreate(name, queryBuilder =>
{
queryBuilder.SyntaxProvider = new MSSQLSyntaxProvider();
// Denies metadata loading requests from live database connection
queryBuilder.MetadataLoadingOptions.OfflineMode = true;
// Load MetaData from XML document. File name is stored in the "Web.config" file in [/configuration/appSettings/NorthwindXmlMetaData] key
var path = ConfigurationManager.AppSettings["NorthwindXmlMetaData"];
var xml = Path.Combine(Server.MapPath("~"), path);
queryBuilder.MetadataContainer.ImportFromXML(xml);
//Set default query
queryBuilder.SQL = GetDefaultSql();
});
return(new EmptyResult());
}
protected void Page_Load(object sender, EventArgs e)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.GetOrCreate(InstanceId, InitializeQueryBuilder);
QueryBuilderControl1.QueryBuilder = qb;
ObjectTreeView1.QueryBuilder = qb;
Canvas1.QueryBuilder = qb;
Grid1.QueryBuilder = qb;
SubQueryNavigationBar1.QueryBuilder = qb;
SqlEditor1.QueryBuilder = qb;
StatusBar1.QueryBuilder = qb;
cbCompanyName.Enabled = cbCustomers.Checked;
tbCompanyName.Enabled = cbCompanyName.Checked;
cbOrderDate.Enabled = cbOrders.Checked;
tbOrderDate.Enabled = cbOrderDate.Checked;
//prepare parsed names
_joinFieldName = qb.SQLContext.ParseQualifiedName(CusomerId);
_companyNameFieldName = qb.SQLContext.ParseQualifiedName(CustomersCompanyName);
_orderDateFieldName = qb.SQLContext.ParseQualifiedName(OrderDate);
}
private QueryBuilder GetOrCreateQueryBuilder()
{
// Get an instance of the QueryBuilder object
return(QueryBuilderStore.GetOrCreate(qbId, InitializeQueryBuilder));
}
public ChangeConnectionController()
{
QueryBuilderStore.GetOrCreate(_instanceId);
}
