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