public bool SaveQuery(string path)
{
var fileName = GenerateFileName(path);
var parameters = new StorageParameters {
FileName = fileName
};
var query = GenerateQuery();
if (query == null)
{
return(false);
}
_storage.SaveQuery(query, parameters);
LinqQuery = "";
SqlQuery = "";
if (!ValidationResults.Any())
{
var schemaFileName = Path.Combine(path, $"Schema.json");
LinqQuery = _linqGenerator.GenerateQuery(schemaFileName, fileName);
}
return(true);
}
public void LoadFromFile(string path, string fileName)
{
var parameters = new StorageParameters {
FileName = fileName, Path = path
};
var q = _storage.LoadQuery(parameters);
Clear();
var queryModel = _engine.LoadFromStoreQuery(this, q);
StoreParameters = queryModel.StoreParameters;
FromTables = queryModel.FromTables;
RegenerateTableLinks();
SelectionProperties = queryModel.SelectionProperties;
foreach (var sp in SelectionProperties)
{
// var t = FindFromTable(sp.);
var prop = sp.FromTable.Properties.SingleOrDefault(p => p.StoreProperty.Name == sp.StoreProperty.Name);
if (prop != null)
{
prop.Selected = true;
}
}
WhereClause = queryModel.WhereClause;
}
public void SaveSchema(string path)
{
var fileName = Path.Combine(path, $"Schema.json");
var parameters = new StorageParameters {
FileName = fileName
};
_storage.SaveSchema(Schema, parameters);
}
public void SaveQuery(string path)
{
var fileName = GenerateFileName(path);
var parameters = new StorageParameters {
FileName = fileName
};
var query = GenerateQuery();
_storage.SaveQuery(query, parameters);
}
public void LoadFromFile(string path, string fileName)
{
var parameters = new StorageParameters {
FileName = fileName, Path = path
};
var q = _storage.LoadQuery(parameters);
Clear();
var fullQuery = _engine.LoadQueryFromStoreQuery(Schema, q);
ReloadControllerModels(fullQuery);
}