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