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