public ActionResult Edit(Guid id)
{
var m = new SavedQueryInfo(id);
if (m.Name.Equals(Util.ScratchPad2))
m.Name = "copy of scratchpad";
return View(m);
}
public ActionResult Update(SavedQueryInfo m)
{
if (m.Name.Equal(Util.ScratchPad2))
m.Ispublic = false;
m.CanDelete = true; // must be true since they can edit if they got here
m.UpdateModel();
return View("Row", m);
}
public ActionResult Update(SavedQueryInfo m)
{
if (m.Name.Equal(Util.ScratchPad2))
{
m.Ispublic = false;
}
m.CanDelete = true; // must be true since they can edit if they got here
m.UpdateModel();
return(View("Row", m));
}
public ActionResult Edit(Guid id)
{
var m = new SavedQueryInfo(id);
if (m.Name.Equals(Util.ScratchPad2))
{
m.Name = "copy of scratchpad";
}
return(View(m));
}
public ActionResult SaveAs(Guid id, string nametosaveas)
{
if (nametosaveas.Equals(Util.ScratchPad2))
{
nametosaveas = "copy of scratchpad";
}
var m2 = new SavedQueryInfo(id)
{
Name = nametosaveas
};
return(View(m2));
}
public ActionResult Update(SavedQueryInfo m)
{
try
{
if (m.Name.Equal(Util.ScratchPad2))
{
m.Ispublic = false;
}
m.CanDelete = true; // must be true since they can edit if they got here
m.UpdateModel();
return(View("Row", m));
}
catch (Exception e)
{
DbUtil.LogActivity($@"error: {e.Message} StackTrace: {e.StackTrace}");
return(PageMessage($@"error: {e.Message} "));
}
}
public ActionResult Save(string name, string value, SavedQueryInfo m)
{
var query = CurrentDatabase.LoadQueryById2(m.QueryId);
var previous = (from p in CurrentDatabase.Queries
where p.Owner == m.Owner
where p.Name == name
orderby p.LastRun
select p).FirstOrDefault();
if (previous != null)
{
// copying over a previous query with same name and owner
m.CopyPropertiesTo(previous);
previous.Text = query.Text;
if (previous.Name.Equal(Util.ScratchPad2))
{
previous.Ispublic = false;
}
CurrentDatabase.SubmitChanges();
return(Redirect("/Query/" + previous.QueryId));
// m.CopyPropertiesTo(previous);
// var pc = previous.ToClause();
// pc.Reset(CurrentDatabase);
// pc = Condition.Import(query.Text, name, newGuids: true, topguid: previous.QueryId);
// previous.Text = pc.ToXml();
// CurrentDatabase.SubmitChanges();
// return Redirect("/Query/" + previous.QueryId);
}
// saving to a new query
m.CopyPropertiesTo(query);
if (query.Name.Equal(Util.ScratchPad2))
{
query.Ispublic = false;
}
CurrentDatabase.SubmitChanges();
return(Redirect("/Query/" + m.QueryId));
}
public ActionResult Save(string name, string value, SavedQueryInfo m)
{
var query = CurrentDatabase.LoadQueryById2(m.QueryId);
var previous = (from p in CurrentDatabase.Queries
where p.Owner == m.Owner
where p.Name == name
orderby p.LastRun
select p).FirstOrDefault();
if (previous != null)
{
// copying over a previous query with same name and owner
m.CopyPropertiesTo(previous);
if (previous.Name.Equal(Util.ScratchPad2))
{
previous.Text = query.Text;
previous.Ispublic = false;
}
else // saved search, not a scratchpad query
{
// remove DisableOnScratchpad attributes from saved search
previous.Text = query.Text.Replace(" DisableOnScratchpad=\"True\"", "");
}
CurrentDatabase.SubmitChanges();
return(Redirect("/Query/" + previous.QueryId));
}
// saving to a new query
m.CopyPropertiesTo(query);
if (query.Name.Equal(Util.ScratchPad2))
{
query.Ispublic = false;
}
CurrentDatabase.SubmitChanges();
return(Redirect("/Query/" + m.QueryId));
}
