protected void gridSolicitudes_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.DataRow)
{
return;
}
//HyperLink link = (HyperLink)e.Row.FindControl("HyperLink1");
// if (link != null)
// {
// link.Text = "Abrir";
// String sQuery = "idtomodify=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString();
// sQuery = Utils.GetEncriptedQueryString(sQuery);
// String strRedirect = "~/frmAddSolicitud.aspx";
// strRedirect += sQuery;
// link.NavigateUrl = strRedirect;
// }
HyperLink link = (HyperLink)e.Row.FindControl("lnkSolicitud2010");
if (link != null)
{
String sQuery = "SolID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString();
sQuery = Utils.GetEncriptedQueryString(sQuery);
String strRedirect = "~/frmAddSolicitud2010.aspx";
strRedirect += sQuery;
link.NavigateUrl = strRedirect;
link.Text = "Abrir";
}
// LinkButton LB = (LinkButton)e.Row.FindControl("LBPrintSolicitud");
// if(LB!=null)
// {
// string sFileName = "SOLICITUD.pdf";
// sFileName = sFileName.Replace(" ", "_");
// String sURL = "frmDescargaTmpFile.aspx";
// string datosaencriptar;
// datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
// datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
// datosaencriptar += "impsol=1&";
// String URLcomplete = sURL + "?data=";
// URLcomplete += Utils.encriptacadena(datosaencriptar);
// //LinkButton l = new LinkButton();
// JSUtils.OpenNewWindowOnClick(ref LB,URLcomplete, "Solicitud ", true);
// LB.Text = "SOLICITUD";
// }
LinkButton LB = (LinkButton)e.Row.FindControl("LBPrintContrato");
if (LB != null)
{
string sFileName = "CONTRATO.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
datosaencriptar += "impcont=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "Contrato", true);
LB.Text = "CONTRATO";
}
// LB = (LinkButton)e.Row.FindControl("LBPrintCaratula");
// if(LB!=null)
// {
// string sFileName = "CARATULA_ANEXA.pdf";
// sFileName = sFileName.Replace(" ", "_");
// string sURL = "frmDescargaTmpFile.aspx";
// string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
// datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
// datosaencriptar += "impcar=1&";
// string URLcomplete = sURL + "?data=";
// URLcomplete += Utils.encriptacadena(datosaencriptar);
// LB.Text = "CARATULA ANEXA";
// JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "Caratula_Anexa", true);
// }
// LB = (LinkButton)e.Row.FindControl("LBPrintSeguro");
// if(LB!=null){
// string sFileName = "CONTRATO_SEGURO.pdf";
// sFileName = sFileName.Replace(" ", "_");
// string sURL = "frmDescargaTmpFile.aspx";
// string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
// datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
// datosaencriptar += "impseg=1&";
// string URLcomplete = sURL + "?data=";
// URLcomplete += Utils.encriptacadena(datosaencriptar);
// JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "Contrato Seguro", true);
// }
HyperLink lnk = (HyperLink)e.Row.FindControl("lnkPagare");
if (lnk != null)
{
Solicitudes sol;
if (this.IsSistemBanco)
{
sol = SolicitudesSisBancos.Get(int.Parse(this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString()));
}
else
{
sol = Solicitudes.Get(int.Parse(this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString()));
}
string sFileName = "PAGARE.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "creditoID=" + sol.CreditoID.ToString() + "&";
datosaencriptar += "solID=" + sol.SolicitudID.ToString() + "&";
datosaencriptar += "impPagare=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
lnk.NavigateUrl = this.Request.Url.ToString();
lnk.Text = "PAGARE";
JSUtils.OpenNewWindowOnClick(ref lnk, URLcomplete, "Pagare", true);
}
LB = (LinkButton)e.Row.FindControl("LBTermsAndCon");
if (LB != null)
{
string sFileName = "TERMINOS Y CONDICIONES.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
datosaencriptar += "imptermsandcond=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
LB.Text = "TERMINOS Y CONDICIONES";
JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "Terminos y condiciones", true);
}
LB = (LinkButton)e.Row.FindControl("LBSolicitud2010");
if (LB != null)
{
string sFileName = "SOLICITUD.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
datosaencriptar += "impSol2010=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "Solicitud", true);
LB.Text = "SOLICITUD";
}
LB = (LinkButton)e.Row.FindControl("LBBuroCredito");
if (LB != null)
{
string sFileName = "BUROCREDITO.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
datosaencriptar += "buroCredito=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "BuroCredito", true);
LB.Text = "BURO";
}
LB = (LinkButton)e.Row.FindControl("LBCartaCompromiso");
if (LB != null)
{
string sFileName = "CARTACOMPROMISO.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
datosaencriptar += "cartaCompromiso=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "CartaCompromiso", true);
LB.Text = "CARTA COMPROMISO";
}
LB = (LinkButton)e.Row.FindControl("LBEvaluacion");
if (LB != null)
{
string sFileName = "EVALUACION.pdf";
sFileName = sFileName.Replace(" ", "_");
string sURL = "frmDescargaTmpFile.aspx";
string datosaencriptar = "filename=" + sFileName + "&ContentType=application/pdf&";
datosaencriptar = datosaencriptar + "solID=" + this.gridSolicitudes.DataKeys[e.Row.RowIndex]["solicitudID"].ToString() + "&";
datosaencriptar += "evaluacion=1&";
string URLcomplete = sURL + "?data=";
URLcomplete += Utils.encriptacadena(datosaencriptar);
JSUtils.OpenNewWindowOnClick(ref LB, URLcomplete, "evaluacion", true);
LB.Text = "EVALUACION";
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
if (!this.IsPostBack)
{
if (Request.QueryString["data"] != null)
{
if (this.loadqueryStrings(Request.QueryString["data"].ToString()))
{
string path = "";
Byte[] bytes = null;
if (myQueryStrings["solID"] != null)
{ // ES SOLICITUD
if (myQueryStrings["impsol"] != null)
{
path = FormatosPdf.imprimeSolicitud(int.Parse(myQueryStrings["solID"].ToString()));
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO LA SOLICITUD: " + myQueryStrings["solID"].ToString());
}
if ((myQueryStrings["impSol2010"] != null))
{
bytes = FormatosPdf.imprimeSolicitud2010(int.Parse(myQueryStrings["solID"].ToString()));
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO LA SOLICITUD: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["impcont"] != null)
{
bytes = FormatosPdf.imprimeContrato(int.Parse(myQueryStrings["solID"].ToString()), this.UserID);
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL CONTRATO DE LA SOLICITUD: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["impcar"] != null)
{
bytes = FormatosPdf.imprimeCaratulaAnexaSola(int.Parse(myQueryStrings["solID"].ToString()), this.UserID);
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO LA CARÁTULA DE LA SOLICITUD: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["impPagare"] != null)
{
/*
* filename=" + sFileName + "&ContentType=application/pdf&";
* datosaencriptar = datosaencriptar + "creditoID=" + actualRow.creditoID.ToString() +"&";
* datosaencriptar += "impPagare=1&monto=" + actualRow.total.ToString() + "&";
* string URLcomplete = sURL + "?data=";
*/
int solicitud = -1;
if (myQueryStrings["creditoID"] != null)
{
SqlCommand comm = new SqlCommand("SELECT solicitudID FROM Solicitudes WHERE (creditoID = @creditoID)");
comm.CommandText = dbFunctions.UpdateSDSForSisBanco(comm.CommandText);
comm.Parameters.Add("@creditoID", System.Data.SqlDbType.Int).Value = int.Parse(myQueryStrings["creditoID"].ToString());
solicitud = dbFunctions.GetExecuteIntScalar(comm, -1);
if (solicitud != -1)
{
// Solicitudes sol = Solicitudes.Get(solicitud);
Solicitudes sol;
if (this.IsSistemBanco)
{
sol = SolicitudesSisBancos.Get(solicitud);
}
else
{
sol = Solicitudes.Get(solicitud);
}
if (this.myQueryStrings["fecha"] == null)
{
this.myQueryStrings.Add("fecha", ((DateTime)sol.Fecha).ToString("yyyy/MM/dd"));
}
//else
// this.myQueryStrings["fecha"] = ((DateTime)sol.Fecha).ToString("yyyy/MM/dd");
if (this.myQueryStrings["monto"] == null)
{
this.myQueryStrings.Add("monto", sol.Monto.ToString());
}
//else
// this.myQueryStrings["monto"] = sol.Monto.ToString();
DateTime fecha;
if (myQueryStrings["fecha"] != null && DateTime.TryParse(myQueryStrings["fecha"].ToString(), out fecha))
{
DateTime FechaPagare;
if (myQueryStrings["fechaPagare"] != null && DateTime.TryParse(myQueryStrings["fechaPagare"].ToString(), out FechaPagare))
{
bytes = FormatosPdf.imprimePagare(solicitud, this.UserID, double.Parse(myQueryStrings["monto"].ToString()), fecha, FechaPagare, true);
}
else
{
bytes = FormatosPdf.imprimePagare(solicitud, this.UserID, double.Parse(myQueryStrings["monto"].ToString()), fecha);
}
}
else
{
bytes = FormatosPdf.imprimePagare(solicitud, this.UserID, double.Parse(myQueryStrings["monto"].ToString()));
}
}
else
{
if (int.TryParse(myQueryStrings["creditoID"].ToString(), out solicitud))
{
DateTime fecha;
if (myQueryStrings["fecha"] != null && DateTime.TryParse(myQueryStrings["fecha"].ToString(), out fecha))
{
DateTime FechaPagare;
if (myQueryStrings["fechaPagare"] != null && DateTime.TryParse(myQueryStrings["fechaPagare"].ToString(), out FechaPagare))
{
bytes = FormatosPdf.imprimePagareCredito(solicitud, this.UserID, double.Parse(myQueryStrings["monto"].ToString()), fecha, FechaPagare, true);
}
else
{
bytes = FormatosPdf.imprimePagareCredito(solicitud, this.UserID, double.Parse(myQueryStrings["monto"].ToString()), fecha);
}
}
else
{
bytes = FormatosPdf.imprimePagareCredito(solicitud, this.UserID, double.Parse(myQueryStrings["monto"].ToString()));
}
}
}
}
else
{
solicitud = int.Parse(myQueryStrings["solID"].ToString());
bytes = FormatosPdf.imprimePagare(solicitud, this.UserID);
}
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO LA CARÁTULA DE LA SOLICITUD: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["impseg"] != null)
{
string sError = "";
FormatosPdf.imprimeReporteSeguro(int.Parse(myQueryStrings["solID"].ToString()), ref path, ref sError);
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL FORMATO DE SEGURO DE LA SOLICITUD: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["imptermsandcond"] != null)
{
bytes = FormatosPdf.imprimeTermsAndConditions(int.Parse(myQueryStrings["solID"].ToString()), UserID);
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL FORMATO DE TERMINOS Y CONDICIONES: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["cartaCompromiso"] != null)
{
bytes = FormatosPdf.imprimeCartaCompromiso(int.Parse(myQueryStrings["solID"].ToString()));
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL FORMATO DE CARTA COMPROMISO: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["evaluacion"] != null)
{
bytes = FormatosPdf.imprimeEvaluacion(int.Parse(myQueryStrings["solID"].ToString()));
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL FORMATO DE Evaluacion: " + myQueryStrings["solID"].ToString());
}
if (myQueryStrings["buroCredito"] != null)
{
bytes = FormatosPdf.imprimeBuroCredito(int.Parse(myQueryStrings["solID"].ToString()));
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL FORMATO DE TERMINOS Y CONDICIONES: " + myQueryStrings["solID"].ToString());
}
}
if (myQueryStrings["NotaCompraFormato"] != null)
{
string sError = "";
FormatosPdf.imprimeOrdendeCompraFormato(int.Parse(myQueryStrings["NotaCompraFormato"].ToString()), ref path, ref sError);
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL FORMATO DE SEGURO DE LA SOLICITUD: " + myQueryStrings["NotaCompraFormato"].ToString());
}
if (myQueryStrings["ordenDeCargaId"] != null)
{
string sError = "";
FormatosPdf.imprimeOrdendeCarga(int.Parse(myQueryStrings["ordenDeCargaId"].ToString()), ref path, ref sError);
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO LA ORDEN DE CARGA: " + myQueryStrings["ordenDeCargaId"].ToString());
}
//printSeguro=1&solSeguroID="
if (myQueryStrings["printSeguro"] != null)
{
string sError = "";
bytes = FormatosPdf.imprimeSeguro(int.Parse(myQueryStrings["solSeguroID"].ToString()));
Logger.Instance.LogUserSessionRecord(Logger.typeModulo.SOLICITUDES, Logger.typeUserActions.PRINT, this.UserID, "IMPRIMIO EL SEGURO: " + myQueryStrings["solSeguroID"].ToString());
}
Response.ClearHeaders();
Response.Clear();
if (myQueryStrings["ContentType"] == null || myQueryStrings["ContentType"].ToString().Length <= 0)
{
Response.ContentType = "application/pdf";
}
else
{
Response.ContentType = myQueryStrings["ContentType"].ToString();//"application/pdf";
}
Response.AddHeader("Content-Disposition", "attachment;filename=" + myQueryStrings["filename"].ToString());
if (myQueryStrings["archivo"] != null)
{
path = myQueryStrings["archivo"].ToString();
}
if (bytes != null)
{
Response.BinaryWrite(bytes);
}
else
{
Response.WriteFile(path);
Response.Flush();
//try to delete the tmp file
try
{
if (File.Exists(path))
{
File.Delete(path);
}
}
catch {}
}
//Response.End();
}
else
{
myQueryStrings.Clear();
//Response.Redirect("~/frmAddModifyProductores.aspx", true);
}
}
}
}
catch (System.Exception ex)
{
Logger.Instance.LogException(Logger.typeUserActions.PRINT, "Error imprimiendo", ref ex);
}
}