/// <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;
}
