We would like to create a windows service (or scheduled task) to automate some special order processing.
1). Is this even possible?
2). Is there a recommended way to accomplish external processes?
Thanks
We would like to create a windows service (or scheduled task) to automate some special order processing.
1). Is this even possible?
2). Is there a recommended way to accomplish external processes?
Thanks
There are many ways of doing it. We have a number of .ashx pages which are called from windows schedule items.
http://www.esedirect.co.uk
--------------------------------------------------------------------------
Using MS 9.2.0.0 with the following customisations:
Lightbox/Fancybox enlarged images;
Auto-suggest searchbox;
Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
Failed transactions emailed via trigger;
Custom app to show basket contents when customer online;
Orders pushed through to accounting systems.
All the above without source!
Here's the content of an .ashx page that is scheduled to run every day at 11:30 on our webserver:
As you can see it outputs some text to the calling application, in this case IE, and it runs a stored procedure on the server. The scheduler closes the IE session after 2mins. Actually it could close it immediately because the sp returns nothing to the IE window.Code:<%@ WebHandler Language="C#" Class="YourPageNameHere" %> using System; using System.Web; using System.Data.SqlClient; using AspDotNetStorefrontCore; public class YourPageNameHere: IHttpHandler { public void ProcessRequest (HttpContext context) { DB.ExecuteSQL("EXEC YourSPNameHere"); context.Response.Write("<root>This page is scheduled to run every day @11:30 and will auto-close after 2 mins.</root>"); } public bool IsReusable { get { return false; } } }
I've changed the names to protect the innocent!
http://www.esedirect.co.uk
--------------------------------------------------------------------------
Using MS 9.2.0.0 with the following customisations:
Lightbox/Fancybox enlarged images;
Auto-suggest searchbox;
Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
Failed transactions emailed via trigger;
Custom app to show basket contents when customer online;
Orders pushed through to accounting systems.
All the above without source!