private static async Task <MCIUserExt> GetUserExtensions(ulong user_id)
{
MCIUserExt res = null;
var sqlconn = await ARDBConnectionManager.default_manager.CheckOut();
try
{
using (MySqlCommand cmd = new MySqlCommand("select data from `user_extensions` where user_id=" + user_id, sqlconn.Connection))
using (MySqlDataReader reader = cmd.ExecuteReader())
{
reader.Read();
if (reader.IsDBNull(0))
{
res = null;
}
else
{
res = JsonConvert.DeserializeObject <MCIUserExt>((string)reader["data"]);
}
}
}
catch (Exception ex)
{
Console.WriteLine("An error occured while attempting to deserialize the user extensions object.");
}
ARDBConnectionManager.default_manager.CheckIn(sqlconn);
return(res);
}
private async void button1_Click(object sender, EventArgs e)
{
//save button clicked
List <int> floors = new List <int>();
foreach (var item in checkedListBox1.CheckedItems)
{
floors.Add(Convert.ToInt32((string)item));
}
foreach (var user in users_to_edit)
{
var ext = new MCIUserExt();
ext.HomeFloors = floors.ToArray();
await DatabaseUtilities.SetUserExtensions(user, ext);
}
DialogResult = DialogResult.OK;
}
