public int RemoveFromCart(MusicAlbum musicAlbum) { var shoppingCartItem = _appDbContext.ShoppingCartItems.SingleOrDefault( s => s.MusicAlbum.MusicAlbumId == musicAlbum.MusicAlbumId && s.ShoppingCartId == ShoppingCartId); var localAmount = 0; if (shoppingCartItem != null) { if (shoppingCartItem.Amount > 1) { shoppingCartItem.Amount--; localAmount = shoppingCartItem.Amount; } else { _appDbContext.ShoppingCartItems.Remove(shoppingCartItem); } } _appDbContext.SaveChanges(); return(localAmount); }
private MusicAlbum GetCategoryByCategoryId(MusicAlbum musicAlbum) { Category tempCategory; switch (musicAlbum.Category.CategoryId) { case 1: tempCategory = new Category { CategoryId = 1, CategoryName = "Electronica", Description = "Electronica Albums" }; musicAlbum.Category = tempCategory; musicAlbum.CategoryId = musicAlbum.Category.CategoryId; break; case 2: tempCategory = new Category { CategoryId = 2, CategoryName = "Jazz", Description = "Jazz Albums" }; musicAlbum.Category = tempCategory; musicAlbum.CategoryId = musicAlbum.Category.CategoryId; break; case 3: tempCategory = new Category { CategoryId = 3, CategoryName = "Rock", Description = "Rock Albums" }; musicAlbum.Category = tempCategory; musicAlbum.CategoryId = musicAlbum.Category.CategoryId; break; case 4: tempCategory = new Category { CategoryId = 4, CategoryName = "Soul-Funk-Disco", Description = "Soul-Funk-Disco Albums" }; musicAlbum.Category = tempCategory; musicAlbum.CategoryId = musicAlbum.Category.CategoryId; break; default: Console.WriteLine($"An unexpected value for CategoryId ({musicAlbum.Category.CategoryId})"); break; } return(musicAlbum); }
public string AddMusicAlbum(MusicAlbum musicAlbum) { try { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); musicAlbum = GetCategoryByCategoryId(musicAlbum); con.Execute( "INSERT INTO MusicAlbums VALUES(@Name, @ShortDescription, @LongDescription, @Price, @ImageUrl, @ImageThumbnailUrl, @IsMusicAlbumOfTheWeek, @InStock, @CategoryId)", musicAlbum); con.Close(); return("Music album saved Successfully"); } } catch (Exception ex) { Console.WriteLine("Count not insert."); return(ex.Message.ToString()); } }
public void AddToCart(MusicAlbum musicAlbum, int amount) { var shoppingCartItem = _appDbContext.ShoppingCartItems.SingleOrDefault( s => s.MusicAlbum.MusicAlbumId == musicAlbum.MusicAlbumId && s.ShoppingCartId == ShoppingCartId); if (shoppingCartItem == null) { shoppingCartItem = new ShoppingCartItem { ShoppingCartId = ShoppingCartId, MusicAlbum = musicAlbum, Amount = 1 }; _appDbContext.ShoppingCartItems.Add(shoppingCartItem); } else { shoppingCartItem.Amount++; } _appDbContext.SaveChanges(); }