Delete all the records of the ContactUs form

Have you registered this task in Kentico admin and have it executed?

Yes I have added this code in a class..Is the structure of the code wrong??

You need to create a scheduled task in the CMS 'Scheduled tasks' application. Just read and follow the whole documentation page please. https://docs.kentico.com/k12/configuring-kentico/scheduling-tasks/scheduling-custom-tasks

There you can configure your custom task to be used as a scheduled task.

Code looks fine, the issue is that system does not executes it currently. As Arjan said, you need to register scheduled task in Kentico admin and either run/execute a task manually or schedule execution.

The task is in a scheduled task and it does not work

What do you mean when you say "does not work?" Does the task execute? Is there any error message in Last result?

Have you tried debugging the task? Maybe the code name of the form isn't "ContactUs" but rather something like "ContactUs_1" so nothing is happening.

Does SiteContext.CurrentSiteID resolve to the correct value?

Your code adds event log record - can you see it?

The task has executed but the records are still in the database.

Have you tried to debug it?

Hi Theodoulos,

Looks like you don't need this code:

[assembly: RegisterCustomClass("Custom.CustomTask", typeof(Custom.CustomTask))]

public class CustomTask : ITask
{
    public string Execute(TaskInfo task)
    {
        throw new System.NotImplementedException();
    }
}

It might be confusing and you might have misselected wrong implementation in Scheduled Tasks application. Could you please post a screenshot of your task configuration in Kentico?

I delete this code i get error message.Can someone check this code?

What eeror message do you get? And where?

I get error on scheduling task.He cannot define the table where needs to select.

Could you post a screenshot or text of the error? Your explanation doesn't give much details. It's really hard to guess what you are talking about...

Error: Custom class 'Custom.CustomTask' was not found. Please make sure you register it properly using RegisterCustomClass attribute, or that you provide it through OnGetCustomClass event.

You need to keep this line in the code: [assembly: RegisterCustomClass("Custom.CustomTask", typeof(Custom.CustomTask))]
Delete just the duplicate method definition:

**public class CustomTask : ITask { public string Execute(TaskInfo task) { throw new System.NotImplementedException(); }}**

1)I have create a class on Visual Studio where I added this code 2)Next , on Scheduling task I have added this task 3)Next, when i am running this task the data of the forms continue to exist in the database

Ok, few more questions for Theodoulos:

1. Are you using Kentico 12 MVC? What is the exact version?
2. Is MVC, have you written your task code only for CMS (non-MVC) solution?

I've just tried the following code on fresh installation of Kentico 12 MVC and it worked well. I've added this class to CMSApp CMS project, into CMSModules folder:

using CMS.DataEngine;
using CMS.EventLog;
using CMS.OnlineForms;
using CMS.Scheduler;
using CMS.SiteProvider;

namespace CMSApp.CMSModules
{
    public class CustomTask : ITask
    {
        public string Execute(TaskInfo ti)
        {
            var details = "Custom scheduled task executed. Task data: " + ti.TaskData;

            EventLogProvider.LogInformation("CustomTask", "Execute", details);
            var formObject = BizFormInfoProvider.GetBizFormInfo("DancingGoatMvcContactUsNew", SiteContext.CurrentSiteID);

            if (formObject == null) return null;

            var formClass = DataClassInfoProvider.GetDataClassInfo(formObject.FormClassID);
            var formClassName = formClass.ClassName;

            var data = BizFormItemProvider.GetItems(formClassName)
                .WhereEmpty("TestText");

            foreach (var item in data)
            {
                BizFormInfoProvider.DeleteBizFormRecordFiles(formClass.ClassFormDefinition, item, SiteContext.CurrentSiteName);
                item.Delete();
            }

            return null;
        }
    }
}

This is how the task was configured in Kentico (registering custom class is not mandatory, you can just select ITask implementation from the assembly you are using):

In the code I was using DancingGoatMvcContactUsNew as form code name:

And this is the data before running the task:

This is after (you can see that all the records with empty Test text were removed):

The only other reason I can think of is that you may have some custom module that uses some Form events and cancels the delete operation or something, but that would have been strange..