public static List<SendEmailListing> GetAllSendEmails()
{
//DB Connection goes here
List<SendEmailListing> _article = new List<SendEmailListing>();
// Create the Database object, using the default database service. The
// default database service is determined through configuration.
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "GetAllEmailToSend";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
// DataSet that will hold the returned results
DataSet commentaryDataSet = null;
commentaryDataSet = db.ExecuteDataSet(dbCommand);
// Note: connection was closed by ExecuteDataSet method call
foreach (DataRow dr in commentaryDataSet.Tables[0].Rows)
{
SendEmailListing _emailListing = new SendEmailListing();
_emailListing.EmailSubject = dr["EmailSubject"].ToString();
_emailListing.EmailDateTime =DateTime.Parse(dr["EmailDateTime"].ToString());
_emailListing.IsEmailSent = bool.Parse(dr["IsEmailSent"].ToString());
_emailListing.SendEmailId = Int32.Parse(dr["SendEmailId"].ToString());
_article.Add(_emailListing);
}
return _article;
}
/// <summary>
///
/// </summary>
/// <param name="filterData"></param>
/// <returns></returns>
public static List<SendEmailListing> GetAllSendEmailsFilterData(string filterData)
{
//DB Connection goes here
List<SendEmailListing> _article = new List<SendEmailListing>();
// Create the Database object, using the default database service. The
// default database service is determined through configuration.
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "GetAllEmailToSend";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
// Retrieve products from the specified category.
//db.AddInParameter(dbCommand, "CategoryID", DbType.Int32, Category);
// DataSet that will hold the returned results
DataSet commentaryDataSet = null;
commentaryDataSet = db.ExecuteDataSet(dbCommand);
DataRow[] dataRow;
dataRow = commentaryDataSet.Tables[0].Select("EmailSubject LIKE '%" + filterData + "%'");
// Note: connection was closed by ExecuteDataSet method call
foreach (DataRow dr in dataRow)
{
SendEmailListing _emailListing = new SendEmailListing();
_emailListing.EmailSubject = dr["EmailSubject"].ToString();
_emailListing.EmailDateTime = DateTime.Parse(dr["EmailDateTime"].ToString());
_emailListing.IsEmailSent = bool.Parse(dr["IsEmailSent"].ToString());
_article.Add(_emailListing);
}
return _article;
}
