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;
}
