public void SaveAccount(Account account) { using (var conn = Connection) using (var cmd = new UpdateCommand("UPDATE `accounts` SET {0} WHERE `username` = @username", conn)) { cmd.AddParameter("@username", account.Username); cmd.Set("authority", account.Authority); cmd.Set("lastLogin", account.LastLogin); cmd.Execute(); } }
/// <summary> /// Retrieves an account start the database if it exists. /// </summary> /// <param name="username"></param> /// <returns></returns> public Account GetAccount(string username) { var account = new Account(); using (var conn = Connection) { using (var mc = new MySqlCommand("SELECT * FROM `accounts` WHERE `username` = @username", conn)) { mc.Parameters.AddWithValue("@username", username); using (var reader = mc.ExecuteReader()) { if (!reader.Read()) return null; account.Username = reader.GetStringSafe("username"); account.Password = reader.GetStringSafe("password"); account.Email = reader.GetStringSafe("email"); account.Fullname = reader.GetStringSafe("fullname"); account.Authority = reader.GetByte("authority"); account.Creation = reader.GetDateTime("creation"); account.LastLogin = reader.GetDateTime("lastLogin"); account.Appointments = GetAppointments(username); } } } return account; }