/// <summary> /// Removes a user /// </summary> /// <param name="ID">The user to remove</param> public void RemoveUser(int ID) { using (MultipleChoiceEntities multipleChoiceEntities = new MultipleChoiceEntities()) { multipleChoiceEntities.Users.Remove(multipleChoiceEntities.Users.Find(ID)); multipleChoiceEntities.SaveChanges(); } }
/// <summary> /// Adds a new user /// </summary> /// <param name="user">The user to add</param> public void AddNewUser(User user) { if (user is null) { return; } using (MultipleChoiceEntities multipleChoiceEntities = new MultipleChoiceEntities()) { multipleChoiceEntities.Users.Add(user); multipleChoiceEntities.SaveChanges(); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { // Create a database object MultipleChoiceEntities multipleChoice = new MultipleChoiceEntities(); // Add the relevant information to the markModels list var mark = multipleChoice.Marks.Where(x => x.Test_ID == _testId).ToList(); List <MarkModel> markModels = mark.Select(t => new MarkModel { Name = t.User.Name, Surname = t.User.Surname, Mark = t.User_Mark }).ToList(); // Set the item source to the markModels list DataGrid.ItemsSource = markModels; }