public IList<EmailTemplate> DequeueEmail()
{
IList<EmailTemplate> list = new List<EmailTemplate>();
MySqlParameter[] parameters = new MySqlParameter[0];
DataSet set = DbHelperMySQL.RunProcedure("sp_Emails_Dequeue", parameters, "ds");
if (set.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in set.Tables[0].Rows)
{
EmailTemplate model = new EmailTemplate();
this.LoadEntityData(ref model, row);
list.Add(model);
}
}
return list;
}
private void LoadEntityData(ref EmailTemplate model, DataRow dr)
{
if (dr["EmailId"].ToString() != "")
{
model.EmailID = int.Parse(dr["EmailId"].ToString());
}
if ((dr["EmailTo"] != null) && (dr["EmailTo"].ToString() != ""))
{
model.EmailTo = dr["EmailTo"].ToString();
}
if ((dr["EmailSubject"] != null) && (dr["EmailSubject"].ToString() != ""))
{
model.Subject = dr["EmailSubject"].ToString();
}
if ((dr["EmailBody"] != null) && (dr["EmailBody"].ToString() != ""))
{
model.Body = dr["EmailBody"].ToString();
}
}