public static List <MessageData> GetAllCampaignsSorted(this AnalyticsDataGateway gateway, Guid managerRoot, string orderBy, SortOrder sortOrder) { StringBuilder bestMessagesQueryPrefix = AnalyticsSQLDataGatewayExtensions.GetBestMessagesQueryPrefix(managerRoot); bestMessagesQueryPrefix.AppendFormat(" SELECT * FROM Data ORDER BY {0} {1}", orderBy, sortOrder); return(GetAnalyticsSqlCommand().ExecuteCommand <MessageData>(new Func <IDataReader, MessageData>(AnalyticsFactory.Instance.GetAnalyticsDataMapper().GetMessageData), bestMessagesQueryPrefix.ToString(), new CommandParameter[0])); }
// Methods public BestMessagesRepository() { List<string> list = new List<string>(); list.Add("Value"); list.Add("ValuePerVisit"); list.Add("VisitsPerEmail"); list.Add("ValuePerEmail"); this.orderByList = list; this.managerRoot = UIFactory.Instance.GetSpeakContext().ManagerRoot; this.analyticsDataGateway = AnalyticsFactory.Instance.GetAnalyticsDataGateway(); }
// Methods public BestMessagesRepository() { List <string> list = new List <string>(); list.Add("Value"); list.Add("ValuePerVisit"); list.Add("VisitsPerEmail"); list.Add("ValuePerEmail"); this.orderByList = list; this.managerRoot = UIFactory.Instance.GetSpeakContext().ManagerRoot; this.analyticsDataGateway = AnalyticsFactory.Instance.GetAnalyticsDataGateway(); }