public override IList <MessageTemplate> GetMessageTemplates()
{
IList <MessageTemplate> list = new List <MessageTemplate>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_MessageTemplates");
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(MessageTemplateProvider.PopulateEmailTempletFromIDataReader(dataReader));
}
dataReader.Close();
}
return(list);
}
public override IList <MessageTemplate> GetDistributorMessageTemplates()
{
IList <MessageTemplate> list = new List <MessageTemplate>();
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_MessageTemplates WHERE UserId=@UserId");
this.database.AddInParameter(sqlStringCommand, "UserId", System.Data.DbType.Int32, HiContext.Current.User.UserId);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
list.Add(MessageTemplateProvider.PopulateEmailTempletFromIDataReader(dataReader));
}
dataReader.Close();
}
return(list);
}
public override MessageTemplate GetMessageTemplate(string messageType)
{
MessageTemplate result = null;
System.Data.Common.DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM Hishop_MessageTemplates WHERE LOWER(MessageType) = LOWER(@MessageType)");
this.database.AddInParameter(sqlStringCommand, "MessageType", System.Data.DbType.String, messageType);
using (System.Data.IDataReader dataReader = this.database.ExecuteReader(sqlStringCommand))
{
while (dataReader.Read())
{
result = MessageTemplateProvider.PopulateEmailTempletFromIDataReader(dataReader);
}
dataReader.Close();
}
return(result);
}
public override MessageTemplate GetDistributorMessageTemplate(string messageType, int distributorUserId)
{
MessageTemplate template = null;
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("SELECT * FROM distro_MessageTemplates WHERE LOWER(MessageType) = LOWER(@MessageType) AND UserId=@UserId");
this.database.AddInParameter(sqlStringCommand, "UserId", DbType.Int32, distributorUserId);
this.database.AddInParameter(sqlStringCommand, "MessageType", DbType.String, messageType);
using (IDataReader reader = this.database.ExecuteReader(sqlStringCommand))
{
while (reader.Read())
{
template = MessageTemplateProvider.PopulateEmailTempletFromIDataReader(reader);
}
reader.Close();
}
return(template);
}
