public string GetPageOgTitle() { string ttid = GetPageTTID(); string userid = GetPageUserID(); if (!string.IsNullOrEmpty(ttid)) { DefectBase d = getDefect(); if (d != null) { return(d.SUMMARY.Replace("\"", """).Replace("\'", "'")); } } else if (!string.IsNullOrEmpty(userid)) { return((new MPSUser(userid)).LOGIN + "'s Live Plan"); } else if (!string.IsNullOrEmpty(GetPageVerson())) { return("Change Log"); } else if (!string.IsNullOrEmpty(GetPageFilter())) { return(StoredDefectsFilter.GetName(int.Parse(GetPageFilter()))); } else if (!string.IsNullOrEmpty(GetPageTracker())) { return((new Tracker(int.Parse(GetPageTracker()))).NAME); } return(""); }
public StoredDefectsFilter udpateFilter(int id, DefectsFilter filter) { CurrentContext.Validate(); StoredDefectsFilter stf = new StoredDefectsFilter(id); stf.SetFilter(filter); stf.Store(); return(stf); }
static public List <StoredDefectsFilter> Enum(int user) { List <StoredDefectsFilter> res = new List <StoredDefectsFilter>(); foreach (DataRow r in (new StoredDefectsFilter()).GetRecords($"WHERE {_Share} = 1 OR {_Usr} = {user} ORDER BY {_Share}, {_Nam} asc")) { StoredDefectsFilter d = new StoredDefectsFilter(); d.Load(r); res.Add(d); } return(res); }
static public StoredDefectsFilter NewFilter(string name, bool personal, DefectsFilter f, int user) { string g = Guid.NewGuid().ToString(); SQLExecute($"INSERT INTO {_Tabl} ({_Nam}, {_Usr}, {_Share}) VALUES ('{g}', '{user}', {(personal ? 0 : 1)})"); int id = Convert.ToInt32(GetValue(string.Format("SELECT {0} FROM {1} WHERE {2} = '{3}'", _pid, _Tabl, _Nam, g))); StoredDefectsFilter sf = new StoredDefectsFilter(id) { NAME = name, DATA = Newtonsoft.Json.JsonConvert.SerializeObject(f) }; sf.Store(); return(sf); }
public List <PublicFilter> getFilters(int user) { CurrentContext.Validate(); List <StoredDefectsFilter> sdf = StoredDefectsFilter.Enum(user); List <PublicFilter> lsout = new List <PublicFilter>(); foreach (var f in sdf) { lsout.Add(new PublicFilter() { NAME = f.NAME, ID = f.ID, SHARED = f.SHARED }); } return(lsout); }
public List <StoredDefectsFilter> getFilters() { return(StoredDefectsFilter.Enum(CurrentContext.TTUSERID)); }
public void deleteFilter(int id) { StoredDefectsFilter.Delete(id); }
public StoredDefectsFilter saveFilter(string name, bool personal, DefectsFilter filter) { CurrentContext.Validate(); return(StoredDefectsFilter.NewFilter(name, personal, filter, CurrentContext.TTUSERID)); }