public void LoadData(Guid key)
{
BasicDatasUpdated = false;
db.DatabasePath = PfadClass.Instance().DatabasePfad;
var data = db.GetByID(key);
piclist = new PictureListClass();
var SFiles = new List <DBFiles>();
actData = data[0];
DataToEdit();
EditToData();
axWMP.Hide();
/*
* btnPause.Enabled = false;
* btnStopPlay.Enabled = false;
* btnPlay.Enabled = false;
* btnContinue.Enabled = false;
*/
foreach (var actFl in actData.SongFiles)
{
if (GlobalFunctionsClass.Instance().SongType(actFl.FilesName) == eDBSongFileType.songimage)
{
SFiles.Add(actFl);
}
else if (GlobalFunctionsClass.Instance().SongType(actFl.FilesName) == eDBSongFileType.mp3file)
{
AudioFile = actFl;
if (AudioFile != null)
{
/*
* btnPause.Enabled = true;
* btnStopPlay.Enabled = true;
* btnPlay.Enabled = true;
* btnContinue.Enabled = true;
*/
axWMP.Show();
PlaySongWP();
}
}
}
SFiles.Sort();
actData.SongFiles = SFiles.ToArray();
int n = 0;
foreach (var fls in actData.SongFiles)
{
string guid = fls.FilesID.ToString();
var files = db.GetImage(guid);
piclist.AddNewPicture(pnlSheets, db.ActMemoryStream);
n++;
}
pbShownPages.Minimum = 0;
pbShownPages.Maximum = (n <= 1) ? 1 : n - 1;
pbShownPages.Value = (ActPicStart + ShowCount > pbShownPages.Maximum) ? pbShownPages.Maximum : ActPicStart + ShowCount;
}
static public PfadClass Instance()
{
if (instance == null)
{
lock (_lock_this)
{
instance = new PfadClass();
}
}
return(instance);
}
private void hsChangeDB_Click(object sender, EventArgs e)
{
FileInfo fi = new FileInfo(db.DatabasePath);
ofdDB.InitialDirectory = fi.DirectoryName;
if (ofdDB.ShowDialog() == DialogResult.OK)
{
nf.AddToINFO($@"Change Database from {PfadClass.Instance().DatabasePfad} to {ofdDB.FileName}");
PfadClass.Instance().DatabasePfad = ofdDB.FileName;
db.DatabasePath = PfadClass.Instance().DatabasePfad;
}
}
public void GetWriteTemp(DBClass db, Guid key, string filekey, string filename, eDBSongFileType filetype)
{
db.DatabasePath = PfadClass.Instance().DatabasePfad;
var data = db.GetByID(key);
Notes actData = data[0];
foreach (var fls in actData.SongFiles)
{
string guid = fls.FilesID.ToString();
if (guid == filekey.ToString())
{
db.GetAndWriteMemoryStreamToFile(guid, filename);
}
}
}
public bool Deserialize(string FileName)
{
bool ok;
XmlReader reader;
try
{
XmlSerializer serializer = new XmlSerializer(typeof(PfadClass));
Stream fs = new FileStream(FileName, FileMode.Open);
reader = new XmlTextReader(fs);
PfadClass PF = (PfadClass)serializer.Deserialize(reader);
reader.Close();
this.XMLName = FileName;
this.LastUserID = PF.LastUserID;
this.DatabasePfad = PF.DatabasePfad;
this.ExportPfad = PF.ExportPfad;
this.DBUsername = PF.DBUsername;
this.MuseScoreExecute = PF.MuseScoreExecute;
this.MuseScoreTemp = PF.MuseScoreTemp;
this.PDFExecute = PF.PDFExecute;
this.TXTExecute = PF.TXTExecute;
this.IMAGEExecute = PF.IMAGEExecute;
this.MP3Execute = PF.MP3Execute;
TestParams();
ok = true;
}
catch (Exception ex)
{
ok = false;
MessageBox.Show(FileName + " -> " + ex.Message, "Grundparameter konnten nicht geladen werden.", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(ok);
}
finally
{
}
return(ok);
}
private void hsExport_Click(object sender, EventArgs e)
{
var dbm = new DBMaintain();
dbm.nf.Register4Info(InfoRaised);
dbm.nf.Register4Error(ErrorRaised);
DirectoryInfo di = new DirectoryInfo(PfadClass.Instance().ExportPfad);
FileInfo[] fii = di.GetFiles();
if (fii.Length > 0)
{
if (MessageBox.Show("Sollen alle ´Daten im Exportpfad gelöscht werden ?", "Exportpfad Daten vorhanden", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
foreach (FileInfo f in fii)
{
try
{
f.Delete();
nf.AddToINFO($@"Delete file:{f.FullName}");
}
catch
{
}
}
}
}
if (di.Exists)
{
FileInfo fi = new FileInfo(db.DatabasePath);
dbm.CopyDB(db.DatabasePath, $@"{fi.DirectoryName}\NewNotesData_{DateTime.Now.Ticks / 100000}.db", di.FullName);
}
else
{
MessageBox.Show($@"Der Exportpfad {PfadClass.Instance().ExportPfad} exitstiert nicht.{Environment.NewLine}Datenbank Kopie kann nicht erstellt werden.");
}
}
public PictureClass GetSongFileImage(Guid key, string filekey)
{
db.DatabasePath = PfadClass.Instance().DatabasePfad;
var data = db.GetByID(key);
int n = 0;
piclist = new PictureListClass();
actData = data[0];
foreach (var fls in actData.SongFiles)
{
string guid = fls.FilesID.ToString();
if (guid == filekey.ToString())
{
var files = db.GetImage(guid);
piclist.AddNewPicture(pnlSheets, db.ActMemoryStream);
return(piclist.pictures[0]);
}
n++;
}
return(null);
}
