public IActionResult transactionUpdate([FromBody] MvTransaction transaction)
{
try
{
var data = _transactionService.UpdateTransaction(transaction);
return(Ok(data));
}
catch (Exception ex)
{
throw;
}
}
public dynamic UpdateTransaction(MvTransaction transaction)
{
var json = JsonConvert.SerializeObject(transaction);
using (var sql = _dah.GetConnection())
{
using (SqlCommand command = new SqlCommand("SpTransactionUpdJson", sql))
{
command.CommandType = (System.Data.CommandType.StoredProcedure);;
command.Parameters.Add(new SqlParameter("@json", json));
command.ExecuteNonQuery();
return(transaction);
}
}
}
public IActionResult AddTransaction([FromBody] MvTransaction transaction)
{
try
{
var added = _transactionService.AddTransaction(transaction);
if (!added)
{
return(BadRequest());
}
return(Ok());
}
catch (Exception e)
{
throw e;
}
}
public IActionResult TransactionUpdate([FromBody] MvTransaction transaction)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
try
{
var data = _transactionService.UpdateTransaction(transaction);
return(Ok(data));
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddTransaction(MvTransaction transaction)
{
using (var connection = _dataAccess.GetConnection())
{
var jsonNew = JsonConvert.SerializeObject(transaction);
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SpTransactionInsertTsk";
command.Parameters.Add("@json", SqlDbType.NChar).Value = jsonNew;
command.CommandTimeout = _commandTimeout;
int rows = command.ExecuteNonQuery();
if (rows > 0)
{
return(true);
}
return(false);
}
}
