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