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));
}
