Aura.Msgr.Database.MsgrDb.InviteFriend C# (CSharp) Method

		public void InviteFriend(int userId, int friendId)
		{
			using (var conn = this.Connection)
			using (var transaction = conn.BeginTransaction())
			{
				using (var cmd = new InsertCommand("INSERT INTO `friends` {0}", conn, transaction))
				{
					cmd.Set("userId1", userId);
					cmd.Set("userId2", friendId);
					cmd.Set("groupId", -1);
					cmd.Set("status", (byte)FriendshipStatus.Inviting);

					cmd.Execute();
				}

				using (var cmd = new InsertCommand("INSERT INTO `friends` {0}", conn, transaction))
				{
					cmd.Set("userId1", friendId);
					cmd.Set("userId2", userId);
					cmd.Set("groupId", -1);
					cmd.Set("status", (byte)FriendshipStatus.Invited);

					cmd.Execute();
				}

				transaction.Commit();
			}
		}