/// <summary>
/// Get ads from wcf service for the following date range: January 1st, 2011 and April 1st, 2011
/// </summary>
/// <returns></returns>
private async Task <IEnumerable <Ad> > GetAllAdsFromServiceAsync()
{
var client = new AdDataServiceClient();
var tasks = new List <Task <Ad[]> >();
var start = new DateTime(2011, 1, 1);
var end = new DateTime(2011, 4, 1);
while (start < end)
{
DateTime taskStart = start;
DateTime taskEnd = start.AddMonths(1);
Task <Ad[]> task = client.GetAdDataByDateRangeAsync(taskStart, taskEnd);
tasks.Add(task);
start = taskEnd;
}
Ad[][] whenAllResult = await Task.WhenAll(tasks.ToArray());
IEnumerable <Ad> ads = whenAllResult.SelectMany(ad => ad);
client.Close();
return(ads);
}
public override void LoadAds(DateTime start, DateTime end)
{
var client = new AdDataServiceClient();
var ads = client.GetAdDataByDateRange(start, end);
var viewModelAds =
ads.Select(a => Models.Ad.Create(a.AdId, a.Brand.BrandId, a.Brand.BrandName, a.NumPages, a.Position));
Ads = viewModelAds.OrderBy(a=>a.BrandName).ToList();
}
/// <summary>
/// Returns all ad data from the server
/// </summary>
/// <returns></returns>
private static List <Ad> GetAdsFromServer()
{
AdDataServiceClient client = new AdDataServiceClient();
DateTime start = new DateTime(2011, 1, 1);
DateTime end = new DateTime(2011, 5, 1);
return(client.GetAdDataByDateRange(start, end).ToList <Ad>());
}
private Ad[] GetAdsDataList()
{
AdDataServiceClient adc = new AdDataServiceClient();
Ad[] retAdList = adc.GetAdDataByDateRange(FromDate, ToDate);
adc.Close();
return(retAdList);
}
public override void LoadAds(DateTime start, DateTime end)
{
var client = new AdDataServiceClient();
var ads = client.GetAdDataByDateRange(start, end);
var viewModelAds =
ads.Select(a => Models.Ad.Create(a.AdId, a.Brand.BrandId, a.Brand.BrandName, a.NumPages, a.Position));
Ads = viewModelAds.OrderBy(a => a.BrandName).ToList();
}
public AdServiceContainer()
{
this.bjk_fromDate = new DateTime(2011, 1, 1, 0, 0, 0);
this.bjk_toDate = new DateTime(2011, 4, 1, 23, 59, 59);
this.bjk_exercise_number = ExerciseNumber.EXERCISE_1;
bjk_client = new AdDataServiceClient();
bjk_ads = bjk_client.GetAdDataByDateRange(this.bjk_fromDate, this.bjk_toDate).ToList();
bjk_client.Close();
}
public async Task <ActionResult> GetAds()
{
IEnumerable <Ad> ads;
using (var svc = new AdDataServiceClient())
{
ads = await svc.GetAdDataByDateRangeAsync(_startDate, _endDate);
ads = ads.OrderBy(x => x.Brand.BrandName);
}
return(Json(ads, JsonRequestBehavior.AllowGet));
}
public async Task <IQueryable <Ad> > GetAll()
{
try
{
var service = new AdDataServiceClient();
var data = await service.GetAdDataByDateRangeAsync(StartDate, EndDate);
return(data.AsQueryable());
}
catch (Exception exception)
{
throw new WcfServiceException(exception);
}
}
}//index
//
public ActionResult FullListAd(int? page, string sortBy = "BrandName", string sortOrder = "", int pageSize = 200, string currentSortBy = "", string currentSortByDir = "")
{
try
{
if (sortOrder == "")
ViewBag.SortDirParm = "desc";
else
ViewBag.SortDirParm = sortOrder == "asc" ? "desc" : "asc";
ViewBag.CurrentSortBy = sortBy;
ViewBag.CurrentSortByDir = sortOrder;
var sortExpression = String.Format("{0} {1}", sortBy, sortOrder);
int pgNum = (page ?? 1);
ViewBag.CurrentPage = pgNum;
startDate = DateTime.Parse(sDate);
endDate = DateTime.Parse(eDate);
AdDataServiceClient ad = new AdDataServiceClient();
var fullList = ad.GetAdDataByDateRange(startDate, endDate).ToList();
switch(sortBy)
{
case "BrandName":
fullList = sortOrder == "desc" ? fullList.OrderByDescending(b => b.Brand.BrandName).ToList() : fullList.OrderBy(b => b.Brand.BrandName).ToList();
break;
case "AdId":
fullList = sortOrder == "desc" ? fullList.OrderByDescending(a => a.AdId).ToList() : fullList.OrderBy(a => a.AdId).ToList();
break;
case "BrandId":
fullList = sortOrder == "desc" ? fullList.OrderByDescending(b => b.Brand.BrandId).ToList() : fullList.OrderBy(b => b.Brand.BrandId).ToList();
break;
case "NumPages":
fullList = sortOrder == "desc" ? fullList.OrderByDescending(n => n.NumPages).ToList() : fullList.OrderBy(n => n.NumPages).ToList();
break;
case "Position":
fullList = sortOrder == "desc" ? fullList.OrderByDescending(p => p.Position).ToList() : fullList.OrderBy(p => p.Position).ToList();
break;
}
return View("FullListAd", fullList.ToPagedList(pgNum, pageSize));
}
catch (Exception ex)
{
return View(ex.Message.ToString());
}
}//FullListAd
private static List <Ad> GetAdData(DateTime startDate, DateTime endDate)
{
var adDataService = new AdDataServiceClient();
return(adDataService.GetAdDataByDateRange(startDate, endDate));
}
}//FullListAd
public ActionResult CoverAdList(int? page, string sortBy = "BrandName", string sortOrder = "",
int pageSize = 200, string currentSortBy = "", string currentSortByDir = "")
{
if (sortOrder == "")
ViewBag.SortDirParm = "desc";
else
ViewBag.SortDirParm = sortOrder == "asc" ? "desc" : "asc";
ViewBag.CurrentSortBy = sortBy;
ViewBag.CurrentSortByDir = sortOrder;
int pgNum = (page ?? 1);
ViewBag.CurrentPage = pgNum;
startDate = DateTime.Parse(sDate);
endDate = DateTime.Parse(eDate);
AdDataServiceClient ad = new AdDataServiceClient();
var cl = ad.GetAdDataByDateRange(startDate, endDate);
var coverList = (from c in cl
where c.Position == "Cover" && c.NumPages >= 0.5M
//orderby c.Brand.BrandName ascending
select c).ToList();
switch (sortBy)
{
case "BrandName":
coverList = sortOrder == "desc" ? coverList.OrderByDescending(b => b.Brand.BrandName).ToList() : coverList.OrderBy(b => b.Brand.BrandName).ToList();
break;
case "AdId":
coverList = sortOrder == "desc" ? coverList.OrderByDescending(a => a.AdId).ToList() : coverList.OrderBy(a => a.AdId).ToList();
break;
case "BrandId":
coverList = sortOrder == "desc" ? coverList.OrderByDescending(b => b.Brand.BrandId).ToList() : coverList.OrderBy(b => b.Brand.BrandId).ToList();
break;
case "NumPages":
coverList = sortOrder == "desc" ? coverList.OrderByDescending(n => n.NumPages).ToList() : coverList.OrderBy(n => n.NumPages).ToList();
break;
case "Position":
coverList = sortOrder == "desc" ? coverList.OrderByDescending(p => p.Position).ToList() : coverList.OrderBy(p => p.Position).ToList();
break;
}
return View(coverList.ToPagedList(pgNum, pageSize));
}//CoverAdList
}//topFiveAds
public ActionResult topFiveBrands()
{
startDate = DateTime.Parse(sDate);
endDate = DateTime.Parse(eDate);
AdDataServiceClient ad = new AdDataServiceClient();
var tBrands = ad.GetAdDataByDateRange(startDate, endDate);
var tBrand = (from t in tBrands
orderby t.NumPages descending, t.Brand.BrandName
select t).Take(5);
return View(tBrand.ToList());
}//topFiveBrands
}//CoverAdList
public ActionResult topFiveAds()
{
startDate = DateTime.Parse(sDate);
endDate = DateTime.Parse(eDate);
AdDataServiceClient ad = new AdDataServiceClient();
var tAds = ad.GetAdDataByDateRange(startDate, endDate);
var tfivead = (from t in tAds
orderby t.NumPages descending, t.Brand.BrandName
select t).Distinct().Take(5);
//var tfiveAds = tfivead.GroupBy(b => b.Brand.BrandName)
// .Select(g => g.ToList())
// .ToList()
// .Distinct().Take(5);
return View(tfivead.ToList());
}//topFiveAds
public HomeController()
{
var client = new AdDataServiceClient();
data = client.GetAdDataByDateRange(new DateTime(2011, 1, 1),
new DateTime(2011, 4, 1));
}
