public void SETKCV(KCVVs input)
{
using (SQLiteTransaction tr = conn.BeginTransaction())
{
SQLiteCommand cmd = new SQLiteCommand(conn);
cmd.CommandText = "UPDATE KCV SET value = @value, open = @open where name = @name";
for (int i = 1; i <= 8; i++)
{
string key = "kcv" + i.ToString();
cmd.Parameters.AddWithValue("@value", input.KV[key]);
cmd.Parameters.AddWithValue("@open", input.KC[key]);
cmd.Parameters.AddWithValue("@name", key);
cmd.ExecuteNonQuery();
}
tr.Commit();
}
}
public KCVVs ALLKCV()
{
KCVVs temp = new KCVVs();
temp.KC = new Dictionary <string, bool>();
temp.KV = new Dictionary <string, string>();
string sql = "SELECT * FROM KCV";
SQLiteCommand cmdQ = new SQLiteCommand(sql, this.conn);
SQLiteDataReader reader = cmdQ.ExecuteReader();
while (reader.Read())
{
string Name = reader.GetString(0);
bool Open = reader.GetBoolean(1);
string Value = reader.GetString(2);
temp.KV[Name] = Value;
temp.KC[Name] = Open;
}
return(temp);
}
