/// <summary> /// Persists a new instance of SavedQuery. /// </summary> /// <returns></returns> public void Save(SavedQuery savedQuery) { if (savedQuery == null) { return; } if (savedQuery.Id == Guid.Empty) { savedQuery.Id = Guid.NewGuid(); if (savedQuery.CreatedBy == Guid.Empty) { savedQuery.CreatedBy = savedQuery.LastModBy; } DBSavedQuery.Create( savedQuery.Id, savedQuery.Name, savedQuery.Statement, savedQuery.CreatedUtc, savedQuery.CreatedBy); } else { DBSavedQuery.Update( savedQuery.Id, savedQuery.Statement, savedQuery.LastModUtc, savedQuery.LastModBy); } }
public SavedQuery Fetch(string name) { using (IDataReader reader = DBSavedQuery.GetOne(name)) { if (reader.Read()) { SavedQuery savedQuery = new SavedQuery(); savedQuery.Id = new Guid(reader["Id"].ToString()); savedQuery.Name = reader["Name"].ToString(); savedQuery.Statement = reader["Statement"].ToString(); savedQuery.CreatedUtc = Convert.ToDateTime(reader["CreatedUtc"]); savedQuery.CreatedBy = new Guid(reader["CreatedBy"].ToString()); savedQuery.LastModUtc = Convert.ToDateTime(reader["LastModUtc"]); savedQuery.LastModBy = new Guid(reader["LastModBy"].ToString()); return(savedQuery); } } return(null); }
/// <summary> /// Gets an IList with all instances of SavedQuery. /// </summary> public List <SavedQuery> GetAll() { IDataReader reader = DBSavedQuery.GetAll(); return(LoadListFromReader(reader)); }
/// <summary> /// Deletes an instance of SavedQuery. Returns true on success. /// </summary> /// <param name="id"> id </param> /// <returns>bool</returns> public bool Delete(Guid id) { return(DBSavedQuery.Delete(id)); }