private void saveData(object sender, RoutedEventArgs e)
{
Database.Database.Instance.Connect();
var kupa = getValues();
for (int i = 0; i < _Users.Count(); i++)
{
for (int j = 0; j < 5 && !_updated; j++)
{
if (_Cells[i, j] != kupa[i, j])
{
int level = 0;
if (j == 3)
{
level = -1;
}
else if (j == 4)
{
level = -2;
}
else
{
level = j + 1;
}
if (_Cells[i, j] == true)
{
Database.Database.Instance.Delete(_Permissions.FirstOrDefault(perm => perm.IdOBene == _currentUser && perm.IdOD == i + 1 && perm.Poziom == level));
}
else
{
UprawnienieModel model = new UprawnienieModel {
IdU = 0,
IdOBene = _currentUser,
IdOD = i + 1,
Poziom = level
};
Database.Database.Instance.Insert(model);
}
}
}
}
if (_isAdmin != Connector.isAdmin.IsChecked)
{
if ((bool)Connector.isAdmin.IsChecked)
{
Database.Database.Instance.Insert(new UprawnienieModel {
IdOBene = _currentUser, IdOD = _currentUser, Poziom = 0
});
}
else
{
Database.Database.Instance.Delete(_Permissions.FirstOrDefault(perm => perm.IdOBene == _currentUser && perm.IdOD == _currentUser && perm.Poziom == 0));
}
}
_Permissions = Database.Database.Instance.SelectAll <UprawnienieModel>();
Database.Database.Instance.Dispose();
}
private void ButtonNext1_Click(object sender, RoutedEventArgs e)
{
Database.Database.Instance.Connect();
var users = Database.Database.Instance.SelectAll <OsobaModel>();
var currentLogin =
users.FirstOrDefault(user => user.Login == LoginBox1.Text && user.Haslo == PasswordBox1.Password);
if (currentLogin != null)
{
var permissions = Database.Database.Instance.SelectAll <UprawnienieModel>();
var userPermission = permissions.FirstOrDefault(perm => perm.IdOD == currentLogin.IdO && perm.Poziom == 0);
if (userPermission != null)
{
OsobaModel newUser = new OsobaModel
{
Login = Login,
Haslo = Password,
Imie = NameBox.Text,
Nazwisko = Surname,
DataU = DateTime.Now
};
Database.Database.Instance.Insert(newUser);
var dbUser = Database.Database.Instance.SelectAll <OsobaModel>().FirstOrDefault(user => user.Login == newUser.Login);
UprawnienieModel uprawnienie1 = new UprawnienieModel {
IdOBene = dbUser.IdO, IdOD = dbUser.IdO, Poziom = 1
};
UprawnienieModel uprawnienie2 = new UprawnienieModel {
IdOBene = dbUser.IdO, IdOD = dbUser.IdO, Poziom = 2
};
UprawnienieModel uprawnienie3 = new UprawnienieModel {
IdOBene = dbUser.IdO, IdOD = dbUser.IdO, Poziom = 3
};
Database.Database.Instance.Insert(uprawnienie1);
Database.Database.Instance.Insert(uprawnienie2);
Database.Database.Instance.Insert(uprawnienie3);
Database.Database.Instance.Dispose();
StateMachine.Instance.PushState <LoggedinLogicState>(new LoggedinStatePushParameters()
{
user = dbUser,
saveLogged = false
});
}
}
else
{
SurnameErrorText1.Visibility = Visibility.Visible;
}
Database.Database.Instance.Dispose();
}
