public System.Guid AddMusician(MusicGroupsFolder.Musician musician) // Pridani do databaze hudebnika
{
Musician tmpMusician = new Musician()
{
MusicianName = musician.Name,
MusicianSurname = musician.Surname,
MusicianDateBirth = musician.DateOfBirth,
MusicianInstrument = musician.MusicianInstrument,
MusicianNationality = musician.Nationality,
MusicianSex = musician.Sex
};
try
{
_database.Musicians.InsertOnSubmit(tmpMusician);
_database.SubmitChanges();
}
catch (Exception e)
{
ErrorString = e.Message;
MessageBox.Show("Nepodařilo se přidat hudebníka do databáze!\n\n" + ErrorString);
}
return(tmpMusician.MusicianID);
}
private Dictionary <string, MusicGroupsFolder.Musician> LoadMusicianTable() // Nahrani tabulky Hudebniku do Dictionary
{
Dictionary <string, MusicGroupsFolder.Musician> dictionary = new Dictionary <string, MusicGroupsFolder.Musician>();
try
{
using (StreamReader reader = File.OpenText(_savingPath + "MusicianTable.csv"))
{
string line = null;
while ((line = reader.ReadLine()) != null)
{
var data = line.Split(';');
if (data.Length == 7)
{
string name = data[1];
string surname = data[2];
DateTime born = ConvertStringDateToDateTime(data[3]);
string instrument = data[4];
string country = data[5];
string sex = data[6];
MusicGroupsFolder.Musician tmpGroup = new MusicGroupsFolder.Musician(name, surname, born, instrument, country, sex);
dictionary.Add(data[0], tmpGroup);
}
}
}
}
catch (Exception e)
{
ErrorString = e.Message;
MessageBox.Show("Nepodařilo se nahrat tabulku hudebníků!\n\n" + ErrorString);
}
return(dictionary);
}
public void RemoveMusician(Musician musician)
{
_musicians.Remove(musician);
}
public void AddMusician(Musician musician)
{
_musicians.Add(musician);
}
