| | | 1 | | namespace Syki.Back.Features.Academic.CreateNotification; |
| | | 2 | | |
| | 24 | 3 | | public class CreateNotificationService(SykiDbContext ctx) : IAcademicService |
| | | 4 | | { |
| | | 5 | | public async Task<NotificationOut> Create(Guid institutionId, CreateNotificationIn data) |
| | | 6 | | { |
| | 24 | 7 | | var notification = new Notification(institutionId, data.Title, data.Description, data.TargetUsers, data.Timeless |
| | | 8 | | |
| | 24 | 9 | | if (data.TargetUsers is UsersGroup.All or UsersGroup.Teachers) |
| | | 10 | | { |
| | 14 | 11 | | await CreateNotificationFor(institutionId, notification.Id, UserRole.Teacher); |
| | | 12 | | } |
| | 24 | 13 | | if (data.TargetUsers is UsersGroup.All or UsersGroup.Students) |
| | | 14 | | { |
| | 16 | 15 | | await CreateNotificationFor(institutionId, notification.Id, UserRole.Student); |
| | | 16 | | } |
| | | 17 | | |
| | 24 | 18 | | ctx.Add(notification); |
| | 24 | 19 | | await ctx.SaveChangesAsync(); |
| | | 20 | | |
| | 24 | 21 | | return notification.ToOut(); |
| | 24 | 22 | | } |
| | | 23 | | |
| | | 24 | | private async Task CreateNotificationFor(Guid institutionId, Guid notificationId, UserRole userRole) |
| | | 25 | | { |
| | 30 | 26 | | FormattableString sql = $@" |
| | 30 | 27 | | SELECT |
| | 30 | 28 | | u.id |
| | 30 | 29 | | FROM |
| | 30 | 30 | | syki.users u |
| | 30 | 31 | | INNER JOIN |
| | 30 | 32 | | syki.roles r ON r.name = {userRole.ToString()} |
| | 30 | 33 | | INNER JOIN |
| | 30 | 34 | | syki.user_roles ur ON ur.user_id = u.id AND ur.role_id = r.id |
| | 30 | 35 | | WHERE |
| | 30 | 36 | | u.institution_id = {institutionId} |
| | 30 | 37 | | "; |
| | | 38 | | |
| | 30 | 39 | | var usersIds = await ctx.Database.SqlQuery<Guid>(sql).ToListAsync(); |
| | | 40 | | |
| | 48 | 41 | | usersIds.ForEach(userId => ctx.UserNotifications.Add(new UserNotification(userId, notificationId))); |
| | 30 | 42 | | } |
| | | 43 | | } |