public async Task GetPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Channel.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, e.GetResource("pasta_error_no_arg")).SendToChannel(e.Channel);
return;
}
List <string> arguments = e.arguments.Split(' ').ToList();
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
GlobalPasta pasta = await context.Pastas.FindAsync(arguments[0]);
if (pasta == null)
{
await Utils.ErrorEmbed(locale, e.GetResource("miki_module_pasta_search_error_no_results", e.arguments)).SendToChannel(e.Channel);
return;
}
pasta.TimesUsed++;
await e.Channel.SendMessage(pasta.Text);
await context.SaveChangesAsync();
}
}
public async Task GetPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, "Please enter one of the tags, or commands."));
return;
}
List <string> arguments = e.arguments.Split(' ').ToList();
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
GlobalPasta pasta = await context.Pastas.FindAsync(arguments[0]);
if (pasta == null)
{
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, $"No pasta found with the name `{e.arguments}`"));
return;
}
pasta.TimesUsed++;
await e.Channel.SendMessage(pasta.Text);
await context.SaveChangesAsync();
}
}
public async Task IdentifyPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Channel.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, e.GetResource("infopasta_error_no_arg"))
.SendToChannel(e.Channel.Id);
return;
}
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
try
{
GlobalPasta pasta = await context.Pastas.FindAsync(e.arguments);
if (pasta == null)
{
await Utils.ErrorEmbed(locale, e.GetResource("miki_module_pasta_error_null")).SendToChannel(e.Channel);
return;
}
User creator = await context.Users.FindAsync(pasta.creator_id);
IDiscordEmbed b = Utils.Embed;
b.SetAuthor(pasta.Id.ToUpper(), "", "");
b.Color = new IA.SDK.Color(47, 208, 192);
if (creator != null)
{
b.AddInlineField(e.GetResource("miki_module_pasta_identify_created_by"), $"{ creator.Name} [{creator.Id}]");
}
b.AddInlineField(e.GetResource("miki_module_pasta_identify_date_created"), pasta.date_created.ToShortDateString());
b.AddInlineField(e.GetResource("miki_module_pasta_identify_times_used"), pasta.TimesUsed.ToString());
VoteCount v = pasta.GetVotes(context);
b.AddInlineField(e.GetResource("infopasta_rating"), $"⬆️ { v.Upvotes} ⬇️ {v.Downvotes}");
await b.SendToChannel(e.Channel);
}
catch (Exception ex)
{
Log.ErrorAt("IdentifyPasta", ex.Message);
}
}
}
public async Task SearchPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, "Please specify the terms you want to search.")
.SendToChannel(e.Channel.Id);
return;
}
List <string> arguments = e.arguments.Split(' ').ToList();
int page = 0;
if (arguments.Count > 1)
{
if (int.TryParse(arguments[arguments.Count - 1], out page))
{
page -= 1;
}
}
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
var pastasFound = context.Database.SqlQuery <PastaSearchResult>("select [GlobalPastas].Id, count(*) OVER() AS total_count from [GlobalPastas] where Id like @p0 ORDER BY id OFFSET @p1 ROWS FETCH NEXT 25 ROWS ONLY;",
"%" + arguments[0] + "%", page * 25).ToList();
if (pastasFound?.Count > 0)
{
string resultString = "";
pastasFound.ForEach(x => { resultString += "`" + x.Id + "` "; });
IDiscordEmbed embed = Utils.Embed;
embed.Title = "🔎 I found these pastas";
embed.Description = resultString;
embed.CreateFooter();
embed.Footer.Text = $"page {page + 1} of {(Math.Ceiling((double)pastasFound[0].Total_Count / 25)).ToString()}";
await e.Channel.SendMessage(embed);
return;
}
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, $"Sorry, but we couldn't find a pasta with `{arguments[0]}`"));
}
}
public async Task CreatePasta(EventContext e)
{
List <string> arguments = e.arguments.Split(' ').ToList();
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
if (arguments.Count < 2)
{
await Utils.ErrorEmbed(locale, "I couldn't find any content for this pasta, please specify what you want to make.").SendToChannel(e.Channel.Id);
return;
}
string id = arguments[0];
arguments.RemoveAt(0);
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
try
{
GlobalPasta pasta = await context.Pastas.FindAsync(id);
if (pasta != null)
{
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, "This pasta already exists! Try a different tag!"));
return;
}
context.Pastas.Add(new GlobalPasta()
{
Id = id, Text = string.Join(" ", arguments), CreatorId = e.Author.Id, date_created = DateTime.Now
});
await context.SaveChangesAsync();
await e.Channel.SendMessage(Utils.SuccessEmbed(locale, $"Created pasta `{id}`!"));
}
catch (Exception ex)
{
Log.ErrorAt("IdentifyPasta", ex.Message);
}
}
}
public async Task DeletePasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Channel.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, e.GetResource("miki_module_pasta_error_specify", e.GetResource("miki_module_pasta_error_specify")))
.SendToChannel(e.Channel.Id);
return;
}
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
GlobalPasta pasta = await context.Pastas.FindAsync(e.arguments);
if (pasta == null)
{
await Utils.ErrorEmbed(locale, e.GetResource("miki_module_pasta_error_null")).SendToChannel(e.Channel);
return;
}
if (pasta.CanDeletePasta(e.Author.Id))
{
context.Pastas.Remove(pasta);
List <PastaVote> votes = context.Votes.AsNoTracking().Where(p => p.Id.Equals(e.arguments)).ToList();
context.Votes.RemoveRange(votes);
await context.SaveChangesAsync();
await Utils.SuccessEmbed(locale, e.GetResource("miki_module_pasta_delete_success", e.arguments)).SendToChannel(e.Channel);
return;
}
await Utils.ErrorEmbed(locale, e.GetResource("miki_module_pasta_error_no_permissions", e.GetResource("miki_module_pasta_error_specify_delete"))).SendToChannel(e.Channel);
return;
}
}
public async Task DeletePasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, "Please specify which pasta you'd like to remove.")
.SendToChannel(e.Channel.Id);
return;
}
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
GlobalPasta pasta = await context.Pastas.FindAsync(e.arguments);
if (pasta == null)
{
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, "This pasta doesn't exist! check the tag!"));
return;
}
if (pasta.CanDeletePasta(e.Author.Id))
{
context.Pastas.Remove(pasta);
List <PastaVote> votes = context.Votes.AsNoTracking().Where(p => p.Id.Equals(e.arguments)).ToList();
context.Votes.RemoveRange(votes);
await context.SaveChangesAsync();
await e.Channel.SendMessage(Utils.SuccessEmbed(locale, $"Deleted pasta `{e.arguments}`!"));
return;
}
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, "This pasta is not yours!"));
return;
}
}
public async Task MyPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
int page = 0;
if (!string.IsNullOrWhiteSpace(e.arguments))
{
if (int.TryParse(e.arguments, out page))
{
page -= 1;
}
}
long authorId = e.Author.Id.ToDbLong();
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
var pastasFound = context.Database.SqlQuery <PastaSearchResult>("select [GlobalPastas].id, count(*) OVER() AS total_count from [GlobalPastas] where CreatorID = @p0 ORDER BY id OFFSET @p1 ROWS FETCH NEXT 25 ROWS ONLY;",
authorId, page * 25).ToList();
if (pastasFound?.Count > 0)
{
string resultString = "";
pastasFound.ForEach(x => { resultString += "`" + x.Id + "` "; });
IDiscordEmbed embed = Utils.Embed;
embed.Title = e.Author.Username + "'s pastas";
embed.Description = resultString;
embed.CreateFooter();
embed.Footer.Text = $"page {page + 1} of {(Math.Ceiling((double)pastasFound[0].Total_Count / 25)).ToString()}";
await e.Channel.SendMessage(embed);
return;
}
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, $"Sorry, but you don't have any pastas yet.."));
}
}
public async Task EditPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, "Please specify which pasta you'd like to edit.")
.SendToChannel(e.Channel.Id);
return;
}
if (e.arguments.Split(' ').Length == 1)
{
await Utils.ErrorEmbed(locale, "Please specify the content you'd like it to be edited to.")
.SendToChannel(e.Channel.Id);
return;
}
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
string tag = e.arguments.Split(' ')[0];
e.arguments = e.arguments.Substring(tag.Length + 1);
GlobalPasta p = await context.Pastas.FindAsync(tag);
if (p.CreatorId == e.Author.Id || Bot.instance.Events.Developers.Contains(e.Author.Id))
{
p.Text = e.arguments;
await context.SaveChangesAsync();
await e.Channel.SendMessage($"Edited `{tag}`!");
}
else
{
await e.Channel.SendMessage($@"You cannot edit pastas you did not create. Baka!");
}
}
}
private async Task VotePasta(EventContext e, bool vote)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
var pasta = await context.Pastas.FindAsync(e.arguments);
if (pasta == null)
{
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, "This pasta doesn't exist :(("));
return;
}
long authorId = e.Author.Id.ToDbLong();
var voteObject = context.Votes.AsNoTracking().Where(q => q.Id == e.arguments && q.__UserId == authorId).FirstOrDefault();
if (voteObject == null)
{
voteObject = new PastaVote()
{
Id = e.arguments, __UserId = e.Author.Id.ToDbLong(), PositiveVote = vote
};
context.Votes.Add(voteObject);
}
else
{
voteObject.PositiveVote = vote;
}
await context.SaveChangesAsync();
var votecount = pasta.GetVotes(context);
await e.Channel.SendMessage(Utils.SuccessEmbed(locale, $"Your vote has been updated!\nCurrent Score: `{votecount.Upvotes - votecount.Downvotes}`"));
}
}
public async Task IdentifyPasta(EventContext e)
{
Locale locale = Locale.GetEntity(e.Guild.Id.ToDbLong());
if (string.IsNullOrWhiteSpace(e.arguments))
{
await Utils.ErrorEmbed(locale, "Please state which pasta you'd like to identify.")
.SendToChannel(e.Channel.Id);
return;
}
using (var context = MikiContext.CreateNoCache())
{
context.Set <GlobalPasta>().AsNoTracking();
try
{
GlobalPasta pasta = await context.Pastas.FindAsync(e.arguments);
if (pasta == null)
{
await e.Channel.SendMessage(Utils.ErrorEmbed(locale, "This pasta doesn't exist!"));
return;
}
User creator = await context.Users.FindAsync(pasta.creator_id);
EmbedBuilder b = new EmbedBuilder();
b.Author = new EmbedAuthorBuilder();
b.Author.Name = pasta.Id.ToUpper();
b.Color = new Discord.Color(47, 208, 192);
if (creator != null)
{
b.AddField(x =>
{
x.Name = "Created by";
x.Value = $"{creator.Name} [{creator.Id}]";
x.IsInline = true;
});
}
b.AddField(x =>
{
x.Name = "Date Created";
x.Value = pasta.date_created.ToShortDateString();
x.IsInline = true;
});
b.AddInlineField("Times Used", pasta.TimesUsed);
b.AddField(x =>
{
x.Name = "Rating";
VoteCount v = pasta.GetVotes(context);
x.Value = $"⬆️ {v.Upvotes} ⬇️ {v.Downvotes}";
x.IsInline = true;
});
await e.Channel.SendMessage(new RuntimeEmbed(b));
}
catch (Exception ex)
{
Log.ErrorAt("IdentifyPasta", ex.Message);
}
}
}