public dynamic EditProduct(MvProduct product)
{
using (var dbConnection = dah.GetConnection())
{
var dbCommand = dbConnection.CreateCommand();
dbCommand.CommandType = CommandType.StoredProcedure;
dbCommand.CommandText = "SpProductUpd";
dbCommand.Parameters.Add("@Json", SqlDbType.NVarChar);
dbCommand.Parameters["@Json"].Value = "{\"productId\":\"" + product.ProductId + "\"," +
"\"name\":\"" + product.Name + "\"," +
"\"rate\":\"" + product.Rate + "\"," +
"\"description\":\"" + product.Description + "\"," +
"\"insertPersonId\":\"" + product.InsertPersonId + "\"," +
"\"remainingQuantity\":\"" + product.RemainingQuantity + "\"}";
using (SqlDataReader reader = dbCommand.ExecuteReader())
{
try
{
if (reader.HasRows)
{
return(dah.GetJson(reader));
}
else
{
return(null);
}
}
catch (Exception e)
{
throw e;
}
}
}
}
public IActionResult EditProduct([FromBody] MvProduct product)
{
try
{
dynamic jsonString = _productService.EditProduct(product);
return(Ok(jsonString));
}
catch (Exception e)
{
throw e;
}
}
public IActionResult productUpdate([FromBody] MvProduct product)
{
try
{
var data = _productService.UpdateProduct(product);
return(Ok(data));
}
catch (Exception ex)
{
throw;
}
}
public dynamic UpdateProduct(MvProduct productItem)
{
var json = JsonConvert.SerializeObject(productItem);
using (var sql = _dah.GetConnection())
{
using (SqlCommand command = new SqlCommand("SpProductUpdJson", sql))
{
command.CommandType = (System.Data.CommandType.StoredProcedure);;
command.Parameters.Add(new SqlParameter("@json", json));
command.ExecuteNonQuery();
return(productItem);
}
}
}
public IActionResult AddProduct([FromBody] MvProduct product)
{
try
{
var added = _productService.AddProduct(product);
if (!added)
{
return(BadRequest());
}
return(Ok());
}
catch (Exception e)
{
throw e;
}
}
public bool AddProduct(MvProduct product)
{
using (var connection = _dataAccess.GetConnection())
{
var jsonNew = JsonConvert.SerializeObject(product);
var command = connection.CreateCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "SpProductProductRateInsTsk";
command.Parameters.Add("@json", SqlDbType.NChar).Value = jsonNew;
command.CommandTimeout = _commandTimeout;
int rows = command.ExecuteNonQuery();
if (rows > 0)
{
return(true);
}
return(false);
}
}
