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());
}
