public int AddAlternative(AlternativeFAHP alternative, int sessionId)
{
using (var connection = new SqlConnection(_connectionString))
{
var command = connection.CreateCommand();
command.CommandText = "FAHPAddAlternative";
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter
{
ParameterName = "@AlternativeName",
Value = alternative.AlternativeName,
SqlDbType = SqlDbType.NVarChar,
Direction = ParameterDirection.Input
});
command.Parameters.Add(new SqlParameter
{
ParameterName = "@SessionID",
Value = sessionId,
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Input
});
var id = new SqlParameter
{
ParameterName = "@AlternativeID",
SqlDbType = SqlDbType.Int,
Direction = ParameterDirection.Output
};
command.Parameters.Add(id);
connection.Open();
command.ExecuteNonQuery();
return((int)id.Value);
}
}
public int AddAlternative(AlternativeFAHP alternative, int sessionId) => _fahpDao.AddAlternative(alternative, sessionId);
