public void InsertAccount(Guid tenantId, Guid accountId, string accountCode, string accountStatus, Guid personId)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var account = new AccountSummary
{
TenantIdentifier = tenantId,
AccountIdentifier = accountId,
AccountCode = accountCode,
AccountStatus = accountStatus,
OwnerIdentifier = personId
};
db.AccountSummaries.Add(account);
db.SaveChanges();
if (accountStatus == "Open")
{
var person = db.PersonSummaries.Single(x => x.PersonIdentifier == personId);
person.OpenAccountCount++;
db.SaveChanges();
}
Denormalize();
}
}
public void DeletePerson(Guid personId)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var p = db.PersonSummaries.Single(x => x.PersonIdentifier == personId);
db.PersonSummaries.Remove(p);
db.SaveChanges();
}
}
public void UpdateUserStatus(Guid user, string status)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var summary = db.UserSummaries.Single(x => x.UserIdentifier == user);
summary.UserRegistrationStatus = status;
db.SaveChanges();
}
}
public void UpdateTransfer(Guid aggregateIdentifier, string status, string activity)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var summary = db.TransferSummaries.Single(x => x.TransferIdentifier == aggregateIdentifier);
summary.TransferStatus = status;
summary.TransferActivity = activity;
db.SaveChanges();
}
}
public void UpdatePersonName(Guid personId, string personName)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var person = db.PersonSummaries.Single(x => x.PersonIdentifier == personId);
person.PersonName = personName;
db.SaveChanges();
Denormalize();
}
}
public void IncreaseAccountBalance(Guid accountId, decimal amount)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var account = db.AccountSummaries.Single(x => x.AccountIdentifier == accountId);
account.AccountBalance += amount;
var person = db.PersonSummaries.Single(x => x.PersonIdentifier == account.OwnerIdentifier);
person.TotalAccountBalance += amount;
db.SaveChanges();
}
}
public void InsertUser(Guid user, string name, string password, string status)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var summary = new UserSummary
{
UserIdentifier = user,
LoginName = name,
LoginPassword = password,
UserRegistrationStatus = status
};
db.UserSummaries.Add(summary);
db.SaveChanges();
}
}
public void InsertPerson(Guid tenantId, Guid personId, string personName, DateTimeOffset personRegistered)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var summary = new PersonSummary
{
TenantIdentifier = tenantId,
PersonIdentifier = personId,
PersonName = personName,
PersonRegistered = personRegistered
};
db.PersonSummaries.Add(summary);
db.SaveChanges();
}
}
public void UpdateAccountStatus(Guid accountId, string accountStatus)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var account = db.AccountSummaries.Single(x => x.AccountIdentifier == accountId);
account.AccountStatus = accountStatus;
if (accountStatus != "Open")
{
var person = db.PersonSummaries.Single(x => x.PersonIdentifier == account.OwnerIdentifier);
person.OpenAccountCount--;
}
db.SaveChanges();
}
}
public void InsertTransfer(Guid tenant, Guid transfer, string status, Guid fromAccount, Guid toAccount, decimal amount)
{
using (var db = new QueryDbContext(DatabaseConnectionString))
{
var summary = new TransferSummary
{
TenantIdentifier = tenant,
TransferIdentifier = transfer,
TransferStatus = status,
TransferAmount = amount,
FromAccountIdentifier = fromAccount,
ToAccountIdentifier = toAccount
};
db.TransferSummaries.Add(summary);
db.SaveChanges();
}
Denormalize();
}
