public bool SetItemDataForUID(int UID, FullItemData item) { var command = connection.CreateCommand(); command.CommandText = "UPDATE Items SET Category = $Category, Name = $Name, Params = $Params, Count = $Count, Price = $Price, Description = $Description WHERE UID = $UID"; command.Parameters.AddWithValue("$UID", UID); command.Parameters.AddWithValue("$Category", item.Category); command.Parameters.AddWithValue("$Name", item.Name); command.Parameters.AddWithValue("$Params", string.Join('\n',item.Params)); command.Parameters.AddWithValue("$Count", item.Count); command.Parameters.AddWithValue("$Price", item.Price); command.Parameters.AddWithValue("$Description", item.Description); return command.ExecuteNonQuery() == 1; }
public FullItemData GetFullItemData(int UID) { var result = new FullItemData(); var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM Items WHERE UID = $UID"; command.Parameters.AddWithValue("$UID", UID); using (var reader = command.ExecuteReader()) { reader.Read(); result.UID = reader.GetInt32(0); result.Category = reader.GetString(1); result.Name = reader.GetString(2); result.Params = reader.GetString(3).Split('\n'); result.Count = reader.GetInt32(4); result.Price = reader.GetInt32(5); result.Description = reader.GetString(6); } return result; }