internal static List <VideoSetting> GetUserVideos(SqlConnection conn, SqlCommand query, SqlDataReader data, List <VideoSetting> userVideos, string userId) { // private const string SQL_SELECT_PERSON_VIDEOS = "Select * from latestsightings.dbo.people where (contributor = @contributor);"; ConfigureConnection(conn, query); userVideos = new List <VideoSetting>(); try { query.CommandText = SQL_SELECT_PERSON_VIDEOS; query.Parameters.Add("contributor", System.Data.SqlDbType.VarChar).Value = userId; conn.Open(); data = query.ExecuteReader(); if (data.HasRows) { while (data.Read()) { VideoSetting video = new VideoSetting(); video.Name = data["title"].ToString(); video.Alias = data["alias"].ToString(); video.RevSplit = data["revenueShare"].ToString(); video.Package = data["package"].ToString(); video.Uploaded = "Y"; if (data["videoStatus"].ToString() == "Accepted") { video.Accepted = "Yes"; } else if (data["videoStatus"].ToString() == "Declined") { video.Accepted = "No"; } else { video.Accepted = "--"; } userVideos.Add(video); } data.Close(); conn.Close(); } } catch { conn.Close(); } return(userVideos); }
internal static List <VideoSetting> GetUserVideos(SqlConnection conn, SqlCommand query, SqlDataReader data, List <VideoSetting> userVideos, string userId) { // private const string SQL_SELECT_PERSON_VIDEOS = "Select * from latestsightings.dbo.people where (contributor = @contributor);"; ConfigureConnection(conn, query); userVideos = new List <VideoSetting>(); try { query.CommandText = SQL_SELECT_PERSON_VIDEOS; query.Parameters.Add("contributor", System.Data.SqlDbType.VarChar).Value = userId; conn.Open(); data = query.ExecuteReader(); if (data.HasRows) { while (data.Read()) { VideoSetting video = new VideoSetting(); video.Name = data["title"].ToString(); video.Alias = data["alias"].ToString(); video.RevSplit = data["revenueShare"].ToString(); video.Uploaded = "Y"; video.created = Convert.ToDateTime(data["created"].ToString()); if (data["package"] != System.DBNull.Value) { video.Package = data["package"].ToString(); if (String.IsNullOrEmpty(video.Package)) { video.Package = "Not Accepted Yet"; } } else { video.Package = "Not Accepted Yet"; } userVideos.Add(video); } data.Close(); conn.Close(); } } catch { conn.Close(); } return(userVideos.OrderByDescending(x => x.created).ToList()); }