public BandVM()
{
Bands = Band.GetBands();
Genres = Genre.GetGenres();
SelectedBand = new Band();
SelectedBandGenres = new ObservableCollection<BandGenre>();
AddGenre(this);
Enabled = true;
ShowEdit = "Hidden";
ShowCancel = "Hidden";
ShowSave = "Visible";
}
private void DeleteBand(BandVM bandvm)
{
if (SelectedBand == null) return;
// Delete the previous genres
foreach (BandGenre bg in _oldBandGenres)
{
BandGenre.DeleteBandGenre(bg);
}
Band.DeleteBand(SelectedBand);
SelectedBand = new Band();
Enabled = true;
ShowEdit = "Hidden";
ShowCancel = "Hidden";
ShowSave = "Visible";
}
private void SelectionChanged(BandVM bandvm)
{
if (SelectedBand == null) return;
if (ShowCancel == "Visible") CancelUpdateBand(this);
_oldBand = SelectedBand.Copy();
SelectedBandGenres = BandGenre.GetBandGenres(SelectedBand.ID);
_oldBandGenres = BandGenre.GetBandGenres(SelectedBand.ID);
bandvm.ShowEdit = "Visible";
bandvm.ShowCancel = "Hidden";
bandvm.ShowSave = "Hidden";
Enabled = false;
}
private void AddBand(BandVM bandvm)
{
SelectedBand = new Band();
SelectedBandGenres = new ObservableCollection<BandGenre>();
AddGenre(this);
_oldBand = null;
bandvm.ShowEdit = "Hidden";
bandvm.ShowCancel = "Visible";
bandvm.ShowSave = "Visible";
bandvm.Enabled = true;
}
public static void UpdateBand(Band band)
{
// If _Band is null, create the Observable Collection
if (_Bands == null) GetBands();
try
{
// Update db
DbParameter param1 = Database.AddParameter("@id", band.ID);
DbParameter param2 = Database.AddParameter("@name", band.Name);
DbParameter param3 = Database.AddParameter("@twitter", band.Twitter);
DbParameter param4 = Database.AddParameter("@facebook", band.Facebook);
DbParameter param5 = Database.AddParameter("@picture", band.Picture);
DbParameter param6 = Database.AddParameter("@description", band.Description);
int affectedRows = Database.ModifyData("UPDATE band SET Name = @name, Twitter = @twitter, Facebook = @facebook, Picture = @picture, Description = @description WHERE id = @id", param1, param2, param3, param4, param5, param6);
if (affectedRows == 0) return;
// Update _Band
_Bands[GetIndexByID(band.ID)] = band;
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static ObservableCollection<Band> GetBands()
{
// If _Band is null, create the Observable Collection
if (_Bands == null)
{
try
{
// Create _Band
_Bands = new ObservableCollection<Band>();
// Get data
DbDataReader reader = Database.GetData("SELECT * FROM band");
foreach (DbDataRecord record in reader)
{
// Create new Band
Band band = new Band();
// Get ID
if (DBNull.Value.Equals(record["ID"])) band.ID = -1;
else band.ID = Convert.ToInt32(record["ID"]);
// Get Name
if (DBNull.Value.Equals(record["Name"])) band.Name = "";
else band.Name = record["Name"].ToString();
// Get Twitter
if (DBNull.Value.Equals(record["Twitter"])) band.Twitter = "";
else band.Twitter = record["Twitter"].ToString();
// Get Facebook
if (DBNull.Value.Equals(record["Facebook"])) band.Facebook = "";
else band.Facebook = record["Facebook"].ToString();
// Get Picture
if (DBNull.Value.Equals(record["Picture"])) band.Picture = null;
else band.Picture = (byte[])record["Picture"];
// Get Description
if (DBNull.Value.Equals(record["Description"])) band.Description = "";
else band.Description = record["Description"].ToString();
// Add Band
_Bands.Add(band);
}
if (reader != null)
reader.Close();
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
// Clear Bands
_Bands.Clear();
_Bands = null;
}
}
// Return _Band
return _Bands;
}
public static void DeleteBand(Band band)
{
// If _Band is null, create the Observable Collection
if (_Bands == null) GetBands();
try
{
// Add to db
DbParameter param = Database.AddParameter("@id", band.ID);
int affectedRows = Database.ModifyData("DELETE FROM band WHERE id = @id", param);
if (affectedRows == 0) return;
// Update _Band
_Bands.RemoveAt(GetIndexByID(band.ID));
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public static int AddBand(Band band)
{
// If _Band is null, create the Observable Collection
if (_Bands == null) GetBands();
try
{
// Add to db
DbParameter param1 = Database.AddParameter("@name", band.Name);
DbParameter param2 = Database.AddParameter("@twitter", band.Twitter);
DbParameter param3 = Database.AddParameter("@facebook", band.Facebook);
DbParameter param4 = Database.AddParameter("@picture", band.Picture);
DbParameter param5 = Database.AddParameter("@description", band.Description);
DbDataReader reader = Database.GetData("INSERT INTO band(Name, Twitter, Facebook, Picture, Description) VALUES(@name, @twitter, @facebook, @picture, @description); SELECT LAST_INSERT_ID() AS ID;", param1, param2, param3, param4, param5);
foreach (DbDataRecord record in reader)
{
// Get ID
if (DBNull.Value.Equals(record["ID"])) band.ID = -1;
else band.ID = Convert.ToInt32(record["ID"]);
}
if (reader != null)
reader.Close();
_Bands.Add(band);
return band.ID;
}
// Fail
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return -1;
}
