public ContentResult AddContact() { var m = new QueryModel(); m.LoadScratchPad(); var cid = CmsData.Contact.AddContact(m.QueryId.Value); return Content("/Contact.aspx?id=" + cid); }
public ActionResult AddTasks() { var m = new QueryModel(); m.LoadScratchPad(); var c = new ContentResult(); c.Content = Task.AddTasks(m.QueryId.Value).ToString(); return c; }
public ActionResult CopyAsNew(int id) { var m = new QueryModel { SelectedId = id }; m.LoadScratchPad(); m.CopyAsNew(); var c = new ContentResult(); c.Content = m.QueryId.ToString(); return c; }
public ActionResult AddToGroup() { var m = new QueryModel(); UpdateModel<IQBUpdateable>(m); m.LoadScratchPad(); if (Validate(m)) m.AddConditionToGroup(); return PartialView("TryConditions", m); }
public JsonResult EditCondition(int id) { var m = new QueryModel { SelectedId = id }; m.LoadScratchPad(); m.EditCondition(); return Json(m); }
public ContentResult TagAll(string tagname, bool? cleartagfirst) { if (!tagname.HasValue()) return Content("error: no tag name"); var m = new QueryModel(); m.LoadScratchPad(); 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 ContentResult UnTagAll() { var m = new QueryModel(); m.LoadScratchPad(); m.UnTagAll(); var c = new ContentResult(); c.Content = "Add"; return c; }
public ActionResult SaveQuery() { var m = new QueryModel(); UpdateModel(m); m.LoadScratchPad(); var ret = m.SaveQuery(); if (ret.HasValue()) return Content(ret); return Content(m.Description); }
public JsonResult SelectCondition(int id, string ConditionName) { var m = new QueryModel { ConditionName = ConditionName, SelectedId = id }; m.LoadScratchPad(); m.SetVisibility(); m.TextValue = ""; m.Comparison = ""; m.IntegerValue = ""; m.DateValue = ""; m.CodeValue = ""; m.CodeValues = new string[0]; m.Days = ""; m.Age = ""; m.Program = 0; m.Quarters = ""; m.StartDate = ""; m.EndDate = ""; return Json(m); }
public ActionResult Results() { var cb = new SqlConnectionStringBuilder(Util.ConnectionString); cb.ApplicationName = "qb"; DbUtil.Db = new CMSDataContext(cb.ConnectionString); var m = new QueryModel(); try { UpdateModel<IQBUpdateable>(m); } catch (Exception ex) { return Content("Something went wrong<br><p>" + ex.Message + "</p>"); } m.LoadScratchPad(); var starttime = DateTime.Now; try { m.PopulateResults(); } catch (Exception ex) { var ex2 = new Exception("SearchBuilder error:\n" + m.GetTopClause().ToXml(), ex); ErrorLog errorLog = ErrorLog.GetDefault(null); errorLog.Log(new Error(ex2)); return Content("Something went wrong<br><p>" + ex.Message + "</p>"); } DbUtil.LogActivity("QB Results ({0:N1}, {1})".Fmt(DateTime.Now.Subtract(starttime).TotalSeconds, m.QueryId)); return View(m); }
public JsonResult Remove() { var m = new QueryModel(); UpdateModel<IQBUpdateable>(m); m.LoadScratchPad(); m.DeleteCondition(); return Json(m); }
public ActionResult Main(int? id, int? run) { if (DbUtil.Db.UserPreference("newlook3", "false").ToBool() && DbUtil.Db.UserPreference("advancedsearch", "false").ToBool()) return Redirect(Request.RawUrl.ToLower().Replace("querybuilder", "search/advanced")); ViewData["Title"] = "QueryBuilder"; ViewData["OnQueryBuilder"] = "true"; ViewData["TagAction"] = "/QueryBuilder/TagAll/"; ViewData["UnTagAction"] = "/QueryBuilder/UnTagAll/"; ViewData["AddContact"] = "/QueryBuilder/AddContact/"; ViewData["AddTasks"] = "/QueryBuilder/AddTasks/"; var m = new QueryModel { QueryId = id }; DbUtil.LogActivity("QueryBuilder"); if (run.HasValue) m.ShowResults = true; m.LoadScratchPad(); ViewData["queryid"] = m.QueryId; ViewBag.AutoRun = (bool?)(TempData["AutoRun"]) == true; return View(m); }
public ActionResult InsGroupAbove(int id) { var m = new QueryModel { SelectedId = id }; m.LoadScratchPad(); m.InsertGroupAbove(); var c = new ContentResult(); c.Content = m.QueryId.ToString(); return c; }
public ActionResult Export() { var m = new QueryModel(); m.LoadScratchPad(); return new QBExportResult(m.QueryId.Value); }