bool IOrderDetalisRepository.UpdateOrderDetalis(OrderDetalis ourOrder) { int rowsAffected = this._db.Execute("UPDATE OrderDetalis SET Amount = @Amount WHERE product_id = " + ourOrder.product_id, ourOrder); if (rowsAffected > 0) { return(true); } return(false); }
bool IOrderDetalisRepository.AddOrderDetalis(OrderDetalis ourOrder) { int rowsAffected = this._db.Execute("INSERT INTO OrderDetalis (OrderID, product_id, Amount) VALUES (@orderID, @productID, @amount)", new { orderID = ourOrder.OrderId, productID = ourOrder.product_id, amount = ourOrder.Amount }); if (rowsAffected > 0) { return(true); } return(false); }
bool IProductsRepository.UpdateProductUp(OrderDetalis amount) { int rowsAffected = this._db.Execute($"UPDATE Products SET quantity = quantity + {amount.Amount} WHERE product_id = {amount.product_id}"); if (rowsAffected > 0) { return(true); } return(false); }
bool IOrderDetalisRepository.UpdatePrice(OrderDetalis ourOrder) { var price = this._db.Query <Products>("SELECT price FROM `Products` WHERE product_id =" + ourOrder.product_id).SingleOrDefault(); int rowsAffected = this._db.Execute($"UPDATE OrderDetalis SET UnitePrice = '{price.price}' * Amount WHERE OrderID = " + ourOrder.OrderId, ourOrder); if (rowsAffected > 0) { return(true); } return(false); }
OrderDetalis IOrderDetalisRepository.GetCurrentAmount(OrderDetalis ourOrder) { return(this._db.Query <OrderDetalis>($"SELECT Amount, product_id FROM OrderDetalis WHERE product_id = '{ourOrder.product_id}' AND OrderID = " + ourOrder.OrderId, ourOrder).SingleOrDefault()); }
string IProductsRepository.GetAmount(OrderDetalis order) { return(this._db.Query <string>($"SELECT quantity FROM Products WHERE product_id = {order.product_id}").Single()); }