public static int AddGenre(Genre genre) { // If _Genre is null, create the Observable Collection if (_genres == null) GetGenres(); try { // Add to db DbParameter param = Database.AddParameter("@name", genre.Name); DbDataReader reader = Database.GetData("INSERT INTO genre(name) VALUES(@name); SELECT LAST_INSERT_ID() AS ID;", param); foreach (DbDataRecord record in reader) { // Get ID if (DBNull.Value.Equals(record["ID"])) genre.ID = -1; else genre.ID = Convert.ToInt32(record["ID"]); } if (reader != null) reader.Close(); _genres.Add(genre); return genre.ID; } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); } return -1; }
public GenreVM() { Genres = Genre.GetGenres(); SelectedGenre = new Genre(); Enabled = true; ShowEdit = "Hidden"; ShowCancel = "Hidden"; ShowSave = "Visible"; }
private void SelectionChanged(GenreVM genrevm) { if (SelectedGenre == null) return; if (ShowCancel == "Visible") CancelUpdateGenre(this); _oldGenre = SelectedGenre.Copy(); genrevm.ShowEdit = "Visible"; genrevm.ShowCancel = "Hidden"; genrevm.ShowSave = "Hidden"; Enabled = false; }
private void DeleteGenre(GenreVM genrevm) { if (SelectedGenre == null) return; Genre.DeleteGenre(SelectedGenre); SelectedGenre = new Genre(); Enabled = true; ShowEdit = "Hidden"; ShowCancel = "Hidden"; ShowSave = "Visible"; }
private void AddGenre(GenreVM genrevm) { SelectedGenre = new Genre(); _oldGenre = null; genrevm.ShowEdit = "Hidden"; genrevm.ShowCancel = "Visible"; genrevm.ShowSave = "Visible"; genrevm.Enabled = true; }
public static void UpdateGenre(Genre genre) { // If _Genre is null, create the Observable Collection if (_genres == null) GetGenres(); try { // Update db DbParameter param1 = Database.AddParameter("@id", genre.ID); DbParameter param2 = Database.AddParameter("@name", genre.Name); int affectedRows = Database.ModifyData("UPDATE genre SET name = @name WHERE id = @id", param1, param2); if (affectedRows == 0) return; // Update _genres _genres[GetIndexByID(genre.ID)] = genre; } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); } }
public static ObservableCollection<Genre> GetGenres() { // If _genres is null, create the Observable Collection if (_genres == null) { try { // Create _genres _genres = new ObservableCollection<Genre>(); // Get data DbDataReader reader = Database.GetData("SELECT * FROM genre"); foreach (DbDataRecord record in reader) { // Create new Genre Genre genre = new Genre(); // Get ID if (DBNull.Value.Equals(record["ID"])) genre.ID = -1; else genre.ID = Convert.ToInt32(record["ID"]); // Get Name if (DBNull.Value.Equals(record["Name"])) genre.Name = ""; else genre.Name = record["Name"].ToString(); // Add Genre _genres.Add(genre); } if (reader != null) reader.Close(); } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); // Clear Genres _genres.Clear(); _genres = null; } } // Return _genres return _genres; }
public static void DeleteGenre(Genre genre) { // If _Genre is null, create the Observable Collection if (_genres == null) GetGenres(); try { // Add to db DbParameter param = Database.AddParameter("@id", genre.ID); int affectedRows = Database.ModifyData("DELETE FROM genre WHERE id = @id", param); if (affectedRows == 0) return; // Update _genres _genres.RemoveAt(GetIndexByID(genre.ID)); } // Fail catch (Exception ex) { Console.WriteLine(ex.Message); } }