public static void SubmitAssignment(int id) { using (MyContext db = new MyContext()) { StudentAssignment SA = new StudentAssignment(); List <StudentAssignment> ASD = db.StudentAssignments.Where(x => x.StudentID == id).ToList(); Console.WriteLine($"{"ID",-3} {"Assignment",-11} {"Description",-17} {"Submission Date and Time",-25} {"Submitted",-10}\n"); foreach (var x in ASD) { Console.WriteLine($"{x.AssignmentID,-3} {x.Assignment.Title,-11} {x.Assignment.Description,-17} {x.Assignment.SubmissionDateAndTime,-25} {x.SubmittedYesorNo,-10}"); } Console.WriteLine("These are your Assignments\nWhich of these do you want to submit(select ID): "); int ass_id = Convert.ToInt32(Console.ReadLine()); StudentAssignment SA1 = db.StudentAssignments.Where(x => x.StudentID == id).Where(x => x.AssignmentID == ass_id).FirstOrDefault(); SA1.SubmittedYesorNo = "Yes"; db.SaveChanges(); Console.WriteLine("\nAssignment successfully Submited"); } }
public void UpdateScore(StudentAssignment assignment, decimal score, decimal?fineScore) { decimal assignmentFine = assignment.Assignment.FineAfterDeadline; if (assignmentFine != 0) { // Расчитать штраф автоматом if (fineScore == null) { DateTime?deadLine = _db.GroupAssignment.FirstOrDefault(x => x.AssignmentId == assignment.AssignmentId && x.GroupId == assignment.GroupId)?.DeadLine; if (deadLine != null && deadLine < assignment.Submitted) { fineScore = assignmentFine; score -= (decimal)fineScore; } } // Назначить другой штраф (возможно 0) else { fineScore = fineScore < 0 ? 0 : fineScore; score -= (decimal)fineScore; } } if (score < 0) { score = 0; } assignment.Score = score; }
public void TestRefreshCommandSucceeded() { var studentAssignmentToReturn = new StudentAssignment(); var dialogShown = false; var stubIDialogService = new StubIDialogService(); stubIDialogService.ShowAsync(async message => dialogShown = true); var refreshRequested = false; var stubIStudentService = new StubIStudentAssignmentService(); stubIStudentService.GetAsync(async id => { refreshRequested = true; return(new ServiceResult <StudentAssignment> { Status = ServiceResultStatus.OK, Result = studentAssignmentToReturn }); }); var studentAssignmentViewModel = new StudentAssignmentViewModel(stubIDialogService, stubIStudentService, null, null); studentAssignmentViewModel.RefreshCommand.Execute(null); Assert.IsFalse(dialogShown); Assert.IsTrue(refreshRequested); Assert.AreSame(studentAssignmentToReturn, studentAssignmentViewModel.StudentAssignment); }
public async Task <IActionResult> OnGet(int?simID) { if (simID == null) { return(NotFound()); } StudentQuestions = await Context.StudentQuestions .Include(q => q.Simulation) .Include(q => q.Question) .Where(q => q.SimulationID == simID && q.UserID == UserManager.GetUserId(User)) .ToListAsync(); StudentAssignment = Context.StudentAssignments .SingleOrDefault(a => a.UserID == UserManager.GetUserId(User) && a.SimulationID == simID); if (StudentQuestions == null || StudentQuestions.Count() == 0 || StudentAssignment == null) { return(NotFound()); } var isAuthorized = await AuthorizationService.AuthorizeAsync(User, StudentAssignment, Operations.ViewStudentAssignment); if (!isAuthorized.Succeeded) { return(Forbid()); } return(Page()); }
public ActionResult Edit([Bind(Include = "StudentAssignmentID,TeacherID,ClassID,SectionID,SubjectID,Title,Detail,AssignedDate,EndDate")] StudentAssignment studentassignment) { Session["err"] = "Error, Please check input fields"; Session["msg"] = ""; try { db.Entry(studentassignment).State = EntityState.Modified; db.SaveChanges(); Session["msg"] = "Modified Successfully"; Session["err"] = ""; return(RedirectToAction("Index")); } catch { } ViewBag.TeacherID = new SelectList(db.Teachers.OrderByDescending(e => e.Name), "TeacherID", "Name", studentassignment.TeacherID); ViewBag.ClassID = new SelectList(db.Classes.OrderByDescending(e => e.Name), "ClassID", "Name", studentassignment.ClassID); ViewBag.SectionID = new SelectList(db.Sections.OrderByDescending(e => e.Name), "SectionID", "Name", studentassignment.SectionID); ViewBag.SubjectID = new SelectList(db.Subjects.OrderByDescending(e => e.Name).Where(s => s.ClassID == studentassignment.ClassID), "SubjectID", "Name", studentassignment.SubjectID); ViewBag.Message = Session["msg"]; ViewBag.Error = Session["err"]; Session["err"] = ""; Session["msg"] = ""; return(View(studentassignment)); }
public static void SeeSDatesOfAssignmentperCourse(int id) { using (MyContext db = new MyContext()) { Student S1 = new Student(); S1 = db.Students.Find(id); StudentAssignment SA = new StudentAssignment(); List <StudentAssignment> SAA = db.StudentAssignments.Where(x => x.StudentID == id).ToList(); Console.WriteLine($"{"Course",-11} {"Assignment",-11} {"Submission Date and Time",-30} {"Submitted",-10}\n"); foreach (var x in S1.Courses) { foreach (var y in x.Assignments) { string submitted = "No"; foreach (var z in SAA) { if (z.AssignmentID == y.AssignmentID && z.SubmittedYesorNo == "Yes") { submitted = "Yes"; } } Console.WriteLine($"{x.Title,-11} {y.Title,-11} {y.SubmissionDateAndTime,-30} {submitted,-10}"); } } } }
public IActionResult OnGet(int?simId) { if (simId == null) { return(NotFound()); } StudentAssignment = Context.StudentAssignments .SingleOrDefault(m => m.UserID == UserManager.GetUserId(User) && m.SimulationID == simId.Value); if (StudentAssignment == null) { if (!SimulationExists(simId.Value)) { return(NotFound()); } StudentAssignment = new StudentAssignment { SimulationID = simId.Value }; } return(Page()); }
public ActionResult SubmitGradeAssignment(int assignmentGradeId, int grade, string instructorFeedback) { gds = new LMS_GRINDEntities1(); //Save grade to database StudentAssignment stuAssignment = gds.StudentAssignments.Where(x => x.assignment_grade_id == assignmentGradeId).FirstOrDefault(); int?id = gds.StudentAssignments.Where(x => x.assignment_grade_id == assignmentGradeId).Select(x => x.assignment_id).FirstOrDefault(); int ic_id = gds.Assignments.Where(x => x.assignment_id == id).Select(x => x.instructor_course_id).FirstOrDefault(); try { stuAssignment.grade = grade; stuAssignment.instructor_feedback = instructorFeedback; gds.SaveChanges(); AssignmentList.GenerateThisStudentsSubmissionsForCourse(stuAssignment.student_id, ic_id); } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { System.Console.WriteLine("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } } catch { return(View("GradeAssignmentView")); } return(RedirectToAction("InstructorGrading", new { assignmentId = id })); }
/// <summary> /// Instructor grade assignment individually /// </summary> /// <param name="assignmentId"></param> /// <returns></returns> public ActionResult GradeAssignment(int assignmentGradeId) { gds = new LMS_GRINDEntities1(); //Populate the page with individual assignment information StudentAssignment stuAssignment = gds.StudentAssignments.Where(x => x.assignment_grade_id == assignmentGradeId).FirstOrDefault(); int student_id = gds.StudentAssignments.Where(x => x.assignment_grade_id == assignmentGradeId).Select(x => x.student_id).FirstOrDefault(); int assignmentId = gds.StudentAssignments.Where(x => x.assignment_grade_id == assignmentGradeId).Select(x => x.assignment_id).FirstOrDefault(); Assignment thisAssignment = gds.Assignments.Where(x => x.assignment_id == assignmentId).FirstOrDefault(); String assignmentName = gds.Assignments.Where(x => x.assignment_id == assignmentId).Select(x => x.assignment_name).FirstOrDefault(); String firstName = gds.ulUsers.Where(x => x.ulUser_id == student_id).Select(x => x.first_name).FirstOrDefault(); String lastName = gds.ulUsers.Where(x => x.ulUser_id == student_id).Select(x => x.last_name).FirstOrDefault(); int courseId = gds.StudentCourses.Where(x => x.student_id == student_id).Select(x => x.course_id).FirstOrDefault(); int ic_id = gds.InstructorCourses.Where(x => x.course_id == courseId).Select(x => x.instructor_course_id).FirstOrDefault(); AssignmentList.GenerateThisStudentsSubmissionsForCourse(student_id, ic_id); ViewBag.AssignmentName = assignmentName; ViewBag.StudentName = firstName + " " + lastName; ViewBag.StudentId = stuAssignment.student_id; ViewBag.SubmissionDate = stuAssignment.submission_date; ViewBag.TextSubmission = stuAssignment.text_submission; ViewBag.FileSubmission = stuAssignment.file_submission; ViewBag.DueDate = thisAssignment.due_date; ViewBag.MaxPoints = thisAssignment.max_points; ViewBag.AssignmentGradeId = stuAssignment.assignment_grade_id; ViewBag.AssignmentId = assignmentId; ViewBag.CurrentGrade = stuAssignment.grade; ViewBag.Feedback = stuAssignment.instructor_feedback; return(View("GradeAssignmentView")); }
public static void CreateAssignmentHelpRequest(int studentId, int courseId, string assignmentName) { using (var c = new HrsContext()) { var student = c.Students.Find(studentId); if (student == null) { return; } var course = c.Courses.Find(courseId); if (course == null) { return; } var assignment = new Assignment() { Teacher = null, AssignmentName = assignmentName, CourseId = courseId }; c.Add(assignment); c.SaveChanges(); var helpRequest = new StudentAssignment() { StudentId = studentId, AssignmentId = assignment.AssignmentId, }; c.Add(helpRequest); c.SaveChanges(); } }
public ActionResult Submit(int id) { StudentAssignment studentassignment = db.StudentAssignments.Find(id); int studentid = 0; int roleid = Convert.ToInt16(Session["RoleID"].ToString()); if (roleid == 5) { int userid = Convert.ToInt16(Session["UserID"].ToString()); Student student = db.Students.Where(t => t.UserID == userid).FirstOrDefault(); studentid = student.StudentID; ViewBag.StudentID = new SelectList(db.Students.Where(s => s.ClassID == studentassignment.ClassID && s.SectionID == studentassignment.SectionID).OrderByDescending(e => e.Name), "StudentID", "Name", studentid); } if (studentid == 0) { ViewBag.StudentID = new SelectList(db.Students.Where(s => s.ClassID == studentassignment.ClassID && s.SectionID == studentassignment.SectionID).OrderByDescending(e => e.Name), "StudentID", "Name"); } StudentAssignmentSubmission studentassignmentsubmission = new StudentAssignmentSubmission(); studentassignmentsubmission.StudentAssignmentID = id; studentassignmentsubmission.StudentID = studentid; studentassignmentsubmission.Remarks = "Submitted asignment"; studentassignmentsubmission.SubmittedDate = DateTime.Now; ViewBag.Message = Session["msg"]; ViewBag.Error = Session["err"]; Session["err"] = ""; Session["msg"] = ""; return(View(studentassignmentsubmission)); }
static void CreateHelpRequestAssignment() { StudentAssignment newStudentAssignment = new StudentAssignment(); using (var _UnitOfWork = new UnitOfWork(new StudentHelperContext())) { Console.WriteLine("Current available student ID's:"); foreach (Student element in _UnitOfWork.Students.GetAll()) { Console.WriteLine(element.AUID); } } Console.WriteLine("Enter students AUID"); newStudentAssignment.StudentAUID = System.Console.ReadLine(); using (var _UnitOfWork = new UnitOfWork(new StudentHelperContext())) { Console.WriteLine("Current assignment ID's:"); foreach (Assignment element in _UnitOfWork.Assignments.GetAll()) { Console.WriteLine(element.AssignmentID); } } Console.WriteLine("Enter assignment ID"); newStudentAssignment.AssignmentID = int.Parse(System.Console.ReadLine()); using (var _UnitOfWork = new UnitOfWork(new StudentHelperContext())) { _UnitOfWork.HelpRequests.AddHelpRequestAssignment(newStudentAssignment); _UnitOfWork.Complete(); } }
/// <summary> /// The SendPushNotificationToTeacher. /// </summary> /// <param name="studAssignment">The studAssignment<see cref="StudentAssignment"/>.</param> /// <returns>The <see cref="Task"/>.</returns> private async Task SendPushNotificationToTeacher(StudentAssignment studAssignment) { try { var assignments = await _tableStorage.GetAllAsync <Entites.Assignment>("Assignment"); var assignment = assignments.SingleOrDefault(assignment => assignment.RowKey == studAssignment.AssignmentId); var pushNotification = new PushNotification { Title = studAssignment.StudentName, Body = $"Upload assignment: {assignment.AssignmentName}" }; var userData = await _tableStorage.GetAllAsync <Entites.User>("User"); var user = userData.FirstOrDefault(s => s.RowKey == assignment.CreatedBy); if (!String.IsNullOrEmpty(user.NotificationToken)) { pushNotification.RecipientDeviceToken = user.NotificationToken; await _pushNotificationService.SendAsync(pushNotification); } } catch (Exception ex) { throw new AppException("Exception thrown in Notify Service: ", ex.InnerException); } }
public static void UNRelateStudentsAssignments() { using (MyContext db = new MyContext()) { Console.WriteLine($"{"StudentID",-10} {"First Name",-10} {"Last Name",15} {"AssID",-10} {"Title",-10}"); foreach (var x in db.StudentAssignments) { Console.WriteLine($"{x.StudentID,-10} {db.Students.Find(x.StudentID).FirstName,-10} {db.Students.Find(x.StudentID).LastName,15} {x.AssignmentID,-10} {db.Assignments.Find(x.AssignmentID).Title,-10}"); } Console.WriteLine("\nPLease select the Students and the Assignments to UN-relate\n"); Console.WriteLine("Select a student ID from the list: "); int id_s = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Select an Assignment ID from the list: "); int id_a = Convert.ToInt32(Console.ReadLine()); // StudentAssignment SA = new StudentAssignment(); StudentAssignment SA = db.StudentAssignments.Where(x => x.StudentID == id_s).Where(y => y.AssignmentID == id_a).FirstOrDefault(); db.StudentAssignments.Remove(SA); db.SaveChanges(); Console.WriteLine("Remove has been successfully done\n"); } }
/// <summary> /// 提交个人作业。 /// </summary> /// <param name="groupAssignment">个人作业。</param> /// <returns>服务结果。</returns> public async Task <ServiceResult> SubmitAsync( StudentAssignment studentAssignment) { var studentAssignmentToSubmit = new StudentAssignment { StudentID = studentAssignment.StudentID, HomeworkID = studentAssignment.HomeworkID, Score = studentAssignment.Score, Solution = studentAssignment.Solution }; var identifiedHttpMessageHandler = _identityService.GetIdentifiedHttpMessageHandler(); using (var httpClient = new HttpClient(identifiedHttpMessageHandler)) { var json = JsonConvert.SerializeObject(studentAssignmentToSubmit); HttpResponseMessage response; try { response = await httpClient.PutAsync( App.ServerEndpoint + "/api/StudentAssignment/" + studentAssignment.HomeworkID, new StringContent(json, Encoding.UTF8, "application/json")); } catch (Exception e) { return(new ServiceResult { Status = ServiceResultStatus.Exception, Message = e.Message }); } var serviceResult = new ServiceResult { Status = ServiceResultStatusHelper.FromHttpStatusCode( response.StatusCode) }; switch (response.StatusCode) { case HttpStatusCode.Unauthorized: case HttpStatusCode.Forbidden: break; case HttpStatusCode.NoContent: break; case HttpStatusCode.BadRequest: serviceResult.Message = await response.Content.ReadAsStringAsync(); break; default: serviceResult.Message = response.ReasonPhrase; break; } return(serviceResult); } }
public static void RelateStudentsAssignments() { using (MyContext db = new MyContext()) { GetAllStudents(); AssignmentManager.GetAllAssignments(); Console.WriteLine("\nPLease relate the Students and the Assignments they have\n"); Console.WriteLine("Select a student ID from the student's list: "); int id_s = Convert.ToInt32(Console.ReadLine()); Console.WriteLine("Select a Assignment ID from the Assignments' list: "); int id_a = Convert.ToInt32(Console.ReadLine()); // Assignment A = new Assignment(); Assignment A1 = db.Assignments.Find(id_a); // Student S = new Student(); Student S1 = db.Students.Find(id_s); StudentAssignment SA = new StudentAssignment(); SA.Student = S1; SA.Assignment = A1; SA.StudentID = id_s; SA.AssignmentID = id_a; db.StudentAssignments.Add(SA); db.SaveChanges(); Console.WriteLine("Input has been successfully submitted\n"); } }
public async Task <IActionResult> NeedReview(int id) { StudentAssignment assignment = await _assignmentService.GetStudentAssignmentById(id); if (assignment == null) { return(NotFound()); } if (assignment.StudentId != _userService.UserId) { return(Forbid()); } if (assignment.Status != AssignmentStatus.ChangesRequested) { return(BadRequest("Вы не можете изменить статус")); } _assignmentService.NeedReview(assignment); await _db.SaveChangesAsync(); // TODO: //await _teacherHub.NewAssignment(assignment.AssignmentId, id, assignment.Assignment.TeacherId); return(Ok()); }
public async Task <IActionResult> Update(int id, StudentAssignmentDto assignmentDto) { StudentAssignment assignment = await _assignmentService.GetStudentAssignmentById(id); if (assignment == null) { return(NotFound()); } if (assignment.StudentId != _userService.UserId) { return(Forbid()); } if (!_assignmentService.IsAllowedToUpdate(assignment)) { return(BadRequest("Вы не можете редактировать работу")); } assignmentDto.AssignmentId = assignment.Id; _mapper.Map(assignmentDto, assignment); _db.Update(assignment); await _db.SaveChangesAsync(); return(Ok()); }
public async Task <IActionResult> PutStudentAssignment(int id, StudentAssignment studentAssignment) { if (id != studentAssignment.StuAssignId) { return(BadRequest()); } _context.Entry(studentAssignment).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudentAssignmentExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IHttpActionResult getMarks(int lesson) { try { StudentAssignment up = new StudentAssignment(); string connectionString = @"Data Source=MALIKKALEEM\SQLEXPRESS01;Initial Catalog=fyp;Integrated Security=True;User ID=sa;Password=l23"; SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("select * from StudentAssignment where LessonNO=" + lesson + "", con); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { up.Marks = int.Parse(sdr["Marks"].ToString()); if (up.Marks > 0) { return(Ok(up)); } else { continue; } } con.Close(); return(Ok(up)); } catch (Exception ex) { return(BadRequest(ex.ToString())); } }
public ActionResult DeleteConfirmed(int id) { StudentAssignment studentAssignment = db.StudentAssignments.Find(id); db.StudentAssignments.Remove(studentAssignment); db.SaveChanges(); return(RedirectToAction("Index")); }
public static SubmissionRepository Get(StudentAssignment studentAssignment) { return(Get( studentAssignment.Assignment.CourseId, studentAssignment.Enrollment.UserName.Trim().ToLowerInvariant(), studentAssignment.AssignmentId.GetValueOrDefault(), true )); }
public void CloseHelpRequestAssignment(StudentAssignment studentAssignment) { var entity = Context.StudentAssignments.First(item => item.StudentAUID == studentAssignment.StudentAUID && item.AssignmentID == studentAssignment.AssignmentID); entity.IsOpen = false; Context.StudentAssignments.Update(entity); }
public static WorkRepository Get(StudentAssignment studentAssignment) { return(Get( studentAssignment.Assignment.CourseId, studentAssignment.Enrollment.UserName, studentAssignment.AssignmentId.GetValueOrDefault(), true )); }
public ActionResult SubmitAssignment(string text_submission, HttpPostedFileBase assignment_file) { gds = new LMS_GRINDEntities1(); StudentAssignment sa = new StudentAssignment(); if (AssignmentList.AssignmentItem.SubmissionType == "File") { if (assignment_file != null) { var instructor = (from ic in gds.InstructorCourses where ic.instructor_course_id == AssignmentList.AssignmentItem.InstructorCourseId select ic).First(); var instructor_l_name = (from i in gds.ulUsers where i.ulUser_id == instructor.instructor_id select i).First(); string course_directory = instructor_l_name.last_name + "_" + AssignmentList.AssignmentItem.CourseNum; string student_directory = Name.first_name + Name.last_name; string file_name = Path.GetFileNameWithoutExtension(assignment_file.FileName) + DateTime.Now.ToString("yymmssfff") + Path.GetExtension(assignment_file.FileName); // Set file path to the course directory within the Assignment Submissions folder string file_path = Path.Combine(Server.MapPath("~/AssignmentSubmissions/"), file_name); sa.file_submission = "~/AssignmentSubmissions/" + file_name; sa.assignment_id = AssignmentList.AssignmentItem.AssignmentId; sa.student_id = Name.user_id; sa.submission_date = DateTime.Now; assignment_file.SaveAs(file_path); gds.StudentAssignments.Add(sa); gds.SaveChanges(); ViewBag.IsSubmitted = true; } else { ViewBag.IsSubmitted = false; } } else // TEXT SUBMISSION { sa.text_submission = text_submission; sa.assignment_id = AssignmentList.AssignmentItem.AssignmentId; sa.student_id = Name.user_id; sa.submission_date = DateTime.Now; gds.StudentAssignments.Add(sa); gds.SaveChanges(); ViewBag.IsSubmitted = true; } ToDoList.GenerateStudentToDoList(); return(View("StudentAssignmentView")); }
/*public void UpdateStatus(StudentAssignment assignment, AssignmentStatus status) * { * assignment.Status = status; * switch (status) * { * case AssignmentStatus.Submitted: * assignment.Submitted = DateTime.UtcNow; * break; * case AssignmentStatus.ChangesRequested: * // change LastStatusChange * break; * case AssignmentStatus.NeedReview: * * case AssignmentStatus.Approved: * assignment.Completed = DateTime.UtcNow; * break; * default: * throw new ArgumentOutOfRangeException(nameof(status), status, null); * } * * assignment.LastStatusChange = DateTime.UtcNow; * }*/ public void Approve(StudentAssignment assignment, decimal score, decimal?fineScore) { DateTime now = DateTime.UtcNow; assignment.Completed = now; assignment.LastStatusChange = now; assignment.Status = AssignmentStatus.Approved; UpdateScore(assignment, score, fineScore); }
public static void SubmitAnAssignment(int studentId, int assignmentId) { using (SchoolContext db = new SchoolContext()) { Student student = db.Students.Find(studentId); Assignment assignment = db.Assignments.Find(assignmentId); StudentAssignment studentAssignment = db.StudentAssignments.Find(studentId, assignmentId); studentAssignment.IsSubmitted = true; } }
public ActionResult Edit([Bind(Include = "AssignmentId,StudentId,Grade")] StudentAssignment studentAssignment) { if (ModelState.IsValid) { db.Entry(studentAssignment).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.AssignmentId = new SelectList(db.Assignments, "AssignmentId", "Title", studentAssignment.AssignmentId); ViewBag.StudentId = new SelectList(db.Students, "StudentId", "FirstName", studentAssignment.StudentId); return(View(studentAssignment)); }
public IHttpActionResult getAnswer(int lesson, string userName) { try { StudentAssignment up = new StudentAssignment(); List <StudentAssignment> stlist = up.getListOfAnswer(lesson, userName); return(Ok(stlist)); }catch (Exception ex) { return(BadRequest(ex.ToString())); } }
public string PostAssignment(StudentAssignment sa) { try { //sa.AssignmentFile = Convert.FromBase64String(sa.base64); StudentAssignment s = new StudentAssignment(); string d = s.InsertAssignment(sa); return(d); }catch (Exception ex) { return(ex.ToString()); } }