private List<Request> Read(DbDataReader reader)
        {
            List<Request> requests = new List<Request>();

            while (reader.Read())
            {
                ExaminationRequest er = new ExaminationRequest();
                er.Id = reader.GetInt32(0);
                er.Type = reader.GetString(1);
                er.Description = reader.GetString(2);
                er.Created = reader.GetDateTime(3);

                requests.Add(er);
            }

            return requests;
        }
        private void PrepareCommand(IDatabase db, DbCommand cmd, ExaminationRequest er)
        {
            cmd.Parameters.Add(db.CreateParameter("@type", "varchar", er.Type.Length));
            cmd.Parameters["@type"].Value = er.Type;

            cmd.Parameters.Add(db.CreateParameter("@description", "varchar", er.Description.Length));
            cmd.Parameters["@description"].Value = er.Description;

            cmd.Parameters.Add(db.CreateParameter("@date", "datetime"));
            cmd.Parameters["@date"].Value = er.Created;
        }