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();
}
}
