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); }