public async Task <InstructorModel> GetForId(Guid Id) { InstructorModel instructor = null; var storeProcedure = "usp_instructor_id"; try{ var connection = _factoryConnection.GetConnection(); instructor = await connection.QueryFirstAsync <InstructorModel>( storeProcedure, new { InstructorId = Id }, commandType : CommandType.StoredProcedure ); }catch (Exception e) { throw new Exception("No se encontro el instructor", e); }finally{ _factoryConnection.CloseConnection(); } return(instructor); }
public async Task <InstructorModel> ObtainById(Guid id) { var storeProcedure = "usp_obtain_instructor_by_id"; InstructorModel instructor = null; try{ var connection = _factoryConnection.GetConnection(); instructor = await connection.QueryFirstAsync <InstructorModel>( storeProcedure, new{ Id = id }, commandType : CommandType.StoredProcedure ); _factoryConnection.CloseConexion(); return(instructor); }catch (Exception ex) { throw new Exception("Something wrong, dont found instructor", ex); } }