public List <string> getDeudores(string sNomDeudor, string sHolding, string sCliente) { List <string> listDeudores = new List <string>(); DBConn oConn = new DBConn(); if (oConn.Open()) { cDashboard oDeudores = new cDashboard(ref oConn); oDeudores.NomDeudor = sNomDeudor; if (!string.IsNullOrEmpty(sHolding)) { oDeudores.CodHolding = sHolding; } if (!string.IsNullOrEmpty(sCliente)) { oDeudores.nKeyCliente = sCliente; } DataTable dtDeudores = oDeudores.GetDeudores(); if (dtDeudores != null) { if (dtDeudores.Rows.Count > 0) { foreach (DataRow oRow in dtDeudores.Rows) { listDeudores.Add(oRow["ncodigodeudor"].ToString() + " " + oRow["deudor"].ToString().Replace("'", "")); } } } dtDeudores = null; } oConn.Close(); return(listDeudores); }
protected void Page_Load(object sender, EventArgs e) { oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); if (oConn.Open()) { cDashboard oHistDBT = new cDashboard(ref oConn); oHistDBT.nKeyCliente = oIsUsuario.NKeyUsuario; oHistDBT.nKeyDeudor = oIsUsuario.NKeyDeudor; oHistDBT.CodHolding = oIsUsuario.NCodHolding; //Response.Write("GetDBT;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt = oHistDBT.GetDBT(); //Response.Write("GetDBT;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { string sMes = string.Empty; string sMeses = string.Empty; string sDBT = string.Empty; string sData = "['Meses','Días', { role: 'annotation' } ]"; foreach (DataRow oRow in dt.Rows) { sMes = oRow["periodo"].ToString().Trim(); sData = sData + ",['" + sMes + "'," + Math.Round(double.Parse(oRow["dbt"].ToString()), 0).ToString() + ",'" + Math.Round(double.Parse(oRow["dbt"].ToString()), 0).ToString("N0") + "']"; } StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawRightY); "); sHtml.Append(" function drawRightY() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(sData); sHtml.Append(" ]); "); sHtml.Append(" var materialOptions = { annotations: { alwaysOutside: true, textStyle: { fontSize: 12, auraColor: 'none', color: '#fff' }, boxStyle: { stroke: '#79B6CD', strokeWidth: 1, rx: 10, ry: 10, gradient: { color1: '#79B6CD', color2: '#79B6CD', x1: '0%', y1: '0%', x2: '100%', y2: '100%' } } }, legend: { position: 'top', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true, } }, vAxis: { format: 'short', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 12, bold: true } }, hAxis: { textStyle: { color: '#91BBDB', fontName: 'Lato', fontSize: 13, bold: true } }, colors: ['#A5E6FE', '#A5E6FE', '#A5E6FE', '#A5E6FE', '#A5E6FE'], bars: 'horizontal', axes: { y: { 0: { side: 'right' } } } }; "); sHtml.Append(" var materialChart = new google.visualization.BarChart(document.getElementById('horizontalBar')); "); sHtml.Append(" materialChart.draw(data, materialOptions); } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "horizontalBar", sHtml.ToString(), true); } } dt = null; dt = oHistDBT.GetCondicionPago(); if (dt != null) { if (dt.Rows.Count > 0) { lb_sla_dbt.Text = dt.Rows[0]["condicion_pago"].ToString() + " días"; } } dt = null; } oConn.Close(); } }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); if (oConn.Open()) { cDashboard oGestiones = new cDashboard(ref oConn); oGestiones.nKeyCliente = oIsUsuario.NKeyUsuario; oGestiones.nKeyDeudor = oIsUsuario.NKeyDeudor; oGestiones.CodHolding = oIsUsuario.NCodHolding; //Response.Write("GetGestiones;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt = oGestiones.GetGestiones(); //Response.Write("GetGestiones;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; gdGestiones.DataSource = dt; gdGestiones.DataBind(); } else { bEnable = false; getDummyTable(); } } else { bEnable = false; getDummyTable(); } } oConn.Close(); if (bEnable) { idGestionesEnable.Visible = true; idGestionesNoEnable.Visible = false; } else { idGestionesEnable.Visible = false; idGestionesNoEnable.Visible = true; } } else { idGestionesEnable.Visible = false; idGestionesNoEnable.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetExpires(DateTime.Now); Response.Cache.SetNoServerCaching(); Response.Cache.SetNoStore(); DBConn oConn = new DBConn(); oIsUsuario = oWeb.ValidaUserAppReport(); if (!IsPostBack) { bool bFromMenu = (!string.IsNullOrEmpty(oWeb.GetData("frommenu")) ? true : false); //idUser.Text = "¡Hola " + oIsUsuario.Nombres + "!"; idUser.Text = "CUSTOMER PROFILE "; if (oConn.Open()) { if (bFromMenu) { hdd_cliente.Value = oWeb.GetData("nkey_cliente"); hdd_holding.Value = oWeb.GetData("ncodholding"); cDashboard oDeudor = new cDashboard(ref oConn); if (!string.IsNullOrEmpty(hdd_cliente.Value)) { oDeudor.nKeyCliente = hdd_cliente.Value; } if (!string.IsNullOrEmpty(hdd_holding.Value)) { oDeudor.CodHolding = hdd_holding.Value; } if (!string.IsNullOrEmpty(oWeb.GetData("nkey_deudor"))) { oDeudor.nKeyDeudor = oWeb.GetData("nkey_deudor"); } DataTable dt = oDeudor.GetDeudores(); if (dt != null) { if (dt.Rows.Count > 0) { hdd_ncodigodeudor.Value = dt.Rows[0]["ncodigodeudor"].ToString() + " " + dt.Rows[0]["deudor"].ToString().Replace("'", ""); } } dt = null; hdd_load_msj.Value = "1"; } else { cDashboardKeys oDashboardKeys = new cDashboardKeys(ref oConn); oDashboardKeys.CodUser = oIsUsuario.CodUsuario; DataTable dt = oDashboardKeys.Get(); if (dt != null) { if (dt.Rows.Count > 0) { hdd_cliente.Value = dt.Rows[0]["nkey_cliente"].ToString(); hdd_holding.Value = dt.Rows[0]["ncodholding"].ToString(); hdd_ncodigodeudor.Value = dt.Rows[0]["ncodigodeudor"].ToString(); oIsUsuario.NKeyUsuario = dt.Rows[0]["nkey_cliente"].ToString(); oIsUsuario.NCodHolding = dt.Rows[0]["ncodholding"].ToString(); oIsUsuario.NCodigodeudor = dt.Rows[0]["ncodigodeudor"].ToString(); oIsUsuario.NKeyDeudor = dt.Rows[0]["nkey_deudor"].ToString(); hdd_load_msj.Value = "1"; } } dt = null; } } oConn.Close(); } if (!string.IsNullOrEmpty(hdd_loadnewcondition.Value)) { oIsUsuario.NKeyUsuario = string.Empty; oIsUsuario.NCodHolding = string.Empty; oIsUsuario.NKeyDeudor = string.Empty; oIsUsuario.NCodigodeudor = string.Empty; hdd_loadnewcondition.Value = ""; } if (oConn.Open()) { if (!string.IsNullOrEmpty(hdd_delete_widget.Value)) { cWidgets oWidgets = new cWidgets(ref oConn); oWidgets.CodUser = oIsUsuario.CodUsuario; oWidgets.CodWidget = hdd_delete_widget.Value; oWidgets.Accion = "ELIMINAR"; oWidgets.Put(); if (!string.IsNullOrEmpty(oWidgets.Error)) { Response.Write("Error de eliminación : " + oWidgets.Error); Response.End(); } hdd_delete_widget.Value = string.Empty; } bool indOneHolding = false; bool indCmbHoldingAct = false; cDashboard oHC = new cDashboard(ref oConn); oHC.CodUsuario = oIsUsuario.CodUsuario; DataTable dtHolding = oHC.GetHolding(); if (dtHolding != null) { if (dtHolding.Rows.Count > 0) { if (dtHolding.Rows.Count > 1) { indCmbHoldingAct = true; foreach (DataRow oRow in dtHolding.Rows) { idItemDropdownHolding.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-holding\" href=\"#\" data-value=\"" + oRow["ncodholding"].ToString() + "\">" + oRow["holding"].ToString().ToUpper() + "</a>")); } } else { indOneHolding = true; } } else { idCmbHolding.Visible = false; } } bool indOneCliente = false; bool indCmbClienteAct = false; DataTable dtClientes = oHC.GetClientes(); if (dtClientes != null) { if (dtClientes.Rows.Count > 0) { if (dtClientes.Rows.Count > 1) { indCmbClienteAct = true; foreach (DataRow oRow in dtClientes.Rows) { idItemDropdownCliente.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-cliente\" href=\"#\" data-value=\"" + oRow["nkey_cliente"].ToString() + "\">" + oRow["sNombre"].ToString().ToUpper() + "</a>")); } } else { indOneCliente = true; } } else { idCmbCliente.Visible = false; } } if ((indOneHolding) && (!idCmbCliente.Visible)) { hdd_holding.Value = dtHolding.Rows[0]["ncodholding"].ToString(); idCmbHolding.Visible = false; hdd_load_msj.Value = "1"; } else { if (!indCmbHoldingAct) { foreach (DataRow oRow in dtHolding.Rows) { idItemDropdownHolding.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-holding\" href=\"#\" data-value=\"" + oRow["ncodholding"].ToString() + "\">" + oRow["holding"].ToString().ToUpper() + "</a>")); } } } if ((indOneCliente) && (!idCmbHolding.Visible)) { hdd_cliente.Value = dtClientes.Rows[0]["nkey_cliente"].ToString(); idCmbCliente.Visible = false; hdd_load_msj.Value = "1"; } else { if (!indCmbClienteAct) { foreach (DataRow oRow in dtClientes.Rows) { idItemDropdownCliente.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-cliente\" href=\"#\" data-value=\"" + oRow["nkey_cliente"].ToString() + "\">" + oRow["sNombre"].ToString().ToUpper() + "</a>")); } } } dtClientes = null; dtHolding = null; } oConn.Close(); if (string.IsNullOrEmpty(hdd_load_msj.Value)) { hdd_load_msj.Value = "1"; ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "openmodal", "$('#modalRelatedContent').modal('show');", true); } else { if ((!string.IsNullOrEmpty(hdd_cliente.Value)) || (!string.IsNullOrEmpty(hdd_holding.Value))) { if (oConn.Open()) { cDashboard oClienteHolding = new cDashboard(ref oConn); oClienteHolding.nKeyCliente = hdd_cliente.Value; oClienteHolding.CodHolding = hdd_holding.Value; DataTable dt = oClienteHolding.GetClienteHolding(); if (dt != null) { if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(hdd_cliente.Value)) { dropdownholding.InnerText = "HOLDING"; dropdownempresas.InnerText = dt.Rows[0]["sNombre"].ToString().ToUpper(); lblClienteHolding.Text = "EMPRESA: " + dt.Rows[0]["sNombre"].ToString().ToUpper(); } if (!string.IsNullOrEmpty(hdd_holding.Value)) { dropdownholding.InnerText = dt.Rows[0]["holding"].ToString().ToUpper(); dropdownempresas.InnerText = "EMPRESAS"; lblClienteHolding.Text = "HOLDING: " + dt.Rows[0]["holding"].ToString().ToUpper(); } } } dt = null; } oConn.Close(); } if ((!string.IsNullOrEmpty(hdd_ncodigodeudor.Value)) && (!string.IsNullOrEmpty(hdd_cliente.Value)) || (!string.IsNullOrEmpty(hdd_holding.Value))) { if (oConn.Open()) { cDashboard oDeudor = new cDashboard(ref oConn); oDeudor.nKeyCliente = hdd_cliente.Value; oDeudor.CodHolding = hdd_holding.Value; oDeudor.NomDeudor = hdd_ncodigodeudor.Value; //oDeudor.CodigoDeudor = hdd_ncodigodeudor.Value; DataTable dt = oDeudor.GetDeudorByCodigo(); if (dt != null) { if (dt.Rows.Count > 0) { cDashboardKeys oDashboardKeys = new cDashboardKeys(ref oConn); oDashboardKeys.CodUser = oIsUsuario.CodUsuario; oDashboardKeys.Accion = "ELIMINAR"; oDashboardKeys.Put(); if (!string.IsNullOrEmpty(hdd_cliente.Value)) { oDashboardKeys.KeyCliente = hdd_cliente.Value; } if (!string.IsNullOrEmpty(hdd_holding.Value)) { oDashboardKeys.CodHolding = hdd_holding.Value; } oDashboardKeys.CodigoDeudor = hdd_ncodigodeudor.Value; oDashboardKeys.KeyDeudor = dt.Rows[0]["nkey_deudor"].ToString(); oDashboardKeys.Accion = "CREAR"; oDashboardKeys.Put(); oIsUsuario.NKeyUsuario = hdd_cliente.Value; oIsUsuario.NCodHolding = hdd_holding.Value; oIsUsuario.NCodigodeudor = hdd_ncodigodeudor.Value; oIsUsuario.NKeyDeudor = dt.Rows[0]["nkey_deudor"].ToString(); oIsUsuario.Moneda = oDeudor.getSimboloMoneda(); //lblDeudor.Text = "Estás en el CUSTOMER PROFILE " + dt.Rows[0]["deudor"].ToString() + " Cod. " + dt.Rows[0]["ncodigodeudor"].ToString(); lblDeudor.Text = (dt.Rows[0]["deudor"].ToString() + " Cod. " + dt.Rows[0]["ncodigodeudor"].ToString()).ToUpper(); Log oLog = new Log(); oLog.IdUsuario = oIsUsuario.CodUsuario; oLog.ObsLog = "CUSTOMER PROFILE " + dt.Rows[0]["deudor"].ToString() + " Cod. " + dt.Rows[0]["ncodigodeudor"].ToString(); oLog.CodEvtLog = "100"; oLog.AppLog = "CUSTOMER PROFILE"; if (!string.IsNullOrEmpty(hdd_cliente.Value)) { oLog.NkeyCliente = hdd_cliente.Value; } if (!string.IsNullOrEmpty(hdd_holding.Value)) { oLog.NcodHolding = hdd_holding.Value; } oLog.NkeyDeudor = dt.Rows[0]["nkey_deudor"].ToString(); oLog.putLog(); } } dt = null; } oConn.Close(); } else { hdd_ncodigodeudor.Value = string.Empty; lblDeudor.Text = string.Empty;; } } getWidgetAvailable(); DataTable dtWidget = null; if (oConn.Open()) { cWidgets oWidgets = new cWidgets(ref oConn); oWidgets.CodUser = oIsUsuario.CodUsuario; dtWidget = oWidgets.getWidgetsByUser(); } oConn.Close(); DrawDashboard(dtWidget); }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); { if (oConn.Open()) { string sMes = ("00" + DateTime.Now.AddMonths(-1).Month.ToString()).Substring(("00" + DateTime.Now.AddMonths(-1).Month.ToString()).Length - 2); double iEstimadoMesAnterior = 0; double iReaMesAnterior = 0; cDashboard oEstadimadoVsReal = new cDashboard(ref oConn); oEstadimadoVsReal.nKeyCliente = oIsUsuario.NKeyUsuario; oEstadimadoVsReal.nKeyDeudor = oIsUsuario.NKeyDeudor; oEstadimadoVsReal.CodHolding = oIsUsuario.NCodHolding; oEstadimadoVsReal.Periodo = sMes + "-01-" + (sMes == "12" ? DateTime.Now.AddYears(-1).Year.ToString() : DateTime.Now.Year.ToString()); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt = oEstadimadoVsReal.GetEstimadoVsReal(); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; iEstimadoMesAnterior = double.Parse(dt.Rows[0]["estimado"].ToString()); iReaMesAnterior = double.Parse(dt.Rows[0]["real"].ToString()); } } dt = null; oEstadimadoVsReal.Periodo = (sMes == "12" ? DateTime.Now.AddYears(-1).Year.ToString() : DateTime.Now.Year.ToString()) + sMes; //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iFacturadoMesAnterior = oEstadimadoVsReal.GetFacturado(); //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); sMes = ("00" + DateTime.Now.Month.ToString()).Substring(("00" + DateTime.Now.Month.ToString()).Length - 2); double iEstimadoMes = 0; double iReaMes = 0; oEstadimadoVsReal.Periodo = sMes + "-01-" + DateTime.Now.Year.ToString(); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oEstadimadoVsReal.GetEstimadoVsReal(); //Response.Write("GetEstimadoVsReal;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; iEstimadoMes = double.Parse(dt.Rows[0]["estimado"].ToString()); iReaMes = double.Parse(dt.Rows[0]["real"].ToString()); } } dt = null; oEstadimadoVsReal.Periodo = DateTime.Now.Year.ToString() + sMes; //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); float iFacturado = oEstadimadoVsReal.GetFacturado(); //Response.Write("GetFacturado;" + DateTime.Now.Millisecond.ToString() + "<br>"); string sdata = "['PERIODO', 'Facturado', { type: 'string', role: 'annotation' }, 'Estimado', { type: 'string', role: 'annotation' }, 'Real', { type: 'string', role: 'annotation' }],"; sdata = sdata + "['Anterior'," + Math.Round(iFacturadoMesAnterior, 0).ToString() + ",'" + ((iFacturadoMesAnterior > 0)? Math.Round((iFacturadoMesAnterior / 1000000), 0).ToString() :"0") + "M'," + Math.Round(iEstimadoMesAnterior, 0).ToString() + ",'" + ((iEstimadoMesAnterior > 0) ? Math.Round((iEstimadoMesAnterior / 1000000), 0).ToString() : "0") + "M'," + Math.Round(iReaMesAnterior, 0).ToString() + ",'" + ((iReaMesAnterior > 0) ? Math.Round((iReaMesAnterior / 1000000), 0).ToString() : "0") + "M'],"; sdata = sdata + "['Actual'," + Math.Round(iFacturado, 0).ToString() + ",'" + ((iFacturado > 0) ? Math.Round((iFacturado / 1000000), 0).ToString() : "0") + "M'," + Math.Round(iEstimadoMes, 0).ToString() + ",'" + ((iEstimadoMes > 0) ? Math.Round((iEstimadoMes / 1000000), 0).ToString() : "0") + "M'," + Math.Round(iReaMes, 0).ToString() + ",'" + ((iReaMes > 0) ? Math.Round((iReaMes / 1000000), 0).ToString() : "0") + "M']"; StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawlineChart2); "); sHtml.Append(" function drawlineChart2() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(sdata); sHtml.Append(" ]); "); sHtml.Append(" var options = { annotations: { alwaysOutside: true, textStyle: { fontSize: 12, auraColor: 'none', color: '#fff' }, boxStyle: { stroke: '#79B6CD', strokeWidth: 1, rx: 10, ry: 10, gradient: { color1: '#79B6CD', color2: '#79B6CD', x1: '0%', y1: '0%', x2: '100%', y2: '100%' } } }, legend: { position: 'bottom', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true, } }, vAxis: { format: 'short', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 12, bold: true } }, hAxis: { textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true } }, colors: ['#BAE1EF', '#A5E6FE', '#6498FF'] }; "); sHtml.Append(" var chart = new google.visualization.ColumnChart(document.getElementById('lineChart2')); "); sHtml.Append(" chart.draw(data, options); "); sHtml.Append(" } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "lineChart2", sHtml.ToString(), true); string sDia = ("00" + DateTime.Now.Day.ToString()).Substring(("00" + DateTime.Now.Day.ToString()).Length - 2); oEstadimadoVsReal.Periodo = DateTime.Now.Year.ToString() + sMes + sDia; //Response.Write("GetTotal;" + DateTime.Now.Millisecond.ToString() + "<br>"); double itotal = oEstadimadoVsReal.GetTotal(); //Response.Write("GetTotal;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iDeudaVencida = oEstadimadoVsReal.GetDeudaVencida(); //Response.Write("GetDeudaVencida;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iDeudaDocumentada = oEstadimadoVsReal.GetDeudaDocumentada(); //Response.Write("GetDeudaDocumentada;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iFacturasMayor30 = oEstadimadoVsReal.GetFacturasMayor30(); //Response.Write("GetFacturasMayor30;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iFacturasMayor30SinLitigio = oEstadimadoVsReal.GetFacturasMayor30SinLitigio(); //Response.Write("GetFacturasMayor30SinLitigio;" + DateTime.Now.Millisecond.ToString() + "<br>"); lblTotal.Text = oIsUsuario.Moneda + " " + Math.Truncate(itotal).ToString("N0"); lblVencidas.Text = oIsUsuario.Moneda + " " + Math.Truncate(iDeudaVencida).ToString("N0"); lblDeudaDocumentada.Text = oIsUsuario.Moneda + " " + Math.Truncate(iDeudaDocumentada).ToString("N0"); lblVencidas30.Text = oIsUsuario.Moneda + " " + Math.Truncate(iFacturasMayor30).ToString("N0"); lblVencidas30SinLitigios.Text = oIsUsuario.Moneda + " " + Math.Truncate(iFacturasMayor30SinLitigio).ToString("N0"); //if ((iEstimadoMesAnterior != 0) || (iReaMesAnterior != 0) || (iEstimadoMes != 0) || (iReaMes != 0) || (itotal != 0) || (iDeudaVencida != 0) || (iFacturasMayor30 != 0) || (iFacturasMayor30SinLitigio != 0)) // bEnable = true; } oConn.Close(); } if (bEnable) { idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { toExcel.Visible = false; Response.Cache.SetCacheability(HttpCacheability.NoCache); Response.Cache.SetExpires(DateTime.Now); Response.Cache.SetNoServerCaching(); Response.Cache.SetNoStore(); DBConn oConn = new DBConn(); oIsUsuario = oWeb.ValidaUserAppReport(); //idUser.Text = "¡Hola " + oIsUsuario.Nombres + "!"; if (!string.IsNullOrEmpty(hdd_loadnewcondition.Value)) { oIsUsuario.NKeyUsuario = string.Empty; oIsUsuario.NCodHolding = string.Empty; oIsUsuario.NKeyDeudor = string.Empty; oIsUsuario.NCodigodeudor = string.Empty; hdd_loadnewcondition.Value = ""; } if (oConn.Open()) { bool indOneHolding = false; bool indCmbHoldingAct = false; cDashboard oHC = new cDashboard(ref oConn); oHC.CodUsuario = oIsUsuario.CodUsuario; DataTable dtHolding = oHC.GetHolding(); if (dtHolding != null) { if (dtHolding.Rows.Count > 0) { if (dtHolding.Rows.Count > 1) { indCmbHoldingAct = true; foreach (DataRow oRow in dtHolding.Rows) { idItemDropdownHolding.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-holding\" href=\"#\" data-value=\"" + oRow["ncodholding"].ToString() + "\">" + oRow["holding"].ToString().ToUpper() + "</a>")); } } else { indOneHolding = true; } } else { idCmbHolding.Visible = false; } } bool indOneCliente = false; bool indCmbClienteAct = false; oHC.CodUsuario = oIsUsuario.CodUsuario; DataTable dtClientes = oHC.GetClientes(); if (dtClientes != null) { if (dtClientes.Rows.Count > 0) { if (dtClientes.Rows.Count > 1) { indCmbClienteAct = true; foreach (DataRow oRow in dtClientes.Rows) { idItemDropdownCliente.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-cliente\" href=\"#\" data-value=\"" + oRow["nkey_cliente"].ToString() + "\">" + oRow["sNombre"].ToString().ToUpper() + "</a>")); } } else { indOneCliente = true; } } else { idCmbCliente.Visible = false; } } if ((indOneHolding) && (!idCmbCliente.Visible)) { hdd_holding.Value = dtHolding.Rows[0]["ncodholding"].ToString(); idCmbHolding.Visible = false; } else { if (!indCmbHoldingAct) { foreach (DataRow oRow in dtHolding.Rows) { idItemDropdownHolding.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-holding\" href=\"#\" data-value=\"" + oRow["ncodholding"].ToString() + "\">" + oRow["holding"].ToString().ToUpper() + "</a>")); } } } if (indOneCliente) { hdd_cliente.Value = dtClientes.Rows[0]["nkey_cliente"].ToString(); idCmbCliente.Visible = false; } else { if (!indCmbClienteAct) { foreach (DataRow oRow in dtClientes.Rows) { idItemDropdownCliente.Controls.Add(new LiteralControl("<a class=\"dropdown-item item-cliente\" href=\"#\" data-value=\"" + oRow["nkey_cliente"].ToString() + "\">" + oRow["sNombre"].ToString().ToUpper() + "</a>")); } } } dtClientes = null; } if ((!string.IsNullOrEmpty(hdd_cliente.Value)) || (!string.IsNullOrEmpty(hdd_holding.Value))) { cDashboard oClienteHolding = new cDashboard(ref oConn); oClienteHolding.nKeyCliente = hdd_cliente.Value; oClienteHolding.CodHolding = hdd_holding.Value; DataTable dt = oClienteHolding.GetClienteHolding(); if (dt != null) { if (dt.Rows.Count > 0) { if (!string.IsNullOrEmpty(hdd_cliente.Value)) { dropdownholding.InnerText = "HOLDING"; dropdownempresas.InnerText = dt.Rows[0]["sNombre"].ToString().ToUpper(); lblDeudor.Text = "Litigios : " + dt.Rows[0]["sNombre"].ToString().ToUpper(); } else { dropdownholding.InnerText = dt.Rows[0]["holding"].ToString().ToUpper(); dropdownempresas.InnerText = "EMPRESAS"; lblDeudor.Text = "Litigios : " + dt.Rows[0]["holding"].ToString().ToUpper(); } getResumen(); getAntiguedad(); getDetalleCanal(); getSubMotivo(); getDetalle(); Log oLog = new Log(); oLog.IdUsuario = oIsUsuario.CodUsuario; oLog.ObsLog = "LITIGIOS " + dt.Rows[0]["sNombre"].ToString(); oLog.CodEvtLog = "201"; oLog.AppLog = "LITIGIOS"; if (!string.IsNullOrEmpty(hdd_cliente.Value)) { oLog.NkeyCliente = hdd_cliente.Value; } if (!string.IsNullOrEmpty(hdd_holding.Value)) { oLog.NcodHolding = hdd_holding.Value; } oLog.putLog(); } } dt = null; } else { lblDeudor.Text = string.Empty; hdd_cliente.Value = string.Empty; } oConn.Close(); }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); if (oConn.Open()) { cDashboard oDso = new cDashboard(ref oConn); oDso.nKeyCliente = oIsUsuario.NKeyUsuario; oDso.nKeyDeudor = oIsUsuario.NKeyDeudor; oDso.CodHolding = oIsUsuario.NCodHolding; oDso.Ano = DateTime.Now.Year.ToString(); //Response.Write("GetDso;" + DateTime.Now.Millisecond.ToString()+"<br>"); DataTable dt = oDso.GetDso(); //Response.Write("GetDso;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; string sMeses = string.Empty; string sMes = string.Empty; string sDso = string.Empty; string sData = "['Perido', 'Días']"; foreach (DataRow oRow in dt.Rows) { sMes = oRow["periodo"].ToString().Trim(); sData = sData + ",['" + sMes + "'," + double.Parse(oRow["dso"].ToString()).ToString("0.00", CultureInfo.InvariantCulture) + "]"; } StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawChartDso); "); sHtml.Append(" function drawChartDso() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(sData); sHtml.Append(" ]); "); sHtml.Append(" var options = { legend: { position: 'bottom', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true, } }, vAxis: { format: 'short', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 12, bold: true } }, hAxis: { textStyle: { color: '#629DCC', fontName: 'Lato', fontSize: 10, bold: true } }, colors: ['#F5A624'], pointSize: 10, backgroundColor: '#fff' }; "); sHtml.Append(" var chart = new google.visualization.AreaChart(document.getElementById('lineChart1')); "); sHtml.Append(" chart.draw(data, options); } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "lineChart1", sHtml.ToString(), true); } } dt = null; dt = oDso.GetSlaDso(); if (dt != null) { if (dt.Rows.Count > 0) { lb_sla_dso.Text = dt.Rows[0]["SLA_DSO"].ToString() + " " + dt.Rows[0]["unidad"].ToString(); } } dt = null; } oConn.Close(); if (bEnable) { idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); { string sPastDue = string.Empty; string sDocOverDue = string.Empty; string sPastDueCritico = string.Empty; string sDocOverDueCritico = string.Empty; if (oConn.Open()) { cDashboard oPastDue = new cDashboard(ref oConn); oPastDue.nKeyCliente = oIsUsuario.NKeyUsuario; oPastDue.nKeyDeudor = oIsUsuario.NKeyDeudor; oPastDue.CodHolding = oIsUsuario.NCodHolding; double iTotalPastDue = oPastDue.getTotalPastDue(); double iPastDueCritico = oPastDue.getPastDueCritico(); string sMes = DateTime.Now.Month.ToString(); sMes = ((sMes.Length > 1) ? sMes : " " + sMes); oPastDue.Periodo = DateTime.Now.AddYears(-1).Year.ToString() + "-" + sMes; double iTotalPastDueHist = oPastDue.getTotalPastDueHist(); double iPastDueCriticoHist = oPastDue.getPastDueCriticoHist(); lb_monto_total.Text = oIsUsuario.Moneda + Math.Truncate(iTotalPastDue).ToString("N0"); lb_monto_critico.Text = oIsUsuario.Moneda + Math.Truncate(iPastDueCritico).ToString("N0"); lb_monto_total_hist.Text = oIsUsuario.Moneda + Math.Truncate(iTotalPastDueHist).ToString("N0"); lb_monto_critico_hist.Text = oIsUsuario.Moneda + Math.Truncate(iPastDueCriticoHist).ToString("N0"); lb_variacion_total.Text = ((iTotalPastDue > 0 && iTotalPastDueHist > 0)? (((iTotalPastDue - iTotalPastDueHist) / iTotalPastDueHist) * 100).ToString("0.00", CultureInfo.InvariantCulture) + "%" : ""); lb_variacion_critico_hist.Text = ((iPastDueCritico > 0 && iPastDueCriticoHist > 0)? (((iPastDueCritico - iPastDueCriticoHist) / iPastDueCriticoHist) * 100).ToString("0.00", CultureInfo.InvariantCulture) + "%" : ""); string sPeriodo1 = oWeb.getMes(DateTime.Now.Month).Substring(0, 3) + ' ' + DateTime.Now.Year.ToString(); lb_mesano_actual.Text = sPeriodo1; string sPeriodo2 = oWeb.getMes(DateTime.Now.Month).Substring(0, 3) + ' ' + DateTime.Now.AddYears(-1).Year.ToString(); lb_mesano_ant.Text = sPeriodo2; StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawChartPasDue); "); sHtml.Append(" function drawChartPasDue() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(" ['PERIODO','Total', 'Crítico'], "); sHtml.Append(" ['" + sPeriodo1 + "'," + iTotalPastDue.ToString("0.00", CultureInfo.InvariantCulture) + "," + iPastDueCritico.ToString("0.00", CultureInfo.InvariantCulture) + "], "); sHtml.Append(" ['" + sPeriodo2 + "'," + iTotalPastDueHist.ToString("0.00", CultureInfo.InvariantCulture) + "," + iPastDueCriticoHist.ToString("0.00", CultureInfo.InvariantCulture) + "] "); sHtml.Append(" ]); "); sHtml.Append(" var options = { "); sHtml.Append(" legend: { position: 'bottom', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 13, bold: true, } }, "); sHtml.Append(" vAxis: { format: 'short', textStyle: { color: '#639ECC', fontName: 'Lato', fontSize: 14, bold: true } }, "); sHtml.Append(" hAxis: { textStyle: { color: '#ACACAC', fontName: 'Lato', fontSize: 10, bold: true } }, "); sHtml.Append(" colors: ['#7ED321', '#6498FF'], "); sHtml.Append(" bars: 'horizontal' "); sHtml.Append(" }; "); sHtml.Append(" var chart = new google.charts.Bar(document.getElementById('chartPasDue')); "); sHtml.Append(" chart.draw(data, google.charts.Bar.convertOptions(options)); "); sHtml.Append(" } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "chartPasDue", sHtml.ToString(), true); } oConn.Close(); bEnable = true; if (bEnable) { idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } } } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { string s30 = string.Empty; string s60 = string.Empty; string s90 = string.Empty; string sMayor = string.Empty; string sDiasProvision = string.Empty; DBConn oConn = new DBConn(); if (oConn.Open()) { DataTable dt = null; cDashboard oLitigios = new cDashboard(ref oConn); oLitigios.nKeyCliente = oIsUsuario.NKeyUsuario; oLitigios.nKeyDeudor = oIsUsuario.NKeyDeudor; oLitigios.CodHolding = oIsUsuario.NCodHolding; oLitigios.Periodo = "30"; //Response.Write("GetLitigios 30;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oLitigios.GetLitigios(); //Response.Write("GetLitigios 30;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; s30 = dt.Rows[0]["saldo"].ToString(); lbl_30.Text = oIsUsuario.Moneda + " " + double.Parse(s30).ToString("N0"); } } dt = null; oLitigios.Periodo = "60"; //Response.Write("GetLitigios 60;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oLitigios.GetLitigios(); //Response.Write("GetLitigios 60;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; s60 = dt.Rows[0]["saldo"].ToString(); lbl_60.Text = oIsUsuario.Moneda + " " + double.Parse(s60).ToString("N0"); } } dt = null; oLitigios.Periodo = "90"; //Response.Write("GetLitigios 90;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oLitigios.GetLitigios(); //Response.Write("GetLitigios 90;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; s90 = dt.Rows[0]["saldo"].ToString(); lbl_90.Text = oIsUsuario.Moneda + " " + double.Parse(s90).ToString("N0"); } } dt = null; oLitigios.Periodo = "mayor"; //Response.Write("GetLitigios mayor;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oLitigios.GetLitigios(); //Response.Write("GetLitigios mayor;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; sMayor = dt.Rows[0]["saldo"].ToString(); lbl_mayor.Text = oIsUsuario.Moneda + " " + double.Parse(sMayor).ToString("N0"); } } dt = null; double iResultado = 0; //Response.Write("GetDiasProcesoNormalizacion;" + DateTime.Now.Millisecond.ToString() + "<br>"); dt = oLitigios.GetDiasProcesoNormalizacion(); //Response.Write("GetDiasProcesoNormalizacion;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { bEnable = true; iResultado = double.Parse(dt.Compute(" sum(resultado) ", string.Empty).ToString()); sDiasProvision = (iResultado / dt.Rows.Count).ToString("N0"); lblDiasProvision.Text = sDiasProvision + " días"; } } dt = null; } oConn.Close(); //if (((!string.IsNullOrEmpty(s30)) && (s30 != "0")) || ((!string.IsNullOrEmpty(s60)) && (s60 != "0")) || ((!string.IsNullOrEmpty(s90)) && (s90 != "0")) || ((!string.IsNullOrEmpty(sMayor))&&(sMayor != "0")) || ((!string.IsNullOrEmpty(sDiasProvision)) && (sDiasProvision != "0")) ) if (bEnable) { idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); if (oConn.Open()) { string sProvision = string.Empty; string sImpactoProvision = string.Empty; string sProvisionAcumulada = string.Empty; cDashboard oProvision = new cDashboard(ref oConn); oProvision.nKeyCliente = oIsUsuario.NKeyUsuario; oProvision.nKeyDeudor = oIsUsuario.NKeyDeudor; oProvision.CodHolding = oIsUsuario.NCodHolding; //Response.Write("GetProvision;" + DateTime.Now.Millisecond.ToString() + "<br>"); sProvision = oProvision.GetProvision(); //Response.Write("GetImpactoProvision;" + DateTime.Now.Millisecond.ToString() + "<br>"); sImpactoProvision = oProvision.GetImpactoProvision(); //Response.Write("GetProvisionAcumulada;" + DateTime.Now.Millisecond.ToString() + "<br>"); sProvisionAcumulada = oProvision.GetProvisionAcumulada(); if ((!string.IsNullOrEmpty(sImpactoProvision)) && (!string.IsNullOrEmpty(sProvisionAcumulada))) { bEnable = true; lblProvision.Text = (!string.IsNullOrEmpty(sProvision) ? oIsUsuario.Moneda + " " + double.Parse(sProvision).ToString("N0") + " M": "0"); lblImpactoProvision.Text = (!string.IsNullOrEmpty(sImpactoProvision) ? oIsUsuario.Moneda + " " + double.Parse(sImpactoProvision).ToString("N0") : "0"); lblProvisionAcumulada.Text = (!string.IsNullOrEmpty(sProvisionAcumulada)? oIsUsuario.Moneda + " " + (double.Parse(sProvisionAcumulada) * 1000000).ToString("N0") : "0"); double iProvisionDisponible = (double.Parse(sProvisionAcumulada) * 1000000) - double.Parse(sImpactoProvision); string sData = "['TIPO', 'MONTO'],"; sData = sData + "['Impacto Provisión'," + Math.Round(double.Parse(sImpactoProvision), 2).ToString("0.00", CultureInfo.InvariantCulture) + "],"; sData = sData + "['Provisión Acumulada'," + Math.Round(iProvisionDisponible, 2).ToString("0.00", CultureInfo.InvariantCulture) + "]"; StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawChartProvison); "); sHtml.Append(" function drawChartProvison() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(sData); sHtml.Append(" ]); "); sHtml.Append(" var options = { pieHole: 0.5, pieSliceText:'none', pieSliceTextStyle: 'none', pieSliceBorderColor: 'none', legend: 'none', colors: ['#D0021B', '#7ED321'], chartArea: { left: 10, right: 10, bottom: 10, top: 10 } }; "); sHtml.Append(" var chart = new google.visualization.PieChart(document.getElementById('pieChart')); "); sHtml.Append(" chart.draw(data, options); } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "pieChart", sHtml.ToString(), true); } } oConn.Close(); if (bEnable) { idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; bool bLCA = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { double iConsumido = 0; double iDisponible = 0; double iLCA = 0; DBConn oConn = new DBConn(); if (oConn.Open()) { cDashboard oOverView = new cDashboard(ref oConn); oOverView.CodHolding = oIsUsuario.NCodHolding; oOverView.nKeyCliente = oIsUsuario.NKeyUsuario; oOverView.nKeyDeudor = oIsUsuario.NKeyDeudor; //Response.Write("GetLCAConsumido;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dtLCA_Consumido = oOverView.GetLCAConsumido(); //Response.Write("GetLCAConsumido;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dtLCA_Consumido != null) { if (dtLCA_Consumido.Rows.Count > 0) { iConsumido = double.Parse(dtLCA_Consumido.Rows[0]["consumido"].ToString()); tt_consumido.Text = oIsUsuario.Moneda + " " + Math.Truncate(double.Parse(dtLCA_Consumido.Rows[0]["consumido"].ToString())).ToString("N0"); } } dtLCA_Consumido = null; //Response.Write("GetLCADisponible;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dtLCA_Disponible = oOverView.GetLCADisponible(); //Response.Write("GetLCADisponible;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dtLCA_Disponible != null) { if (dtLCA_Disponible.Rows.Count > 0) { iLCA = double.Parse(dtLCA_Disponible.Rows[0]["disponible"].ToString()); iDisponible = iLCA - iConsumido; tt_disponible.Text = oIsUsuario.Moneda + " " + Math.Truncate(iDisponible).ToString("N0"); } } dtLCA_Consumido = null; double iPorcentaje = 0; string sProgress = string.Empty; string sPorcentaje = string.Empty; lblPorcentaje.CssClass = "percentaje-overview"; if ((iConsumido != 0) && (iLCA != 0)) { bLCA = true; bEnable = true; lblTitle.Text = "Línea de Crédito"; lblConsumido.Text = "Consumido"; lblDisponible.Text = "Disponible"; iPorcentaje = Math.Round((iConsumido / iLCA) * 100, 0); sPorcentaje = iPorcentaje.ToString() + "%"; lblPorcentaje.Text = sPorcentaje; if (iDisponible <= 0) { if (iPorcentaje <= -100000) { lblPorcentaje.CssClass = "percentaje-overview-red-low"; } else if (iPorcentaje >= 100000) { lblPorcentaje.CssClass = "percentaje-overview-red-low"; } else { lblPorcentaje.CssClass = "percentaje-overview-red"; } } else { if (iPorcentaje >= 100000) { lblPorcentaje.CssClass = "percentaje-overview-low"; } else { lblPorcentaje.CssClass = "percentaje-overview"; } } } else { string sMes = "00" + DateTime.Now.Month.ToString(); sMes = sMes.Substring(sMes.Length - 2); oOverView.Periodo = sMes + "-01-" + DateTime.Now.Year.ToString(); //Response.Write("GetEstimadoCaja;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dtEstimadoCaja = oOverView.GetEstimadoCaja(); //Response.Write("GetEstimadoCaja;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dtEstimadoCaja != null) { if (dtEstimadoCaja.Rows.Count > 0) { bEnable = true; iConsumido = double.Parse(dtEstimadoCaja.Rows[0]["estimado"].ToString()); tt_consumido.Text = oIsUsuario.Moneda + " " + Math.Truncate(double.Parse(dtEstimadoCaja.Rows[0]["estimado"].ToString())).ToString("N0"); iDisponible = double.Parse(dtEstimadoCaja.Rows[0]["real"].ToString()); tt_disponible.Text = oIsUsuario.Moneda + " " + Math.Truncate(double.Parse(dtEstimadoCaja.Rows[0]["real"].ToString())).ToString("N0"); lblTitle.Text = "Estimado Caja"; lblConsumido.Text = "Estimado"; lblDisponible.Text = "Real"; if ((iConsumido != 0) && (iDisponible != 0)) { iPorcentaje = Math.Round((iDisponible / iConsumido) * 100, 0); if (iPorcentaje >= 100) { if (iPorcentaje >= 100000) { lblPorcentaje.CssClass = "percentaje-overview-crema-low"; } else { lblPorcentaje.CssClass = "percentaje-overview-crema"; } } else { if (iPorcentaje <= -100000) { lblPorcentaje.CssClass = "percentaje-overview-low"; } else { lblPorcentaje.CssClass = "percentaje-overview"; } } sPorcentaje = iPorcentaje.ToString() + "%"; } else { sPorcentaje = "0%"; } lblPorcentaje.Text = sPorcentaje; } } dtEstimadoCaja = null; } StringBuilder sHtml_Graph = new StringBuilder(); sHtml_Graph.Append(" google.charts.setOnLoadCallback(drawChart); "); sHtml_Graph.Append(" function drawChart() { "); sHtml_Graph.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml_Graph.Append(" ['Porcentaje','Dato'], "); sHtml_Graph.Append(" ['" + lblConsumido.Text + "'," + ((iConsumido >= 0) ? iConsumido.ToString("0.00", CultureInfo.InvariantCulture) : "0") + "], "); sHtml_Graph.Append(" ['" + lblDisponible.Text + "'," + ((iDisponible > 0) ? iDisponible.ToString("0.00", CultureInfo.InvariantCulture) : "0") + "], "); sHtml_Graph.Append(" ]); "); sHtml_Graph.Append(" var options = { "); sHtml_Graph.Append(" pieHole: 0.9, "); sHtml_Graph.Append(" pieSliceText:'none', pieSliceTextStyle: 'none', pieSliceBorderColor: 'none', "); if (bLCA) { sHtml_Graph.Append(" colors: ['" + ((iDisponible <= 0) ? "#D0021B" : "#1578FF") + "', '#FFDFAB'], "); } else { if (iPorcentaje >= 100) { sHtml_Graph.Append(" colors: ['#FFDFAB', '#FFDFAB'], "); } else if (iPorcentaje <= 0) { sHtml_Graph.Append(" colors: ['#1578FF', '#1578FF'], "); } else { sHtml_Graph.Append(" colors: ['#1578FF', '#FFDFAB'], "); } } sHtml_Graph.Append(" legend: 'none', chartArea: { left: 10, right: 10, bottom: 10, top: 10 } "); sHtml_Graph.Append(" }; "); sHtml_Graph.Append(" var chart = new google.visualization.PieChart(document.getElementById('donut_single')); "); sHtml_Graph.Append(" chart.draw(data, options); "); sHtml_Graph.Append(" }; "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "donut_single", sHtml_Graph.ToString(), true); //sProgress = "<div class=\"progress-bar\" role=\"progressbar\" style=\"width:" + sPorcentaje + "\" aria-valuenow=\"25\" aria-valuemin=\"0\" aria-valuemax=\"100\">" + sPorcentaje + "</div>"; //oProgressBar.Controls.Add(new LiteralControl(sProgress)); string sTipoPago = string.Empty; //Response.Write("GetMonto_TipoPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt_Monto_TipoPago = oOverView.GetMonto_TipoPago(); //Response.Write("GetMonto_TipoPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt_Monto_TipoPago != null) { if (dt_Monto_TipoPago.Rows.Count > 0) { lb_Monto_abono.Text = oIsUsuario.Moneda + " " + Math.Truncate(double.Parse(dt_Monto_TipoPago.Rows[0]["monto_ultimo_abono"].ToString())).ToString("N0"); lb_tipo_pago.Text = dt_Monto_TipoPago.Rows[0]["sTipoPago"].ToString(); } } dt_Monto_TipoPago = null; //Response.Write("GetUltimoDocPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt_UltDocPago = oOverView.GetUltimoDocPago(); //Response.Write("GetUltimoDocPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt_UltDocPago != null) { if (dt_UltDocPago.Rows.Count > 0) { bEnable = true; string dUltimoAbono = string.Empty; switch (dt_UltDocPago.Rows[0]["descripcion_via_pago"].ToString()) { case "Depósito": dUltimoAbono = DateTime.Parse(dt_UltDocPago.Rows[0]["dfechaVencimiento"].ToString()).ToString("dd-MM-yyyy"); break; default: dUltimoAbono = DateTime.Parse(dt_UltDocPago.Rows[0]["dFechaIngreso"].ToString()).ToString("dd-MM-yyyy"); break; } lbl_UltAbono.Text = dUltimoAbono; if (!string.IsNullOrEmpty(dt_UltDocPago.Rows[0]["seguro"].ToString())) { switch (dt_UltDocPago.Rows[0]["seguro"].ToString()) { case "0": lb_Seguro_Credito.Text = "No"; break; case "1": lb_Seguro_Credito.Text = "Si"; break; } } if (bLCA) { idStatus.Visible = true; string sEstatus = dt_UltDocPago.Rows[0]["estatus"].ToString(); string sColorIcono = string.Empty; StringBuilder sHtml = new StringBuilder(); sHtml.Append(" <div class=\"col-md-12 col_status_overview\"> "); sHtml.Append("<span class=\"tt-status\">Status Línea de crédito: </span><span class=\"lbl-dt-status\">").Append(sEstatus.Trim()).Append("</span>"); sHtml.Append("</div>"); idStatus.Controls.Add(new LiteralControl(sHtml.ToString())); } lb_Via_Pago.Text = dt_UltDocPago.Rows[0]["descripcion_via_pago"].ToString(); lb_Canal.Text = dt_UltDocPago.Rows[0]["canal"].ToString(); } } dt_UltDocPago = null; } oConn.Close(); if (bEnable) { idOverviewEnable.Visible = true; idOverviewNoEnable.Visible = false; } else { idOverviewEnable.Visible = false; idOverviewNoEnable.Visible = true; } } else { idOverviewEnable.Visible = false; idOverviewNoEnable.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); if (oConn.Open()) { double iDiscrecionalesMes = 0; double iAcuerdosComerciales = 0; double iCantDoc = 0; double iAcuerdosComercialesAno = 0; double iTotal = 0; cDashboard oFacturasComerciales = new cDashboard(ref oConn); oFacturasComerciales.nKeyCliente = oIsUsuario.NKeyUsuario; oFacturasComerciales.nKeyDeudor = oIsUsuario.NKeyDeudor; oFacturasComerciales.CodHolding = oIsUsuario.NCodHolding; iDiscrecionalesMes = oFacturasComerciales.getDiscrecionalesMes(); iAcuerdosComerciales = oFacturasComerciales.getAcuerdosComercialesMes(); string sData = "['Tipo', 'Monto', { role: 'annotation' }, { role: 'style' }],"; sData = sData + "['Discrecionales'," + Math.Round(iDiscrecionalesMes, 0).ToString() + ",'" + Math.Round(iDiscrecionalesMes, 0).ToString("N0") + "','#F57F23'],"; sData = sData + "['Acuerdos Comerciales'," + Math.Round(iAcuerdosComerciales, 0).ToString() + ",'" + Math.Round(iAcuerdosComerciales, 0).ToString("N0") + "','#9AD558']"; StringBuilder sHtml = new StringBuilder(); sHtml.Append(" google.charts.setOnLoadCallback(drawBarChart); "); sHtml.Append(" function drawBarChart() { "); sHtml.Append(" var data = google.visualization.arrayToDataTable([ "); sHtml.Append(sData); sHtml.Append(" ]); "); sHtml.Append(" var Options = { annotations: { textStyle: { fontSize: 12, auraColor: 'none', color: '#ffffff', bold: true } }, legend: \"none\", vAxis: { textPosition: 'none' }, hAxis: { format: 'short', textStyle: { color: '#c5c5c5', fontName: 'Lato', fontSize: 10, bold: true } } }; "); sHtml.Append(" var oChart = new google.visualization.BarChart(document.getElementById('horizontalBar2')); "); sHtml.Append(" oChart.draw(data, Options); } "); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "horizontalBar2", sHtml.ToString(), true); DataTable dt = oFacturasComerciales.getNoDiscrecionalAno(); if (dt != null) { if (dt.Rows.Count > 0) { iCantDoc = double.Parse(dt.Rows[0]["documentos"].ToString()); idDocumentos.Text = iCantDoc.ToString("N0"); iAcuerdosComercialesAno = double.Parse(dt.Rows[0]["acuerdos_comerciales"].ToString()); idAcuerdosComerciales.Text = oIsUsuario.Moneda + " " + iAcuerdosComercialesAno.ToString("N0"); } } dt = null; iTotal = oFacturasComerciales.getTotalAcuerdosComercialesAno(); if ((iAcuerdosComercialesAno > 0) && (iTotal > 0)) { idBudget.Text = ((iAcuerdosComercialesAno / iTotal) * 100).ToString("N0") + "%"; } else { idBudget.Text = "N/A"; } } oConn.Close(); idVistaEnable.Visible = true; idVistaNoEnable.Visible = false; } else { idVistaEnable.Visible = false; idVistaNoEnable.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { bool bEnable = false; calendario_pago_nodias.Visible = false; oIsUsuario = oWeb.ValidaUserAppReport(); if ((!string.IsNullOrEmpty(oIsUsuario.NKeyDeudor)) && (!string.IsNullOrEmpty(oIsUsuario.NKeyUsuario)) || (!string.IsNullOrEmpty(oIsUsuario.NCodHolding))) { DBConn oConn = new DBConn(); if (oConn.Open()) { string nKeyCodigoDeudor = string.Empty; string sDias = string.Empty; string sSemanas = string.Empty; string sValor = string.Empty; string sTipo = string.Empty; cDashboard oCalendarioPago = new cDashboard(ref oConn); oCalendarioPago.nKeyCliente = oIsUsuario.NKeyUsuario; oCalendarioPago.nKeyDeudor = oIsUsuario.NKeyDeudor; oCalendarioPago.CodHolding = oIsUsuario.NCodHolding; oCalendarioPago.Periodo = DateTime.Now.ToString("yyyyMMdd"); //Response.Write("getCalendarioPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dt = oCalendarioPago.getCalendarioPago(); //Response.Write("getCalendarioPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dt != null) { if (dt.Rows.Count > 0) { lbl_compromiso_pago.Text = "Si"; lbl_fecha.Text = DateTime.Parse(dt.Rows[0]["fecha"].ToString()).ToString("dd-MM-yyyy"); lblMonto.Text = oIsUsuario.Moneda + " " + (!string.IsNullOrEmpty(dt.Rows[0]["Monto"].ToString()) ? double.Parse(dt.Rows[0]["Monto"].ToString()).ToString("N0") : "0"); } else { lbl_compromiso_pago.Text = "No"; lbl_fecha.Text = "N/A"; lblMonto.Text = "N/A"; } } dt = null; //Response.Write("GetCumplidas;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iCumplido = oCalendarioPago.GetCumplidas(); //Response.Write("GetCumplidas;" + DateTime.Now.Millisecond.ToString() + "<br>"); lbl_cumplido.Text = iCumplido.ToString(); //Response.Write("GetNoCumplidas;" + DateTime.Now.Millisecond.ToString() + "<br>"); double iNoComplido = oCalendarioPago.GetNoCumplidas(); //Response.Write("GetNoCumplidas;" + DateTime.Now.Millisecond.ToString() + "<br>"); lbl_no_cumplido.Text = iNoComplido.ToString(); //Response.Write("Get_nKeyCodigoDeudor;" + DateTime.Now.Millisecond.ToString() + "<br>"); nKeyCodigoDeudor = oCalendarioPago.Get_nKeyCodigoDeudor(); //Response.Write("Get_nKeyCodigoDeudor;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (!string.IsNullOrEmpty(nKeyCodigoDeudor)) { oCalendarioPago.nKeyCodigoDeudor = nKeyCodigoDeudor; //Response.Write("getDiaPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); DataTable dtt = oCalendarioPago.getDiaPago(); //Response.Write("getDiaPago;" + DateTime.Now.Millisecond.ToString() + "<br>"); if (dtt != null) { if (dtt.Rows.Count > 0) { foreach (DataRow oRow in dtt.Rows) { sTipo = oRow["tipo"].ToString(); if (sTipo == "1") { sDias = "Día"; sSemanas = (!string.IsNullOrEmpty(sSemanas) ? sSemanas + ", " + oRow["valor"].ToString() : oRow["valor"].ToString()); } else { sDias = oRow["dia_letra"].ToString(); sValor = (!string.IsNullOrEmpty(sValor) ? sValor + "," + oRow["valor"].ToString() : oRow["valor"].ToString()); sSemanas = (!string.IsNullOrEmpty(sSemanas) ? sSemanas + ", " + oRow["valor"].ToString() + "°" : oRow["valor"].ToString() + "°"); } } } } dtt = null; } lbl_dias.Text = string.Empty; lbl_semana.Text = string.Empty; if ((!string.IsNullOrEmpty(sDias)) || (!string.IsNullOrEmpty(sSemanas))) { lbl_dias.Text = sDias; if (sTipo == "1") { lbl_semana.Text = sSemanas; } else { if (sValor != "1,2,3,4") { lbl_semana.Text = sSemanas; } } } else { calendario_pago_sidias.Visible = false; calendario_pago_nodias.Visible = true; } double iPorcentaje = 0; string sPorcentaje = string.Empty; if ((iNoComplido != 0) || (iCumplido != 0)) { iPorcentaje = ((iCumplido / (iNoComplido + iCumplido)) * 100); sPorcentaje = iPorcentaje.ToString("N0") + "%"; //lblIndiceCredibilidad.Text = sPorcentaje; } else { sPorcentaje = "0%"; //lblIndiceCredibilidad.Text = sPorcentaje; } string sCanvas = "<canvas id=\"myCanvas\" width=\"50\" height=\"50\"></canvas>"; string sClassBackGroudColor = string.Empty; string sStyleBoxRiesgo = string.Empty; string sStyleTxtRiesgo = string.Empty; string sIndexRiesgo = string.Empty; string sColor = string.Empty; if (iPorcentaje <= 20) { sIndexRiesgo = "2"; sColor = "#D0021B"; sClassBackGroudColor = "sbackgroudcolorbar_rojo"; sStyleBoxRiesgo = "box-riesgo-rojo"; sStyleTxtRiesgo = "lbl-riesgo-rojo"; id_rojo.Controls.Add(new LiteralControl(sCanvas)); } else if ((iPorcentaje > 20) && (iPorcentaje <= 40)) { sIndexRiesgo = "4"; sColor = "#F57F23"; sClassBackGroudColor = "sbackgroudcolorbar_naranjo"; sStyleBoxRiesgo = "box-riesgo-naranjo"; sStyleTxtRiesgo = "lbl-riesgo-naranjo"; id_naranjo.Controls.Add(new LiteralControl(sCanvas)); } else if ((iPorcentaje > 40) && (iPorcentaje <= 60)) { sIndexRiesgo = "6"; sColor = "#F5D423"; sClassBackGroudColor = "sbackgroudcolorbar_amarillo"; sStyleBoxRiesgo = "box-riesgo-amarillo"; sStyleTxtRiesgo = "lbl-riesgo-amarillo"; id_amarillo.Controls.Add(new LiteralControl(sCanvas)); } else if ((iPorcentaje > 60) && (iPorcentaje <= 80)) { sIndexRiesgo = "8"; sColor = "#7ED321"; sClassBackGroudColor = "sbackgroudcolorbar_verdeclaro"; sStyleBoxRiesgo = "box-riesgo-verdeclaro"; sStyleTxtRiesgo = "lbl-riesgo-verdeclaro"; id_verdeclaro.Controls.Add(new LiteralControl(sCanvas)); } else if ((iPorcentaje > 80) && (iPorcentaje <= 100)) { sIndexRiesgo = "10"; sColor = "#4EA528"; sClassBackGroudColor = "sbackgroudcolorbar_verdeoscuro"; sStyleBoxRiesgo = "box-riesgo-verdeoscuro"; sStyleTxtRiesgo = "lbl-riesgo-verdeoscuro"; id_verdeocscuro.Controls.Add(new LiteralControl(sCanvas)); } StringBuilder sHtml = new StringBuilder(); sHtml.Append("var canvas = document.getElementById('myCanvas');"); sHtml.Append("var context = canvas.getContext('2d');"); sHtml.Append("var centerX = canvas.width / 2;"); sHtml.Append("var centerY = canvas.height / 2;"); sHtml.Append("var radius = 20;"); sHtml.Append("context.beginPath();"); sHtml.Append("context.arc(centerX, centerY, radius, 0, 2 * Math.PI, false);"); sHtml.Append("context.fillStyle = '" + sColor + "';"); sHtml.Append("context.fill();"); sHtml.Append("context.lineWidth = 5;"); sHtml.Append("context.strokeStyle = '#fff';"); sHtml.Append("context.stroke();"); sHtml.Append("context.lineWidth = 1;"); sHtml.Append("context.fillStyle = \"#fff\";"); sHtml.Append("context.lineStyle = \"#fff\";"); sHtml.Append("context.font = \"12px Lato\";"); sHtml.Append("context.fillText('" + sPorcentaje + "', 15, 30);"); string sBoxRiesgo = "<div class=\"" + sClassBackGroudColor + "\"><span class=\"index-riesgo\">" + sIndexRiesgo + "</span></div>"; //idBox_riesgo.Controls.Add(new LiteralControl(sBoxRiesgo)); string sTt_riesgo = "<span class=\"" + sStyleBoxRiesgo + "\">Nivel de riesgo del cliente</span>"; //idtit_riesgo.Controls.Add(new LiteralControl(sTt_riesgo)); ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "comportamiento-financiero", sHtml.ToString(), true); //string sProgress = "<div class=\"progress-bar " + sClassBackGroudColor + "\" role=\"progressbar\" style=\"width:" + sPorcentaje + "\" aria-valuenow=\"25\" aria-valuemin=\"0\" aria-valuemax=\"100\">" + sPorcentaje + "</div>"; //oBarIndiceCredibilidad.Controls.Add(new LiteralControl(sProgress)); } oConn.Close(); } }