protected void btnGenerar_Click(object sender, EventArgs e)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cReportingRegional oReportingRegional = new cReportingRegional(ref oConn);
oReportingRegional.NomReporting = "Reporte solicitado el " + DateTime.Now.ToString("dd-MM-yyyy");
oReportingRegional.EstReporting = "S";
oReportingRegional.FechReporting = DateTime.Now.ToString("yyyyMMdd");
oReportingRegional.AnoReporting = cmbox_ano.SelectedValue;
oReportingRegional.CodTipo = oUsuario.CodTipoUsuario;
oReportingRegional.Accion = "CREAR";
oReportingRegional.Put();
StringBuilder js = new StringBuilder();
js.Append("function LgRespuesta() {");
js.Append(" window.radalert('Se realizo la solicitud de generación del Reporting Regional, espere uno 5 minutos y vuelva a ingresar a la funcionalidad para obtener el reporte.', 330, 210); ");
js.Append(" Sys.Application.remove_load(LgRespuesta); ");
js.Append("};");
js.Append("Sys.Application.add_load(LgRespuesta);");
Page.ClientScript.RegisterStartupScript(this.GetType(), "radalert", js.ToString(), true);
rdGridReporting.Rebind();
}
oConn.Close();
}
protected void rdGridReporting_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cReportingRegional oReportingRegional = new cReportingRegional(ref oConn);
oReportingRegional.CodTipo = oUsuario.CodTipoUsuario;
rdGridReporting.DataSource = oReportingRegional.Get();
}
oConn.Close();
}
public void ProcessRequest(HttpContext context)
{
string sPath = string.Empty;
string sFileName = string.Empty;
string sCodUsuario = oWeb.GetData("CodUsuario");
string pCodReporting = oWeb.GetData("pCodReporting");
DBConn oConn = new DBConn();
if (oConn.Open())
{
cReportingRegional oReportingRegional = new cReportingRegional(ref oConn);
oReportingRegional.CodReporting = pCodReporting;
DataTable dtReportingRegional = oReportingRegional.Get();
if (dtReportingRegional != null)
{
if (dtReportingRegional.Rows.Count > 0)
{
sFileName = dtReportingRegional.Rows[0]["filename_reporting"].ToString();
cCliente oCliente = new cCliente(ref oConn);
oCliente.NkeyCliente = sCodUsuario;
DataTable dtCliente = oCliente.Get();
if (dtCliente != null)
{
if (dtCliente.Rows.Count > 0)
{
sPath = dtCliente.Rows[0]["pathsdocscaneados"].ToString();
}
}
dtReportingRegional = null;
}
}
}
oConn.Close();
System.Web.HttpResponse oResponse = System.Web.HttpContext.Current.Response;
sPath = sPath + "\\Mattel Europa\\Reporte_Regional\\" + sFileName;
oResponse.AppendHeader("Content-Disposition", "attachment; filename=" + sFileName);
// Write the file to the Response
const int bufferLength = 10000;
byte[] buffer = new Byte[bufferLength];
int length = 0;
Stream download = null;
try
{
download = new FileStream(sPath, FileMode.Open, FileAccess.Read);
do
{
if (oResponse.IsClientConnected)
{
length = download.Read(buffer, 0, bufferLength);
oResponse.OutputStream.Write(buffer, 0, length);
buffer = new Byte[bufferLength];
}
else
{
length = -1;
}
}while (length > 0);
oResponse.Flush();
oResponse.End();
}
finally
{
if (download != null)
{
download.Close();
}
}
}
