public void handleConnectRequest(HttpListenerContext context) { try { ConnectionDto connParams = readResponseAsJson <ConnectionDto>(context.Request); MsSqlRequestService msSqlRequestService = new MsSqlRequestService(connParams.server, connParams.database); sendAnswerWithCode(context.Response, 200); } catch (Exception ex) { Console.WriteLine(ex.Message); sendStaticResourceWithCode(context.Response, JObject.FromObject(new { errorMessage = ex.Message }).ToString(), "application/json", 406); return; } }
public void handleDatabaseListRequest(HttpListenerContext context) { try { ConnectionDto connParams = readResponseAsJson <ConnectionDto>(context.Request); MsSqlRequestService msSqlRequestService = new MsSqlRequestService(connParams.server, "master"); List <string> databaseList = msSqlRequestService.requestDatabaseList(string.Format(Resources.connectionStringTemplate, connParams.server, "master")); sendStaticResource(context.Response, JArray.FromObject(databaseList).ToString(), "application/javascript"); } catch (Exception ex) { Console.WriteLine(ex.Message); sendStaticResourceWithCode(context.Response, JObject.FromObject(new { errorMessage = ex.Message }).ToString(), "application/json", 406); } }
public void handleServerObjectList(HttpListenerContext context) { try { ConnectionDto connParams = readResponseAsJson <ConnectionDto>(context.Request); MsSqlRequestService msSqlRequestService = new MsSqlRequestService(connParams.server.ToString(), connParams.database.ToString()); string result = JArray.FromObject(msSqlRequestService.requestAllServerObjectList()).ToString(); sendStaticResource(context.Response, result, "application/javascript"); } catch (Exception ex) { Console.WriteLine(ex.Message); sendStaticResourceWithCode(context.Response, JObject.FromObject(new { errorMessage = ex.Message }).ToString(), "application/json", 406); return; } }
public void handleGetObjTextRequest(HttpListenerContext context) { try { ConnectionDto connParams = readResponseAsJson <ConnectionDto>(context.Request); MsSqlRequestService msSqlRequestService = new MsSqlRequestService(connParams.server, connParams.database); string result = ""; string objectName = context.Request.QueryString[Resources.objectNameParam]; string schemaName = context.Request.QueryString[Resources.schemaNameParam]; if (objectName != null) { result = msSqlRequestService.requestDatabaseObjectInfo(objectName, schemaName); } sendStaticResource(context.Response, result, "text/html"); } catch (Exception ex) { Console.WriteLine(ex.Message); sendStaticResourceWithCode(context.Response, JObject.FromObject(new { errorMessage = ex.Message }).ToString(), "application/json", 406); return; } }