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