public StoredDefectsFilter udpateFilter(int id, DefectsFilter filter)
{
CurrentContext.Validate();
StoredDefectsFilter stf = new StoredDefectsFilter(id);
stf.SetFilter(filter);
stf.Store();
return(stf);
}
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);
}
