public static ReactionImage GetLastImage()
{
using var DbContext = new NamikoDbContext();
ReactionImage message = DbContext.Images.OrderByDescending(x => x.Id).FirstOrDefault();
return(message);
}
public static ReactionImage GetImage(int id)
{
using var DbContext = new NamikoDbContext();
ReactionImage message = DbContext.Images.Where(x => x.Id == id).FirstOrDefault();
return(message);
}
public static async Task DeleteImage(int id)
{
using var DbContext = new NamikoDbContext();
ReactionImage image = DbContext.Images.Where(x => x.Id == id).FirstOrDefault();
DbContext.Images.Remove(image);
await DbContext.SaveChangesAsync();
}
public static async Task <ReactionImage> AddImage(string name, string url, ulong guildId = 0, int id = -1)
{
using var DbContext = new NamikoDbContext();
ReactionImage img;
if (id == -1)
{
img = new ReactionImage {
Name = name.ToLowerInvariant(), Url = url, GuildId = guildId
};
}
else
{
img = new ReactionImage {
Id = id, Name = name.ToLowerInvariant(), Url = url, GuildId = guildId
};
}
DbContext.Images.Add(img);
await DbContext.SaveChangesAsync();
return(img);
}
public static async Task UpdateImage(ReactionImage image)
{
using var db = new NamikoDbContext();
db.Images.Update(image);
await db.SaveChangesAsync();
}
