Ejemplo n.º 1
0
        public static async Task <JGN_Badges> Add(ApplicationDbContext context, JGN_Badges entity)
        {
            entity.icon = await processImage(context, entity.title, entity.icon);

            var _ga = new JGN_Badges()
            {
                title        = entity.title,
                description  = entity.description,
                icon         = entity.icon,
                icon_sm      = entity.icon_sm,
                icon_lg      = entity.icon_lg,
                category_id  = entity.category_id,
                type         = entity.type,
                icon_css     = entity.icon_css,
                priority     = entity.priority,
                credits      = entity.credits,
                xp           = entity.xp,
                price        = entity.price,
                notification = entity.notification,
                isdeduct     = entity.isdeduct,
                ilevel       = entity.ilevel,
                ishide       = entity.ishide,
                ismultiple   = entity.ismultiple
            };

            context.Entry(_ga).State = EntityState.Added;

            await context.SaveChangesAsync();

            entity.id = _ga.id;


            return(entity);
        }
Ejemplo n.º 2
0
        public static async Task <JGN_Badges> Update(ApplicationDbContext context, JGN_Badges entity)
        {
            entity.icon = await processImage(context, entity.title, entity.icon);

            var item = context.JGN_Badges
                       .Where(p => p.id == entity.id)
                       .FirstOrDefault <JGN_Badges>();

            item.title        = UtilityBLL.processNull(entity.title, 0);
            item.description  = string.Join(",", entity.description);
            item.icon         = UtilityBLL.processNull(entity.icon, 0);
            item.icon_sm      = UtilityBLL.processNull(entity.icon_sm, 0);
            item.icon_lg      = UtilityBLL.processNull(entity.icon_lg, 0);
            item.category_id  = entity.category_id;
            item.type         = entity.type;
            item.icon_css     = entity.icon_css;
            item.priority     = entity.priority;
            item.credits      = entity.credits;
            item.xp           = entity.xp;
            item.price        = entity.priority;
            item.notification = entity.notification;
            item.isdeduct     = entity.isdeduct;
            item.ilevel       = entity.ilevel;
            item.ishide       = entity.ishide;
            item.ismultiple   = entity.ismultiple;

            context.Entry(item).State = EntityState.Modified;
            await context.SaveChangesAsync();

            return(entity);
        }
Ejemplo n.º 3
0
        public static bool Delete(ApplicationDbContext context, int id, string filename)
        {
            removeImages(filename);

            var filterID = id;
            var list     = from s in context.JGN_Badges_LevelAssociates
                           where s.levelid.Equals(filterID)
                           select s;

            var items = list.ToList();

            foreach (var item in items)
            {
                context.JGN_Badges_LevelAssociates.Attach(item);
                context.JGN_Badges_LevelAssociates.Remove(item);
                context.SaveChanges();
            }

            // remove badge
            var bentity = new JGN_Badges {
                id = id
            };

            context.JGN_Badges.Attach(bentity);
            context.JGN_Badges.Remove(bentity);
            context.SaveChanges();

            return(true);
        }