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); }