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