public ActionResult Results()
{
var m = new SavedQueryModel();
UpdateModel(m.Pager);
UpdateModel(m);
return(View(m));
}
public ActionResult Code(SavedQueryModel m)
{
var qlist = from q in m.DefineModelList()
select q.QueryId;
var list = string.Join(",", qlist);
TempData["codelist"] = list;
return(Content("ok"));
}
public ActionResult Index()
{
var m = new SavedQueryModel
{
OnlyMine = DbUtil.Db.UserPreference("SavedQueryOnlyMine", "false").ToBool()
};
return(View(m));
}
public ActionResult Index()
{
var m = new SavedQueryModel(CurrentDatabase)
{
OnlyMine = CurrentDatabase.UserPreference("SavedQueryOnlyMine", "false").ToBool()
};
return(View(m));
}
public ActionResult Index()
{
var m = new SavedQueryModel {
OnlyMine = DbUtil.Db.UserPreference("SavedQueryOnlyMine", "false").ToBool()
};
m.Pager.Set("/SavedQuery/Results", 1, null, "Last Run", "desc");
return(View(m));
}
public ActionResult PythonCode(SavedQueryModel m)
{
var qlist = from q in m.DefineModelList()
select q.QueryId;
var list = string.Join(",", qlist);
Util.TempCodeList = list;
return(Content("ok"));
}
public ActionResult Index()
{
var m = new SavedQueryModel
{
OnlyMine = DbUtil.Db.UserPreference("SavedQueryOnlyMine", "false").ToBool()
};
//m.Pager.Set("/SavedQuery/Results", 1, null, "Last Run", "desc");
return View(m);
}
public async Task <ActionResult> SaveQuery(MeasurementQueryModel query)
{
string c = "";
if (string.IsNullOrEmpty(query?.Name))
{
ModelState.AddModelError("Name", "Name field is required!");
c = " <div class='alert alert-warning fade in'><a class='close' data-dismiss='alert' aria-label='close'>×</a>Name field is required</div>";
return(Content(c));
}
Helpers.LoginHelper lh = new Helpers.LoginHelper();
query.Key = lh.GetAuthenticationKey(this.HttpContext);
if (query.Key != null)
{
ModelState.Remove("key");
ModelState.Add("Key", new ModelState());
ModelState.SetModelValue("Key", new ValueProviderResult(query.Key, query.Key, System.Globalization.CultureInfo.CurrentCulture));
}
c = " <div class='alert alert-danger fade in'><a class='close' data-dismiss='alert' aria-label='close'>×</a><span class='text-info'><span class='text-success'>Query: " + query.Name + " was <strong>NOT</strong> Saved successfully!</span></span></div>";
if (!ModelState.IsValid)
{
return(Content(c));
}
Repository r = new Repository();
int result = 0;
SavedQueryModel savedQuery = new SavedQueryModel();
try
{
result = await r.SaveQueryAsync(query);
if (result > 0)
{
query.ID = result;
savedQuery = new SavedQueryModel(query);
}
else if (result == -1)
{
c = " <div class='alert alert-danger fade in'><a class='close' data-dismiss='alert' aria-label='close'>×</a><span class='text-info'><span class='text-success'>Queries cannot be saved with Master key!</span></span></div>";
return(Content(c));
}
else
{
return(Content(c));
}
}
catch (Exception ex)
{
Savonia.Web.ErrorReporter.ErrorReporterModule.HandleException(ex, System.Web.HttpContext.Current.Request);
return(Content(c));
}
return(Json(savedQuery));
}
public ActionResult Results()
{
var m = new SavedQueryModel();
UpdateModel(m.Pager);
UpdateModel(m);
var onlyMine = DbUtil.Db.UserPreference("savedSearchOnlyMine", "true").ToBool();
if (m.onlyMine != onlyMine)
{
DbUtil.Db.SetUserPreference("savedSearchOnlyMine", m.onlyMine);
}
return(View(m));
}
/// <summary>
/// Sets the types for explicit filters.
/// </summary>
/// <param name="model">The model to be prepared.</param>
private void PrepareExplicitFilters(SavedQueryModel model)
{
var tables = model.Filters.Select(x => new { x.TableName, x.SchemaName }).Distinct();
foreach (var table in tables)
{
var columns = tableDal.GetTable(new TableViewModel()
{
Name = table.TableName,
Schema = table.SchemaName
}).Columns;
foreach (var filter in model.Filters.Where(x => x.TableName == table.TableName && x.SchemaName == table.SchemaName))
{
filter.ColumnType = columns[filter.ColumnName];
}
}
}
public async Task <ActionResult> DeleteQuery([System.Web.Http.FromBody] MeasurementQueryModel query)
{
Helpers.LoginHelper lh = new Helpers.LoginHelper();
query.Key = lh.GetAuthenticationKey(this.HttpContext);
if (query.Key != null)
{
ModelState.Remove("key");
ModelState.Add("Key", new ModelState());
ModelState.SetModelValue("Key", new ValueProviderResult(query.Key, query.Key, System.Globalization.CultureInfo.CurrentCulture));
}
string c = " <div class='alert alert-danger fade in'><a class='close' data-dismiss='alert' aria-label='close'>×</a><span class='text-info'><span class='text-success'>Query: " + query.Name + " was <strong>NOT</strong> deleted successfully!</span></span></div>";
if (!ModelState.IsValid)
{
return(Content(c));
}
Repository r = new Repository();
int result = 0;
SavedQueryModel savedQuery = new SavedQueryModel();
try
{
result = await r.DeleteQueryAsync(query);
if (result > 0)
{
savedQuery = new SavedQueryModel(query);
}
else
{
return(Content(c));
}
}
catch (Exception ex)
{
Savonia.Web.ErrorReporter.ErrorReporterModule.HandleException(ex, System.Web.HttpContext.Current.Request);
return(Content(c));
}
return(Json(savedQuery));
}
public ActionResult Index()
{
var m = new SavedQueryModel();
return(View(m));
}
public ActionResult Results(SavedQueryModel m)
{
return(View(m));
}
public ActionResult Results(SavedQueryModel m)
{
m.Db = CurrentDatabase;
return(View(m));
}
public ActionResult Results(int?page, int?size, string sort, string dir, SavedQueryModel m)
{
m.Pager.Set("/SavedQuery/Results", page, size, sort, dir);
return(View(m));
}
public ActionResult Results(SavedQueryModel m)
{
return View(m);
}
