public async Task <bool> AddAsync(string smeu, DateTime date, ulong author, ulong messageid)
{
// has the smeu been submitted before?
using (SmeuContext database = smeuBaseFactory.GetSmeuBase())
{
Submission dbresult = (from s in database.Submissions
where s.Smeu == smeu
orderby s.Date
select s).FirstOrDefault();
if (dbresult != null)
{
// create a duplicate if an original already exists
database.Duplicates.Add(new Duplicate {
Author = author, Date = date, MessageId = messageid, Original = dbresult
});
await database.SaveChangesAsync().ConfigureAwait(false);
return(false);
}
else
{
// otherwise add it to the database
database.Submissions.Add(new Submission {
Author = author, Date = date, MessageId = messageid, Smeu = smeu
});
await database.SaveChangesAsync().ConfigureAwait(false);
return(true);
}
}
}
public async Task <bool> SuspendAsync(ulong user, ulong suspender, string reason, Duplicate duplicate = null)
{
if (GetUserSuspension(user) != null)
{
// if user is already suspended, return feedback to user
return(false);
}
// if there is no suspension, add one to the database
using (SmeuContext database = smeuBaseFactory.GetSmeuBase())
{
Suspension suspension = new Suspension {
User = user, Date = DateTime.UtcNow, Suspender = suspender, Reason = reason
};
database.Suspensions.Add(suspension);
if (duplicate != null)
{
// if a duplicate was given, update the duplicate to reflect the suspension
duplicate.Suspension = suspension;
database.Duplicates.Update(duplicate);
}
await database.SaveChangesAsync().ConfigureAwait(false);
}
return(true);
}
private async Task AddPendingSmeuToChat()
{
// get the smeu channel and add all the un-assigned smeu to it
if (!(client.GetChannel(settings.SmeuChannelId) is IMessageChannel smeuChannel))
{
await logger.LogAsync(new LogMessage(LogSeverity.Warning, "RestoreService", $"Could not restore pending smeu, because something went wrong while acquiring the smeu text channel")).ConfigureAwait(false);
return;
}
using (SmeuContext database = smeuBaseFactory.GetSmeuBase())
{
// get all unassigned smeu from the chat
var dbresult = from s in database.Submissions
where s.MessageId == 0
select s;
await logger.LogAsync(new LogMessage(LogSeverity.Info, "RestoreService", $"Found {dbresult.Count()} smeu to restore.")).ConfigureAwait(false);
foreach (Submission submission in dbresult)
{
// send all unassigned smeu to the chat and update the database
IUserMessage msg = await smeuChannel.SendMessageAsync(submission.Smeu).ConfigureAwait(false);
submission.MessageId = msg.Id;
}
database.Submissions.UpdateRange(dbresult);
await database.SaveChangesAsync().ConfigureAwait(false);
await logger.LogAsync(new LogMessage(LogSeverity.Info, "RestoreService", "All smeu are restored")).ConfigureAwait(false);
}
}
public async Task AddSmeu(Submission submission)
{
var smeuDao = new Submission
{
Date = submission.Date,
Smeu = submission.Smeu
};
smeuContext.Submissions.Add(smeuDao);
await smeuContext.SaveChangesAsync();
}
public async Task <bool> UnsuspendAsync(ulong user, ulong revoker)
{
Suspension suspension;
if ((suspension = GetUserSuspension(user)) == null)
{
// if there is no suspension, return feedback to the user
return(false);
}
else
{
// if there is a suspension, add the revoker to it.
suspension.Revoker = revoker;
using (SmeuContext context = smeuBaseFactory.GetSmeuBase())
{
context.Suspensions.Update(suspension);
await context.SaveChangesAsync().ConfigureAwait(false);
}
return(true);
}
}
public async Task <bool> RemoveAsync(string smeu, ulong author)
{
using (SmeuContext database = smeuBaseFactory.GetSmeuBase())
{
// first check if this combination is a duplicate
Duplicate duplicate = (from d in database.Duplicates
where d.Author == author && d.Original.Smeu == smeu
orderby d.Date descending
select d).FirstOrDefault();
if (duplicate != null)
{
// remove the duplicate
IMessage msg = await(client.GetChannel(settings.SmeuChannelId) as IMessageChannel).GetMessageAsync(duplicate.MessageId).ConfigureAwait(false);
await msg.DeleteAsync().ConfigureAwait(false);
database.Duplicates.Remove(duplicate);
await database.SaveChangesAsync().ConfigureAwait(false);
return(true);
}
// check if there is an original
Submission submission = await(from s in database.Submissions
where s.Author == author && s.Smeu == smeu
select s).Include(x => x.Duplicates).FirstOrDefaultAsync().ConfigureAwait(false);
if (submission != null)
{
// remove the original message
IMessage msg = await(client.GetChannel(settings.SmeuChannelId) as IMessageChannel).GetMessageAsync(submission.MessageId).ConfigureAwait(false);
await msg.DeleteAsync().ConfigureAwait(false);
// check if a duplicate must take this submission's place
if (submission.Duplicates.Count > 0)
{
// if so, take the oldest duplicate and change the details of the submission to these.
duplicate = (from d in submission.Duplicates
orderby d.Date ascending
select d).First();
submission.Author = duplicate.Author;
submission.Date = duplicate.Date;
submission.MessageId = duplicate.MessageId;
database.Submissions.Update(submission);
database.Duplicates.Remove(duplicate);
}
else
{
// if not, just remove the submission from the database
database.Submissions.Remove(submission);
}
await database.SaveChangesAsync().ConfigureAwait(false);
return(true);
}
// if there was no duplicate and no original, return failure
return(false);
}
}