topher-b
2/9/2016 - 10:30 PM

Forming a Model

Forming a Model

public class RelayData
    {
        public int RelayId { get; set; }
        public DateTime ActivationDate { get; set; }
        public DateTime ExpirationDate { get; set; }
        public string RelayMessage { get; set; }
        public string MoreInfoUrl { get; set; }
        public string RelatedDepartment { get; set; }
        public bool Priority { get; set; }
        public string SubmittedBy { get; set; }
        public DateTime SubmittedDate { get; set; }

        public RelayData(SqlDataReader reader)
        {
            RelayId = (int)reader["RelayID"];
            ActivationDate = (DateTime)reader["ActivationDate"];
            ExpirationDate = reader["ExpirationDate"] == DBNull.Value ? DateTime.Now : (DateTime)reader["ExpirationDate"];
            RelayMessage = (string)reader["RelayMessage"];
            MoreInfoUrl = reader["MoreInfoURL"] == DBNull.Value ? null : (string)reader["MoreInfoURL"];
            RelatedDepartment = reader["RelatedDepartment"] == DBNull.Value ? null : (string)reader["RelatedDepartment"];
            Priority = reader["Priority"] != DBNull.Value && (bool)reader["Priority"];
            SubmittedBy = (string)reader["SubmittedBy"];
            SubmittedDate = (DateTime)reader["SubmittedDate"];
        }
    }
List<RelayData> relayData = new List<RelayData>();

using (SqlDataReader reader = command.ExecuteReader())
  {
  while (reader.Read())
    {
      relayData.Add(new RelayData(reader));
    }
  }