private static List <EmailSendQueue> LoadListFromReader(IDataReader reader) { List <EmailSendQueue> emailSendQueueList = new List <EmailSendQueue>(); try { while (reader.Read()) { EmailSendQueue emailSendQueue = new EmailSendQueue(); emailSendQueue.guid = new Guid(reader["Guid"].ToString()); emailSendQueue.siteGuid = new Guid(reader["SiteGuid"].ToString()); emailSendQueue.moduleGuid = new Guid(reader["ModuleGuid"].ToString()); emailSendQueue.userGuid = new Guid(reader["UserGuid"].ToString()); emailSendQueue.specialGuid1 = new Guid(reader["SpecialGuid1"].ToString()); emailSendQueue.specialGuid2 = new Guid(reader["SpecialGuid2"].ToString()); emailSendQueue.fromAddress = reader["FromAddress"].ToString(); emailSendQueue.replyTo = reader["ReplyTo"].ToString(); emailSendQueue.toAddress = reader["ToAddress"].ToString(); emailSendQueue.ccAddress = reader["CcAddress"].ToString(); emailSendQueue.bccAddress = reader["BccAddress"].ToString(); emailSendQueue.subject = reader["Subject"].ToString(); emailSendQueue.textBody = reader["TextBody"].ToString(); emailSendQueue.htmlBody = reader["HtmlBody"].ToString(); emailSendQueue.type = reader["Type"].ToString(); emailSendQueue.dateToSend = Convert.ToDateTime(reader["DateToSend"]); emailSendQueue.createdUtc = Convert.ToDateTime(reader["CreatedUtc"]); emailSendQueueList.Add(emailSendQueue); } } finally { reader.Close(); } return(emailSendQueueList); }
private static List<EmailSendQueue> LoadListFromReader(IDataReader reader) { List<EmailSendQueue> emailSendQueueList = new List<EmailSendQueue>(); try { while (reader.Read()) { EmailSendQueue emailSendQueue = new EmailSendQueue(); emailSendQueue.guid = new Guid(reader["Guid"].ToString()); emailSendQueue.siteGuid = new Guid(reader["SiteGuid"].ToString()); emailSendQueue.moduleGuid = new Guid(reader["ModuleGuid"].ToString()); emailSendQueue.userGuid = new Guid(reader["UserGuid"].ToString()); emailSendQueue.specialGuid1 = new Guid(reader["SpecialGuid1"].ToString()); emailSendQueue.specialGuid2 = new Guid(reader["SpecialGuid2"].ToString()); emailSendQueue.fromAddress = reader["FromAddress"].ToString(); emailSendQueue.replyTo = reader["ReplyTo"].ToString(); emailSendQueue.toAddress = reader["ToAddress"].ToString(); emailSendQueue.ccAddress = reader["CcAddress"].ToString(); emailSendQueue.bccAddress = reader["BccAddress"].ToString(); emailSendQueue.subject = reader["Subject"].ToString(); emailSendQueue.textBody = reader["TextBody"].ToString(); emailSendQueue.htmlBody = reader["HtmlBody"].ToString(); emailSendQueue.type = reader["Type"].ToString(); emailSendQueue.dateToSend = Convert.ToDateTime(reader["DateToSend"]); emailSendQueue.createdUtc = Convert.ToDateTime(reader["CreatedUtc"]); emailSendQueueList.Add(emailSendQueue); } } finally { reader.Close(); } return emailSendQueueList; }