93 lines
2.4 KiB
C#
93 lines
2.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.ComponentModel.DataAnnotations.Schema;
|
|
using System.ComponentModel.DataAnnotations;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using Microsoft.EntityFrameworkCore;
|
|
|
|
namespace Entities.Contracts
|
|
{
|
|
[Table("submissions")]
|
|
public class Submission
|
|
{
|
|
[Key]
|
|
[Column("id")]
|
|
public Guid Id { get; set; }
|
|
|
|
[Required]
|
|
[Column("exam_id")]
|
|
public Guid ExamId { get; set; }
|
|
[ForeignKey(nameof(ExamId))]
|
|
public virtual Exam Exam { get; set; }
|
|
|
|
[Required]
|
|
[Column("student_id")]
|
|
public Guid StudentId { get; set; }
|
|
[ForeignKey(nameof(StudentId))]
|
|
public virtual User Student { get; set; }
|
|
|
|
[Column("graded_by")]
|
|
public Guid? GraderId { get; set; }
|
|
[ForeignKey(nameof(GraderId))]
|
|
public virtual User Grader { get; set; }
|
|
|
|
[Column("class_id")]
|
|
public Guid ClassId { get; set; }
|
|
[ForeignKey(nameof(ClassId))]
|
|
public virtual Class Class { get; set; }
|
|
|
|
[Required]
|
|
[Column("attempt_number")]
|
|
public byte AttemptNumber { get; set; } // 第几次提交
|
|
|
|
[Column("submission_time")]
|
|
public DateTime SubmissionTime { get; set; }
|
|
|
|
[Column("overall_grade")]
|
|
public float OverallGrade { get; set; } = 0;
|
|
|
|
[Column("overall_feedback")]
|
|
public string? OverallFeedback { get; set; }
|
|
|
|
[Column("graded_at")]
|
|
public DateTime? GradedAt { get; set; }
|
|
|
|
[Required]
|
|
[Column("status")]
|
|
public SubmissionStatus Status { get; set; }
|
|
|
|
[Column("deleted")]
|
|
public bool IsDeleted { get; set; }
|
|
// Navigation Properties
|
|
|
|
[NotMapped]
|
|
public int ErrorCount => SubmissionDetails.Where(sd => sd?.IsCorrect == false && sd.IsCorrect != null).Count();
|
|
|
|
[NotMapped]
|
|
public Dictionary<string, int> ErrorQuestionTypeDistribution => SubmissionDetails
|
|
.Where(sd => sd?.IsCorrect == false)
|
|
.GroupBy(sd => sd.ExamQuestion.Type.Name)
|
|
.ToDictionary(g => g.Key, g => g.Count());
|
|
|
|
[NotMapped]
|
|
public Dictionary<string, int> ErrorQuestionLessonDistribution => SubmissionDetails
|
|
.Where(sd => sd?.IsCorrect == false && sd.ExamQuestion.Question?.Lesson != null)
|
|
.GroupBy(sd => sd.ExamQuestion.Question.Lesson.Title)
|
|
.ToDictionary(g => g.Key, g => g.Count());
|
|
|
|
|
|
|
|
[InverseProperty(nameof(SubmissionDetail.Submission))]
|
|
public virtual ICollection<SubmissionDetail> SubmissionDetails { get; set; }
|
|
|
|
public Submission()
|
|
{
|
|
Id = Guid.NewGuid();
|
|
SubmissionDetails = new HashSet<SubmissionDetail>();
|
|
}
|
|
}
|
|
|
|
}
|