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 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 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 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);
}
public object Get_ComboxPadre(String co_maestro, String co_padre)
{
ComboBL oComboBL = new ComboBL();
ComboBE oComboBE = new ComboBE();
ComboBEList oComboBEList = oComboBL.Get_Combo(co_maestro, co_padre);
//return oComboBEList;
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
return(serializer.Serialize(oComboBEList));
}
public ComboBEList Get_Combo(String co_maestro, String co_padre)
{
ComboBEList oComboBEList = new ComboBEList();
SqlConnection cn = new SqlConnection(DataBaseHelper.GetDbConnectionString());
/*Propiedades del SqlCommand*/
SqlCommand = new SqlCommand();
SqlCommand.CommandText = "src_sps_combo_FO";
SqlCommand.Connection = cn;
SqlCommand.CommandType = CommandType.StoredProcedure;
/*Agregar Parametros al SqlCommand */
SqlCommand.Parameters.AddWithValue("@vi_co_maestro", co_maestro);
SqlCommand.Parameters.AddWithValue("@vi_co_padre", co_padre);
SqlDataReader reader = null;
try
{
cn.Open();
reader = SqlCommand.ExecuteReader();
while (reader.Read())
{
int indice;
ComboBE oBE = new ComboBE();
indice = reader.GetOrdinal("value");
oBE.value = reader.IsDBNull(indice) ? string.Empty : reader.GetString(indice);
indice = reader.GetOrdinal("nombre");
oBE.nombre = reader.IsDBNull(indice) ? string.Empty : reader.GetString(indice);
oComboBEList.Add(oBE);
}
reader.Close();
}
catch (Exception)
{
if (reader != null && !reader.IsClosed)
{
reader.Close();
}
throw;
}
finally
{
cn.Close();
cn.Dispose();
}
return(oComboBEList);
}
private ComboBE CrearEntidad_Combo(IDataRecord DReader)
{
ComboBE Entidad = new ComboBE();
int indice;
indice = DReader.GetOrdinal("ID");
Entidad.ID = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice).Trim());
indice = DReader.GetOrdinal("DES");
Entidad.DES = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice).Trim());
return(Entidad);
}
private ComboBE CrearEntidad_Combo(IDataRecord DReader)
{
ComboBE Entidad = new ComboBE();
int indice;
String var1 = "";
indice = DReader.GetOrdinal("ID");
var1 = DReader.GetString(indice);
Entidad.ID = (var1 == null ? "" : var1);
indice = DReader.GetOrdinal("DES");
var1 = DReader.GetString(indice);
Entidad.DES = (var1 == null ? "" : var1);
return(Entidad);
}
