private async void buttonStart_Click(object sender, RoutedEventArgs e)
{
statusText.Content = "";
buttonStart.IsEnabled = false;
try
{
if (checkboxFullpathfromdb.IsChecked == true)
{
statusText.Content = "write Database fullpath list...";
DataGetSet dataGetSet = new DataGetSet();
await dataGetSet.CreareNewDbFullathListAsync();
dataGetSet = null;
statusText.Content = "finish";
}
if (checkboxFullpathfromfile.IsChecked == true)
{
statusText.Content = "write File fullpath list...";
DataGetSet dataGetSet = new DataGetSet();
await dataGetSet.CreateNewFileListAsync();
dataGetSet = null;
statusText.Content = "finish";
}
buttonStart.IsEnabled = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
buttonStart.IsEnabled = true;
}
}
private async Task FillCollectionsAsync()
{
List <string> list = await DataGetSet.GetGenresAsync();
list.Insert(0, "NA");
_genres = new ObservableCollection <string>(list);
list = await DataGetSet.GetCatalogsAsync();
list.Insert(0, "NA");
_catalogs = new ObservableCollection <string>(list);
list = await DataGetSet.GetMediaAsync();
list.Insert(0, "NA");
_medias = new ObservableCollection <string>(list);
list = new List <string>(); // await DataGetSet.GetInterpretersAsync();
list.Add("NA");
_artists = new ObservableCollection <string>(list);
list = new List <string>(); // await DataGetSet.GetAlbumsAsync();
list.Add("NA");
_albums = new ObservableCollection <string>(list);
}
private void FillTables()
{
using (var context = new MyJukeboxEntities())
{
Label label;
TextBox textBox;
var settings = DataGetSet.GetParameters();
foreach (var setting in settings)
{
label = new Label();
label.Name = $"label{setting.ID}";
label.ForeColor = System.Drawing.Color.White;
label.AutoSize = true;
label.Anchor = AnchorStyles.Left;
label.Text = $"{setting.Name}";
tableLayoutPanel.Controls.Add(label);
textBox = new AutoSizeTextBox();
textBox.Name = $"{setting.Name}";
textBox.AutoSize = true;
textBox.Text = $"{(setting.Value.Length == 0 ? " " : setting.Value)}";
if (setting.Editable == false)
{
textBox.Enabled = false;
}
tableLayoutPanel.Controls.Add(textBox);
}
}
}
private void dgmenuitemSendTo_Click(object sender, RoutedEventArgs e)
{
var rowlist = (vSongs)datagrid.SelectedItem;
var titelID = rowlist.ID;
var playlistID = 12;
DataGetSet.AddSongToPlaylist(Convert.ToInt32(titelID), playlistID);
}
private void dgmenuitemCopyLine_Click(object sender, RoutedEventArgs e)
{
var rowlist = (vSongs)datagrid.SelectedItem;
string songFields = DataGetSet.GetSongFieldValuesByID(rowlist.ID);
Clipboard.Clear();
Clipboard.SetText(songFields);
}
private void CopyDataRowExecuted(object sender, ExecutedRoutedEventArgs e)
{
var rowlist = (vSongs)datagrid.SelectedItem;
string songFields = DataGetSet.GetSongFieldValuesByID(rowlist.ID);
Clipboard.Clear();
Clipboard.SetText(songFields);
}
private void LoadData()
{
_dataLoaded = false;
DataGetSet.Datasource = DataGetSet.DataSourceEnum.Songs;
var songs = DataGetSet.GetSongs("Annette", "VHS = Burning Boots 1998");
datagrid.ItemsSource = songs;
_dataLoaded = true;
}
private void LoadData(string catalog, string album)
{
_dataLoaded = false;
var songs = DataGetSet.GetSongs(catalog, album);
datagrid.ItemsSource = songs;
_dataLoaded = true;
}
private void buttonSave_Click(object sender, EventArgs e)
{
if (IsSongChanged == true)
{
mp3Record = new MP3Record();
mp3Record.Genre = comboBoxGenre.Text;
mp3Record.Catalog = comboBoxCatalog.Text;
mp3Record.Album = textBoxAlbum.Text;
mp3Record.Artist = textBoxInterpret.Text;
mp3Record.Titel = textBoxTitel.Text;
mp3Record.Path = textBoxPath.Text;
mp3Record.FileName = textBoxFilename.Text;
bool result = DataGetSet.EditSaveSongChanges(_id, mp3Record);
}
if (IsFileInfoChanged == true)
{
mp3Record = new MP3Record();
mp3Record.FileSize = Convert.ToInt32(textBoxFilesize.Text);
mp3Record.FileDate = Convert.ToDateTime(textBoxFiledate.Text);
mp3Record.Duration = TimeSpan.Parse(textBoxDuration.Text);
bool result = DataGetSet.EditSaveFileinfoChanges(_id, mp3Record);
}
if (IsSongInfoChanged == true)
{
mp3Record = new MP3Record();
mp3Record.IsSample = chechBoxSampler.Checked;
mp3Record.Error = checkBoxError.Checked;
mp3Record.Hide = checkBoxHide.Checked;
mp3Record.Comment = textboxComment.Text;
mp3Record.Media = Convert.ToInt32(textBoxMedia.Text);
}
#region Zeuch
//if (textBoxTitel.Text != (string)textBoxTitel.Tag)
//{
//}
//foreach( c In Me)
//{
// if ( c.BackColor = +HC0C0FF )
// {
// // Textfeld wurde bearbeitet;
// if ( IsFieldChanged(c) )
// {
// SaveChanges c;
// }
// }
//}
#endregion
}
private void Import(bool isSampler)
{
int recordsAffected = 0;
buttonImport.IsEnabled = false;
DateTime t1 = DateTime.Now;
statusbarStart.Content = t1.ToString("HH:mm:ss");
statusbarDauer.Content = "";
statusbarProgress.Visibility = Visibility.Visible;
if (checkboxTestimport.IsChecked == true)
{
var result = DataGetSet.TruncateTestTables();
if (result == false)
{
return;
}
}
for (int i = 0; i <= comboboxAlbum.Items.Count - 1; i++)
{
comboboxAlbum.SelectedIndex = i;
if (isSampler == false && _ignores.Contains(comboboxAlbum.Text))
{
continue;
}
List <MP3Record> mp3List = mp3Records(_fileDetails, false); // isSampler = false
// save records
if ((bool)checkboxTestimport.IsChecked == true)
{
recordsAffected += DataGetSet.SaveTestRecord(mp3List);
}
else
{
recordsAffected += DataGetSet.SaveRecord(mp3List);
}
}
DateTime t2 = DateTime.Now;
statusbarProgress.Visibility = Visibility.Hidden;
statusbarDauer.Content = (t2 - t1).Milliseconds.ToString() + " ms";
labelSuccess.Content = $"{recordsAffected}";
labelFailed.Content = $"{_fileDetails.Count - recordsAffected}";
checkboxTestimport.IsChecked = false;
buttonImport.IsEnabled = true;
}
//bool IsFieldChanged(Control c)
//{
// //Dim strValueNew$, strValueOld$, strFieldName$, strCtype
// //bool IsFieldChanged = false;
// //strCtype = TypeName(Contr)
// //Debug.Print strCtype
// //Select Case strCtype
// // Case "TextBox"
// // strValueOld = Contr.Tag
// // strValueNew = Contr.Text
// // Case "CheckBox"
// // strValueOld = Contr.Tag
// // strValueNew = Contr.Value
// // Case Else
// //End Select
// //If strValueOld = strValueNew Then
// // IsFieldChanged = False
// //Else
// return true;
// //End If
//}
#endregion
#region Methods
private async Task FillFormAsync()
{
List <string> record = null;
try
{
// fill combo genres
List <string> genres = await DataGetSet.GetGenresFullAsync();
foreach (string genre in genres)
{
comboBoxGenre.Items.Add(genre);
}
// fill combo catalogs
List <string> catalogs = await DataGetSet.GetCatalogsAsync();
foreach (string catalog in catalogs)
{
comboBoxCatalog.Items.Add(catalog);
}
record = DataGetSet.GetSongRecord(_id);
textBoxID.Text = record[0];
comboBoxGenre.Text = record[1];
comboBoxCatalog.Text = record[2];
textBoxAlbum.Text = record[3];
textBoxInterpret.Text = record[4];
textBoxTitel.Text = record[5];
textBoxPath.Text = record[6];
textBoxFilename.Text = record[7];
record = DataGetSet.GetFileRecord(_id);
textBoxFilesize.Text = record[0];
textBoxFiledate.Text = record[1];
textBoxDuration.Text = record[2];
record = DataGetSet.GetInfoRecord(_id);
textBoxBeat.Text = record[0];
textboxComment.Text = record[1];
textBoxMedia.Text = record[2];
textBoxPlayed.Text = record[3];
textBoxRating.Text = record[4];
chechBoxSampler.Text = record[5];
checkBoxError.Checked = Convert.ToBoolean(record[6]);
}
catch
{ }
_formloaded = true;
}
private void datagridFilelist_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
{
if (datagridFilelist.Items.Count > 0)
{
int index = datagridFilelist.SelectedIndex;
comboboxGenre.Text = DataGetSet.GetGenre(songRecords[index].Genre);
comboboxCatalog.Text = DataGetSet.GetCatalog(songRecords[index].Catalog);
comboboxMedia.Text = DataGetSet.GetMedia(songRecords[index].Media);
comboboxAlbum.Text = songRecords[index].Album;
comboboxArtist.Text = songRecords[index].Artist;
}
}
private void FillDatagridByTabPlaylist(int playlistID)
{
var results = DataGetSet.GetPlaylistEntries(playlistID);
if (results != null)
{
DataGetSet.Datasource = DataGetSet.DataSourceEnum.Playlist;
datagrid.ItemsSource = results;
_dataLoaded = true;
if (datagrid.Items.Count > 1)
{
datagrid.SelectedIndex = 1;
}
}
}
private void ImportStart()
{
int catalogID = -1;
labelSuccess.Content = "0";
labelFailed.Content = "0";
if (datagridFilelist.Items.Count == 0)
{
return;
}
if ((bool)labelGenre.Tag == false)
{
var result = MessageBox.Show($"Missing genre '{comboboxGenre.Text}' in table tGenre!\n\n" +
"You want create this genre?", "New Genre", MessageBoxButton.YesNo, MessageBoxImage.Exclamation);
if (result == MessageBoxResult.No)
{
return;
}
else
{
catalogID = DataGetSet.CreateGenre(comboboxGenre.Text);
}
}
if ((bool)labelCatalog.Tag == false)
{
var result = MessageBox.Show($"Missing catalog '{comboboxCatalog.Text}' in table tCatalogs!\n\n" +
"You want create this catalog?", "New Catalog", MessageBoxButton.YesNo, MessageBoxImage.Exclamation);
if (result == MessageBoxResult.No)
{
return;
}
catalogID = DataGetSet.CreateCatalog(comboboxCatalog.Text);
if (catalogID == -1)
{
return;
}
}
Import((bool)checkboxSampler.IsChecked);
}
private void buttonSave_Click(object sender, EventArgs e)
{
List <Setting> settings = new List <Setting>();
foreach (Control c in tableLayoutPanel.Controls)
{
string control = c.GetType().Name;
if (control == "AutoSizeTextBox")
{
settings.Add(new Setting {
Name = c.Name, Value = c.Text
});
}
}
DataGetSet.SaveParameters(settings);
}
private void Import2(bool isSampler)
{
int recordsAffected = 0;
buttonImport.IsEnabled = false;
DateTime t1 = DateTime.Now;
statusbarStart.Content = t1.ToString("HH:mm:ss");
statusbarDauer.Content = "";
statusbarProgress.Visibility = Visibility.Visible;
if (checkboxTestimport.IsChecked == true)
{
var result = DataGetSet.TruncateTestTables();
if (result == false)
{
// Todo write log
return;
}
}
List <MP3Record> mp3List;
foreach (var song in songRecords)
{
mp3List = new List <MP3Record>();
mp3List.Add(new MP3Record()
{
Album = song.Album,
Artist = song.Artist,
Catalog = song.Catalog,
FileName = song.FileName,
Genre = song.Genre,
Media = song.Media,
MD5 = song.MD5,
Path = song.Path,
Titel = song.Titel,
FileDate = song.FileDate,
FileSize = song.FileSize,
IsSample = (bool)checkboxSampler.IsChecked
}
);
// save records
if ((bool)checkboxTestimport.IsChecked == true)
{
recordsAffected += DataGetSet.SaveTestRecord(mp3List);
}
else
{
recordsAffected += DataGetSet.SaveRecord(mp3List);
}
}
DateTime t2 = DateTime.Now;
statusbarProgress.Visibility = Visibility.Hidden;
statusbarDauer.Content = (t2 - t1).Milliseconds.ToString() + " ms";
labelSuccess.Content = $"{recordsAffected}";
labelFailed.Content = $"{songRecords.Count - recordsAffected}";
checkboxTestimport.IsChecked = false;
buttonImport.IsEnabled = true;
}
private void GetTokens(string fullName, string extension)
{
string genre = "", catalog = "", media = "", artist, album = "", title, file, path, t1;
int l;
try
{
#region Path
l = fullName.LastIndexOf("\\");
path = fullName.Substring(0, l);
#endregion
#region File
string container = Helpers.GetContainer(fullName);
string[] ar = container.Split('\\');
file = ar[ar.Length - 1];
#endregion
#region Album
if (ar[4] == "_Various Artists")
{
album = ar[5];
}
else
{
album = ar[5];
}
#endregion
#region Artist
t1 = $" - ";
l = l = file.IndexOf(t1);
artist = file.Substring(0, l);
#endregion
#region Title
t1 = $" - ";
l = l = file.IndexOf(t1);
title = file.Substring(l + t1.Length).Replace(extension, "");
#endregion
#region Genre
var genreList = GenreList.Instance;
var genres = genreList.Get();
foreach (var g in genres)
{
if (fullName.IndexOf(g) > -1)
{
genre = g;
break;
}
}
#endregion
#region Catalog
var catalogList = CatalogList.Instance;
var catalogs = catalogList.Get();
foreach (var c in catalogs)
{
if (fullName.IndexOf(c) > -1)
{
catalog = c;
break;
}
}
#endregion
#region Media
var mediaList = MediaList.Instance;
var medias = mediaList.Get();
foreach (var m in medias)
{
if (fullName.IndexOf($"\\{m}\\") > -1)
{
media = m;
break;
}
}
#endregion
FileInfo fi = new FileInfo(fullName);
SongRecord songRecord = new SongRecord()
{
Album = album,
Artist = artist,
Catalog = DataGetSet.GetCatalogId(catalog),
FileName = file,
Genre = DataGetSet.GetGenreId(genre),
Media = DataGetSet.GetMediaId(media),
Path = path,
Titel = title,
MD5 = Helpers.MD5($"{path}\\{file}"),
FileDate = File.GetLastWriteTime(fullName),
FileSize = Convert.ToInt32(fi.Length),
};
songRecords.Add(songRecord);
}
catch (Exception ex)
{
Debug.Print(ex.Message);
Debug.Print($"{fullName}");
}
}
//
//miSendto.Items.Add(miFilea);
//MenuItem miOpen = new MenuItem();
//miOpen.Header = "Open";
//miOpen.Click += new RoutedEventHandler(this.menuitemFileOpen_Click);
//miSendto.Items.Add(miOpen);
//MenuItem miOpen1 = new MenuItem();
//miOpen1.Header = "Recently Opened";
//miOpen.Items.Add(miOpen1);
//MenuItem miOpen1a = new MenuItem();
//miOpen1a.Header = "Text.xaml";
//miOpen1.Items.Add(miOpen1a);
//contextmenu.Items.Add(miSendto);
//datagrid.ContextMenu = contextmenu;
#endregion
private void DatagridContextmenuCreate()
{
var comboboxitem = combobox.SelectedItem as ComboBoxItem;
string selectedItem = comboboxitem.Content.ToString();
Debug.Print(selectedItem);
var context = new MyJukeboxEntities();
var list = DataGetSet.GetPlaylists();
ContextMenu contextmenu = (ContextMenu)this.FindResource("contextmenuDatagrid");
// add menu item to Mainmenu
MenuItem miFile = new MenuItem();
miFile.Header = "File";
MenuItem miFileNew = new MenuItem();
miFileNew.Header = "New";
miFileNew.Click += new RoutedEventHandler(this.DatagridContextMenuitemFileNew_Click);
miFile.Items.Add(miFileNew);
contextmenu.Items.Add(miFile);
// add menu items to existing menu
MenuItem miSendto = (MenuItem)contextmenu.Items[0];
miSendto.Items.Clear();
if (selectedItem == "Audio")
{
miSendto.Header = "Send to";
foreach (var playlist in list)
{
MenuItem menuItem = new MenuItem();
menuItem.Header = playlist.Name;
menuItem.Tag = playlist.ID;
menuItem.Click += new RoutedEventHandler(this.contextmenuDatagridSendtoPlaylist_Click);
miSendto.Items.Add(menuItem);
}
// remove menuitem 'remove'
MenuItem mi = (MenuItem)contextmenu.Items[1];
Debug.Print(mi.Header.ToString());
contextmenu.Items.Remove(mi);
MenuItem miRemove = new MenuItem();
miRemove.Header = "Remove";
miRemove.Click += new RoutedEventHandler(this.contextmenuDatagridRemoveFromAudio_Click);
contextmenu.Items.Insert(1, miRemove);
}
if (selectedItem == "Playlist")
{
miSendto.Header = "Move to";
foreach (var playlist in list)
{
MenuItem menuItem = new MenuItem();
menuItem.Header = playlist.Name;
menuItem.Tag = playlist.ID;
menuItem.Click += new RoutedEventHandler(this.contextmenuDatagridMovetoPlaylist_Click);
miSendto.Items.Add(menuItem);
}
// remove menuitem 'remove'
MenuItem mi = (MenuItem)contextmenu.Items[1];
Debug.Print(mi.Header.ToString());
contextmenu.Items.Remove(mi);
MenuItem miRemove = new MenuItem();
miRemove.Header = "Remove";
miRemove.Click += new RoutedEventHandler(this.contextmenuDatagridRemoveFromPlaylist_Click);
contextmenu.Items.Insert(1, miRemove);
}
}
