示例#1
0
 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["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();
      return _emailTemplate;
 }
示例#2
0
 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;
 }
示例#3
0
 protected void btnSave_Click(object sender, EventArgs e)
 {
     template = new EmailTemplate();
     template.EmailContent = txtContent.Html;
     template.Description = txtDesc.Text;
     template.Name = txtName.Text;
     template.ConferenceID = Convert.ToInt32(cbConference.Value);
     template.SystemEmailTypeID = Convert.ToInt32(cbEmailType.Value);
     template.LanguageID = Convert.ToInt32(cbLang.Value);
     if (Request.QueryString["ID"] != null)
         new EmailTemplateLogic().Update(template, Convert.ToInt32(Request.QueryString["ID"]));
     else
         new EmailTemplateLogic().Insert(template);
     Response.Redirect("Manage.aspx");
 }
示例#4
0
 private void FillFOrmControls()
 {
     if (Request.QueryString["ID"] != null)
     {
         cbConference.DataBind();
         cbEmailType.DataBind();
         cbLang.DataBind();
         template = new EmailTemplateLogic().GetByID(Convert.ToInt32(Request.QueryString["ID"]));
         txtContent.Html = template.EmailContent;
         txtDesc.Text = template.Description;
         txtName.Text = template.Name;
         cbConference.SelectedIndex = cbConference.Items.FindByValue(template.ConferenceID).Index;
         cbEmailType.SelectedIndex = cbEmailType.Items.FindByValue(template.SystemEmailTypeID).Index;
         cbLang.SelectedIndex = cbLang.Items.FindByValue(template.LanguageID).Index;
     }
 }
示例#5
0
        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;
        }
示例#6
0
 public bool Update(EmailTemplate emailtemplate ,int old_emailTemplateID)
 {
     EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
     return emailtemplateComponent.UpdateEmailTemplate( emailtemplate.SystemEmailTypeID,  emailtemplate.ConferenceID,  emailtemplate.LanguageID,  emailtemplate.Name,  emailtemplate.Description,  emailtemplate.EmailContent,  old_emailTemplateID);
 }
示例#7
0
 public bool Insert(EmailTemplate emailtemplate)
 {
     int autonumber = 0;
     EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
     bool endedSuccessfuly = emailtemplateComponent.InsertNewEmailTemplate( ref autonumber,  emailtemplate.SystemEmailTypeID,  emailtemplate.ConferenceID,  emailtemplate.LanguageID,  emailtemplate.Name,  emailtemplate.Description,  emailtemplate.EmailContent);
     if(endedSuccessfuly)
     {
         emailtemplate.EmailTemplateID = autonumber;
     }
     return endedSuccessfuly;
 }