// ADD , EDIT I DELETE ZA ARTIST vwArtist IService1.AddArtist(vwArtist artist) // AddArtist { try { using (VinylRecordsShopEntities context = new VinylRecordsShopEntities()) { if (artist.ArtistID == 0) { // ZA ADD tblArtist newArtist = new tblArtist(); newArtist.ArtistName = artist.ArtistName; context.tblArtists.Add(newArtist); context.SaveChanges(); artist.ArtistID = newArtist.ArtistID; return(artist); } else { // ZA EDIT tblArtist artistToEdit = (from r in context.tblArtists where r.ArtistID == artist.ArtistID select r).First(); artistToEdit.ArtistName = artist.ArtistName; context.Entry(artistToEdit).State = EntityState.Modified; context.SaveChanges(); return(artist); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
void IService1.DeleteArtist(int artistID) // DeleteArtist { try { using (VinylRecordsShopEntities context = new VinylRecordsShopEntities()) { tblArtist artistToDelete = (from r in context.tblArtists where r.ArtistID == artistID select r).First(); context.tblArtists.Remove(artistToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }