public bool Insert(EmailTemplate emailtemplate)
{
int autonumber = 0;
EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
bool endedSuccessfuly = emailtemplateComponent.InsertNewEmailTemplate( ref autonumber, emailtemplate.SiteId, emailtemplate.Title, emailtemplate.TemplateContent);
if(endedSuccessfuly)
{
emailtemplate.EmailTemplateId = autonumber;
}
return endedSuccessfuly;
}
public EmailTemplate GetByID(int _emailTemplateId)
{
EmailTemplateDAC _emailTemplateComponent = new EmailTemplateDAC();
IDataReader reader = _emailTemplateComponent.GetByIDEmailTemplate(_emailTemplateId);
EmailTemplate _emailTemplate = null;
while(reader.Read())
{
_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; } reader.Close();
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["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 bool Update(EmailTemplate emailtemplate ,int old_emailTemplateId)
{
EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
return emailtemplateComponent.UpdateEmailTemplate( emailtemplate.SiteId, emailtemplate.Title, emailtemplate.TemplateContent, old_emailTemplateId);
}
