public static List <MediaSample> GetSamples(long titleId, MediaSampleKind kind) { using (var db = DB.GetDatabase()) { var res = db.Fetch <MediaSample>("SELECT * FROM MEDIA_SAMPLE WHERE TITLE_ID = @0 and MEDIA_KIND = @1", titleId, kind); return(res); } }
public static MediaSample AddSample(byte[] data, long titleId, MediaSampleKind kind, string extension) { if (data == null) { throw new ArgumentNullException("data", "Sample data can't be null"); } var ms = new MediaSample { TitleId = titleId, Extension = extension, MediaKind = kind }; using (var db = DB.GetDatabase()) { db.Insert(ms); } string fn = GetSampleFileName(ms); File.WriteAllBytes(fn, data); return(ms); }