public async Task <bool> Update(StudentViewModel vmStudent)
{
Core.Entities.Student student = _mapper.Map <Core.Entities.Student>(vmStudent);
student.LastUpdate = DateTime.Now;
_studentRepository.Update(student);
return(await _studentRepository.UnitOfWork.Save());
}
public async Task <StudentViewModel> Handle(GetStudentByIdQuery request, CancellationToken cancellationToken)
{
Core.Entities.Student student = await _store.Students.WithIdAsync(request.Id);
StudentViewModel studentViewModel = _mapper.Map <StudentViewModel>(student);
return(studentViewModel);
}
public async Task <bool> Delete(int id)
{
Core.Entities.Student student = await _studentRepository.GetById(id);
student.DeletedAt = DateTime.Now;
_studentRepository.Delete(student);
return(await _studentRepository.UnitOfWork.Save());
}
public async Task <StudentViewModel> GetById(int id)
{
Core.Entities.Student student = await _studentRepository.GetById(id);
StudentViewModel vmStudents = _mapper.Map <StudentViewModel>(student);
return(vmStudents);
}
public async Task <int> Update(Core.Entities.Student entity)
{
var sql = "UPDATE Students SET Name = @Name, Surname = @Surname WHERE Id = @Id";
using (var connection = new SqlConnection(configuration.GetConnectionString("DefaultConnection")))
{
connection.Open();
var affectedRows = await connection.ExecuteAsync(sql, entity);
return(affectedRows);
}
}
public async Task <int> Add(Core.Entities.Student entity)
{
var sql = "INSERT INTO Students (Name, Surname) VALUES (@Name, @Surname)";
using (var connection = new SqlConnection(configuration.GetConnectionString("DefaultConnection")))
{
connection.Open();
var affectedRows = await connection.ExecuteAsync(sql, entity);
return(affectedRows);
}
}
public async Task <StudentViewModel> Handle(UpdateStudentCommand request, CancellationToken cancellationToken)
{
Core.Entities.Student student = await _store.Students.WithIdAsync(request.Id);
student.FirstName = request.FirstName;
student.MiddleName = request.MiddleName;
student.LastName = request.LastName;
student.DateOfBirth = request.DateOfBirth;
student.UniversityName = request.UniversityName;
student.Major = request.Major;
await _store.SaveChangesAsync();
StudentViewModel studentViewModel = _mapper.Map <StudentViewModel>(student);
return(studentViewModel);
}
public async Task <bool> Create(StudentViewModel vmStudent)
{
Core.Entities.Student student = _mapper.Map <Core.Entities.Student>(vmStudent);
_studentRepository.Add(student);
return(await _studentRepository.UnitOfWork.Save());
}
