public IActionResult EditShippedDate(EditProductOrderDto shippedDate)
{
if (_repo.EditShippedDate(shippedDate))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public IActionResult EditQuantityOrdered(EditProductOrderDto quantityOrdered)
{
if (_repo.EditQuantityOrdered(quantityOrdered))
{
return(Ok());
}
else
{
return(BadRequest());
}
}
public bool EditQuantityOrdered(EditProductOrderDto quantityOrdered)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"UPDATE ProductOrder
SET QuantityOrdered = @quantityOrdered
WHERE [Id] = @id";
return(db.Execute(sql, quantityOrdered) == 1);
}
}
public bool EditShippedDate(EditProductOrderDto shippedDate)
{
using (var db = new SqlConnection(_connectionString))
{
var sql = @"UPDATE ProductOrder
SET ShippedDate = @shippedDate
,IsShipped = 1
WHERE [Id] = @id";
return(db.Execute(sql, shippedDate) == 1);
}
}
