public void Update(string username, User user)
{
var parms = new Dictionary<string, string>();
parms.Add("@TableName", "users");
parms.Add("@User", "user");
parms.Add("@UserName", username);
_db.Update("users", user.ToDictionary(), "@User = '******'", parms);
}
private User NewUser(string username)
{
var user = new User(username);
user.FirstSeen = DateTime.Now;
var stream = _twitch.GetTwitchStream(Chat.MainChannel.Substring(1));
if (stream != null) user.FirstGame = stream.game;
var data = user.ToDictionary();
data.Add("user", user.Name);
_db.Insert("users", data);
return user;
}
private void InitializeUser(string username)
{
//Get the message to be edited
var parms = new Dictionary<string, string>();
parms.Add("@TableName", "users");
parms.Add("@User", "user");
parms.Add("@Name", username);
var results = _db.Query("SELECT * FROM @TableName WHERE @User = '******'", parms);
//If user isn't found, create a new user
if (results.Rows.Count == 0)
_users[username] = NewUser(username);
else //Otherwise, create a user and fill it with data from the database.
{
var user = new User(username, DataRowToDictionary(results.Rows[0]));
_users[username] = user;
}
}