public List <BE_DATO> AutomotorAnioFabricacion()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_AUTOMOTOR_ANIO_FABRICACION");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["ANIO_FAB_VC"]);
objDatoBE.NU_CAN_SI = Convert.ToInt32(sdr["NU_CAN_SI"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> DemograficoEdad()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_DEMOGRAFIA_EDAD");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["DES_RAN_VC"]);
objDatoBE.NU_CAN_SI = Convert.ToInt32(sdr["NU_CAN_SI"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> EmpresaUbicacion()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_EMPRESAS_UBICACION");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.ABR_DAT_VC = Convert.ToString(sdr["ABR_DEP_VC"]);
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["DES_DEP_VC"]);
objDatoBE.NU_CAN_SI = Convert.ToInt32(sdr["NU_CAN_SI"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> AutomotorMarca()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_AUTOMOTOR_MARCA");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["NOM_MAR_VC"]);
objDatoBE.NU_POR_DO = Convert.ToDecimal(sdr["NUM_PAR_DO"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> SoatVencimiento()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_SOAT_VENCIMIENTO");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["FEC_VEN_VC"]);
objDatoBE.NU_CAN_SI = Convert.ToInt32(sdr["NUM_CAN_IN"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> SoatTipoVehiculo()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_SOAT_TIPO_VEHICULO");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["DES_TIP_VC"]);
objDatoBE.NU_POR_DO = Convert.ToDecimal(sdr["NU_POR_DO"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> MedicosEstado()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_MEDICOS_ESTADO");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["DES_EST_VC"]);
objDatoBE.NU_CAN_SI = Convert.ToInt32(sdr["NU_CAN_SI"]);
//objDatoBE.NU_POR_DO = Convert.ToDecimal(sdr["NU_POR_DO"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
public List <BE_DATO> TelecomunicacionesMarketshare()
{
try
{
List <BE_DATO> lstDatoBE = new List <BE_DATO>();
sdr = SqlHelper.ExecuteReader(constr_dya, "DASHBOARD.SP_TELECOMUNICACIONES_MARKETSHARE");
BE_DATO objDatoBE = null;
while (sdr.Read())
{
objDatoBE = new BE_DATO();
objDatoBE.DES_DAT_VC = Convert.ToString(sdr["DES_OPE_VC"]);
objDatoBE.NU_POR_DO = Convert.ToDecimal(sdr["NU_POR_DO"]);
lstDatoBE.Add(objDatoBE);
}
return(lstDatoBE);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (sdr != null)
{
sdr.Close();
}
}
}
