< Summary

Information

Class:	Syki.Back.Features.Academic.GetTeachers.GetTeachersService
Assembly:	Back
File(s):	/home/runner/work/syki/syki/Back/Features/Academic/GetTeachers/GetTeachersService.cs
Tag:	22_11348620282

Line coverage

100%

Branch coverage

N/A

Method coverage

Feature is only available for sponsors

Metrics

Method	Branch coverage	Crap Score	Cyclomatic complexity	Line coverage
.ctor(...)	100%	1	1	100%
Get()	100%	1	1	100%

#	Line	Line coverage
	`1`	`namespace Syki.Back.Features.Academic.GetTeachers;`
	`2`
1	`3`	`public class GetTeachersService(SykiDbContext ctx) : IAcademicService`
	`4`	`{`
	`5`	`public async Task<List<TeacherOut>> Get(Guid institutionId)`
	`6`	`{`
1	`7`	`FormattableString sql = $@"`
1	`8`	`SELECT`
1	`9`	`t.id,`
1	`10`	`t.name,`
1	`11`	`u.email`
1	`12`	`FROM`
1	`13`	`syki.teachers t`
1	`14`	`INNER JOIN`
1	`15`	`syki.users u ON u.id = t.id`
1	`16`	`WHERE`
1	`17`	`u.institution_id = {institutionId}`
1	`18`	`ORDER BY`
1	`19`	`t.name`
1	`20`	`";`
	`21`
1	`22`	`var teachers = await ctx.Database.SqlQuery<TeacherOut>(sql).ToListAsync();`
	`23`
1	`24`	`return teachers;`
1	`25`	`}`
	`26`	`}`