public void UbahShoppingCartDatabase(String cartId, UbahShoppingCart[] UbahCartItem) { using (var db = new TokoTelevisiOnline.model.ProdukContext()) { try { int CartItemCount = UbahCartItem.Count(); List <CartItem> myCart = GetCartItem(); foreach (var cartItem in myCart) { for (int i = 0; i < CartItemCount; i++) { if (cartItem.Produk.ProdukId == UbahCartItem[i].ProdukId) { if (UbahCartItem[i].JumlahTextBox < 1 || UbahCartItem[i].HapusItem == true) { HapusItem(cartId, cartItem.ProdukId); } else { UbahItem(cartId, cartItem.ProdukId, UbahCartItem[i].JumlahTextBox); } } } } } catch (Exception exp) { throw new Exception("Error: Ubah Cart Database tidak berhasil - " + exp.Message.ToString(), exp); } } }
public void UbahItem(string ubahCartID, int ubahProdukID, int jumlah) { using (var _db = new TokoTelevisiOnline.model.ProdukContext()) { try { var myItem = (from c in _db.DataShoppingCart where c.CartId == ubahCartID && c.Produk.ProdukId == ubahProdukID select c).FirstOrDefault(); if (myItem != null) { myItem.Jumlah = jumlah; _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Unable to Updte cart Item - " + exp.Message.ToString(), exp); } } }
public void HapusItem(string hapusCartID, int hapusProdukID) { using (var _db = new TokoTelevisiOnline.model.ProdukContext()) { try { var myItem = (from c in _db.DataShoppingCart where c.CartId == hapusCartID && c.Produk.ProdukId == hapusProdukID select c).FirstOrDefault(); if (myItem != null) { _db.DataShoppingCart.Remove(myItem); _db.SaveChanges(); } } catch (Exception exp) { throw new Exception("ERROR: Cart Item tidak berhasil dihapus " + exp.Message.ToString(), exp); } } }