public IActionResult AddProduct([FromBody] MvAddProduct product)
{
try
{
var added = _productService.AddProduct(product);
if (!added)
{
return(BadRequest());
}
return(Ok());
}
catch (Exception e)
{
throw e;
}
}
public bool AddProduct(MvAddProduct product)
{
var jsonNew = JsonConvert.SerializeObject(product);
using (var conn = _dah.GetConnection())
{
using (var cmd = new SqlCommand("SpProductProductRateTsk", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Json", SqlDbType.NChar).Value = jsonNew;
cmd.CommandTimeout = int.Parse(_commandTimeout);
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
return(true);
}
return(false);
}
}
}
public IActionResult AddProduct([FromBody] MvAddProduct product)
{
if (!ModelState.IsValid)
{
return(BadRequest());
}
try
{
var added = _productService.AddProduct(product);
if (!added)
{
return(BadRequest());
}
return(Ok());
}
catch (Exception)
{
throw;
}
}
public bool AddProduct(MvAddProduct product)
{
using (var con = _da.GetConnection())
{
var jsonNew = JsonConvert.SerializeObject(product);
var cmd = con.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SpProductInsTsk_OUTPUT";
cmd.Parameters.Add("@Json", SqlDbType.NVarChar).Value = jsonNew;
cmd.CommandTimeout = _commandTimeout;
int rows = cmd.ExecuteNonQuery();
if (rows > 0)
{
return(true);
}
return(false);
}
}