Пример #1
0
        public async Task <string> GetDateByDateRange(string connection, string ProviderName, RangeDateParam obj)
        {
            httpClient.DefaultRequestHeaders.Accept.Clear();
            httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            var content  = new StringContent(JsonConvert.SerializeObject(obj), Encoding.UTF8, "application/json");
            var response = await httpClient.PostAsync("api/Values/GetDateRageData/" + connection + "," + ProviderName, content).Result.Content.ReadAsStringAsync();

            return(response);
        }
Пример #2
0
        public async Task <IEnumerable <object> > GetDateRageData(string connectionString, string ProviderName, [FromBody] RangeDateParam Value)
        {
            IEnumerable <object> output = null;

            switch (ProviderName.ToLower())
            {
            case "sqlserver":
                output = await exSp.GetDataByDateRange(connectionString, Value);

                break;

            case "postgresql":
                output = await PostgreSQLClass.GetDataByDateRange(connectionString, Value);

                break;

            //case "mysql":
            // reponse = await MySqlClass.GetChartsData(connectionString, value);
            //break;
            case "oracle":
                break;
            }
            return(output);
        }