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("search/advanced", "querybuilder")));
}
ViewData["Title"] = "QueryBuilder";
ViewData["OnQueryBuilder"] = "true";
ViewData["TagAction"] = "/Search/Advanced/TagAll/";
ViewData["UnTagAction"] = "/Search/Advanced/UnTagAll/";
ViewData["AddContact"] = "/Search/Advanced/AddContact/";
ViewData["AddTasks"] = "/Search/Advanced/AddTasks/";
var m = new AdvancedModel {
QueryId = id
};
DbUtil.LogActivity("QueryBuilder");
if (run.HasValue)
{
m.ShowResults = true;
}
m.LoadScratchPad();
ViewData["queryid"] = m.QueryId;
ViewBag.AutoRun = (bool?)(TempData["AutoRun"]) == true;
var newsearchid = (int?)TempData["newsearch"];
if (newsearchid.HasValue)
{
ViewBag.NewSearch = true;
m.SelectedId = newsearchid.Value;
}
return(View(m));
}
public ActionResult SelectCondition(int id, string conditionName)
{
var m = new AdvancedModel {
SelectedId = id
};
m.LoadScratchPad();
m.ConditionName = conditionName;
m.SetVisibility();
m.TextValue = "";
m.IntegerValue = "";
m.DateValue = "";
m.CodeValue = "";
m.CodeValues = new string[0];
m.Days = "";
m.Age = "";
m.Program = 0;
m.Quarters = "";
m.StartDate = "";
m.EndDate = "";
m.Comparison = "Equal";
m.UpdateCondition();
m.SelectedId = id;
return(View("Conditions", m));
}
public ActionResult Export()
{
var m = new AdvancedModel();
m.LoadScratchPad();
return(new QBExportResult(m.QueryId.Value));
}
public ActionResult Reload()
{
var m = new AdvancedModel();
m.LoadScratchPad();
return(View("Conditions", m));
}
public ContentResult AddContact()
{
var m = new AdvancedModel();
m.LoadScratchPad();
var cid = CmsData.Contact.AddContact(m.QueryId.Value);
return(Content("/Contact.aspx?id=" + cid));
}
public ActionResult DuplicateCondition(int id)
{
var m = new AdvancedModel();
m.LoadScratchPad();
m.EditCondition();
m.CopyCurrentCondition(id);
return(View("Conditions", m));
}
public ActionResult AddTasks()
{
var m = new AdvancedModel();
m.LoadScratchPad();
var c = new ContentResult();
c.Content = Task.AddTasks(m.QueryId.Value).ToString();
return(c);
}
public ActionResult SaveCondition(AdvancedModel m)
{
m.LoadScratchPad();
if (m.Validate(ModelState))
{
m.UpdateCondition();
DbUtil.Db.SubmitChanges();
}
return(View("Conditions", m));
}
public ActionResult EditCondition(int id)
{
var m = new AdvancedModel {
SelectedId = id
};
m.LoadScratchPad();
m.EditCondition();
return(View("Conditions", m));
}
public ActionResult RemoveCondition(int id)
{
var m = new AdvancedModel {
SelectedId = id
};
m.LoadScratchPad();
m.DeleteCondition();
m.SelectedId = null;
return(View("Conditions", m));
}
public ContentResult UnTagAll()
{
var m = new AdvancedModel();
m.LoadScratchPad();
m.UnTagAll();
var c = new ContentResult();
c.Content = "Add";
return(c);
}
public ActionResult SaveQuery()
{
var m = new AdvancedModel();
UpdateModel(m);
m.LoadScratchPad();
m.SaveQuery();
var c = new ContentResult();
c.Content = m.Description;
return(c);
}
public ActionResult InsGroupAbove(int id)
{
var m = new AdvancedModel {
SelectedId = id
};
m.LoadScratchPad();
m.InsertGroupAbove();
var c = new ContentResult();
c.Content = m.QueryId.ToString();
return(c);
}
public ActionResult CopyAsNew(int id)
{
var m = new AdvancedModel {
SelectedId = id
};
m.LoadScratchPad();
m.CopyAsNew();
var c = new ContentResult();
c.Content = m.QueryId.ToString();
return(c);
}
public ActionResult AddNewCondition(int id)
{
var m = new AdvancedModel {
SelectedId = id
};
m.LoadScratchPad();
m.EditCondition();
if (m.ConditionName == "Group")
{
m.AddConditionToGroup();
}
else
{
m.AddNewConditionAfterCurrent(id);
}
return(View("Conditions", m));
}
public ContentResult TagAll(string tagname, bool cleartagfirst)
{
var m = new AdvancedModel();
m.LoadScratchPad();
if (Util2.CurrentTagName == tagname && !cleartagfirst)
{
m.TagAll();
return(Content("Remove"));
}
var tag = DbUtil.Db.FetchOrCreateTag(tagname, Util.UserPeopleId, DbUtil.TagTypeId_Personal);
if (cleartagfirst)
{
DbUtil.Db.ClearTag(tag);
}
m.TagAll(tag);
Util2.CurrentTag = tagname;
DbUtil.Db.TagCurrent();
return(Content("Manage"));
}
public ActionResult Results()
{
var cb = new SqlConnectionStringBuilder(Util.ConnectionString);
cb.ApplicationName = "qb";
DbUtil.Db = new CMSDataContext(cb.ConnectionString);
var m = new AdvancedModel();
try
{
UpdateModel(m);
}
catch (Exception ex)
{
return(Content("Something went wrong<br><p>" + ex.Message + "</p>"));
}
m.LoadScratchPad();
var starttime = DateTime.Now;
m.PopulateResults();
DbUtil.LogActivity("QB Results ({0:N1}, {1})".Fmt(DateTime.Now.Subtract(starttime).TotalSeconds, m.QueryId));
return(View(m));
}