Insert

    public class UserGateway : Connection
    {
        // PŘIDÁ ZÁZNAM DO TABULKY USERS
        public void Insert(User temp)
        {
            string commandText = "INSERT INTO Users VALUES (DEFAULT, @name, @email, @password, @person)";

            using (SqlConnection con = base.NewConnection())
            {
                SqlCommand myCommand = new SqlCommand(commandText, con);
                SqlTransaction myTransaction = con.BeginTransaction("myTransaction");
                myCommand.Parameters.AddWithValue("@name", temp.name);
                myCommand.Parameters.AddWithValue("@email", temp.email);
                myCommand.Parameters.AddWithValue("@password", temp.password);
                myCommand.Parameters.AddWithValue("@person", temp.person);
                myCommand.Transaction = myTransaction;
                try
                {
                    myCommand.ExecuteNonQuery();
                    myTransaction.Commit();
                }
                catch
                {
                    myTransaction.Rollback();
                    throw new SqlInsertCommandException("Vytvoření uživatele se nezdrařilo.");
                }
                finally
                {
                    con.Close();
                }
            }
        }
   }