db.Database.SetBonuses C# (CSharp) Method

Database Class Documentation 显示文件 Open project: C453/OryxKingdom

SetBonuses() public method

public SetBonuses ( int accId, List bonuses ) : bool
accId	int
bonuses	List
return	bool

        public bool SetBonuses(int accId, List<short> bonuses)
        {
            MySqlCommand cmd = CreateQuery();
            cmd.CommandText = "UPDATE accounts SET bonuses=@newbonuses WHERE id=@accId";
            cmd.Parameters.AddWithValue("@newbonuses", Utils.GetCommaSepString(bonuses.ToArray()));
            cmd.Parameters.AddWithValue("@accId", accId);
            if (cmd.ExecuteNonQuery() == 0)
                return false;
            return true;
        }