public dynamic EditSales(MvSales sales)
{
using (var dbConnection = _dah.GetConnection())
{
var dbCommand = dbConnection.CreateCommand();
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.CommandText = "SpSalesUpd";
dbCommand.Parameters.Add("@Json", SqlDbType.NVarChar);
dbCommand.Parameters["@Json"].Value = "{\"salesId\":" + sales.SalesId + "," +
"\"productId\":" + sales.ProductId + "," +
"\"quantity\":" + sales.Quantity + "," +
"\"insertPersonId\": 1337 }";
using (SqlDataReader reader = dbCommand.ExecuteReader())
{
try
{
if (reader.HasRows)
{
return(_dah.GetJson(reader));
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
}
}
public IActionResult EditSales([FromBody] MvSales sales)
{
try
{
dynamic jsonString = _salesService.EditSales(sales);
return(Ok(jsonString));
}
catch (Exception e)
{
throw e;
}
}
public IActionResult AddSales([FromBody] MvSales sales)
{
try
{
var added = _salesService.AddSales(sales);
if (!added)
{
return(BadRequest());
}
return(Ok());
}
catch (Exception e)
{
throw e;
}
}
public bool AddSales(MvSales sales)
{
using (var connection = _dah.GetConnection())
{
var jsonNew = JsonConvert.SerializeObject(sales);
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SpInvoiceTsk";
command.Parameters.Add("@json", SqlDbType.NChar).Value = jsonNew;
command.CommandTimeout = _comdTimeout;
int rows = command.ExecuteNonQuery();
if (rows > 0)
{
return(true);
}
return(false);
}
}
