/// <summary>
/// Get All Video reels
/// </summary>
/// <returns>collection of video reels</returns>
public IList <VideoReel> GetVideoReels()
{
IList <VideoReel> videoReels;
var database = ApplicationDatabase.Create();
using (var command = database.GetStoredProcCommand(Constants.Procedure_GetAllVideoReels))
{
videoReels = this.Populate(database.ExecuteDataSet(command));
}
return(videoReels);
}
/// <summary>
/// Get All Clips
/// </summary>
/// <param name="clipId">Clip Id</param>
/// <returns>Video Clip details</returns>
public VideoClip GetClipDetails(int clipId)
{
IList <VideoClip> videoClips;
var database = ApplicationDatabase.Create();
using (var command = database.GetStoredProcCommand(Constants.Procedure_GetVideoClipById))
{
database.AddInParameter(command, Constants.Parameter_VideoClipId, DbType.Int32, clipId);
videoClips = this.Populate(database.ExecuteDataSet(command));
}
return(videoClips[0]);
}
/// <summary>
/// Get a Video reel
/// </summary>
/// <param name="reelId">
/// The reel Id.
/// </param>
/// <returns>
/// video reel
/// </returns>
public VideoReel GetVideoReel(int reelId)
{
IList <VideoReel> videoReels;
var database = ApplicationDatabase.Create();
using (var command = database.GetStoredProcCommand(Constants.Procedure_GetVideoReel))
{
database.AddInParameter(command, Constants.Parameter_VideoReelId, DbType.Int32, reelId);
videoReels = this.Populate(database.ExecuteDataSet(command));
}
return(videoReels.Count > 0 ? videoReels[0] : null);
}
/// <summary>
/// Save a video reel Name
/// </summary>
/// <param name="videoReel">video reel</param>
public bool SaveVideoReel(VideoReel videoReel)
{
var database = ApplicationDatabase.Create();
try
{
using (var command = database.GetStoredProcCommand(Constants.Procedure_SaveVideoReel))
{
database.AddInParameter(command, Constants.Parameter_VideoReelName, DbType.String, videoReel.Name);
database.AddInParameter(command, Constants.Parameter_VideoReelId, DbType.Int32, videoReel.Id);
database.ExecuteNonQuery(command);
return(true);
}
}
catch
{
return(false);
}
}
/// <summary>
/// Remove a clip from a reel
/// </summary>
/// <param name="reel">reel details</param>
/// <param name="clip">clip details</param>
/// <returns>true/ false </returns>
public bool RemoveClipFromReel(VideoReel reel, VideoClip clip)
{
var database = ApplicationDatabase.Create();
try
{
using (var command = database.GetStoredProcCommand(Constants.Procedure_RemoveClipFromReel))
{
database.AddInParameter(command, Constants.Parameter_VideoReelId, DbType.Int32, reel.Id);
database.AddInParameter(command, Constants.Parameter_VideoClipId, DbType.Int32, clip.Id);
database.ExecuteNonQuery(command);
return(true);
}
}
catch
{
return(false);
}
}
