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