private void Initialize()
{
try
{
//Inicializa conexion sqlite
Ambiente.SqliteConnectionString = Application.StartupPath + @"\config.s3db";
Ambiente.SqliteConnection = new SQLiteConnection(string.Format("Data Source={0};Version=3;", Ambiente.SqliteConnectionString));
Ambiente.SqliteConnection.Open();
conexionController = new ConexionController();
//Llenar Empresas
CboEmpresa.DataSource = conexionController.SelectAll();
CboEmpresa.DisplayMember = "Empresa";
CboEmpresa.ValueMember = "ConexionId";
CboEmpresa.SelectedIndex = 0;
//Llenar Establecimientos
//CboEstablecimineto.DataSource = conexionController.SelectAll();
CboEstablecimineto.SelectedIndex = 0;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
public void ProcessRequest(HttpContext context)
{
try
{
string Rut = context.Request.QueryString["Rut"];
string Mes = context.Request.QueryString["Mes"];
string Anio = context.Request.QueryString["Anio"];
string usuario = context.Request.QueryString["Usuario"];
string contrasena = context.Request.QueryString["Clave"];
string retorno = "ERROR";
ConexionController conexion = new ConexionController();
try
{
if (!string.IsNullOrEmpty(usuario) && !string.IsNullOrEmpty(contrasena))
{
retorno = conexion.connectionsSAP(usuario, contrasena);
}
if (string.IsNullOrEmpty(retorno))
{
RfcDestination SapRfcDestination = RfcDestinationManager.GetDestination(conexion.connectorConfig);
RfcRepository SapRfcRepository = SapRfcDestination.Repository;
IRfcFunction BapiGetUser = SapRfcRepository.CreateFunction("ZHR_LIQ_SUE");
BapiGetUser.SetValue("I_RUT", Rut);
BapiGetUser.SetValue("I_MES", Mes);
BapiGetUser.SetValue("I_ANO", Anio);
BapiGetUser.Invoke(SapRfcDestination);
Byte[] bytes = (Byte[])BapiGetUser.GetValue("PDF_LIQUI");
using (MemoryStream input = new MemoryStream(bytes))
{
using (MemoryStream output = new MemoryStream())
{
string password = Rut;
PdfReader reader = new PdfReader(input);
PdfEncryptor.Encrypt(reader, output, true, password, password, PdfWriter.ALLOW_SCREENREADERS);
bytes = output.ToArray();
}
}
context.Response.Buffer = true;
context.Response.Charset = "";
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
context.Response.ContentType = "application/pdf";
context.Response.BinaryWrite(bytes);
context.Response.Flush();
context.Response.End();
}
}
catch (Exception e)
{
}
finally
{
}
}
catch (Exception ex)
{
}
}