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(); }