public ActionResult GetStatisticByTeacherId(int userId)
{
TeacherDataAccess teacher = new TeacherDataAccess();
Mapper mapper = new Mapper();
var groups = teacher.GetGroupsWithStudentsByTeacherId(userId);
if (groups == null)
{
return(BadRequest("Запрашиваемого учителя не существует"));
}
List <StudentsVSTestsDTO> students = new List <StudentsVSTestsDTO>();
List <TestDTO> tests = new List <TestDTO>();
foreach (var g in groups)
{
if (g.Students != null)
{
foreach (var s in g.Students)
{
students.AddRange(teacher.GetTestsByStudentId(s.ID));
}
}
}
if (students != null)
{
foreach (var s in students)
{
tests.Add(new AuthorDataAccess().GetTestById(s.TestId));
}
}
return(Ok(mapper.ConvertStudentsVSTestsDTOAndTeacherGroupsWithStudentsDTOToGroupWithStudentsWithAttemptsOutputModel(students, groups, tests)));
}
public ActionResult ConfirmTeacherDelete(int id)
{
int i = id;
TeacherDataAccess.Delete(i);
return(RedirectToAction("Index"));
}
public IActionResult GetGroupTestsAndResults(int userId, int groupId)
{
TeacherDataAccess teacher = new TeacherDataAccess();
Mapper mapper = new Mapper();
TeacherGroup groups = new TeacherGroup();
var g = groups.GetAll();
if (!g.Any(g => g.UserID == userId))
{
return(BadRequest("Такой преподаватель отсутствует"));
}
if (!g.Any(g => g.GroupID == groupId))
{
return(BadRequest("Группа отсутствует"));
}
if (!groups.GetAllByUserId(userId).Any(g => g.GroupID == groupId))
{
return(BadRequest("Группа относится к другому преподавателю"));
}
List <TestDTO> tests = teacher.GetTestByGroupId(groupId);
GroupStatistics gs = new GroupStatistics(groupId);
Dictionary <int, double> statistic = gs.GetAverageResultsOfAllTestsByGroupId(groupId);
return(Ok(mapper.ConvertTestDTOToGroupTestsAndResultsOutputModel(tests, statistic)));
}
public frmTeacherNoticeUp()
{
teacherDataAccess = new TeacherDataAccess();
notice = new NoticeDataAccess();
InitializeComponent();
textBox1.Text = "Student";
textBox1.Enabled = false;
}
public IActionResult SelectTeacher(int id)
{
int i = id;
List <teacherModel> teacher = new List <teacherModel>();
teacher = TeacherDataAccess.SelectTeacher(i);
return(View(teacher));
}
public frmStudentStartup()
{
InitializeComponent();
StartPosition = FormStartPosition.CenterScreen;
studentDataAccess = new StudentDataAccess();
admindataAccess = new AdminDataAccess();
teacherDataAccess = new TeacherDataAccess();
dataGridView1.DataSource = studentDataAccess.GetStudentNotice();
}
public frmStudentReg()
{
InitializeComponent();
StartPosition = FormStartPosition.CenterScreen;
studentDataAccess = new StudentDataAccess();
admindataAccess = new AdminDataAccess();
teacherDataAccess = new TeacherDataAccess();
comboBoxRegSelect.Items.Add("Student");
comboBoxRegSelect.Items.Add("Teacher");
}
public frmApprove()
{
InitializeComponent();
StartPosition = FormStartPosition.CenterScreen;
studentDataAccess = new StudentDataAccess();
admindataAccess = new AdminDataAccess();
teacherDataAccess = new TeacherDataAccess();
comboBox1.Items.Add("Teacher");
comboBox1.Items.Add("Student");
MessageBox.Show("Test1");
}
public ActionResult GetLateStudentsByTestID(int testid)
{
if (new TestCRUD().GetById(testid) == null)
{
return(BadRequest("Теста с таким id не существует"));
}
TeacherDataAccess access = new TeacherDataAccess();
Mapper mapper = new Mapper();
return(Ok(mapper.ConvertTestWithStudentsDTOToTestWithStudentsOutputModel(access.GetLateStudentsByTestID(testid))));
}
public IActionResult GetQuestionAndAnswerByAttemptId(int attemptId)
{
TeacherDataAccess teacher = new TeacherDataAccess();
Mapper mapper = new Mapper();
List <QuestionAnswerDTO> answers = teacher.GetQuestionAndAnswerByAttempt(attemptId);
if (answers == null)
{
return(BadRequest("Несуществующий номер попытки"));
}
return(Ok(mapper.ConvertQuestionAnswerDTOToQuestionAnswerModel(teacher.GetQuestionAndAnswerByAttempt(attemptId))));
}
public IActionResult GetTestByGroupId(int groupId)
{
TeacherDataAccess teacher = new TeacherDataAccess();
Mapper mapper = new Mapper();
List <TestDTO> tests = teacher.GetTestByGroupId(groupId);
if (tests == null)
{
return(BadRequest("Группы не существет"));
}
return(Ok(mapper.ConvertTestDTOToTestModelList(teacher.GetTestByGroupId(groupId))));
}
public ActionResult <List <AllTestsByStudentIdOutputModel> > GetGetAllStudentsByTestId(int testId)
{
TeacherDataAccess teacher = new TeacherDataAccess();
Mapper mapper = new Mapper();
AuthorDataAccess tests = new AuthorDataAccess();
var test = tests.GetTestById(testId);
if (test == null)
{
return(BadRequest("Теста не существует"));
}
return(Ok(mapper.ConvertAllStudentTestsDTOToAllTestsByStudentIdOutputModel(teacher.GetStudentsByTestId(testId))));
}
public studentProfile()
{
login = new LoginHistoryDataAccess();
userId = login.getLastLogin();
MessageBox.Show(userId + " buccho");
InitializeComponent();
StartPosition = FormStartPosition.CenterScreen;
studentDataAccess = new StudentDataAccess();
admindataAccess = new AdminDataAccess();
teacherDataAccess = new TeacherDataAccess();
initialMethod();
}
public frmAdminUpNotice()
{
InitializeComponent();
comboBox1.Items.Add("Teacher");
comboBox1.Items.Add("Student");
comboBox1.Items.Add("Both");
StartPosition = FormStartPosition.CenterScreen;
studentDataAccess = new StudentDataAccess();
adminDataAccess = new AdminDataAccess();
teacherDataAccess = new TeacherDataAccess();
noticeDataAccess = new NoticeDataAccess();
dataGridView1.DataSource = adminDataAccess.getNoticeList();
}
public IActionResult GetCorrectAnswersByTestId(int testId)
{
TeacherDataAccess teacher = new TeacherDataAccess();
Mapper mapper = new Mapper();
List <QuestionAnswerDTO> tests = teacher.GetCorrectAnswerByTestId(testId);
if (tests == null)
{
return(BadRequest("Теста не существует"));
}
return(Ok(mapper.ConvertQuestionAnswerDTOToQuestionAnswerModel(teacher.GetCorrectAnswerByTestId(testId))));
}
public frmAdminStartup()
{
login = new LoginHistoryDataAccess();
currentUser = login.getLastLogin();
InitializeComponent();
StartPosition = FormStartPosition.CenterScreen;
comboBox1.Items.Add("Teacher");
comboBox1.Items.Add("Student");
studentDataAccess = new StudentDataAccess();
admindataAccess = new AdminDataAccess();
teacherDataAccess = new TeacherDataAccess();
}
public ActionResult GetUserResultByTestIdUserId(int testid, int userid)
{
if (new TestCRUD().GetById(testid) == null)
{
return(BadRequest("Теста с таким id не существует"));
}
if (new UserCRUD().GetByID(userid) == null)
{
return(BadRequest("Пользователя с таким id не существует"));
}
TeacherDataAccess access = new TeacherDataAccess();
return(Ok(new Mapper().ConverUserTestWithQuestionsAndAnswersDTOToBestAttemptModel(access.GetAttemptsByUserIdTestId(userid, testid))));
}
public IActionResult Index(int?value)
{
//dropwdown list
List <SelectListItem> items = new List <SelectListItem>();
SelectListItem item1 = new SelectListItem()
{
Text = "Select Option", Value = "null"
};
SelectListItem item2 = new SelectListItem()
{
Text = "Teacher", Value = "1"
};
SelectListItem item3 = new SelectListItem()
{
Text = "Staff", Value = "2"
};
items.Add(item1);
items.Add(item2);
items.Add(item3);
ViewBag.Options = items;
if (value != null)
{
ViewBag.Value = value;
}
//Teacher Model
List <teacherModel> teacher = new List <teacherModel>();
teacher = TeacherDataAccess.LoadTeachers();
ViewBag.Teachers = teacher;
//Staff Model
List <staffModel> staff = new List <staffModel>();
staff = StaffDataAccess.LoadStaff();
ViewBag.Staff = staff;
return(View());
}
public IActionResult ClassCreate()
{
List <teacherModel> teachers = new List <teacherModel>();
teachers = TeacherDataAccess.LoadTeachers();
teachers.Insert(0, new teacherModel {
TeacherId = 0, fname = "Select"
});
ViewBag.Teachers = teachers;
var dictionary = new Dictionary <int, int>
{
{ 9, 9 },
{ 10, 10 }
};
ViewBag.SelectList = new SelectList(dictionary, "Key", "Value");
return(View());
}
public IActionResult PostTestForGroup([FromBody] TestGroupInputModel test)
{
AdminDataAccess adm = new AdminDataAccess();
var group = adm.GetGroupById(test.groupId.Value);
if (group == null)
{
return(BadRequest("Группа не существует"));
}
AuthorDataAccess author = new AuthorDataAccess();
var t = author.GetTestById(test.testId.Value);
if (t == null)
{
return(BadRequest("Тест не существует"));
}
if (test.testId == null)
{
return(BadRequest("Не выбран тест"));
}
if (test.groupId == null)
{
return(BadRequest("Не выбрана группа"));
}
if (string.IsNullOrWhiteSpace(test.startDate))
{
return(BadRequest("Отсутствует дата начала теста"));
}
if (string.IsNullOrWhiteSpace(test.endDate))
{
return(BadRequest("Отсутствует дата окончания теста"));
}
Mapper mapper = new Mapper();
TeacherDataAccess teacher = new TeacherDataAccess();
int id = teacher.SetTestForGroup(mapper.ConvertTestGroupInputModelToTestGroupDTO(test));
return(Ok(id));
}
public IActionResult UpdateTeacher(teacherModel m)
{
TeacherDataAccess.Update(m);
return(RedirectToAction("Index"));
}
public IActionResult TeacherCreate(teacherModel m)
{
TeacherDataAccess.CreateNew(m);
return(RedirectToAction("Index"));
}
