public List <MarkDTO> GetAllMark(string _studentId) { List <MarkDTO> listMark = new List <MarkDTO>(); this.ConnectToDatabase(); MySqlCommand command = this.mySQLConnection.CreateCommand(); command.CommandText = "SELECT * FROM MARK where STUDENT_ID = " + _studentId; MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { string studentId = reader.GetString(0); string testId = reader.GetString(1); float grade = reader.GetFloat(2); MarkDTO mark = new MarkDTO(studentId, testId, grade); listMark.Add(mark); } reader.Close(); this.Close(); return(listMark); }
public HttpResponseMessage PostMark([FromBody] PostMarkDTO postDTO, string teacherId, int subjectId, int formId, string studentId) { string userId = ((ClaimsPrincipal)RequestContext.Principal).FindFirst(x => x.Type == "UserId").Value; string userRole = ((ClaimsPrincipal)RequestContext.Principal).FindFirst(x => x.Type == ClaimTypes.Role).Value; logger.Info("UserRole: " + userRole + ", UserId: " + userId + ": Requesting Mark Insert - " + "TeacherId: " + teacherId + ", SubjectId: " + subjectId + ", FormId: " + formId + ", StudentId: " + studentId); if (userRole == "admin" || userId == teacherId) { try { MarkDTO saved = marksService.Create(postDTO, teacherId, subjectId, formId, studentId); if (saved == null) { logger.Info("Failed!"); return(Request.CreateResponse(HttpStatusCode.BadRequest, "Failed!")); } logger.Info("Success!"); return(Request.CreateResponse(HttpStatusCode.OK, saved)); } catch (Exception e) { logger.Error(e); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, e)); } } logger.Info("Authorisation failure. User is not authorised for this request."); return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "Access Denied. " + "We’re sorry, but you are not authorized to perform the requested operation.")); }
public ActionResult AddMark(int?score, int?id) { if (score == null) { return(HttpNotFound()); } MarkDTO mark = new MarkDTO() { AuthorId = User.Identity.GetUserId(), PictureId = id.Value, Score = score.Value, Time = DateTime.Now }; try { photoService.AddMark(mark); } catch (ValidationException ex) { return(Content(ex.Message)); } int photoId = id.Value; return(RedirectToAction("Detail", new { id = photoId })); }
public int UpdateMark(MarkDTO editedMark) { using (var unitOfWork = unitOfWorkFactory.Get()) { var markRepository = unitOfWork.MarkRepository; var existingMark = markRepository.Get().SingleOrDefault(m => m.Id == editedMark.Id); if (existingMark == null) { var mark = new Mark { Value = editedMark.Value, Date = editedMark.Date, ChildId = editedMark.ChildId }; markRepository.Add(mark); unitOfWork.SaveChanges(); return(mark.Id); } else { existingMark.Value = editedMark.Value; markRepository.Edited(existingMark); unitOfWork.SaveChanges(); return(existingMark.Id); } } }
public async Task <IActionResult> PutMark([FromRoute] int id, [FromBody] MarkDTO markDto) { var mark = await _context.Marks.FirstOrDefaultAsync(m => m.ID == id); mark.IsAbsent = markDto.IsAbsent; mark.IsCredited = markDto.IsCredited; mark.Value = markDto.Value; mark.StudentId = markDto.Student.Id; mark.LessonId = markDto.Lesson.ID; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MarkExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public IEnumerable <MarkDTO> GetMarkByStudentUserName(string username) { IEnumerable <MarkDTO> mark = db.MarksRepository.Get(filter: x => x.Teaches.StudentDepartments.Students.UserName == username). Select(x => { MarkDTO markDTO = new MarkDTO(); markDTO.MarkValue = x.MarkValue; //markDTO.StudentName = x.Students.FirstName; //markDTO.StudentSurname = x.Students.LastName; //x.Teaches.Teachers. //markDTO.Teaches = new TeachesDTOOut(); //markDTO.Teaches.SubjectName = x.Teaches.Subjects.SubjectName; //markDTO.Teaches.StudentName = x.Teaches.e; //markDTO.Teaches.StudentSurname = x.Teaches.StudentSubjects.Students.LastName; //markDTO.Teaches.TeacherName = x.Teaches.Teachers.FirstName; // markDTO.Teaches.TeacherSurname = x.Teaches.Teachers.LastName; return(markDTO); }); if (mark.Count() < 1) { throw new UserNotFoundException($"Student with username {username} does not have any mark!!!"); } return(mark); }
public MarkDTO ConvertToMarkDTO(Mark x) { MarkDTO dto = new MarkDTO { Id = x.Id, MarkValue = x.MarkValue, Semester = x.Semester, Created = x.Created, StudentID = x.Student.Id, Student = x.Student.FirstName + " " + x.Student.LastName, SubjectID = x.FormToTeacherSubject.TeacherToSubject.Subject.Id, SubjectName = x.FormToTeacherSubject.TeacherToSubject.Subject.Name, TeacherID = x.FormToTeacherSubject.TeacherToSubject.Teacher.Id, Teacher = x.FormToTeacherSubject.TeacherToSubject.Teacher.FirstName + " " + x.FormToTeacherSubject.TeacherToSubject.Teacher.LastName, ParentID = x.Student.Parent.Id, FormID = x.Student.Form.Id, AttendingTeacherID = x.Student.Form.AttendingTeacher.Id, TeacherToSubjectID = x.FormToTeacherSubject.TeacherToSubject.Id, FormToTeacherToSubjectID = x.FormToTeacherSubject.Id }; return(dto); }
public static List <MarkDTO> loadMarkByNameWithoutSchoolYear(string idStudent, string nameClass, string semester, string nameSubject) { string sCommand = @"select* from dbo.Mark where IDStudent = '" + idStudent + "' and nameClass = '" + nameClass + "' and semester = " + int.Parse(semester) + "and IDSubject = '" + SubjectDTO.getIDSubject(nameSubject) + "'"; con = DataProvider.OpenConnection(); DataTable dt = DataProvider.GetDataTable(sCommand, con); List <MarkDTO> result = new List <MarkDTO>(); if (dt.Rows.Count <= 0) { DataProvider.CloseConnection(con); return(null); } else { for (int i = 0; i < dt.Rows.Count; i++) { MarkDTO temp = new MarkDTO(); temp.IDStudent = dt.Rows[i]["IDStudent"].ToString(); // temp.IdTeacher = dt.Rows[i]["IDTeacher"].ToString(); temp.NameClass = dt.Rows[i]["nameClass"].ToString(); temp.SchoolYear = dt.Rows[i]["schoolYear"].ToString(); temp.Subject.IdSubject = dt.Rows[i]["IDSubject"].ToString(); temp.Subject.NameSubject = SubjectDTO.getNameSubject(temp.Subject.IdSubject); temp.Semester = int.Parse(dt.Rows[i]["Semester"].ToString()); if (dt.Rows[i]["FirstFifteenMinutes"].ToString() != "") { temp.FirstFifteenMinutesMark = double.Parse(dt.Rows[i]["FirstFifteenMinutes"].ToString()); } if (dt.Rows[i]["SecondFifteenMinutes"].ToString() != "") { temp.SecondFifteenMinutesMark = double.Parse(dt.Rows[i]["SecondFifteenMinutes"].ToString()); } if (dt.Rows[i]["ThirdFifteenMinutes"].ToString() != "") { temp.ThirdFifteenMinutesMark = double.Parse(dt.Rows[i]["ThirdFifteenMinutes"].ToString()); } if (dt.Rows[i]["FirstFortyFiveMinutes"].ToString() != "") { temp.FirstFortyFiveMinutesMark = double.Parse(dt.Rows[i]["FirstFortyFiveMinutes"].ToString()); } if (dt.Rows[i]["SecondFortyFiveMinutes"].ToString() != "") { temp.SecondFortyFiveMinutesMark = double.Parse(dt.Rows[i]["SecondFortyFiveMinutes"].ToString()); } if (dt.Rows[i]["ThirdFortyFiveMinutes"].ToString() != "") { temp.ThirdFortyFiveMinutesMark = double.Parse(dt.Rows[i]["ThirdFortyFiveMinutes"].ToString()); } if (dt.Rows[i]["SemesterMark"].ToString() != "") { temp.SemesterScore = double.Parse(dt.Rows[i]["SemesterMark"].ToString()); } result.Add(temp); } DataProvider.CloseConnection(con); return(result); } }
public ActionResult <MarkVM> AddMark([FromBody] MarkDTO markDTO) { var mark = _mapper.Map <Mark>(markDTO); _markService.AddMark(mark); _markService.SaveChanges(); _log.Save(User.Identity.Name, "Dodano Markę", GetType().Name); return(Ok()); }
public void adding_auditdata() { MarkDTO dto = new MarkDTO(); dto.Task = _testMarkService.Get("1,10"); dto.Filter = "1,10"; var result = _testAuditService.AddAudit(dto); Assert.AreEqual(result.Result, 1); }
public MarkDTO GetByIDDTOFromService(int id) { Mark mark = db.MarksRepository.GetByID(id); if (mark != null) { MarkDTO dto = ConvertToMarkDTO(mark.Id); return(dto); } return(null); }
public void DeleteItem(MarkDTO item) { var mark = Mapper.Map <MarkDTO, Mark>(item); var findMark = _unitOfWork.MarkRepository.GetAll() .FirstOrDefault(mar => mar.Name == item.Name); if (findMark != null) { _unitOfWork.MarkRepository.Delete(findMark.Id); } }
public MarkDTO GetDTOByID(int id) { Mark mark = db.MarksRepository.GetByID(id); if (mark != null) { MarkDTO dto = toDTO.ConvertToMarkDTO(mark); return(dto); } return(null); }
public IList <MarkDTO> ConvertToMarkDTOList(List <Mark> marks) { IList <MarkDTO> dtos = new List <MarkDTO>(); foreach (var mark in marks) { MarkDTO dto = ConvertToMarkDTO(mark); dtos.Add(dto); } return(dtos); }
public IActionResult PutMark(int markId, [FromBody] MarkDTO markDTO) { var mark = universityContext.Marks.FirstOrDefault(s => s.Id == markId); mark.Type = markDTO.Type; mark.AtestationNo = markDTO.AtestationNo; universityContext.Entry(mark).State = EntityState.Modified; universityContext.SaveChanges(); return(Ok(new { Id = mark.Id, Status = mark.Status })); }
public bool UpdateMark(MarkDTO mark) { var markToUpdate = markRepository.Query(x => x.Id == mark.Id).FirstOrDefault(); if (markToUpdate != null) { markToUpdate.InjectFrom(mark); unitOfWork.Save(); return(true); } return(false); }
public async Task <Marks> AddMark(MarkDTO marks) { var mark = new Marks() { Name = marks.Name, Description = marks.Description, Image = marks.Image }; await context.Markses.AddAsync(mark); await context.SaveChangesAsync(); return(mark); }
public async Task <ActionResult> AddMark([FromBody] MarkDTO marks) { if (ModelState.IsValid) { var result = await marksService.AddMark(marks); if (result == null) { return(NotFound()); } return(Ok(result)); } return(BadRequest("Not correct query")); }
public MarkDTO Create(PostMarkDTO postDTO, string teacherId, int subjectId, int formId, string studentId) { FormToTeacherSubject foundFTS = formsToTeacherSubjectsService.FindFTSForMark(formId, teacherId, subjectId); Student foundStudent = studentsService.GetByID(studentId); if (foundStudent == null) { throw new HttpException("The student with id: " + studentId + " was not found."); } if (foundStudent.IsActive == false) { throw new HttpException("The student with id: " + studentId + " is no longer actively enrolled in this school."); } if (foundFTS.Form.Id != foundStudent.Form.Id) { throw new HttpException("The teacher (id: " + teacherId + ") does not teach the subject (" + subjectId + ") " + "in the student's (id: " + studentId + ") form."); } Mark mark = new Mark { MarkValue = postDTO.MarkValue, Created = DateTime.UtcNow, FormToTeacherSubject = foundFTS, Student = foundStudent }; if (DateTime.Today.Month > DateTime.ParseExact("Avgust", "MMMM", CultureInfo.CurrentCulture).Month) { mark.Semester = Semesters.FIRST_SEMESTER; } else { mark.Semester = Semesters.SECOND_SEMESTER; } db.MarksRepository.Insert(mark); db.Save(); emailsService.NewMarkMailForParent(mark.Id); emailsService.NewMarkMailForStudent(mark.Id); MarkDTO markDto = ConvertToMarkDTO(mark.Id); return(markDto); }
public bool InsertMark(MarkDTO mark) { this.ConnectToDatabase(); string Query = "insert into MARK values('" + mark.StudentId + "','" + mark.TestId + "','" + mark.Grade + "');"; //This is command class which will handle the query and connection object. MySqlCommand command = new MySqlCommand(Query, mySQLConnection); command.ExecuteNonQuery(); this.Close(); return(true); }
public ActionResult UpdateMark([FromBody] MarkDTO markDTO, int id) { var uMark = _markService.FindById(id); if (uMark == null) { return(NotFound()); } _mapper.Map(markDTO, uMark); _markService.UpdateMark(uMark); _markService.SaveChanges(); _log.Save(User.Identity.Name, "Edytowano Markę", GetType().Name); return(Ok()); }
public bool UpdateMark(MarkDTO mark) { this.ConnectToDatabase(); string Query = "update MARK set STUDENT_ID='" + mark.StudentId + "',TEST_ID = '" + mark.TestId + "',GRADE = '" + mark.Grade + "'"; //This is command class which will handle the query and connection object. MySqlCommand command = new MySqlCommand(Query, mySQLConnection); command.ExecuteNonQuery(); this.Close(); return(true); }
public IActionResult PostMark([FromBody] MarkDTO markDTO) { var student = universityContext.Students.FirstOrDefault(s => s.Id == markDTO.StudentId); var mark = new Mark { Value = markDTO.Value, Status = "building", Student = student }; // student.Marks.Add(mark); var createdMark = universityContext.Marks.Add(mark); universityContext.SaveChanges(); return(Ok(new { Id = createdMark.Entity.Id, Status = createdMark.Entity.Status })); }
public IEnumerable <MarkDTO> GetAllDTOsFromService() { IEnumerable <Mark> marks = db.MarksRepository.Get(); if (marks != null) { IList <MarkDTO> dtos = new List <MarkDTO>(); foreach (var mark in marks) { MarkDTO dto = ConvertToMarkDTO(mark.Id); dtos.Add(dto); } return(dtos); } return(null); }
public static bool InsertMark(MarkDTO mark) { string sCommand = string.Format(@"Insert into Mark values('{0}',{1},{2},{3},{4},{5},{6},{7},'{8}','{9}','{10}','{11}')", mark.Semester.ToString(), mark.FirstFifteenMinutesMark, mark.SecondFifteenMinutesMark, mark.ThirdFifteenMinutesMark, mark.FirstFortyFiveMinutesMark, mark.SecondFortyFiveMinutesMark, mark.ThirdFortyFiveMinutesMark, mark.SemesterScore, mark.IDStudent, mark.Subject.IdSubject, mark.NameClass, mark.SchoolYear); con = DataProvider.OpenConnection(); try { bool result = DataProvider.ExecuteQuery(sCommand, con); DataProvider.CloseConnection(con); return(result); } catch (Exception ex) { DataProvider.CloseConnection(con); return(false); } }
public void AddMark(MarkDTO markDto) { Photo photo = Database.Photos.Get(markDto.PictureId); if (photo != null) { var mapper = new MapperConfiguration(cfg => cfg.CreateMap <MarkDTO, Mark>()).CreateMapper(); Mark mark = mapper.Map <MarkDTO, Mark>(markDto); Database.Marks.Create(mark); Database.Save(); } else { throw new ValidationException("Photo can not be found", ""); } }
public IActionResult UpdateMark(int id, string value, int childId, DateTime date) { var user = GetUser(); if (!AdminService.IsAdmin(user)) { return(Unauthorized()); } var mark = new MarkDTO() { Id = id, ChildId = childId, Value = value, Date = date.Date }; id = RegisterService.UpdateMark(mark); return(Json(new { id })); }
public async Task <IActionResult> PostMark([FromBody] MarkDTO markDto) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } _context.Marks.Add(new Mark() { IsAbsent = markDto.IsAbsent, IsCredited = markDto.IsCredited, Value = markDto.Value, LessonId = markDto.Lesson.ID, StudentId = markDto.Student.Id }); await _context.SaveChangesAsync(); return(Ok()); }
public IEnumerable <MarkDTO> GetMarksDTOByTeacherId(string teacherId) { IList <Mark> marks = (List <Mark>)GetMarksByTeacherId(teacherId); if (marks.Count == 0) { throw new HttpException("Null"); } IList <MarkDTO> dtos = new List <MarkDTO>(); foreach (var mark in marks) { MarkDTO dto = ConvertToMarkDTO(mark.Id); dtos.Add(dto); } dtos = dtos.OrderBy(x => x.Student).ThenBy(x => x.Created).ToList(); return(dtos); }
private void SelectItem(object sender, MouseButtonEventArgs e) { if (listviewUser.SelectedItems.Count > 0) { MarkDTO item = (MarkDTO)listviewUser.SelectedItems[0]; //subject_st_infor.Text = item.IdSubject; fullname_st_infor.Text = item.NameStudent; id_st_infor.Text = item.IDStudent; class_st_infor.Text = item.NameClass; m15st_st_infor.Text = item.FirstFifteenMinutesMark.ToString(); m15nd_st_infor.Text = item.SecondFifteenMinutesMark.ToString(); m15rd_st_infor.Text = item.ThirdFifteenMinutesMark.ToString(); m45st_st_infor.Text = item.FirstFortyFiveMinutesMark.ToString(); m45nd_st_infor.Text = item.SecondFortyFiveMinutesMark.ToString(); m45rd_st_infor.Text = item.ThirdFortyFiveMinutesMark.ToString(); subject_st_infor.Text = item.Subject.NameSubject; semester_st_infor.Text = item.SemesterScore.ToString(); } }