// 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());
}
}
