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