private void SaveRecord()
{
try
{
_Storage.OpenConnection();
_Storage.BeginTransaction(AzManIsolationLevel.ReadUncommitted);
#region Managers
KeyValuePair <string, bool>[] managers = _Store.GetManagers();
foreach (CheckBox sqlLogin in flpManagers.Controls)
{
if (sqlLogin.Checked)
{
if (!FindLogin(managers, sqlLogin.Text))
{
_Store.GrantAccessAsManager(sqlLogin.Text);
}
}
else
{
if (FindLogin(managers, sqlLogin.Text))
{
_Store.RevokeAccessAsManager(sqlLogin.Text);
}
}
}
#endregion
#region Users
KeyValuePair <string, bool>[] users = _Store.GetUsers();
foreach (CheckBox sqlLogin in flpUsers.Controls)
{
if (sqlLogin.Checked)
{
if (!FindLogin(users, sqlLogin.Text))
{
_Store.GrantAccessAsUser(sqlLogin.Text);
}
}
else
{
if (FindLogin(users, sqlLogin.Text))
{
_Store.RevokeAccessAsUser(sqlLogin.Text);
}
}
}
#endregion
#region Readers
KeyValuePair <string, bool>[] readers = _Store.GetReaders();
foreach (CheckBox sqlLogin in flpReaders.Controls)
{
if (sqlLogin.Checked)
{
if (!FindLogin(readers, sqlLogin.Text))
{
_Store.GrantAccessAsReader(sqlLogin.Text);
}
}
else
{
if (FindLogin(readers, sqlLogin.Text))
{
_Store.RevokeAccessAsReader(sqlLogin.Text);
}
}
}
#endregion
_Storage.CommitTransaction();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
_Storage.CloseConnection();
}
_Dirty = true;
}