private service invoque(TSQLCommands command, string query)
{
try
{
WebApiConfig.DbCnnCnfg.Clear();
WebApiConfig.DbCnnCnfg.Add("Provider", valida.header(Request, "Provider"));
WebApiConfig.DbCnnCnfg.Add("CnnString", System.Text.Encoding.UTF8.GetString(System.Convert.FromBase64String(valida.header(Request, "CnnString"))));
if (valida.parameter(query))
{
new System.ArgumentException(Resources.REST_Service_Parametros_Incorrectos);
}
query = HttpContext.Current.Server.UrlDecode(query);
List <string> querys = new List <string>(query.Split(';'));
if (!valida.query(querys, command))
{
throw new System.FormatException(Resources.REST_Service_Message_PERMISO_DENEGADO);
}
List <Models.structs.response> dataResults = new List <Models.structs.response>();
foreach (string item in querys)
{
if (!string.IsNullOrEmpty(item.Trim()))
{
Models.structs.response data = new Models.structs.response();
data.Command = item.Replace(System.Environment.NewLine, string.Empty);
switch (WebApiConfig.DbCnnCnfg["Provider"].Trim().ToLower())
{
case "sqlserver":
data.Result = getSqlServer.genericQuery(command, item);
break;
case "mysqlserver":
data.Result = getMySqlServer.genericQuery(command, item);
break;
}
dataResults.Add(data);
}
}
return(Libs.response.make(dataResults));
}
catch (Exception ex)
{
return(Libs.response.make(Resources.REST_Service_Status_code_ERROR, Resources.REST_Service_Status_response_ERROR, ex.Message));
}
}
private service invoque(TSQLCommands command, string query)
{
try
{
WebApiConfig.DbCnnCnfg.Clear();
WebApiConfig.DbCnnCnfg.Add("Provider", valida.header(Request, "Provider"));
WebApiConfig.DbCnnCnfg.Add("CnnString",System.Text.Encoding.UTF8.GetString(System.Convert.FromBase64String(valida.header(Request, "CnnString"))));
if (valida.parameter(query))
new System.ArgumentException(Resources.REST_Service_Parametros_Incorrectos);
query = HttpContext.Current.Server.UrlDecode(query);
List<string> querys = new List<string>(query.Split(';'));
if (!valida.query(querys, command))
throw new System.FormatException(Resources.REST_Service_Message_PERMISO_DENEGADO);
List<Models.structs.response> dataResults = new List<Models.structs.response>();
foreach (string item in querys)
{
if (!string.IsNullOrEmpty(item.Trim()))
{
Models.structs.response data = new Models.structs.response();
data.Command = item.Replace(System.Environment.NewLine, string.Empty);
switch (WebApiConfig.DbCnnCnfg["Provider"].Trim().ToLower())
{
case "sqlserver":
data.Result = getSqlServer.genericQuery(command, item);
break;
case "mysqlserver":
data.Result = getMySqlServer.genericQuery(command, item);
break;
}
dataResults.Add(data);
}
}
return Libs.response.make(dataResults);
}
catch (Exception ex)
{
return Libs.response.make(Resources.REST_Service_Status_code_ERROR, Resources.REST_Service_Status_response_ERROR, ex.Message);
}
}
