public ChangeConnectionController()
{
if (QueryBuilderStore.Get(_instanceId) == null)
{
QueryBuilderStore.Create(_instanceId);
}
}
/// <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)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.Get(name);
if (qb != null)
{
return(new EmptyResult());
}
try
{
// Create an instance of the QueryBuilder object
qb = QueryBuilderStore.Create(name);
// 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
// Set default query
qb.SQL = GetDefaultSql();
}
catch (Exception e)
{
return(new HttpStatusCodeResult(500, e.Message));
}
return(new EmptyResult());
}
private QueryBuilder CreateQueryBuilder()
{
// Create an instance of the QueryBuilder object
var qb = QueryBuilderStore.Create(_instanceId);
SetNorthwindXml(qb);
return(qb);
}
private QueryBuilder CreateQueryBuilder()
{
// Create an instance of the QueryBuilder object
var qb = QueryBuilderStore.Create("ChangeConnection");
SetNorthwindXml(qb);
return(qb);
}
public ActionResult Index()
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.Get("LoadMetadata");
if (qb == null)
{
qb = QueryBuilderStore.Create("LoadMetadata");
qb.SyntaxProvider = new GenericSyntaxProvider();
}
return(View(qb));
}
protected void Page_Load(object sender, EventArgs e)
{
// Get an instance of the QueryBuilder object
var qb = QueryBuilderStore.Get("LoadMetadata");
if (qb == null)
{
qb = QueryBuilderStore.Create("LoadMetadata");
qb.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 if it doesn't exist.
/// </summary>
/// <param name="httpContext"></param>
private void CreateQueryBuilder(IHttpContext httpContext)
{
// Create an instance of the QueryBuilder object
var queryBuilder = QueryBuilderStore.Create(httpContext, InstanceId);
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["QueryBuilderXmlMetaData"];
var xml = Path.Combine(HostingEnvironment.MapPath("~"), path);
queryBuilder.MetadataContainer.ImportFromXML(xml);
//Set default query
queryBuilder.SQL = GetDefaultOfflineSql();
}
/// <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
var qb = QueryBuilderStore.Get(name);
if (qb != null)
{
return(new HttpStatusCodeResult(200));
}
try
{
// Create an instance of the QueryBuilder object
QueryBuilderStore.Create(name);
return(new HttpStatusCodeResult(200));
}
catch (QueryBuilderException e)
{
return(new HttpStatusCodeResult(400, e.Message));
}
}