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(); }