public void ProcessRequest(HttpContext context) { var queryStringConverter = new QueryStringConverter(); var parameters = queryStringConverter .ConvertToParameters(context.Request.QueryString); string procedure = queryStringConverter.StoredProcedure; string connectionName = queryStringConverter.ConnectionName; context.Response.ContentType = "application/json"; context.Response.ContentEncoding = Encoding.UTF8; List<SourceTarget> sourceTargets = context.Application["SourceTargets"] as List<SourceTarget>; // Does this procedure and connection combo exist var matchedSourceTarget = FetchMatchingSourceTarget(procedure, connectionName, sourceTargets); if (matchedSourceTarget != null) { var dataProvider = new DataProvider(matchedSourceTarget.ConnectionString, procedure); var records = dataProvider.SetParameters(parameters) .ExecuteStoredProcedure(); context.Response.Write(JsonConvert.SerializeObject(records)); } else { context.Response.Write(string.Empty); } }
public void CanConvertStringOfDatesToString() { string theDateString = @"12/31/2012,1/1/2011"; var nvCollection = new NameValueCollection(); nvCollection.Add("DateString", theDateString); var queryStringConverter = new QueryStringConverter(); var results = queryStringConverter.ConvertToParameters(nvCollection); Assert.AreEqual(1, results.Count); Assert.AreEqual(theDateString, results["DateString"].ToString()); }
public void CanConvertDelimitedStringToParameters() { // 15,'07/01/09','06/30/10','pai,app' string parameterSource = @"AgentID=15;StartDate=07/01/09;EndDate=06/30/10;StatusList=pai,app"; var queryStringConverter = new QueryStringConverter(); var converted = queryStringConverter.ConvertToParameters(parameterSource); Assert.AreEqual(15, converted["AgentID"]); }
public void CanExecProceWithConvertedParms() { // 15,'07/01/09','06/30/10','pai,app' int agentId = 15; DateTime startDate = new DateTime(2009, 7, 1); DateTime endDate = new DateTime(2010, 6, 30); string statusList = "pai,app"; string procedure = "sp_Report_Agent_Wity_Listing"; var dataProvider = new DataProvider(connection, procedure); var nvCollection = new NameValueCollection(); nvCollection.Add("AgentId", agentId.ToString()); nvCollection.Add("StartDate", startDate.ToShortDateString()); nvCollection.Add("EndDate", endDate.ToShortDateString()); nvCollection.Add("StatusList", statusList); var queryStringConverter = new QueryStringConverter(); var parameters = queryStringConverter.ConvertToParameters(nvCollection); var results = dataProvider.SetParameters(parameters) .ExecuteStoredProcedure(); Assert.AreEqual(36, results.Count); }
public void CanExcludeProcedureAndConnectionFromConversion() { string theDateString = @"12/31/2012,1/1/2011"; var nvCollection = new NameValueCollection(); nvCollection.Add("DateString", theDateString); nvCollection.Add("procedure", "sp_procedure"); nvCollection.Add("Connection", "the connection"); var queryStringConverter = new QueryStringConverter(); var results = queryStringConverter.ConvertToParameters(nvCollection); Assert.AreEqual(1, results.Count); Assert.AreEqual(theDateString, results["DateString"].ToString()); Assert.AreEqual("sp_procedure", queryStringConverter.StoredProcedure); Assert.AreEqual("the connection", queryStringConverter.ConnectionName); }
public void CanConvertStringToInt() { var queryStringConverter = new QueryStringConverter(); var nvCollection = new NameValueCollection(); nvCollection.Add("TheInteger", "32"); var results = queryStringConverter.ConvertToParameters(nvCollection); Assert.AreEqual(1, results.Count); Assert.AreEqual(32, results["TheInteger"]); }
public void CanConvertStringToDateTime() { var queryStringConverter = new QueryStringConverter(); var nvCollection = new NameValueCollection(); var theDate = new DateTime(2012, 12, 31); nvCollection.Add("TheDate", theDate.ToShortDateString()); var results = queryStringConverter.ConvertToParameters(nvCollection); Assert.AreEqual(1, results.Count); Assert.AreEqual(theDate, results["TheDate"]); }