//Benutzer erstellen public void CreateClient(Client newClient) { DatabaseContextInstance cdl = DatabaseContext.GetContext(); cdl.Clients.Add(newClient); cdl.SaveChanges(); }
//Einen Benutzer löschen public void DeleteClient(String username) { DatabaseContextInstance cdl = DatabaseContext.GetContext(); cdl.Clients.Remove(cdl.Clients.Find(username)); cdl.SaveChanges(); }
//Teilnehmer anhand der ID loeschen public void DeleteCompetitor(Guid CompetitorID) { DatabaseContextInstance cdl = DatabaseContext.GetContext(); cdl.Competitors.Remove(cdl.Competitors.Find(CompetitorID)); cdl.SaveChanges(); }
//Teilnehmer hinzufuegen public void CreateCompetitor(Competitor participant) { DatabaseContextInstance cdl = DatabaseContext.GetContext(); cdl.Competitors.Add(participant); cdl.SaveChanges(); }
//Alle Teilnehmer loeschen public void DeleteAllCompetitors() { using (DatabaseContextInstance cdl = DatabaseContext.GetContext()) { cdl.Competitors.RemoveRange(cdl.Competitors); cdl.SaveChanges(); } }
//Benutzer aktualisieren public void UpdateClient(String username, Client newClient) { DatabaseContextInstance cdl = DatabaseContext.GetContext(); Client oldClient = cdl.Clients.Find(username); oldClient.Name = newClient.Name; oldClient.Surname = newClient.Surname; oldClient.Gender = newClient.Gender; oldClient.EMail = newClient.EMail; oldClient.Password = newClient.Password; cdl.SaveChanges(); }
//Teilnehmer anhand der ID updaten public void UpdateCompetitor(Guid compID, Competitor newParticipant) { DatabaseContextInstance cdl = DatabaseContext.GetContext(); Competitor oldParticipant = cdl.Competitors.Find(compID); oldParticipant.Name = newParticipant.Name; oldParticipant.Surname = newParticipant.Surname; oldParticipant.Gender = newParticipant.Gender; oldParticipant.SkillLevel = newParticipant.SkillLevel; oldParticipant.Visibility = newParticipant.Visibility; cdl.SaveChanges(); }