public IActionResult EditTransaction([FromBody] MvEditTransaction transaction) { try { var edited = _transactionService.EditTransaction(transaction); if (!edited) { return(BadRequest()); } return(Ok()); } catch (Exception e) { throw e; } }
public bool EditTransaction(MvEditTransaction transaction) { using (var con = _da.GetConnection()) { var jsonNew = JsonConvert.SerializeObject(transaction); var cmd = con.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SpSalesTransactionUpd_Json"; cmd.Parameters.Add("@Json", SqlDbType.NChar).Value = jsonNew; cmd.CommandTimeout = _commandTimeout; int rows = cmd.ExecuteNonQuery(); if (rows > 0) { return(true); } return(false); } }