// GET api/nextsession
public Session Get()
{
var retryStrategy = new Incremental(5, TimeSpan.FromSeconds(1), TimeSpan.FromSeconds(2));
var retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(retryStrategy);
Session nextSession = new Session();
using (VidPackEntities db = new VidPackEntities())
{
retryPolicy.ExecuteAction(() =>
{
db.Database.Connection.Open();
});
ExistingSession dbSession = retryPolicy.ExecuteAction <ExistingSession>(() =>
db.ExistingSession.Where(item => item.IsNextSession == 1).FirstOrDefault()
);
if (dbSession != null)
{
nextSession = new VidPackModel.Session()
{
SessionDate = dbSession.SessionDate.ToString(),
SessionDescription = dbSession.SessionDescription,
SessionSubTitle = dbSession.SessionSubTitle,
SessionThumbnailUrl = String.Format("{0}{1}", ThumbnailStorageUrl, dbSession.SessionThumbnailUri),
SessionTitle = dbSession.SessionSubTitle,
SessionVideoUrl = dbSession.SessionVideoUri == null ? "" : dbSession.SessionVideoUri,
Speaker = dbSession.Speaker
}
}
;
}
return(nextSession);
}
// GET api/notification
public IEnumerable <NotificationInfo> Get()
{
var retryStrategy = new Incremental(5, TimeSpan.FromSeconds(1), TimeSpan.FromSeconds(2));
var retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(retryStrategy);
List <NotificationInfo> notifications = new List <NotificationInfo>();
using (VidPackEntities db = new VidPackEntities())
{
retryPolicy.ExecuteAction(() =>
{
db.Database.Connection.Open();
});
notifications = retryPolicy.ExecuteAction <List <NotificationInfo> >(() =>
db.Notification.Select(item => new NotificationInfo()
{
NotificationTag = item.NotificationTag,
}).ToList <NotificationInfo>()
);
}
return(notifications);
}
// GET api/session
public IEnumerable <Session> Get(ODataQueryOptions <Session> queryOptions)
{
var retryStrategy = new Incremental(5, TimeSpan.FromSeconds(1), TimeSpan.FromSeconds(2));
var retryPolicy = new RetryPolicy <SqlAzureTransientErrorDetectionStrategy>(retryStrategy);
List <Session> session = new List <Session>();
try
{
using (VidPackEntities db = new VidPackEntities())
{
retryPolicy.ExecuteAction(() =>
{
db.Database.Connection.Open();
});
var listSession = retryPolicy.ExecuteAction(() =>
db.ExistingSession.Include("DownloadItem").Select(item => new
{
SessionDate = item.SessionDate,
SessionDescription = item.SessionDescription,
SessionSubTitle = item.SessionSubTitle,
SessionThumbnailUrl = item.SessionThumbnailUri,
SessionTitle = item.SessionSubTitle,
SessionVideoUrl = item.SessionVideoUri == null ? "" : item.SessionVideoUri,
Speaker = item.Speaker,
isActual = item.IsActualSession,
DownloadItem = item.DownloadItem.Select(_ => new
{
Caption = _.Caption,
Description = _.Description,
Url = _.Url,
})
}).ToList()
);
//ToString() / String.Format() is not know within projection
session = listSession.Select(item => new Session()
{
SessionDate = Convert.ToString(item.SessionDate),
SessionDescription = item.SessionDescription,
SessionSubTitle = item.SessionSubTitle,
SessionThumbnailUrl = String.Format("{0}{1}", ThumbnailStorageUrl, item.SessionThumbnailUrl),
SessionTitle = item.SessionSubTitle,
SessionVideoUrl = item.SessionVideoUrl,
Speaker = item.Speaker,
SessionDownloadItem = item.DownloadItem.Select(_ => new DownloadItemInfo()
{
Caption = _.Caption,
Description = _.Description,
Url = _.Url,
}).ToList <DownloadItemInfo>(),
}).ToList <Session>();
return(session);
}
}
catch (Exception ex)
{
//TODO: Implement Error Handling
return(new List <Session>());
}
}
