/// <summary>
/// Retrieve a record from the database.
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
/// <remarks></remarks>
public Datafile RetrieveDatafile(int id)
{
DbCommand cmd = store.GetStoredProcCommand("RetrieveDatafileByID");
store.AddInParameter(cmd, "id", DbType.String, id);
using (System.Data.IDataReader reader = store.ExecuteReader(cmd))
{
if (reader.Read() == true)
{
Datafile newfile = new Datafile();
newfile.ID = reader.GetInt32(reader.GetOrdinal("id"));
newfile.Category = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("category")));
newfile.Group = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("group")));
newfile.Filename = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("filename")));
newfile.Extension = System.Convert.ToString(reader.SafeGetString(reader.GetOrdinal("extension")));
newfile.Content = (byte[])(reader.GetValue(reader.GetOrdinal("content")));
return(newfile);
}
else
{
return(null);
}
}
}
