public Response Insert(string dataObject)
        {
            IncomingWebRequestContext woc = WebOperationContext.Current.IncomingRequest;

            string fileName = woc.Headers["PhysicalFileName"];
            string key      = woc.Headers["SecretKey"];

            if (key != secretKey)
            {
                return(new Response {
                    Data = "Action Not authorized", ID = 500
                });
            }
            Response response = new Response();
            Object   obj      = new Object();

            JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
            iQueryProvider       queryProvider        = qFactory.GetQueryProvider("mssql");
            DatabaseAccess       dbAccess             = new DatabaseAccess();

            obj           = dbAccess.DeserializeToDomain(fileName, dataObject);
            response.Data = javaScriptSerializer.Serialize(queryProvider.Insert(fileName, obj));

            Logger("INSERT " + fileName + " - " + response.Data);
            return(response);
        }
        public Response DeleteAll()
        {
            IncomingWebRequestContext woc = WebOperationContext.Current.IncomingRequest;

            string fileName = woc.Headers["PhysicalFileName"];
            string key      = woc.Headers["SecretKey"];

            if (key != secretKey)
            {
                return(new Response {
                    Data = "Action Not authorized", ID = 500
                });
            }
            Response response = new Response();
            Object   obj      = new Object();

            JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
            iQueryProvider       queryProvider        = qFactory.GetQueryProvider("mssql");
            DatabaseAccess       dbAccess             = new DatabaseAccess();

            response.Data = javaScriptSerializer.Serialize(queryProvider.DeleteAll(fileName));
            return(response);
        }
        public Response SelectAll(string fileName)
        {
            IncomingWebRequestContext woc = WebOperationContext.Current.IncomingRequest;
            string key = woc.Headers["SecretKey"];

            if (key != secretKey)
            {
                return(new Response {
                    Data = "Action Not authorized", ID = 500
                });
            }
            JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer();
            iQueryProvider       queryProvider        = qFactory.GetQueryProvider("mssql");

            DatabaseAccess dbAccess = new DatabaseAccess();

            Response      response = new Response();
            List <Object> list     = new List <Object>();

            response.Data = javaScriptSerializer.Serialize(queryProvider.SelectAll(fileName));
            response.ID   = 200;

            return(response);
        }