public IActionResult UpdateSalesTransaction([FromBody] MvSalesTransactionUpdate salesTransaction)
{
try
{
var updated = _salesTransactionService.UpdateSalesTransaction(salesTransaction);
if (!updated)
{
return(BadRequest());
}
return(Ok());
}
catch (Exception e)
{
throw e;
}
}
public bool UpdateSalesTransaction(MvSalesTransactionUpdate salesTransactionUpdate)
{
using (var connection = _dataAccess.GetConnection())
{
var jsonNew = JsonConvert.SerializeObject(salesTransactionUpdate);
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SpSalesTransactionUpd";
command.Parameters.Add("@json", SqlDbType.NChar).Value = jsonNew;
command.CommandTimeout = _commandTimeout;
int rows = command.ExecuteNonQuery();
if (rows > 0)
{
return(true);
}
return(false);
}
}
