public async Task <JsonResult> ItemAttributeValueCreate([FromBody] itemattributevalueModel iavm) { try { return(await _itemLogic.ItemAttributeValueCreate(iavm).ConfigureAwait(false)); } catch (Exception ee) { return(await _itemLogic.SendRespose("False", ee.Message).ConfigureAwait(false)); } }
internal async Task <JsonResult> ItemAttributeValueCreate(itemattributevalueModel iavm) { SqlConnection cn = null; try { cn = Connection.GetConnection(); SqlCommand smd = new SqlCommand("[item_attribute_value_create]", cn) { CommandType = CommandType.StoredProcedure }; smd.Parameters.AddWithValue("@attribute_type_no", iavm.attribute_type_no); smd.Parameters.AddWithValue("@attribute_value_no", iavm.attribute_value_no); smd.Parameters.AddWithValue("@value", iavm.value); smd.Parameters.AddWithValue("@description", iavm.description); smd.Parameters.AddWithValue("@created_by", iavm.created_by); smd.Parameters.AddWithValue("@update_by", iavm.updated_by); smd.Parameters.AddWithValue("@flag", iavm.flag); smd.Parameters.Add("@jsonOutput", SqlDbType.NVarChar, -1).Direction = ParameterDirection.Output; // Execute the command await smd.ExecuteNonQueryAsync().ConfigureAwait(false); // Get the values string json = smd.Parameters["@jsonOutput"].Value.ToString(); smd.Dispose(); JArray arr = JArray.Parse(json); return(new JsonResult(arr)); } catch (Exception) { throw; } finally { Connection.CloseConnection(ref cn); } }