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