public static VideoScreenlist GetVideoScreenlist(VideoRecord _record)
{
var screenlist = new VideoScreenlist(_record);
using (var command = new SQLiteCommand())
{
command.CommandText = "Select [Id], [Vid], [Screenlist] From [VideoScreenlists] Where [Deleted] = 0 and [Vid] = @vid;";
command.Parameters.Add(new SQLiteParameter("@vid")
{
DbType = DbType.String, Value = _record.Vid
});
using (var reader = accesser.ExecuteReader(command))
{
if (!reader.HasRows)
{
return(screenlist);
}
else
{
reader.Read();
screenlist.Id = reader.GetInt32(0);
screenlist.Vid = reader.GetString(1);
screenlist.Screenlist = reader.GetBitmap(2);
}
}
}
return(screenlist);
}
public static VideoTagCollection GetVideoTags(VideoRecord _record)
{
var tags = new VideoTagCollection();
using (var command = new SQLiteCommand())
{
command.CommandText = "Select [Id], [Vid], [Text], [Intensity] From [VideoTags] Where [Deleted] = 0 and [Vid] = @vid;";
command.Parameters.Add(new SQLiteParameter("@vid")
{
DbType = DbType.String, Value = _record.Vid
});
using (var reader = accesser.ExecuteReader(command))
{
if (!reader.HasRows)
{
return(tags);
}
while (reader.Read())
{
VideoTag tag = new VideoTag(_record);
tag.Id = reader.GetInt32(0);
tag.Vid = reader.GetString(1);
tag.Text = reader.GetString(2);
tag.Intensity = reader.GetIntensity(3);
tags.Add(tag);
}
}
}
return(tags);
}
public static VideoRecordCollection GetVideoRecords(VideoSeries _series)
{
var records = new VideoRecordCollection();
using (var command = new SQLiteCommand())
{
command.CommandText = "Select [Vid],[File_Path],[File_Name],[File_Extention],[File_Size],[Alias],[Alt_Alias],[Series],[Alt_Series],[Icon],[Score],[Favorite],[Duration],[Intensity],[Last_playback],[Format],[Resolution],[Checksum],[Inserted] From [VideoRecords] Where [Deleted] = 0 and [Series] = @series;";
command.Parameters.Add(new SQLiteParameter("@series")
{
DbType = DbType.String, Value = _series.Series
});
using (var reader = accesser.ExecuteReader(command))
{
if (!reader.HasRows)
{
return(records);
}
while (reader.Read())
{
VideoRecord record = new VideoRecord();
record.Vid = reader.GetString(0);
record.File_Path = reader.GetString(1);
record.File_Name = reader.GetString(2);
record.File_Extention = reader.GetString(3);
record.File_Size = reader.GetInt64(4);
record.Alias = reader.GetString(5);
record.Alt_Alias = reader.GetNullableString(6);
record.Series = reader.GetString(7);
record.Alt_Series = reader.GetNullableString(8);
record.Icon = reader.GetBitmap(9);
record.Score = reader.GetInt32(10);
record.Favorite = reader.GetBoolean(11);
record.Duration = reader.GetTimeSpan(12);
record.Intensity = reader.GetNullableString(13);
record.Last_playback = reader.GetDateTime(14);
record.Format = reader.GetNullableString(15);
record.Resolution = reader.GetNullableString(16);
record.Checksum = reader.GetNullableString(17);
record.Inserted = reader.GetDateTime(18);
records.Add(record);
}
}
}
return(records);
}
public static bool CheckIfInPlaylist(VideoRecord _videoRecord)
{
using (var command = new SQLiteCommand())
{
command.CommandText = "Select [Pid] From [VideoPlaylist] Where [Vid] = @vid Limit 1;";
command.Parameters.Add(new SQLiteParameter("@vid")
{
DbType = DbType.String, Value = _videoRecord.Vid
});
using (var reader = accesser.ExecuteReader(command))
{
if (reader.HasRows)
{
return(true);
}
else
{
return(false);
}
}
}
}
public VideoScreenlist(VideoRecord _record)
{
this.VideoRecord = _record;
}
public VideoTag(VideoRecord _record)
{
this.VideoRecord = _record;
}