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