Beispiel #1
0
        public Result Update(List <MenuEntity> list, string type)
        {
            var con = new DapperConnectionManager();

            var queryList = new List <QueryEntity>();
            var query     = new QueryEntity
            {
                Query  = @"DELETE from Menus WHERE Type = @Type",
                Entity = new { Type = type },
            };

            queryList.Add(query);
            foreach (var item in list)
            {
                item.Type = type;
                var queryItem = new QueryEntity()
                {
                    Entity = item,
                    Query  = @"INSERT into Menus (Title, Href, Position, Type, Submenu, Separator) VALUES(@Title, @Href, @Position, @Type, @Submenu, @Separator)"
                };
                queryList.Add(queryItem);
            }
            var result = con.ExecuteQueries(queryList);

            result.Message = result.Success ? "The menu have been modifed" : "An error has ocurred";
            return(result);
        }