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