// ADD , EDIT I DELETE ZA GENRE
vwGenre IService1.AddGenre(vwGenre genre) // AddGenre
{
try
{
using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
{
if (genre.GenreID == 0)
{ // ZA ADD
tblGenre newGenre = new tblGenre();
newGenre.Name = genre.Name;
newGenre.Description = genre.Description;
context.tblGenres.Add(newGenre);
context.SaveChanges();
genre.GenreID = newGenre.GenreID;
return(genre);
}
else
{ // ZA EDIT
tblGenre genreToEdit = (from r in context.tblGenres where r.GenreID == genre.GenreID select r).First();
genreToEdit.Name = genre.Name;
genreToEdit.Description = genre.Description;
context.Entry(genreToEdit).State = EntityState.Modified;
context.SaveChanges();
return(genre);
}
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
void IService1.DeleteGenre(int genreID) // DeleteGenre
{
try
{
using (VinylRecordsShopEntities context = new VinylRecordsShopEntities())
{
tblGenre genreToDelete = (from r in context.tblGenres where r.GenreID == genreID select r).First();
context.tblGenres.Remove(genreToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
