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;
}
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;
}
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 void Delete(int Original_EmailTemplateID)
{
EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
emailtemplateComponent.DeleteEmailTemplate(Original_EmailTemplateID);
}
public int UpdateDataset(System.Data.DataSet dataset)
{
EmailTemplateDAC emailtemplatecomponent = new EmailTemplateDAC();
return emailtemplatecomponent.UpdateDataset(dataset);
}
public bool Update( int SystemEmailTypeID, int ConferenceID, int LanguageID, string Name, string Description, string EmailContent, int Original_EmailTemplateID)
{
EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
return emailtemplateComponent.UpdateEmailTemplate( SystemEmailTypeID, ConferenceID, LanguageID, Name, Description, EmailContent, Original_EmailTemplateID);
}
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);
}
public bool Insert( int SystemEmailTypeID, int ConferenceID, int LanguageID, string Name, string Description, string EmailContent)
{
EmailTemplateDAC emailtemplateComponent = new EmailTemplateDAC();
int EmailTemplateID = 0;
return emailtemplateComponent.InsertNewEmailTemplate( ref EmailTemplateID, SystemEmailTypeID, ConferenceID, LanguageID, Name, Description, EmailContent);
}
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;
}