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); }