public Int32 InsertTallerServicio(TallerBE ent) { try { return(new TallerDA().GETInsertarTallerServicio(ent)); } catch { return(0); } }
public Int32 ActualizarHorario(TallerBE ent) { try { return(new TallerDA().ActualizarHorario(ent)); } catch { return(0); } }
public Int32 InsertTallerDiaExceptuado(TallerBE ent) { try { return(new TallerDA().GETInsertarTallerDiaExceptuado(ent)); } catch { return(0); } }
public Int32 ActualizarTallerModelos(TallerBE ent) { try { return(new TallerDA().ActualizarTallerModelos(ent)); } catch { return(0); } }
public Int32 ActualizarDiasExcep(TallerBE ent) { try { return(new TallerDA().ActualizarDiasExcep(ent)); } catch { return(0); } }
public Int32 MantenimientoTallerModelosCapacidad(TallerBE ent) { try { return(new TallerDA().MantenimientoTallerModelosCapacidad(ent)); } catch { return(0); } }
public Int32 MantenimientoTallerDiasExceptuados(TallerBE ent) { try { return(new TallerDA().MantenimientoTallerDiasExceptuados(ent)); } catch { return(0); } }
public Int32 InsertarTallerModeloCapacidad(TallerBE ent) { try { return(new TallerDA().GETInsertarTallerModeloCapacidad(ent)); } catch { return(0); } }
public Int32 MantenimientoTallerServicios(TallerBE ent) { try { return(new TallerDA().MantenimientoTallerServicios(ent)); } catch { return(0); } }
public TallerBEList GETListarTalleres(TallerBE ent) { try { return(new TallerDA().GETListarTalleres(ent)); } catch (Exception ex) { this.ErrorEvent(this, ex); return(null); } }
private TallerBE Entidad_Listar_PuntosRed(IDataRecord DReader) { TallerBE Entidad = new TallerBE(); Int32 indice = 0; indice = DReader.GetOrdinal("nid_ubica"); Entidad.nid_ubica = (DReader.IsDBNull(indice) ? 0 : DReader.GetInt32(indice)); indice = DReader.GetOrdinal("no_ubica"); Entidad.no_ubica = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("coddpto"); Entidad.coddpto = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("codprov"); Entidad.codprov = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("coddist"); Entidad.coddist = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); return(Entidad); }
public TallerBE ListarContenidoInformativoTaller(int nid_taller) { TallerBE ent = null; SqlConnection conn = new SqlConnection(DataBaseHelper.GetDbConnectionString()); SqlCommand cmd = new SqlCommand("src_sps_contenido_total_taller_bo", conn); SqlDataReader reader = null; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vi_nid_taller", nid_taller); try { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { ent = new TallerBE(); ent.no_taller = reader["no_taller"].ToString(); ent.tx_promociones = reader["tx_promociones"].ToString(); ent.tx_noticias = reader["tx_noticias"].ToString(); ent.tx_datos = reader["tx_datos"].ToString(); ent.tx_fotos = reader["tx_fotos"].ToString(); } reader.Close(); } catch (Exception) { if (reader != null && !reader.IsClosed) { reader.Close(); } throw; } finally { conn.Close(); conn.Dispose(); } return(ent); }
public TallerBEList Listar_Talleres(TallerBE ent) { TallerBEList lista = new TallerBEList(); SqlConnection conn = new SqlConnection(DataBaseHelper.GetDbConnectionString()); SqlCommand cmd = new SqlCommand("[SRC_SPS_LISTAR_TALLERES_FO]", conn); SqlDataReader reader = null; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@vi_nid_servicio", ent.nid_servicio); cmd.Parameters.AddWithValue("@vi_nid_modelo", ent.nid_modelo); cmd.Parameters.AddWithValue("@vi_nid_ubica", ent.nid_ubica); cmd.Parameters.AddWithValue("@vi_coddpto", ent.coddpto); cmd.Parameters.AddWithValue("@vi_codprov", ent.codprov); cmd.Parameters.AddWithValue("@vi_coddist", ent.coddist); try { conn.Open(); reader = cmd.ExecuteReader(); while (reader.Read()) { lista.Add(Entidad_Listar_Talleres(reader)); } reader.Close(); } catch (Exception) { if (reader != null && !reader.IsClosed) { reader.Close(); } throw; } finally { conn.Close(); conn.Dispose(); } return(lista); }
private TallerBE Entidad_Listar_Talleres(IDataRecord DReader) { TallerBE Entidad = new TallerBE(); Int32 indice = 0; indice = DReader.GetOrdinal("nid_taller"); Entidad.nid_taller = (DReader.IsDBNull(indice) ? 0 : DReader.GetInt32(indice)); indice = DReader.GetOrdinal("no_taller"); Entidad.no_taller = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("tx_mapa_taller"); Entidad.tx_mapa_taller = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("fl_taxi"); Entidad.fl_taxi = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("nid_ubica"); Entidad.nid_ubica = (DReader.IsDBNull(indice) ? 0 : DReader.GetInt32(indice)); indice = DReader.GetOrdinal("coddpto"); Entidad.coddpto = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("codprov"); Entidad.codprov = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); indice = DReader.GetOrdinal("coddist"); Entidad.coddist = (DReader.IsDBNull(indice) ? "" : DReader.GetString(indice)); return(Entidad); }
public TallerBEList GETDetallePorPuntoRed(TallerBE ent) { return(new TallerDA().GETDetallePorPuntoRed(ent)); }
public TallerBEList GETListarCapacidadTallerModelo(TallerBE ent) { return(new TallerDA().GETListarCapacidadTallerModelo(ent)); }
//MARCAS Y MODElOS public TallerBEList GETListarMarcasModelos(TallerBE ent) { return(new TallerDA().GETListarMarcaModelo(ent)); }
public CombosBEList GETListarPuntoRed(TallerBE ent, int Nid_usuario) { return(new TallerDA().GETListarPuntoRed(ent, Nid_usuario)); }
public CombosBEList GETListarDistrito(TallerBE ent, int Nid_usuario) { return(new TallerDA().GETListarDistrito(ent, Nid_usuario)); }
public TallerBEList GETDiasHabiles_Hora_PorTaller(TallerBE ent) { return(new TallerDA().GETDiasHabiles_Hora_PorTaller(ent)); }
public TallerBEList GETListarUbicacion(TallerBE ent) { return(new TallerDA().GETListarUbicacion(ent)); }
public TallerBEList ListarHorario_Taller(TallerBE ent) { return(new TallerDA().ListarHorario_Taller(ent)); }
public TallerBEList ListarDias_Taller(TallerBE ent) { return(new TallerDA().ListarDias_Taller(ent)); }
public TallerBEList GETDiasExcepPorTaller(TallerBE ent) { return(new TallerDA().GETDiasExcepPorTaller(ent)); }
public TallerBEList GETServiciosPorTaller(TallerBE ent) { return(new TallerDA().GETServiciosPorTaller(ent)); }
//PARA UPDATE public TallerBEList GETDetalleTaller(TallerBE ent) { return(new TallerDA().GETDetalleTaller(ent)); }
public TallerBEList GETModelosPorTaller(TallerBE ent) { return(new TallerDA().GETModelosPorTaller(ent)); }
public CombosBEList GETListarProvincia(TallerBE ent, int Nid_usuario) { return(new TallerDA().GETListarProvincia(ent, Nid_usuario)); }
public TallerBEList Listar_Talleres(TallerBE ent) { return(new TallerDA().Listar_Talleres(ent)); }
public String ExisteCodigo(TallerBE ent) { return(new TallerDA().ExisteCodigo(ent)); }