kirill19837 / mediaremove Goto Github PK

public class BlockGridEditorParser : BaseTextParser
{
    public override bool IsParserFor(string propertyEditorAlias)
    {
        return propertyEditorAlias.Equals("Umbraco.BlockGrid");
    }
}

mediaService.MoveToRecycleBin(mediaService.GetById(id));

if (!string.IsNullOrWhiteSpace(root.Model.Source))
                        {
                            string src = "";

                            if (root.Model.Source.ToLower().Trim().StartsWith("/media"))
                            {
                                src = root.Model.Source.ToLower().Trim();
                            }
                            else
                            {
                                JObject json = JObject.Parse(root.Model.Source);
                                src = json["src"].Value<string>();
                            }                            

                            if (!string.IsNullOrWhiteSpace(src))
                            {
                                this.logger.Info<MediaRemoveController>("querying: " + src);

                                var result = db.Query<string>("SELECT Data FROM [dbo].[cmsContentNu] where data like '%" + src + "%' and published > 0 and rv > 0 ");

                                if (result != null && result.Count() > 0)
                                {
                                    //referenced in the site but not using Umbraco ID, so do not delete
                                    mediaRemoveContext.JustAMessage += src + " |";
                                    this.logger.Info<MediaRemoveController>("referenced but not using UDI: " + src);
                                }
                                else
                                {
                                    this.logger.Info<MediaRemoveController>("unused: " + src);
                                    mediaRemoveContext.UnusedMedia.Add(root);
                                }
                            }
                        }