public CombosBEList GETListarTipoPersona()
{
CombosBEList lista = new CombosBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_SEL_DDL_TIPOPERSONA]";
DReader = db.GetDataReader();
}
while (DReader.Read())
{
ComboBE oCombosBE = CrearEntidad_Combo(DReader);
lista.Add(oCombosBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public CombosBEList GETListarModelosXMarca(VehiculoBE ent, int Nid_usuario)
{
CombosBEList lista = new CombosBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_SEL_DDL_MODELO]";
db.AddParameter("@nid_marca", DbType.Int32, ParameterDirection.Input, ent.nid_marca);
db.AddParameter("@Nid_usuario", DbType.String, ParameterDirection.Input, Nid_usuario);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
ComboBE oCombosBE = CrearEntidad_Combo(DReader);
lista.Add(oCombosBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public CombosBEList GETListarTipoDocumento(string oPersona)
{
CombosBEList lista = new CombosBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_SEL_DDL_TIPODOCUMENTO2]";
db.AddParameter("@vi_tipopersona", DbType.String, ParameterDirection.Input, oPersona);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
ComboBE oCombosBE = CrearEntidad_Combo(DReader);
lista.Add(oCombosBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public CombosBEList GETListarNegocios_X_Marca(string s_nid_marca)
{
CombosBEList lista = new CombosBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_SEL_NEGOCIO_X_MARCA]";
db.AddParameter("@nid_marca", DbType.Int32, ParameterDirection.Input, Int32.Parse(s_nid_marca));
DReader = db.GetDataReader();
}
while (DReader.Read())
{
ComboBE oCombosBE = CrearEntidad_Combo(DReader);
lista.Add(oCombosBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public CombosBEList GETListarFamiliasByNegocio(ModeloBE ent)
{
CombosBEList lista = new CombosBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_SEL_MODELO_BY_NEGOCIO]";
db.AddParameter("@co_negocio", DbType.String, ParameterDirection.Input, ent.co_negocio);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
ComboBE oCombosBE = CrearEntidad_Combo(DReader);
lista.Add(oCombosBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
public CombosBEList GETListarTalleres(int PuntoRed, int Nid_usuario)
{
CombosBEList lista = new CombosBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "[SRC_SPS_SEL_DDL_TALLER]";
db.AddParameter("@NID_UBICA", DbType.Int32, ParameterDirection.Input, PuntoRed);
//db.AddParameter("@Nid_usuario", DbType.String, ParameterDirection.Input, Nid_usuario);
db.AddParameter("@Nid_usuario", DbType.Int32, ParameterDirection.Input, Nid_usuario);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
ComboBE oCombosBE = CrearEntidad_Combo2(DReader);
lista.Add(oCombosBE);
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
