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