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();
}
}
