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); } }