public Dictionary <string, DTreasurePackage> DBGetPackage(string playerName) { NpgsqlConnection conn = new NpgsqlConnection(connStr); using (conn) { NpgsqlCommand objCommand = new NpgsqlCommand(GetPackageSQL, conn); objCommand.Parameters.Add("@playername", NpgsqlTypes.NpgsqlDbType.Char).Value = playerName; conn.Open(); DbDataReader reader = objCommand.ExecuteReader(); Dictionary <string, DTreasurePackage> result = new Dictionary <string, DTreasurePackage>(); while (reader.Read()) { DTreasurePackage tmp = new DTreasurePackage() { wear = reader.GetBoolean(reader.GetOrdinal("wear")), number = reader.GetInt32(reader.GetOrdinal("ownnum")) }; result.Add(reader.GetString(reader.GetOrdinal("treasurename")).Trim(), tmp); } ; return(result); } }
public DTreasurePackage ToDTreasurePackagep() { DTreasurePackage treasurePackage = new DTreasurePackage() { wear = this.wear, number = this.number }; return(treasurePackage); }
public TreasurePackage FromDTreasurePackage(DTreasurePackage dTreasurePackage) { this.wear = dTreasurePackage.wear; this.number = dTreasurePackage.number; return(this); }