public int DeleteAlbumById(int AlbumId) { Albumdetail mvd = new Albumdetail(); mvd.AlbumId = AlbumId; tstDb.Entry(mvd).State = System.Data.Entity.EntityState.Deleted; int Retval = tstDb.SaveChanges(); return(Retval); }
public int AddAlbum(int AlbumId, string AlbumName, string Artist, string Type, int stock) { Albumdetail mvd = new Albumdetail(); mvd.AlbumId = AlbumId; mvd.AlbumName = AlbumName; mvd.Artist = Artist; mvd.Type = Type; mvd.Stock = stock; tstDb.Albumdetail.Add(mvd); int Retval = tstDb.SaveChanges(); return(Retval); }
public int UpdateAlbum(int AlbumId, string AlbumName, string Artist, string Type, int stock) { Albumdetail mvd = new Albumdetail(); mvd.AlbumId = AlbumId; mvd.AlbumName = AlbumName; mvd.Artist = Artist; mvd.Type = Type; mvd.Stock = stock; tstDb.Entry(mvd).State = System.Data.Entity.EntityState.Modified; int Retval = tstDb.SaveChanges(); return(Retval); }
public Albumdetail GetAllAlbumById(int AlbumId) { var albumListResult = from k in tstDb.movies where k.Id == AlbumId select k; Albumdetail mv = new Albumdetail(); foreach (var item in albumListResult) { mv.AlbumId = item.AlbumId; mv.AlbumName = item.AlbumName; mv.Artist = item.Artist; mv.Type = item.Type; mv.Stock = item.stock; } return(mv); }
public List <Albumdetail> GetAlbumdetails() { List <Albumdetail> albumList = new List <Albumdetail>(); var movieListResult = from k in tstDb.Albumdetail select k; foreach (var item in movieListResult) { Albumdetail mv = new Albumdetail(); mv.AlbumId = item.AlbumId; mv.AlbumName = item.AlbumName; mv.Artist = item.Artist; mv.Type = item.Type; mv.Stock = item.Stock; albumList.Add(mv); } return(albumList); }