public List <EmailTemplate> GetAll()
{
EmailTemplateDAC _emailTemplateComponent = new EmailTemplateDAC();
IDataReader reader = _emailTemplateComponent.GetAllEmailTemplate().CreateDataReader();
List <EmailTemplate> _emailTemplateList = new List <EmailTemplate>();
while (reader.Read())
{
if (_emailTemplateList == null)
{
_emailTemplateList = new List <EmailTemplate>();
}
EmailTemplate _emailTemplate = new EmailTemplate();
if (reader["EmailTemplateId"] != DBNull.Value)
{
_emailTemplate.EmailTemplateId = Convert.ToInt32(reader["EmailTemplateId"]);
}
if (reader["SiteId"] != DBNull.Value)
{
_emailTemplate.SiteId = Convert.ToInt32(reader["SiteId"]);
}
if (reader["Title"] != DBNull.Value)
{
_emailTemplate.Title = Convert.ToString(reader["Title"]);
}
if (reader["TemplateContent"] != DBNull.Value)
{
_emailTemplate.TemplateContent = Convert.ToString(reader["TemplateContent"]);
}
_emailTemplate.NewRecord = false;
_emailTemplateList.Add(_emailTemplate);
}
reader.Close();
return(_emailTemplateList);
}
public EmailTemplate GetTemplate(int TemplateTypeID, int ConferenceID, int LanguageID)
{
EmailTemplateDAC _emailTemplateComponent = new EmailTemplateDAC();
IDataReader reader = _emailTemplateComponent.GetAllEmailTemplate(string.Format("SystemEmailTypeID = {0} and ConferenceID = {1} and LanguageID = {2}", TemplateTypeID, ConferenceID, LanguageID)).CreateDataReader();
EmailTemplate _emailTemplate = null;
while (reader.Read())
{
_emailTemplate = new EmailTemplate();
if (reader["EmailTemplateID"] != DBNull.Value)
{
_emailTemplate.EmailTemplateID = Convert.ToInt32(reader["EmailTemplateID"]);
}
if (reader["SystemEmailTypeID"] != DBNull.Value)
{
_emailTemplate.SystemEmailTypeID = Convert.ToInt32(reader["SystemEmailTypeID"]);
}
if (reader["ConferenceID"] != DBNull.Value)
{
_emailTemplate.ConferenceID = Convert.ToInt32(reader["ConferenceID"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_emailTemplate.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["Name"] != DBNull.Value)
{
_emailTemplate.Name = Convert.ToString(reader["Name"]);
}
if (reader["Description"] != DBNull.Value)
{
_emailTemplate.Description = Convert.ToString(reader["Description"]);
}
if (reader["EmailContent"] != DBNull.Value)
{
_emailTemplate.EmailContent = Convert.ToString(reader["EmailContent"]);
}
_emailTemplate.NewRecord = false;
}
reader.Close();
if (_emailTemplate == null && LanguageID != Convert.ToInt32(Common.DefaultLanguageId))
{
return(GetTemplate(TemplateTypeID, ConferenceID, Convert.ToInt32(Common.DefaultLanguageId)));
}
return(_emailTemplate);
}
public List <EmailTemplate> GetAll()
{
EmailTemplateDAC _emailTemplateComponent = new EmailTemplateDAC();
IDataReader reader = _emailTemplateComponent.GetAllEmailTemplate().CreateDataReader();
List <EmailTemplate> _emailTemplateList = new List <EmailTemplate>();
while (reader.Read())
{
if (_emailTemplateList == null)
{
_emailTemplateList = new List <EmailTemplate>();
}
EmailTemplate _emailTemplate = new EmailTemplate();
if (reader["EmailTemplateID"] != DBNull.Value)
{
_emailTemplate.EmailTemplateID = Convert.ToInt32(reader["EmailTemplateID"]);
}
if (reader["SystemEmailTypeID"] != DBNull.Value)
{
_emailTemplate.SystemEmailTypeID = Convert.ToInt32(reader["SystemEmailTypeID"]);
}
if (reader["ConferenceID"] != DBNull.Value)
{
_emailTemplate.ConferenceID = Convert.ToInt32(reader["ConferenceID"]);
}
if (reader["LanguageID"] != DBNull.Value)
{
_emailTemplate.LanguageID = Convert.ToInt32(reader["LanguageID"]);
}
if (reader["Name"] != DBNull.Value)
{
_emailTemplate.Name = Convert.ToString(reader["Name"]);
}
if (reader["Description"] != DBNull.Value)
{
_emailTemplate.Description = Convert.ToString(reader["Description"]);
}
if (reader["EmailContent"] != DBNull.Value)
{
_emailTemplate.EmailContent = Convert.ToString(reader["EmailContent"]);
}
_emailTemplate.NewRecord = false;
_emailTemplateList.Add(_emailTemplate);
}
reader.Close();
return(_emailTemplateList);
}