Skip to content

Instantly share code, notes, and snippets.

@fernandezdavid

fernandezdavid/gist:6180639

Created August 8, 2013 01:25
Show Gist options
  • Save fernandezdavid/6180639 to your computer and use it in GitHub Desktop.
Save fernandezdavid/6180639 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. fernandezdavid created this gist Aug 8, 2013.
    13 changes: 13 additions & 0 deletions gistfile1.cs
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,13 @@
    foreach (var campDetail in camp.AdvertCampaignDetails)
    {
    DateTime check_date = DateTime.Now.AddDays(-i);
    inter += _db.AdvertCampaignDetailInteractions
    .Where(c => c.AdvertID == campDetail.AdvertID && EntityFunctions.TruncateTime(c.StartDatetime) == check_date.Date)
    .Count();
    elapsedTime += _db.AdvertCampaignDetailInteractions
    .Where(c => c.AdvertID == campDetail.AdvertID && EntityFunctions.TruncateTime(c.StartDatetime) == check_date.Date && c.TimeElapsed!=null)
    .Sum(c => c.TimeElapsed.GetValueOrDefault(0));
    height += _db.AdvertCampaignDetailInteractions
    .Where(c => c.AdvertID == campDetail.AdvertID && EntityFunctions.TruncateTime(c.StartDatetime) == check_date.Date)
    .Sum(c=>c.Height);
    }