public void ProcesoConsultaDocumentoFiscal()
{
if (ValidarDatosConexion())
{
DBAxon db = new DBAxon();
Axon.DAL.Conexion oConexion = new Axon.DAL.Conexion();
string baseDatos = ConfigurationManager.AppSettings["BaseDatos"].ToString();
string dataSource = ConfigurationManager.AppSettings["DataSource"].ToString();
string userId = ConfigurationManager.AppSettings["UserId"].ToString();
string password = ConfigurationManager.AppSettings["Password"].ToString();
string dbLocale = ConfigurationManager.AppSettings["dbLocale"].ToString();
string clientLocale = ConfigurationManager.AppSettings["clientLocale"].ToString();
Axon.DAL.TipoConexion tipoConexion = (Axon.DAL.TipoConexion)Convert.ToInt32(ConfigurationManager.AppSettings["TipoConn"].ToString());
oConexion.CargarDatosConfiguracion(tipoConexion, baseDatos, dataSource, userId, password, clientLocale, dbLocale);
ServiceCensador serviceCensador = new ServiceCensador();
serviceCensador.EjecutarProcesoConsultaDocumentoFiscal();
}
}
public void ServicioGFEvalidacion()
{
if (ValidarDatosConexion())
{
DBAxon db = new DBAxon();
Axon.DAL.Conexion oConexion = new Axon.DAL.Conexion();
string baseDatos = ConfigurationManager.AppSettings["BaseDatos"].ToString();
string dataSource = ConfigurationManager.AppSettings["DataSource"].ToString();
string userId = ConfigurationManager.AppSettings["UserId"].ToString();
string password = ConfigurationManager.AppSettings["Password"].ToString();
string dbLocale = ConfigurationManager.AppSettings["dbLocale"].ToString();
string clientLocale = ConfigurationManager.AppSettings["clientLocale"].ToString();
Axon.DAL.TipoConexion tipoConexion = (Axon.DAL.TipoConexion)Convert.ToInt32(ConfigurationManager.AppSettings["TipoConn"].ToString());
oConexion.CargarDatosConfiguracion(tipoConexion, baseDatos, dataSource, userId, password, clientLocale, dbLocale);
DataTable facturas = null;
try
{
db.OpenFactoryConnection();
db.SetLockModeToWait();
string query = "SELECT FIRST 500 fehfeifee, fehfenfac, fehfeccuf FROM fehfe WHERE fehfeifee IS NOT NULL AND fehfenfac IS NOT NULL AND fehfeccuf IS NOT NULL";
facturas = db.DataAdapter(CommandType.Text, query);
}
catch (Exception ex)
{
Debug.WriteLine(ex.Message);
}
finally
{
db.CloseFactoryConnection();
db = null;
}
string request = @"{""tipoValidacion""= 12,""idDocFiscalFEEL"" = ""11"",""respuestaSIN"" = true,""codigoRecepcion"" = """",""estado"" = 903,""numeroFactura"" = 1,""cuf"" = ""BCA""}";
Debug.WriteLine("Iniciando - " + DateTime.Now.ToString("HH:mm:ss"));
Debug.WriteLine(facturas.Rows.Count + " facturas...");
foreach (DataRow f in facturas.Rows)
{
request = @"{""tipoValidacion"": 12,""idDocFiscalFEEL"" : ""[@idDoc]"",""respuestaSIN"" : true,""codigoRecepcion"": -1,""estado"": 903,""numeroFactura"": [@numFactu],""cuf"": ""[@cuf]""}";
request = request.Replace("[@idDoc]", f["fehfeifee"].ToString());
request = request.Replace("[@numFactu]", f["fehfenfac"].ToString());
request = request.Replace("[@cuf]", f["fehfeccuf"].ToString());
Stopwatch sw = new Stopwatch();
sw.Start();
//var restClient = new RestClient("http://localhost:64918/axon-gfe");
var restClient = new RestClient("http://190.104.3.139:1580/GFE/axon-gfe");
var rr = new RestRequest("validacion", Method.POST);
rr.AddParameter("application/json", request, ParameterType.RequestBody);
var resp = restClient.Execute(rr);
sw.Stop();
Debug.WriteLine(sw.ElapsedMilliseconds);
JObject res = JObject.Parse(resp.Content);
if (res.ContainsKey("codRespuesta"))
{
if (res["codRespuesta"].ToString() != "0")
{
throw new Exception("Retornó error: " + res["codRespuesta"].ToString() + " - " + res["txtRespuesta"]);
}
}
else
{
throw new Exception("no hay codRespuesta" + Environment.NewLine + resp.Content);
}
}
Debug.WriteLine("FIN - " + DateTime.Now.ToString("HH:mm:ss"));
}
}
