Kaffeplaneten.DAL.ProductDAL.updateQuantity C# (CSharp) Method

updateQuantity() public method

public updateQuantity ( ProductModel productModel ) : bool
productModel Kaffeplaneten.Models.ProductModel
return bool
        public bool updateQuantity(ProductModel productModel)
        {
            using (var db = new CustomerContext())
            {
                try
                {
                    var product = (from p in db.Products
                                   where p.productID == productModel.productID
                                   select p).FirstOrDefault();
                    if (product == null)
                        return false;
                    if (product.stock < productModel.stock)
                        return false;
                    product.stock = productModel.stock;
                    db.SaveChanges();
                    return true;
                }
                catch (Exception ex)
                {
                    _logging.logToDatabase(ex);
                }
                return false;
            }
        }

Usage Example

示例#1
0
 /*Legger ProductOrders inn i databasen. OrderNr og pruductID-ene må være med i modellen*/
 private bool addProductOrders(OrderModel orderModel)
 {
     using (var db = new CustomerContext())
         {
         try
         {
             var order = db.Orders.Find(orderModel.orderNr);
             if (order == null)//tester om ordren eksisterer
                 return false;
             var productDAL = new ProductDAL();
             foreach (var p in orderModel.products)//Opretter ProductOrders fra modellen
             {
                 p.stock -= p.quantity;
                 productDAL.updateQuantity(p);
                 var productOrder = new ProductOrders();
                 productOrder.orders = order;
                 productOrder.price = p.price;
                 productOrder.products = db.Products.Find(p.productID);
                 productOrder.quantity = p.quantity;
                 productOrder.price = p.price * p.quantity;
                 db.ProductOrders.Add(productOrder);
             }
             db.SaveChanges();
             return true;
             }
         catch (Exception ex)
         {
             _logging.logToDatabase(ex);
         }
         return false;
     }
 }