public ActionResult NamedQuery(string name)
{
ViewBag.Title = "QueryBuilder";
var id = DbUtil.Db.QueryIdByName(name);
var m = new QueryModel(id);
return ViewQuery(m);
}
public ActionResult Index(Guid? id)
{
ViewBag.Title = "QueryBuilder";
ViewBag.OrigQueryId = id;
var m = new QueryModel(id);
return ViewQuery(m);
}
public ActionResult Cut(QueryModel m)
{
try { m.Cut(); }
catch (Exception ex)
{
var errorLog = ErrorLog.GetDefault(null);
errorLog.Log(new Error(ex));
}
return View("Conditions", m);
}
private void InitToolbar(QueryModel m)
{
ViewBag.OnQueryBuilder = "true";
ViewBag.TagAction = "/Query/TagAll/";
ViewBag.UnTagAction = "/Query/UnTagAll/";
ViewBag.AddContact = "/Query/AddContact/";
ViewBag.AddTasks = "/Query/AddTasks/";
ViewBag.GearSpan = "span12";
ViewBag.queryid = m.TopClause.Id;
}
private ActionResult ViewQuery(QueryModel m)
{
InitToolbar(m);
m.TopClause.IncrementLastRun();
DbUtil.Db.SubmitChanges();
m.QueryId = m.TopClause.Id;
ViewBag.xml = m.TopClause.ToXml();
var sb = new StringBuilder();
foreach (var c in m.TopClause.AllConditions)
{
sb.AppendLine(c.Key.ToString());
if (c.Value.FieldInfo == null)
return NewQuery();
}
ViewBag.ConditionList = sb.ToString();
return View("Index", m);
}
private void UpdateConditions(Guid id)
{
var query = DbUtil.Db.LoadQueryById2(id);
userpeopleid = (from u in DbUtil.Db.Users
where u.Username == query.Owner
select u.PeopleId).SingleOrDefault();
var c = Condition.Import(query.Text, query.Name, newGuids: false, topguid: id);
m = new QueryModel { TopClause = c };
var settings = new XmlWriterSettings
{
Indent = true,
Encoding = new UTF8Encoding(false)
};
var sb = new StringBuilder();
using (var w = XmlWriter.Create(sb, settings))
UpdateCondition(w, id);
query.Text = sb.ToString();
DbUtil.Db.SubmitChanges();
}
public ActionResult Copy(QueryModel m)
{
m.Copy();
return Content("ok");
}
public ActionResult CodeSelect(QueryModel m)
{
return View("EditorTemplates/CodeSelect", m);
}
public ActionResult AddTasks(QueryModel m)
{
return Content(Task.AddTasks(m.TopClause.Id).ToString());
}
public ContentResult AddContact(QueryModel m)
{
var cid = Contact.AddContact(m.TopClause.Id);
return Content("/Contact/" + cid);
}
public ContentResult TagAll(string tagname, bool? cleartagfirst, QueryModel m)
{
if (!tagname.HasValue())
return Content("error: no tag name");
if (Util2.CurrentTagName == tagname && !(cleartagfirst ?? false))
{
m.TagAll();
return Content("Remove");
}
var tag = DbUtil.Db.FetchOrCreateTag(tagname, Util.UserPeopleId, DbUtil.TagTypeId_Personal);
if (cleartagfirst ?? false)
DbUtil.Db.ClearTag(tag);
m.TagAll(tag);
Util2.CurrentTag = tagname;
DbUtil.Db.TagCurrent();
return Content("Manage");
}
public JsonResult SavedQueries(QueryModel m)
{
return Json(m.SavedQueries());
}
public ActionResult EditCondition(QueryModel m)
{
Response.NoCache();
m.EditCondition();
return View(m);
}
public ActionResult ToXml(Guid? id)
{
var m = new QueryModel(id);
var xml1 = m.TopClause.ToXml();
return Content(xml1, "text/xml");
}
public ActionResult Results(QueryModel m)
{
var starttime = DateTime.Now;
DbUtil.LogActivity($"QB Results ({DateTime.Now.Subtract(starttime).TotalSeconds:N1}, {m.TopClause.Id})");
InitToolbar(m);
ViewBag.xml = m.TopClause.ToXml();
return View(m);
}
public ActionResult Results(int? page, int? size, string sort, string dir, QueryModel m)
{
m.Pager.Set("/Query/Results", page, size, sort, dir);
var starttime = DateTime.Now;
DbUtil.LogActivity("QB Results ({0:N1}, {1})".Fmt(DateTime.Now.Subtract(starttime).TotalSeconds, m.TopClause.Id));
InitToolbar(m);
ViewBag.xml = m.TopClause.ToXml();
return View(m);
}
public ActionResult SaveCondition(QueryModel m)
{
if (m.Validate(ModelState))
m.UpdateCondition();
if (ModelState.IsValid)
return View("Conditions", m);
return View("EditCondition", m);
}
public ActionResult Export()
{
var m = new QueryModel();
Response.ContentType = "text/xml";
var settings = new XmlWriterSettings { Indent = true, Encoding = new System.Text.UTF8Encoding(false) };
using (var w = XmlWriter.Create(Response.OutputStream, settings))
m.TopClause.SendToWriter(w);
return new EmptyResult();
}
public ActionResult SelectCondition(QueryModel m)
{
m.Comparison = "Equal";
m.UpdateCondition();
return View("EditCondition", m);
}
public ActionResult Index(Guid? id)
{
if (!ViewExtensions2.UseNewLook())
return Redirect("/QueryBuilder2/Main/" + id);
ViewBag.Title = "QueryBuilder";
var m = new QueryModel(id);
m.Pager.Set("/Query/Results/");
InitToolbar(m);
var newsearchid = (Guid?)TempData["newsearch"];
if (m.TopClause.NewMatchAnyId.HasValue)
newsearchid = m.TopClause.NewMatchAnyId;
if (newsearchid.HasValue)
ViewBag.NewSearchId = newsearchid.Value;
m.TopClause.IncrementLastRun();
DbUtil.Db.SubmitChanges();
m.QueryId = m.TopClause.Id;
ViewBag.xml = m.TopClause.ToXml();
var sb = new StringBuilder();
foreach (var c in m.TopClause.AllConditions)
sb.AppendLine(c.Key.ToString());
ViewBag.ConditionList = sb.ToString();
return View(m);
}
public ContentResult UnTagAll(QueryModel m)
{
m.UnTagAll();
return Content("Add");
}
public ActionResult InsGroupAbove(QueryModel m)
{
m.InsertGroupAbove();
return View("Conditions", m);
}
public ActionResult AddNewGroup(QueryModel m)
{
m.EditCondition();
ViewBag.NewId = m.AddGroupToGroup();
return View("Conditions", m);
}
public ActionResult MakeTopGroup(QueryModel m)
{
m.MakeTopGroup();
return View("Conditions", m);
}
public ActionResult ChangeGroup(string comparison, QueryModel m)
{
m.Selected.Comparison = comparison;
m.TopClause.Save(DbUtil.Db);
return Content("ok");
}
public ActionResult Paste(QueryModel m)
{
m.Paste();
return View("Conditions", m);
}
public ActionResult Conditions(QueryModel m)
{
return View("Conditions", m);
}
public ActionResult Reload()
{
var m = new QueryModel();
return View("Conditions", m);
}
public ActionResult Cut(QueryModel m)
{
m.Cut();
return View("Conditions", m);
}
public ActionResult RemoveCondition(QueryModel m)
{
m.DeleteCondition();
m.SelectedId = null;
return View("Conditions", m);
}
