/// <summary>
/// Создание пустого экземпляра
/// </summary>
public MusicFile(MusicDB db, long id, string title, string comment, bool cycle)
{
DB = db;
ID = id;
this.title = title;
this.comment = comment;
this.cycle = cycle;
}
protected virtual void Dispose(bool disposing)
{
if (disposing)
{
title = null;
comment = null;
DB = null;
}
}
/// <summary>
/// Создание пустого экземпляра
/// </summary>
public Track(MusicDB db, long id, int desk, string number, string title, int file, int order)
{
DB = db;
ID = id;
this.desk = desk;
this.number = number;
this.title = title;
this.file = file;
this.order = order;
Sound = new MusicFile(db, file);
}
public static MusicFile CreateNewRecord(MusicDB db, string Title, string Comment, bool Cycle, MemoryStream Data)
{
if (db == null)
{
return(null);
}
string CycleS = Cycle ? "1" : "0";
db.Execute($"INSERT INTO `files` (`title`, `comment`, `cycle`) VALUES ('{Title}', '{Comment}', {CycleS});");
long ID = db.LastID;
db.ExecuteBLOB($"UPDATE `files` SET `file`=@BLOB WHERE `id`={ID};", Data);
return(new MusicFile(db, ID));
}
public MusicFile(MusicDB db, long id)
{
DB = db;
ID = id;
Update();
}
/// <summary>
/// Загрузка трека из БД по ID
/// </summary>
/// <param name="db">База данных</param>
/// <param name="id">Номер записи</param>
public Track(MusicDB db, long id)
{
DB = db;
ID = id;
Update();
}
