< Summary - Syki

Information

Class:	Syki.Back.Features.Academic.GetCampusClasses.GetCampusClassesService
Assembly:	Back
File(s):	/home/runner/work/syki/syki/Back/Features/Academic/GetCampusClasses/GetCampusClassesService.cs
Tag:	21_17346963026

Line coverage

Branch coverage

Method coverage

Feature is only available for sponsors

Metrics

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

#	Line	Line coverage
	`1`	`using Dapper;`
	`2`	`using Npgsql;`
	`3`
	`4`	`namespace Syki.Back.Features.Academic.GetCampusClasses;`
	`5`
0	`6`	`public class GetCampusClassesService(SykiDbContext ctx, NpgsqlDataSource dataSource) : IAcademicService`
	`7`	`{`
	`8`	`public async Task<List<GetCampusClassesOut>> Get(Guid institutionId, Guid campusId)`
	`9`	`{`
0	`10`	`await using var connection = await dataSource.OpenConnectionAsync();`
	`11`
0	`12`	`var period = await ctx.GetCurrentAcademicPeriod(institutionId);`
	`13`
	`14`	`const string sql = @"`
	`15`	`SELECT`
	`16`	`c.id,`
	`17`	`c.discipline_id,`
	`18`	`d.name AS discipline,`
	`19`	`c.vacancies,`
	`20`	`c.workload,`
	`21`	`c.status,`
	`22`	`c.teacher_id,`
	`23`	`t.name AS teacher`
	`24`	`FROM`
	`25`	`syki.classes c`
	`26`	`INNER JOIN`
	`27`	`syki.disciplines d ON d.id = c.discipline_id`
	`28`	`LEFT JOIN`
	`29`	`syki.teachers t ON t.id = c.teacher_id`
	`30`	`WHERE`
	`31`	`c.institution_id = @InstitutionId`
	`32`	`AND`
	`33`	`c.campus_id = @CampusId`
	`34`	`AND`
	`35`	`c.period_id = @PeriodId`
	`36`	`ORDER BY`
	`37`	`d.name`
	`38`	`";`
	`39`
0	`40`	`var parameters = new`
0	`41`	`{`
0	`42`	`campusId,`
0	`43`	`institutionId,`
0	`44`	`PeriodId = period.Id`
0	`45`	`};`
	`46`
0	`47`	`return (await connection.QueryAsync<GetCampusClassesOut>(sql, parameters)).ToList();`
0	`48`	`}`
	`49`	`}`