blob: b0890a46f9712c99feeb71ab44564073692727a1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
|
using Microsoft.EntityFrameworkCore;
using BackendPIA.Models;
using BackendPIA.Forms;
namespace BackendPIA.Services {
public class RaffleService : IRaffleService {
private readonly ApplicationDbContext _context;
public RaffleService(ApplicationDbContext context) {
_context = context;
}
public async Task<Raffle> CreateRaffle(Raffle to_create) {
to_create.IsClosed = false;
await _context.AddAsync(to_create);
await _context.SaveChangesAsync();
return to_create;
}
public async Task<Raffle> UpdateRaffle(Raffle to_update) {
bool it_exists = _context.Raffles.Any(r => r.Id == to_update.Id);
if(!it_exists)
return null;
_context.Update(to_update);
await _context.SaveChangesAsync();
return to_update;
}
public async Task<IEnumerable<Raffle>> GetRaffles(string query) {
if(String.IsNullOrEmpty(query))
return await _context.Raffles.ToListAsync();
return _context.Raffles.FromSql($"SELECT * FROM \"Raffles\" AS r WHERE r.\"Name\" ILIKE {query}").ToList();
}
public async Task<Raffle> GetRaffle(long id) {
return await _context.Raffles.Include(r => r.Prizes).FirstOrDefaultAsync(r => r.Id == id);
}
public async Task<bool> DeleteRaffle(long id) {
var to_delete = await _context.Raffles.FindAsync(id);
if(to_delete == null)
return false;
_context.Raffles.Remove(to_delete);
await _context.SaveChangesAsync();
return true;
}
public async Task<IEnumerable<int>> GetTakenTickets(long id) {
return await _context.Tickets.Where(t => t.RaffleId == id).Select(t => t.Number).ToListAsync();
}
public IEnumerable<Ticket> GetRaffleTickets(long id) {
return _context.Tickets.Where(t => t.RaffleId == id);
}
public async Task<IEnumerable<RaffleWinner>> GetRaffleWinners(long id) {
return await _context.RaffleWinners.Include(rw => rw.UserAccount).Include(rw => rw.Raffle).Include(rw => rw.Prize)
.Where(rw => rw.RaffleId == id).ToListAsync();
}
public bool RaffleExists(long id) {
return _context.Raffles.Any(r => r.Id == id);
}
public IEnumerable<Prize> GetRafflePrizes(long id) {
return _context.Prizes.Where(p => p.RaffleId == id).ToList();
}
}
}
|
