public void DeleteWorker(Worker worker) { MessageBoxResult result = MessageBox.Show("Czy na pewno chcesz usunąć pracownika?", "Potwierdzenie", MessageBoxButton.YesNo, MessageBoxImage.Question); if (result == MessageBoxResult.Yes) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Workers.Attach(worker); dataContext.Workers.DeleteOnSubmit(worker); dataContext.SubmitChanges(); } } catch (System.Data.SqlClient.SqlException) { System.Windows.MessageBox.Show("Nie udało się usunąć pracownika. Błąd połączenia z bazą danych lub pracownik jest przypisany do zajęć"); } } else { Application.Current.Shutdown(); } }
public void AddClass(Class _class) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Classes.InsertOnSubmit(_class); dataContext.SubmitChanges(); } }
public void AddWorker(Worker worker) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Workers.InsertOnSubmit(worker);; dataContext.SubmitChanges(); } }
public void AddRoom(Room room) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Rooms.InsertOnSubmit(room); dataContext.SubmitChanges(); } }
public void AddClient(Client client) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Clients.InsertOnSubmit(client); dataContext.SubmitChanges(); } }
public void DeleteWorkPlanElement(WorkPlanElement workPlanElement) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.WorkPlanElements.Attach(workPlanElement); dataContext.WorkPlanElements.DeleteOnSubmit(workPlanElement); dataContext.SubmitChanges(); } }
public void DeleteClient(Client client) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Clients.Attach(client); dataContext.Clients.DeleteOnSubmit(client); dataContext.SubmitChanges(); } }
public void DeleteClass(Class _class) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Classes.Attach(_class); dataContext.Classes.DeleteOnSubmit(_class); dataContext.SubmitChanges(); } }
public void EditRoom(Room room) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var roomToEdit = dataContext.Rooms.FirstOrDefault(r => r.ID == room.ID); roomToEdit.Name = room.Name; roomToEdit.Capacity = room.Capacity; dataContext.SubmitChanges(); } }
public void EditWorker(Worker worker) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var workerToEdit = dataContext.Workers.FirstOrDefault(w => w.ID == worker.ID); workerToEdit.Name = worker.Name; workerToEdit.Surname = worker.Surname; dataContext.SubmitChanges(); } }
public void EditClass(Class _class) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var classToEdit = dataContext.Classes.FirstOrDefault(c => c.ID == _class.ID); classToEdit.Name = _class.Name; classToEdit.Popularity = _class.Popularity; dataContext.SubmitChanges(); } }
public void AddClass(Class _class) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Classes.InsertOnSubmit(_class); dataContext.SubmitChanges(); } } catch (Exception e) { MessageBox.Show("Operacja dodaj nie powiodła się"); } }
public void EditWorker(Worker worker) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var workerToEdit = dataContext.Workers.FirstOrDefault(w => w.ID == worker.ID); workerToEdit.Name = worker.Name; workerToEdit.Surname = worker.Surname; dataContext.SubmitChanges(); } } catch (System.Data.SqlClient.SqlException) { System.Windows.MessageBox.Show("Nie udało się dokonać edycji pracownika.", "Błąd połączenia z bazą danych"); } }
public void EditClass(Class _class) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var classToEdit = dataContext.Classes.FirstOrDefault(c => c.ID == _class.ID); classToEdit.Name = _class.Name; classToEdit.Popularity = _class.Popularity; dataContext.SubmitChanges(); } } catch (Exception e) { MessageBox.Show("Operacja edycji nie powiodła się"); } }
public void DeleteClass(Class _class) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Classes.Attach(_class); dataContext.Classes.DeleteOnSubmit(_class); dataContext.SubmitChanges(); } } catch { System.Windows.MessageBox.Show("Brak połączenia z bazą danych!"); } }
public void DeleteWorkPlanElement(WorkPlanElement workPlanElement) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.WorkPlanElements.Attach(workPlanElement); dataContext.WorkPlanElements.DeleteOnSubmit(workPlanElement); dataContext.SubmitChanges(); } } catch { System.Windows.MessageBox.Show("Brak połączenia z bazą danych!"); } }
public void EditRoom(Room room) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var roomToEdit = dataContext.Rooms.FirstOrDefault(r => r.ID == room.ID); roomToEdit.Name = room.Name; roomToEdit.Capacity = room.Capacity; dataContext.SubmitChanges(); } } catch (Exception e) { MessageBox.Show("Operacja Edytuj nie powiodła się"); } }
public void EditClient(Client client) { try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { var clientToEdit = dataContext.Clients.FirstOrDefault(w => w.ID == client.ID); clientToEdit.Name = client.Name; clientToEdit.Surname = client.Surname; clientToEdit.Address = client.Address; clientToEdit.VIP = client.VIP; dataContext.SubmitChanges(); } } catch (System.Data.SqlClient.SqlException) { System.Windows.MessageBox.Show("Nie udało się dokonać edycji klienta.", "Błąd połączenia z bazą danych"); } }
internal void DeleteRoom(Room EditedRoom) { try { var buttons = MessageBoxButton.YesNo; var question = MessageBoxImage.Question; if (MessageBox.Show("Czy na pewno chcesz usunac salę?", "Potwierdzenie usuniecia", buttons, question) == MessageBoxResult.Yes) { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Rooms.Attach(EditedRoom); dataContext.Rooms.DeleteOnSubmit(EditedRoom); dataContext.SubmitChanges(); } } } catch { MessageBox.Show("Nie można usunąć sali!", "Błąd"); } }
public void AddRoom(Room room) { if (string.IsNullOrWhiteSpace(room.Name) == true) { MessageBox.Show("Nazwa nie może być pusta."); return; } try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { dataContext.Rooms.InsertOnSubmit(room); dataContext.SubmitChanges(); } } catch (Exception e) { MessageBox.Show("Operacja Dodaj nie powiodła się"); } }
public void AddWorker(Worker worker) { if (worker.Salary <= 0) { MessageBox.Show("Pensja musi być większa od 0"); return; } try { using (var dataContext = new MotoFitAcademyDataContext(Confiuration.GetSqlConnectionString())) { string pattern = @"^[0-9]{11}$"; if (Regex.IsMatch(worker.Pesel, pattern) == false) { MessageBox.Show("Niepoprawny pesel"); return; } var workers = GetWorkers(); foreach (var w in workers) { if (worker.Pesel == w.Pesel) { MessageBox.Show("Kolizja peseli"); return; } } dataContext.Workers.InsertOnSubmit(worker); dataContext.SubmitChanges(); } } catch (System.Data.SqlClient.SqlException) { System.Windows.MessageBox.Show("Nie udało się dodać pracownika.", "Błąd połączenia z bazą danych"); } }