private List <Channel> GetListChannel() { var db = new youtubeEntities(); var lstChannel = db.Database.SqlQuery <Channel>("yt_Get_Channel").ToList(); return(lstChannel); }
private int SaveVideo(PlaylistItem playlistItem) { var db = new youtubeEntities(); ObjectParameter objParam = new ObjectParameter("ReturnId", typeof(int)); var videoid = db.yt_Save_Video( playlistItem.Snippet.ChannelId, playlistItem.Snippet.ResourceId.VideoId, playlistItem.Snippet.Title, playlistItem.Snippet.Thumbnails.Default__.Url, objParam); return(Convert.ToInt32(objParam.Value)); }
private int SaveVideoNumberCount(int videoid, Google.Apis.YouTube.v3.Data.Video video) { var db = new youtubeEntities(); ObjectParameter objParam = new ObjectParameter("Id", typeof(int)); var videoNumberCountId = db.yt_Save_Video_NumberCount( videoid, ParseData.GetLong(video.Statistics.ViewCount), ParseData.GetLong(video.Statistics.LikeCount), ParseData.GetLong(video.Statistics.DislikeCount), ParseData.GetLong(video.Statistics.FavoriteCount), ParseData.GetLong(video.Statistics.CommentCount) , objParam); return(Convert.ToInt32(objParam.Value)); }