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 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 Save(string name, string value, SavedQueryInfo m) { var query = DbUtil.Db.LoadQueryById2(m.QueryId); var previous = (from p in DbUtil.Db.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; DbUtil.Db.SubmitChanges(); return Redirect("/Query/" + previous.QueryId); // m.CopyPropertiesTo(previous); // var pc = previous.ToClause(); // pc.Reset(DbUtil.Db); // pc = Condition.Import(query.Text, name, newGuids: true, topguid: previous.QueryId); // previous.Text = pc.ToXml(); // DbUtil.Db.SubmitChanges(); // return Redirect("/Query/" + previous.QueryId); } // saving to a new query m.CopyPropertiesTo(query); if (query.Name.Equal(Util.ScratchPad2)) query.Ispublic = false; DbUtil.Db.SubmitChanges(); return Redirect("/Query/" + m.QueryId); }