protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cCliente oCliente = new cCliente(ref oConn);
DataTable tblCliente = oCliente.Get();
if (tblCliente != null)
{
if (tblCliente.Rows.Count > 0)
{
oCmbCliente.Items.Add(new ListItem("Seleccione Cliente", ""));
foreach (DataRow oRow in tblCliente.Rows)
{
oCmbCliente.Items.Add(new ListItem(oRow["snombre"].ToString(), oRow["nkey_cliente"].ToString()));
}
}
tblCliente.Dispose();
}
oCliente = null;
}
oConn.Close();
sTipo.Value = oWeb.GetData("sTipo");
oCmbTipoConsulta.Items.Add(new ListItem("Seleccione Tipo Consulta", ""));
switch (sTipo.Value)
{
case "calidadproductiva":
oCmbTipoConsulta.Items.Add(new ListItem("Analista", "A"));
oCmbTipoConsulta.Items.Add(new ListItem("Cliente", "C"));
oCmbTipoConsulta.Items.Add(new ListItem("Supervisor", "S"));
break;
case "impecabilidad":
oCmbTipoConsulta.Items.Add(new ListItem("Analista", "A"));
oCmbTipoConsulta.Items.Add(new ListItem("Cliente", "C"));
break;
case "managersp1":
case "managersp2":
oCmbTipoConsulta.Items.Add(new ListItem("Supervisor", "S"));
break;
case "analistap1":
case "analistap2":
oCmbTipoConsulta.Items.Add(new ListItem("Analista", "A"));
break;
case "riegooperacional":
oCmbTipoConsulta.Items.Add(new ListItem("Manual", "M"));
break;
case "tesoreriaproceso":
oCmbTipoConsulta.Items.Add(new ListItem("Analista", "A"));
break;
}
}
}
protected void lnkButton_Click(object sender, EventArgs e)
{
string sPath = string.Empty;
DBConn oConn = new DBConn();
if (oConn.Open())
{
cCliente oCliente = new cCliente(ref oConn);
oCliente.NkeyCliente = "79";
DataTable dt = oCliente.Get();
if (dt != null)
{
sPath = dt.Rows[0]["pathsdocscaneados"].ToString();
}
dt = null;
}
oConn.Close();
sPath = sPath + "Mattel Europa\\ContratosWeb\\" + hddpdfcontrato.Value;
Response.AppendHeader("Content-Disposition", "attachment; filename=" + hddpdfcontrato.Value);
// 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 (Response.IsClientConnected)
{
length = download.Read(buffer, 0, bufferLength);
Response.OutputStream.Write(buffer, 0, length);
buffer = new Byte[bufferLength];
}
else
{
length = -1;
}
}while (length > 0);
Response.Flush();
Response.End();
}
finally
{
if (download != null)
{
download.Close();
}
}
}
protected void LoadGrid()
{
DBConn oConn = new DBConn();
if (oConn.Open())
{
cCliente oCliente = new cCliente(ref oConn);
if (!string.IsNullOrEmpty(txtlogo.Text))
{
oCliente.SNombre = txtlogo.Text;
}
gridLogos.DataSource = oCliente.Get();
gridLogos.DataBind();
oConn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
oWeb.ValidaSessionAdm();
if (!IsPostBack)
{
string sFile = string.Empty;
CodCliente.Value = oWeb.GetData("CodCliente");
hddTipo.Value = oWeb.GetData("tp");
DBConn oConn = new DBConn();
if (oConn.Open())
{
cCliente oCliente = new cCliente(ref oConn);
oCliente.NKey_cliente = CodCliente.Value;
DataTable dtCliente = oCliente.Get();
if (dtCliente.Rows.Count > 0)
{
Label1.Text = dtCliente.Rows[0]["sNombre"].ToString();
}
cAppLogoCliente oAppLogoCliente = new cAppLogoCliente(ref oConn);
oAppLogoCliente.NKey_cliente = CodCliente.Value;
DataTable dtLogo = oAppLogoCliente.Get();
if (dtLogo != null)
{
if (dtLogo.Rows.Count > 0)
{
hddAccion.Value = "EDITAR";
if (!string.IsNullOrEmpty(dtLogo.Rows[0]["logo_cliente"].ToString()))
{
sFile = dtLogo.Rows[0]["logo_cliente"].ToString();
getImage(sFile);
}
else
{
getImage("nada.jpg");
}
}
}
}
oConn.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
rdCmbCliente.Items.Add(new ListItem("<< Seleccione Cliente", "0"));
rdCmbLicencitarios.Items.Add(new ListItem("<< Seleccione Licenciatario", "0"));
DBConn oConn = new DBConn();
if (oConn.Open())
{
cCliente oCliente = new cCliente(ref oConn);
DataTable dtCliente = oCliente.Get();
if (dtCliente != null)
{
foreach (DataRow oRow in dtCliente.Rows)
{
rdCmbCliente.Items.Add(new ListItem(oRow["sNombre"].ToString(), oRow["nKey_cliente"].ToString()));
}
}
dtCliente = null;
cDeudor oDeudor = new cDeudor(ref oConn);
DataTable dtDeudor = oDeudor.Get();
if (dtDeudor != null)
{
foreach (DataRow oRow in dtDeudor.Rows)
{
rdCmbLicencitarios.Items.Add(new ListItem(oRow["sNombre"].ToString(), oRow["nKey_Deudor"].ToString()));
}
}
dtDeudor = null;
oConn.Close();
}
hdd_codusuario.Value = oWeb.GetData("codusuario");
if (!string.IsNullOrEmpty(hdd_codusuario.Value))
{
getUsuario();
}
}
}
public void ProcessRequest(HttpContext context)
{
string sPath = string.Empty;
string sNomFactura = oWeb.GetData("sNomFactura");
string sNumContrato = oWeb.GetData("sNumContrato");
DBConn oConn = new DBConn();
if (oConn.Open())
{
cContratos oContratos = new cContratos(ref oConn);
oContratos.NumContrato = sNumContrato;
DataTable dtContrato = oContratos.Get();
if (dtContrato != null)
{
if (dtContrato.Rows.Count > 0)
{
cCliente oCliente = new cCliente(ref oConn);
oCliente.NkeyCliente = dtContrato.Rows[0]["nkey_cliente"].ToString();
DataTable dtCliente = oCliente.Get();
if (dtCliente != null)
{
if (dtCliente.Rows.Count > 0)
{
sPath = dtCliente.Rows[0]["pathsdocscaneados"].ToString() + "\\" + dtCliente.Rows[0]["direcarchivos"].ToString();
}
}
dtContrato = null;
}
}
}
oConn.Close();
System.Web.HttpResponse oResponse = System.Web.HttpContext.Current.Response;
sPath = sPath + "\\" + sNomFactura + ".pdf";
oResponse.ContentType = "application/pdf";
oResponse.AppendHeader("Content-Disposition", "attachment; filename=" + sNomFactura + ".pdf");
// 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();
}
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
Web oWeb = new Web();
string sTimePage = string.Empty;
string sUrlPage = string.Empty;
string pCodMonitor = oWeb.GetData("codmonitor");
string indexToken = oWeb.GetData("indexToken");
string pCodUsuario = oWeb.GetData("codusuario");
string pOrderPage = oWeb.GetData("order");
DBConn oConn = new DBConn();
if (oConn.Open())
{
cAptMonitorPages oAptMonitorPages = new cAptMonitorPages(ref oConn);
oAptMonitorPages.CodMonitor = pCodMonitor;
oAptMonitorPages.OrderPage = (Convert.ToInt32(pOrderPage) + 1).ToString();
DataTable dtMPage = oAptMonitorPages.Get();
if (dtMPage != null)
{
if (dtMPage.Rows.Count > 0)
{
sUrlPage = dtMPage.Rows[0]["url_page"].ToString();
sUrlPage = sUrlPage + "?codmonitor=" + pCodMonitor;
sUrlPage = sUrlPage + "&indexToken=" + indexToken;
if (!string.IsNullOrEmpty(pCodUsuario))
{
sUrlPage = sUrlPage + "&codusuario=" + pCodUsuario;
}
sUrlPage = sUrlPage + "&order=" + dtMPage.Rows[0]["order_page"].ToString();
sTimePage = dtMPage.Rows[0]["time_page"].ToString();
}
else
{
oAptMonitorPages.OrderPage = string.Empty;
dtMPage = oAptMonitorPages.Get();
if (dtMPage != null)
{
if (dtMPage.Rows.Count > 0)
{
if ((string.IsNullOrEmpty(dtMPage.Rows[0]["cod_cliente"].ToString())) && (string.IsNullOrEmpty(dtMPage.Rows[0]["cod_holding"].ToString())))
{
cCliente oCliente = new cCliente(ref oConn);
DataTable dtCliente = oCliente.Get();
if (!string.IsNullOrEmpty(indexToken))
{
if (dtCliente.Rows.Count == (Convert.ToInt32(Session[indexToken].ToString()) + 1))
{
Session[indexToken] = 0;
}
else
{
Session[indexToken] = Convert.ToInt32(Session[indexToken].ToString()) + 1;
}
}
else
{
if (dtCliente.Rows.Count == (Convert.ToInt32(Session["indexcliente"].ToString()) + 1))
{
Session["indexcliente"] = 0;
}
else
{
Session["indexcliente"] = Convert.ToInt32(Session["indexcliente"].ToString()) + 1;
}
}
dtCliente = null;
}
sUrlPage = dtMPage.Rows[0]["url_page"].ToString();
sUrlPage = sUrlPage + "?codmonitor=" + pCodMonitor;
sUrlPage = sUrlPage + "&indexToken=" + indexToken;
if (!string.IsNullOrEmpty(pCodUsuario))
{
sUrlPage = sUrlPage + "&codusuario=" + pCodUsuario;
}
sUrlPage = sUrlPage + "&order=" + dtMPage.Rows[0]["order_page"].ToString();
sTimePage = dtMPage.Rows[0]["time_page"].ToString();
}
}
}
}
dtMPage = null;
Response.AppendHeader("Refresh", sTimePage + "; URL=" + sUrlPage);
}
oConn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
DBConn oConn = new DBConn();
Web oWeb = new Web();
string pCodMonitor = oWeb.GetData("codmonitor");
string pCodUsuario = oWeb.GetData("codusuario");
string pAuthenCodUser = oWeb.GetData("authuser");
string indexToken = oWeb.GetData("indexToken");
string pCodPage = string.Empty;
string pOrderPage = oWeb.GetData("order");
string pCodCliente = string.Empty;
string pTipoUsuario = string.Empty;
string sIdFecha = string.Empty;
int maxdt = (new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1)).Day;
firtDay.InnerText = "01-" + DateTime.Now.ToString("MM-yyyy");
lastDay.InnerText = maxdt.ToString() + "-" + DateTime.Now.ToString("MM-yyyy");
if (!string.IsNullOrEmpty(pAuthenCodUser))
{
AuthenticUser(pAuthenCodUser);
}
oWeb.ValidaUserPanel();
if (!IsPostBack)
{
if (oConn.Open())
{
cAptMonitorPages oAptMonitorPages = new cAptMonitorPages(ref oConn);
oAptMonitorPages.CodMonitor = pCodMonitor;
oAptMonitorPages.OrderPage = pOrderPage;
DataTable dtMPage = oAptMonitorPages.Get();
if (dtMPage != null)
{
if (dtMPage.Rows.Count > 0)
{
pCodPage = dtMPage.Rows[0]["cod_page"].ToString();
pTipoUsuario = dtMPage.Rows[0]["tipo_usuario"].ToString();
if (!string.IsNullOrEmpty(dtMPage.Rows[0]["cod_cliente"].ToString()))
{
pCodCliente = dtMPage.Rows[0]["cod_cliente"].ToString();
}
else if (!string.IsNullOrEmpty(dtMPage.Rows[0]["cod_holding"].ToString()))
{
pCodCliente = dtMPage.Rows[0]["cod_holding"].ToString();
pTipoUsuario = "H";
}
else
{
cCliente oCliente = new cCliente(ref oConn);
DataTable dtCliente = oCliente.Get();
if (!string.IsNullOrEmpty(indexToken))
{
pCodCliente = dtCliente.Rows[Convert.ToInt32(Session[indexToken].ToString())]["nkey_cliente"].ToString();
}
else
{
pCodCliente = dtCliente.Rows[Convert.ToInt32(Session["indexcliente"].ToString())]["nkey_cliente"].ToString();
}
dtCliente = null;
}
}
}
dtMPage = null;
oCmbTipoConsulta.Value = pTipoUsuario;
oCmbCliente.Value = pCodCliente;
if (!string.IsNullOrEmpty(oCmbCliente.Value))
{
cAppLogoCliente oAppLogoCliente = new cAppLogoCliente(ref oConn);
oAppLogoCliente.NKey_cliente = pCodCliente;
oAppLogoCliente.Tipo = (pTipoUsuario == "H" ? pTipoUsuario : "C");
DataTable dtlogo = oAppLogoCliente.Get();
if (dtlogo != null)
{
if (dtlogo.Rows.Count > 0)
{
imglogo.ImageUrl = "images/logos/" + dtlogo.Rows[0]["logo_cliente"].ToString();
}
}
}
else
{
imglogo.Visible = false;
}
}
oConn.Close();
}
if (oConn.Open())
{
cIndejecucion oIndejecucion = new cIndejecucion(ref oConn);
DataTable tblEjecucion = oIndejecucion.Get();
if (tblEjecucion != null)
{
if (tblEjecucion.Rows.Count > 0)
{
sIdFecha = tblEjecucion.Rows[0]["idfecha"].ToString();
}
tblEjecucion.Dispose();
}
tblEjecucion = null;
DateTime idFechaMesAnterior = new DateTime(Int32.Parse(sIdFecha.Substring(0, 4)), Int32.Parse(sIdFecha.Substring(4, 2)), Int32.Parse(sIdFecha.Substring(6, 2)), Int32.Parse(sIdFecha.Substring(8, 2)), Int32.Parse(sIdFecha.Substring(10, 2)), 0);
idFechaMesAnterior = idFechaMesAnterior.AddMonths(-1);
cAptPagesKpi oAptPagesKpi = new cAptPagesKpi(ref oConn);
oAptPagesKpi.CodCliente = pCodUsuario;
oAptPagesKpi.CodPage = pCodPage;
DataTable dtKPIs = oAptPagesKpi.Get();
if (dtKPIs != null)
{
cIndresultado oIndResultado = new cIndresultado(ref oConn);
DataTable tblColumn1 = null;
cIndumbral oIndumbral = null;
HtmlTableCell oCell;
HtmlTableCell oCelldataColumn;
HtmlGenericControl dynDiv;
HtmlTableCell oCelldataAceptacion;
HtmlGenericControl oDivAceptacion;
HtmlTableCell oCellSLA;
HtmlGenericControl oDivSLA;
HtmlTableCell oCellMesAnterior;
HtmlGenericControl oDivImg;
Image oImage;
foreach (DataRow oRow in dtKPIs.Rows)
{
string iDato = "0";
string sKeyTipo = string.Empty;
oCell = new HtmlTableCell();
oCell.ID = "tdCell_" + oRow["identificador_kpi"].ToString();
oCell.Controls.Add(new LiteralControl("<div align=\"center\" class=\"tbTit\">" + oRow["nombrekpi"].ToString() + "</div>"));
HeaderId.Controls.Add(oCell);
oCelldataColumn = new HtmlTableCell();
oCelldataColumn.ID = "tdCell_dataColumn" + oRow["identificador_kpi"].ToString();
oCelldataColumn.Attributes.Add("class", "clDtPanel");
dynDiv = new HtmlGenericControl("div");
dynDiv.ID = "divControl_" + oRow["identificador_kpi"].ToString();
oIndResultado.Tipo = oCmbTipoConsulta.Value;
oIndResultado.KeyCliente = oCmbCliente.Value;
oIndResultado.IdFecha = sIdFecha;
oIndResultado.Indicador = oRow["identificador_kpi"].ToString();
tblColumn1 = oIndResultado.Get();
if (tblColumn1 != null)
{
if (tblColumn1.Rows.Count > 0)
{
iDato = (!string.IsNullOrEmpty(tblColumn1.Rows[0]["valor"].ToString()) ? tblColumn1.Rows[0]["valor"].ToString() : "0");
sKeyTipo = tblColumn1.Rows[0]["nkey_tipo"].ToString();
dynDiv.InnerText = String.Format("{0:0}", double.Parse(iDato));
//oColumn1.InnerText = String.Format("{0:0}", double.Parse(iDato));
}
tblColumn1.Dispose();
}
tblColumn1 = null;
oCellMesAnterior = new HtmlTableCell();
oCellMesAnterior.ID = "tdCell_mesanterior" + oRow["identificador_kpi"].ToString();
oCellMesAnterior.Attributes.Add("class", "clDtPanel");
/*******************************************************/
/***************** Mes Anterior ************************/
/*******************************************************/
oIndResultado.IdFecha = idFechaMesAnterior.ToString("yyyyMMddHHmm");
tblColumn1 = oIndResultado.GetMesAnterior();
if (tblColumn1 != null)
{
if (tblColumn1.Rows.Count > 0)
{
oDivImg = new HtmlGenericControl("div");
oDivImg.Attributes.Add("class", "tbDat");
oImage = new Image();
oImage.ImageUrl = oWeb.getColorArrowCalidad(double.Parse(iDato), double.Parse(tblColumn1.Rows[0]["valor"].ToString()));
oDivImg.Controls.Add(oImage);
oCellMesAnterior.Controls.Add(oDivImg);
//oColumnMesAnt1.ImageUrl = oWeb.getColorArrowCalidad(double.Parse(iDato), double.Parse(tblColumn1.Rows[0]["valor"].ToString()));
}
tblColumn1.Dispose();
}
tblColumn1 = null;
oCelldataAceptacion = new HtmlTableCell();
oCelldataAceptacion.ID = "tdCell_aceptacion" + oRow["identificador_kpi"].ToString();
oCelldataAceptacion.Attributes.Add("class", "clDtPanel");
oDivAceptacion = new HtmlGenericControl("div");
oDivAceptacion.ID = "divAceptacion_" + oRow["identificador_kpi"].ToString();
oDivAceptacion.Attributes.Add("class", "tbDat");
oCellSLA = new HtmlTableCell();
oCellSLA.ID = "tdCell_SLA" + oRow["identificador_kpi"].ToString();
oCellSLA.Attributes.Add("class", "clDtPanel");
oDivSLA = new HtmlGenericControl("div");
oDivSLA.ID = "divSLA_" + oRow["identificador_kpi"].ToString();
oDivSLA.Attributes.Add("class", "tbDat");
oIndumbral = new cIndumbral(ref oConn);
oIndumbral.KeyCliente = oCmbCliente.Value;
oIndumbral.Tipo = oCmbTipoConsulta.Value;
oIndumbral.Indicador = oRow["identificador_kpi"].ToString();
oIndumbral.KeyTipo = sKeyTipo;
tblColumn1 = oIndumbral.Get();
if (tblColumn1 != null)
{
if (tblColumn1.Rows.Count > 0)
{
oDivAceptacion.InnerText = tblColumn1.Rows[0]["criterio_aceptacion"].ToString() + tblColumn1.Rows[0]["unidad"].ToString();
oCelldataAceptacion.Controls.Add(oDivAceptacion);
//oCAceptacion1.InnerHtml = tblColumn1.Rows[0]["criterio_aceptacion"].ToString() + tblColumn1.Rows[0]["unidad"].ToString();
oDivSLA.InnerText = tblColumn1.Rows[0]["sla"].ToString();
oCellSLA.Controls.Add(oDivSLA);
//oSLA1.InnerHtml = tblColumn1.Rows[0]["sla"].ToString();
dynDiv.Attributes.Add("class", oWeb.getColorNumAvance(double.Parse(iDato), tblColumn1));
oCelldataColumn.Controls.Add(dynDiv);
//oColumn1.Attributes.Add("class", oWeb.getColorNumAvance(double.Parse(iDato), tblColumn1));
}
tblColumn1.Dispose();
}
tblColumn1 = null;
dataColumn.Controls.Add(oCelldataColumn);
dataAceptacion.Controls.Add(oCelldataAceptacion);
dataSLA.Controls.Add(oCellSLA);
dataMesAnterior.Controls.Add(oCellMesAnterior);
}
}
dtKPIs = null;
oConn.Close();
}
}
protected void oCmbTipoConsulta_OnClientSelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)
{
DataTable oPages = null;
tdselectvista.Visible = true;
DBConn oConn = new DBConn();
if (oConn.Open())
{
cAppPages oAppPages = new cAppPages(ref oConn);
oAppPages.CodTipo = oCmbTipoConsulta.SelectedValue.ToString();
if (oCmbTipoConsulta.SelectedValue.ToString() == "N")
{
oAppPages.CodMonitor = CodMonitorView.Value;
oPages = oAppPages.GetByType();
}
else
{
oPages = oAppPages.GetByTipo();
}
cAppTipoConnsulta oTipoConnsulta = new cAppTipoConnsulta(ref oConn);
oTipoConnsulta.CodTipo = oCmbTipoConsulta.SelectedValue.ToString();
oTipoConnsulta.IndSegNivel = "S";
DataTable dtTpCon = oTipoConnsulta.Get();
if (dtTpCon != null)
{
if (dtTpCon.Rows.Count > 0)
{
//tpconsulta_segundonivel.Visible = true;
tpconsulta_normal.Visible = false;
//oCmbPages.Visible = false;
//lblPage.Visible = true;
//if (oPages != null)
//{
// if (oPages.Rows.Count > 0)
// {
// lblPage.Text = oPages.Rows[0]["nom_page"].ToString();
// hddCodPage.Value = oPages.Rows[0]["cod_page"].ToString();
//LoadGrid();
// }
// oPages.Dispose();
//}
//oPages = null;
btnGrabar2.Visible = false;
}
else
{
lblPage.Visible = false;
cCliente oCliente = new cCliente(ref oConn);
DataTable dtcliente = oCliente.Get();
tpconsulta_normal.Visible = true;
tpconsulta_segundonivel.Visible = false;
btnGrabar2.Visible = true;
//oCmbPages.Items.Add(new ListItem("Selecciona una vista", ""));
oCmbHolding.Items.Clear();
oCmbHolding.Items.Add(new ListItem("Selecciona holding", ""));
DataTable dtholding = oCliente.GetHolding();
if (dtholding != null)
{
foreach (DataRow oRow in dtholding.Rows)
{
oCmbHolding.Items.Add(new ListItem(oRow["holding"].ToString(), oRow["ncodholding"].ToString()));
}
}
dtholding = null;
oCmbCliente.Items.Clear();
oCmbCliente.Items.Add(new RadComboBoxItem("Selecciona cliente", ""));
if (dtcliente != null)
{
foreach (DataRow oRow in dtcliente.Rows)
{
oCmbCliente.Items.Add(new RadComboBoxItem(oRow["snombre"].ToString(), oRow["nkey_cliente"].ToString()));
}
}
dtcliente = null;
}
}
dtTpCon = null;
oCmbPages.Visible = true;
oCmbPages.Items.Clear();
oCmbPages.Items.Add(new RadComboBoxItem("Selecciona una Vista", ""));
if (oPages != null)
{
if (oPages.Rows.Count > 0)
{
foreach (DataRow oRow in oPages.Rows)
{
oCmbPages.Items.Add(new RadComboBoxItem(oRow["nom_page"].ToString(), oRow["cod_page"].ToString()));
}
}
oPages.Dispose();
}
oPages = null;
}
oConn.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
DBConn oConn = new DBConn();
Web oWeb = new Web();
StringBuilder sNAvance;
string pCodMonitor = oWeb.GetData("codmonitor");
string pCodUsuario = oWeb.GetData("codusuario");
string pAuthenCodUser = oWeb.GetData("authuser");
string indexToken = oWeb.GetData("indexToken");
string pCodPage = string.Empty;
string pOrderPage = oWeb.GetData("order");
string pCodCliente = string.Empty;
string pTipoConsulta = string.Empty;
string pTipoCliente = string.Empty;
string sIdFecha = string.Empty;
string iDato = "0";
string sKeyTipo = string.Empty;
if (!string.IsNullOrEmpty(pAuthenCodUser))
{
AuthenticUser(pAuthenCodUser);
}
oWeb.ValidaUserPanel();
int maxdt = (new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1).AddMonths(1).AddDays(-1)).Day;
firtDay.InnerText = "01-" + DateTime.Now.ToString("MM-yyyy");
lastDay.InnerText = maxdt.ToString() + "-" + DateTime.Now.ToString("MM-yyyy");
if (!IsPostBack)
{
if (oConn.Open())
{
cAptMonitorPages oAptMonitorPages = new cAptMonitorPages(ref oConn);
oAptMonitorPages.CodMonitor = pCodMonitor;
oAptMonitorPages.OrderPage = pOrderPage;
DataTable dtMPage = oAptMonitorPages.Get();
if (dtMPage != null)
{
if (dtMPage.Rows.Count > 0)
{
pCodPage = dtMPage.Rows[0]["cod_page"].ToString();
pTipoConsulta = dtMPage.Rows[0]["tipo_usuario"].ToString();
if (!string.IsNullOrEmpty(dtMPage.Rows[0]["cod_cliente"].ToString()))
{
pCodCliente = dtMPage.Rows[0]["cod_cliente"].ToString();
pTipoCliente = "C";
}
else if (!string.IsNullOrEmpty(dtMPage.Rows[0]["cod_holding"].ToString()))
{
pCodCliente = dtMPage.Rows[0]["cod_holding"].ToString();
pTipoCliente = "H";
}
else
{
cCliente oCliente = new cCliente(ref oConn);
DataTable dtCliente = oCliente.Get();
if (!string.IsNullOrEmpty(indexToken))
{
pCodCliente = dtCliente.Rows[Convert.ToInt32(Session[indexToken].ToString())]["nkey_cliente"].ToString();
}
else
{
pCodCliente = dtCliente.Rows[Convert.ToInt32(Session["indexcliente"].ToString())]["nkey_cliente"].ToString();
}
dtCliente = null;
}
}
}
dtMPage = null;
oCmbTipoConsulta.Value = pTipoConsulta;
oCmbCliente.Value = pCodCliente;
if (oCmbTipoConsulta.Value == "S")
{
pie.Attributes.Add("class", "tdPieManagers");
lblSubTitle.Text = "Medición de Managers";
}
else
{
pie.Attributes.Add("class", "tdPieEjecutivos");
lblSubTitle.Text = "Medición de Ejecutivos";
}
if (!string.IsNullOrEmpty(oCmbCliente.Value))
{
cAppLogoCliente oAppLogoCliente = new cAppLogoCliente(ref oConn);
oAppLogoCliente.NKey_cliente = pCodCliente;
oAppLogoCliente.Tipo = (pTipoCliente == "H" ? pTipoCliente : "C");
DataTable dtlogo = oAppLogoCliente.Get();
if (dtlogo != null)
{
if (dtlogo.Rows.Count > 0)
{
imglogo.ImageUrl = "images/logos/" + dtlogo.Rows[0]["logo_cliente"].ToString();
}
}
}
else
{
imglogo.Visible = false;
}
}
oConn.Close();
}
if (oConn.Open())
{
if (!IsPostBack)
{
cCliente oCliente = new cCliente(ref oConn);
oCliente.NKey_cliente = oCmbCliente.Value;
DataTable tblCliente = oCliente.Get();
if (!string.IsNullOrEmpty(oCliente.Error))
{
Response.Write(oCliente.Query);
Response.End();
}
if (tblCliente != null)
{
if (tblCliente.Rows.Count > 0)
{
hddNCod.Value = tblCliente.Rows[0]["ncod"].ToString();
}
}
tblCliente.Dispose();
tblCliente = null;
}
cIndejecucion oIndejecucion = new cIndejecucion(ref oConn);
DataTable tblEjecucion = oIndejecucion.Get();
if (tblEjecucion != null)
{
if (tblEjecucion.Rows.Count > 0)
{
sIdFecha = tblEjecucion.Rows[0]["idfecha"].ToString();
}
tblEjecucion.Dispose();
}
tblEjecucion = null;
DateTime idFechaMesAnterior = new DateTime(Int32.Parse(sIdFecha.Substring(0, 4)), Int32.Parse(sIdFecha.Substring(4, 2)), Int32.Parse(sIdFecha.Substring(6, 2)), Int32.Parse(sIdFecha.Substring(8, 2)), Int32.Parse(sIdFecha.Substring(10, 2)), 0);
idFechaMesAnterior = idFechaMesAnterior.AddMonths(-1);
HtmlTableCell htmlTblCell;
cAnalista oAnalista = new cAnalista(ref oConn);
oAnalista.NCod = hddNCod.Value;
oAnalista.TipoAnalista = oCmbTipoConsulta.Value;
DataTable tblAnalista = oAnalista.Get();
if (tblAnalista != null)
{
foreach (DataRow oRow in tblAnalista.Rows)
{
htmlTblCell = new HtmlTableCell();
htmlTblCell.Controls.Add(new LiteralControl("<div class=\"tbTit\">" + oRow["snombre"].ToString() + "</div>"));
trCabecera.Controls.Add(htmlTblCell);
}
}
tblAnalista.Dispose();
tblAnalista = null;
DataTable tblColumn2;
HtmlGenericControl oDivImg;
DataTable tblColumn1;
cIndresultado oIndResultado;
cIndumbral oIndumbral;
cAptPagesKpi oAptPagesKpi = new cAptPagesKpi(ref oConn);
oAptPagesKpi.CodCliente = pCodUsuario;
oAptPagesKpi.CodPage = pCodPage;
DataTable dtKPIs = oAptPagesKpi.Get();
if (dtKPIs != null)
{
foreach (DataRow oRowKpi in dtKPIs.Rows)
{
iDato = string.Empty;
sKeyTipo = string.Empty;
HtmlTableCell HtmlTablecell;
HtmlTablecell = new HtmlTableCell();
StringBuilder sNomKpi = new StringBuilder();
sNomKpi.Append("<td class=\"clPanel\"><div class=\"tbTTitRow\">");
sNomKpi.Append(oRowKpi["nombrekpi"].ToString());
sNomKpi.Append("</div></td>");
HtmlTablecell.Controls.Add(new LiteralControl(sNomKpi.ToString()));
HtmlTableRow htmlTblRowKpi = new HtmlTableRow();
htmlTblRowKpi.ID = oRowKpi["cod_kpi"].ToString() + "_KPI";
htmlTblRowKpi.Controls.Add(HtmlTablecell);
tbl.Controls.Add(htmlTblRowKpi);
HtmlTablecell = new HtmlTableCell();
StringBuilder sCriterioAceptacion = new StringBuilder();
sCriterioAceptacion.Append("<td class=\"clPanel\"><div class=\"tbTitRow\">Criterio Aceptación</div></td>");
HtmlTablecell.Controls.Add(new LiteralControl(sCriterioAceptacion.ToString()));
HtmlTableRow htmlTblRowCriAcep = new HtmlTableRow();
htmlTblRowCriAcep.ID = oRowKpi["cod_kpi"].ToString() + "_CriAcept";
htmlTblRowCriAcep.Controls.Add(HtmlTablecell);
tbl.Controls.Add(htmlTblRowCriAcep);
HtmlTablecell = new HtmlTableCell();
StringBuilder sCriterioSLA = new StringBuilder();
sCriterioSLA.Append("<td class=\"clPanel\"><div class=\"tbTitRow\">SLA</div></td>");
HtmlTablecell.Controls.Add(new LiteralControl(sCriterioSLA.ToString()));
HtmlTableRow htmlTblRowSLA = new HtmlTableRow();
htmlTblRowSLA.ID = oRowKpi["cod_kpi"].ToString() + "_SLA";
htmlTblRowSLA.Controls.Add(HtmlTablecell);
tbl.Controls.Add(htmlTblRowSLA);
HtmlTablecell = new HtmlTableCell();
StringBuilder sCriterioMesAnte = new StringBuilder();
sCriterioMesAnte.Append("<td class=\"clPanel\"><div class=\"tbTitRow\">Mes Anterior</div></td>");
HtmlTablecell.Controls.Add(new LiteralControl(sCriterioMesAnte.ToString()));
HtmlTableRow htmlTblRowMesAnt = new HtmlTableRow();
htmlTblRowMesAnt.ID = oRowKpi["cod_kpi"].ToString() + "_MesAnt";
htmlTblRowMesAnt.Controls.Add(HtmlTablecell);
tbl.Controls.Add(htmlTblRowMesAnt);
HtmlTableRow htmlTblRow = new HtmlTableRow();
htmlTblRow.ID = oRowKpi["cod_kpi"].ToString() + "row";
HtmlTablecell = new HtmlTableCell();
HtmlTablecell.Controls.Add(new LiteralControl("<td colspan=\"20\" style=\"height: 10px; \"></td>"));
htmlTblRow.Controls.Add(HtmlTablecell);
tbl.Controls.Add(htmlTblRow);
oAnalista = new cAnalista(ref oConn);
oAnalista.NCod = hddNCod.Value;
oAnalista.TipoAnalista = oCmbTipoConsulta.Value;
tblAnalista = oAnalista.Get();
if (tblAnalista != null)
{
foreach (DataRow oRow in tblAnalista.Rows)
{
oIndResultado = new cIndresultado(ref oConn);
oIndResultado.Tipo = oCmbTipoConsulta.Value;
oIndResultado.KeyCliente = oCmbCliente.Value;
oIndResultado.KeyTipo = oRow["nKey_Analista"].ToString();
oIndResultado.Indicador = oRowKpi["identificador_kpi"].ToString();
oIndResultado.IdFecha = sIdFecha;
tblColumn1 = oIndResultado.Get();
if (tblColumn1 != null)
{
if (tblColumn1.Rows.Count > 0)
{
iDato = (!string.IsNullOrEmpty(tblColumn1.Rows[0]["valor"].ToString()) ? tblColumn1.Rows[0]["valor"].ToString() : "0");
sKeyTipo = tblColumn1.Rows[0]["nkey_tipo"].ToString();
oIndumbral = new cIndumbral(ref oConn);
oIndumbral.KeyCliente = oCmbCliente.Value;
oIndumbral.Indicador = oRowKpi["identificador_kpi"].ToString();
oIndumbral.KeyTipo = sKeyTipo;
tblColumn2 = oIndumbral.Get();
if (tblColumn2 != null)
{
if (tblColumn2.Rows.Count > 0)
{
sNAvance = new StringBuilder();
sNAvance.Append("<div class=\"").Append(oWeb.getColorNumAvance(double.Parse(iDato), tblColumn2));
sNAvance.Append("\">").Append(String.Format("{0:0}", double.Parse(iDato))).Append("</div>");
htmlTblCell = new HtmlTableCell();
htmlTblCell.Attributes.Add("align", "center");
htmlTblCell.Attributes.Add("class", "clDtPanel");
htmlTblCell.Controls.Add(new LiteralControl(sNAvance.ToString()));
htmlTblRowKpi.Controls.Add(htmlTblCell);
htmlTblCell = new HtmlTableCell();
htmlTblCell.Attributes.Add("class", "clDtPanel");
htmlTblCell.Controls.Add(new LiteralControl("<div class=\"tbDat\">" + tblColumn2.Rows[0]["criterio_aceptacion"].ToString() + " " + tblColumn2.Rows[0]["unidad"].ToString() + "</div>"));
htmlTblRowCriAcep.Controls.Add(htmlTblCell);
htmlTblCell = new HtmlTableCell();
htmlTblCell.Attributes.Add("class", "clDtPanel");
htmlTblCell.Controls.Add(new LiteralControl("<div class=\"tbDat\">" + tblColumn2.Rows[0]["sla"].ToString() + "</div>"));
htmlTblRowSLA.Controls.Add(htmlTblCell);
}
tblColumn2.Dispose();
}
tblColumn2 = null;
}
tblColumn1.Dispose();
}
tblColumn1 = null;
oIndResultado.IdFecha = idFechaMesAnterior.ToString("yyyyMMddHHmm");
tblColumn1 = oIndResultado.GetMesAnterior();
if (tblColumn1 != null)
{
if (tblColumn1.Rows.Count > 0)
{
htmlTblCell = new HtmlTableCell();
htmlTblCell.Attributes.Add("class", "clDtPanel");
oDivImg = new HtmlGenericControl("div");
oDivImg.Attributes.Add("class", "tbDat");
oDivImg.Controls.Add(new LiteralControl("<img src=\"" + oWeb.getColorArrowCalidad(double.Parse(iDato), double.Parse(tblColumn1.Rows[0]["valor"].ToString())) + "\" border=\"0\">"));
htmlTblCell.Controls.Add(oDivImg);
htmlTblRowMesAnt.Controls.Add(htmlTblCell);
}
tblColumn1.Dispose();
}
tblColumn1 = null;
}
oIndResultado = null;
}
}
tblAnalista = null;
}
dtKPIs = null;
}
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();
}
}
}