private static Response HomeResponse(HomeRequest HomeRequest) { //request SQL DataBase DatabaseManager database = new DatabaseManager(); (MySqlDataReader reader, var Connection) = database.RunQuery("SELECT duration, thumbnail, title, videoid FROM video_details ORDER BY lastupdatedon DESC LIMIT 20"); if (reader != null) { Data.HomePageResponse res = new Data.HomePageResponse(); res.VideoList = new List <VideoMini>(); while (reader.Read()) { res.VideoList.Add(new VideoMini() { Duration = reader.GetString(0), Thumbnail = reader.GetString(1), Title = reader.GetString(2), VideoId = reader.GetString(3) }); } Connection.Close(); return(new Response() { Type = ResponseType.Home, Content = res, Status = "OK" }); } Connection.Close(); return(new Response() { Content = null, Type = ResponseType.Home, Status = "FAIL" }); }
private static Response VideoDetailsResponse(VideoDetails videoDetails) { DatabaseManager database = new DatabaseManager(); (MySqlDataReader reader, var Connection) = database.RunQuery($"SELECT video_details.videoid, video_details.path, video_details.thumbnail, video_details.title, video_details.description," + $" video_details.width, video_details.height, video_details.duration, video_details.authorid, account_data.fullname, account_data.profileimage, course_details.coursename, video_details.courseid, " + $"video_details.lastupdatedon, video_details.likes, video_details.dislikes, course_details.rating FROM video_details INNER JOIN course_details INNER JOIN account_data WHERE videoid='{videoDetails.VideoID}' " + $"AND account_data.username=video_details.authorid AND course_details.courseid=video_details.courseid;"); if (reader != null) { Data.HomePageResponse res = new Data.HomePageResponse(); res.VideoList = new List <VideoMini>(); reader.Read(); Video video = new Video() { VideoID = reader.GetString(0), Path = reader.GetString(1), Thumbnail = reader.GetString(2), Title = reader.GetString(3), Description = reader.GetString(4), Width = int.Parse(reader.GetString(5)), Height = int.Parse(reader.GetString(6)), Duration = TimeSpan.Parse(reader.GetString(7)), AuthorId = reader.GetString(8), AuthorName = reader.GetString(9), AuthorImage = reader.GetString(10), Course = reader.GetString(11), CourseID = reader.GetString(12), LastUpdatedOn = DateTime.Parse(reader.GetString(13)), Likes = int.Parse(reader.GetString(14)), Dislikes = int.Parse(reader.GetString(15)), CommentList = new List <Comment>(), Tags = new List <string>(), CourseRating = float.Parse(reader.GetString(16)), }; Connection.Close(); (reader, Connection) = database.RunQuery($"SELECT * FROM favorites WHERE userid='{videoDetails.UserID}' AND videoid='{videoDetails.VideoID}'"); if (reader != null && reader.HasRows) { video.IsFavorite = true; } Connection.Close(); (reader, Connection) = database.RunQuery($"SELECT comments.userid, comments.videoid, account_data.fullname, account_data.profileimage, comments.content, comments.likes, comments.dislikes, comments.date, comments.uid FROM comments INNER JOIN account_data WHERE videoid='{video.VideoID}' AND account_data.username=comments.userid ORDER BY date DESC "); if (reader != null) { while (reader.Read()) { video.CommentList.Add(new Comment() { UserId = reader.GetString(0), VideoID = reader.GetString(1), Username = reader.GetString(2), Thumbnail = reader.GetString(3), Content = reader.GetString(4), Likes = int.Parse(reader.GetString(5)), Dislikes = int.Parse(reader.GetString(6)), Date = DateTime.Parse(reader.GetString(7)), Uid = reader.GetString(8) } ); } } Connection.Close(); (reader, Connection) = database.RunQuery($"SELECT tag from tag_details WHERE videoid = '{videoDetails.VideoID}'"); if (reader != null) { while (reader.Read()) { video.Tags.Add(reader.GetString(0)); } } Connection.Close(); return(new Response() { Type = ResponseType.VideoDetails, Content = video, Status = "OK" }); } Connection.Close(); return(new Response() { Type = ResponseType.VideoDetails, Content = null, Status = "FAIL" }); }