blob: a6bd4b952ba6c1e0a923ce04886cee9e52621870 (
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
|
/*
* Copyright (c) 2022 Vaughn Nugent
*
* Library: VNLib
* Package: Transactional Emails
* File: TransactionStore.cs
*
* TransactionStore.cs is part of Transactional Emails which is part of the larger
* VNLib collection of libraries and utilities.
*
* Transactional Emails is free software: you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published
* by the Free Software Foundation, either version 2 of the License,
* or (at your option) any later version.
*
* Transactional Emails is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with Transactional Emails. If not, see http://www.gnu.org/licenses/.
*/
using System;
using System.Linq;
using Microsoft.EntityFrameworkCore;
using VNLib.Plugins.Extensions.Data;
namespace Emails.Transactional.Transactions
{
internal class TransactionStore : DbStore<EmailTransaction>
{
private readonly DbContextOptions Options;
public TransactionStore(DbContextOptions options)
{
Options = options;
}
public override TransactionalDbContext NewContext() => new EmailDbCtx(Options);
public override string RecordIdBuilder => Guid.NewGuid().ToString("N");
protected override void OnRecordUpdate(EmailTransaction newRecord, EmailTransaction oldRecord)
{
oldRecord.LastModified = DateTime.UtcNow;
}
protected override IQueryable<EmailTransaction> GetCollectionQueryBuilder(TransactionalDbContext context, params string[] constraints)
{
string userId = constraints[0];
//Get the last transactions for the specifed user
EmailDbCtx ctx = context as EmailDbCtx;
return from trans in ctx.EmailTransactions
where trans.UserId == userId
orderby trans.LastModified descending
select trans;
}
protected override IQueryable<EmailTransaction> GetSingleQueryBuilder(TransactionalDbContext context, params string[] constraints)
{
string transactionid = constraints[0];
EmailDbCtx ctx = context as EmailDbCtx;
//Selet the exact transaction from its id
return from trans in ctx.EmailTransactions
where trans.Id == transactionid
select trans;
}
}
}
|
