public static int FormularioServicioDetalleDanos(
int idExpediente,
string porcentajeVivienda,
string porcentajeEnseres,
string porcentajeVehiculo,
string porcentajeUno,
string descripcionPorcentajeUno,
string porcentajeDos,
string descripcionPorcentajeDos
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_detalle_danos(id_expediente, porcentajeVivienda, porcentajeEnseres, porcentajeVehiculo, porcentajeUno, descripcionPorcentajeUno, porcentajeDos, descripcionPorcentajeDos) ";
reqSQL += "VALUES (" + idExpediente + ", '" + porcentajeVivienda + "', '" + porcentajeEnseres + "', '" + porcentajeVehiculo + "', '" + porcentajeUno + "', '" + descripcionPorcentajeUno + "', '" + porcentajeDos + "', '" + descripcionPorcentajeDos + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_dos_6 getObjectz_dos_6(System.Int32 myID)
{
z_dos_6 myz_dos_6 = new z_dos_6();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_dos_6,id_despacho,id_carro FROM z_dos_6 WHERE (id_despacho=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_dos_6.id_dos_6 = Convert.ToInt32(myReader[0]);
myz_dos_6.id_despacho = Convert.ToInt32(myReader[1]);
myz_dos_6.id_carro = Convert.ToInt32(myReader[2]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myz_dos_6);
}
public z_cargos getObjectz_cargos_llam(Int32 myID)
{
var myz_cargos = new z_cargos();
var myBase = new CnxBase();
// se añade join con tabla z_oficiales
string reqSQL =
"SELECT id_cargo,id_voluntario,z_oficiales.grado,orden_antiguedad,cargo_antiguedad,llamado_oficial,reemplaza_a,z_cargos.id_oficial FROM z_cargos, z_oficiales WHERE (llamado_oficial=" +
myID + ") AND z_cargos.id_oficial = z_oficiales.id_oficial";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
var myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_cargos.id_cargo = Convert.ToInt32(myReader[0]);
myz_cargos.id_voluntario = Convert.ToInt32(myReader[1]);
myz_cargos.grado = Convert.ToInt32(myReader[2]);
myz_cargos.orden_antiguedad = Convert.ToInt32(myReader[3]);
myz_cargos.cargo_antiguedad = Convert.ToInt32(myReader[4]);
myz_cargos.llamado_oficial = Convert.ToInt32(myReader[5]);
myz_cargos.reemplaza_a = Convert.ToInt32(myReader[6]);
myz_cargos.id_oficial = Convert.ToInt32(myReader[7]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr + reqSQL));
}
return(myz_cargos);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public est_consultas_detalle getObjectest_consultas_detalle(System.Int32 myID)
{
est_consultas_detalle myest_consultas_detalle = new est_consultas_detalle();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_consulta,id_categoria,autor,titulo,descripcion,consulta FROM est_consultas_detalle WHERE (id_consulta=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myest_consultas_detalle.id_consulta = Convert.ToInt32(myReader[0]);
myest_consultas_detalle.id_categoria = Convert.ToInt32(myReader[1]);
myest_consultas_detalle.autor = myReader[2].ToString();
myest_consultas_detalle.titulo = myReader[3].ToString();
myest_consultas_detalle.descripcion = myReader[4].ToString();
myest_consultas_detalle.consulta = myReader[5].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myest_consultas_detalle);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_novedad getObjectz_novedad(System.Int32 myID)
{
z_novedad myz_novedad = new z_novedad();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_novedad,id_operadora,fecha,novedad,descripcion FROM z_novedad WHERE (id_novedad=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_novedad.id_novedad = Convert.ToInt32(myReader[0]);
myz_novedad.id_operadora = Convert.ToInt32(myReader[1]);
myz_novedad.fecha = Convert.ToDateTime(myReader[2]);
myz_novedad.novedad = myReader[3].ToString();
myz_novedad.descripcion = myReader[4].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myz_novedad);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public s_aljibe getObjects_aljibe(System.Int32 myID)
{
s_aljibe mys_aljibe = new s_aljibe();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_especialidad,id_sector,prioridad,contacto,id_central FROM s_aljibe WHERE (id_especialidad=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mys_aljibe.id_especialidad = Convert.ToInt32(myReader[0]);
mys_aljibe.id_sector = Convert.ToInt32(myReader[1]);
mys_aljibe.prioridad = Convert.ToInt32(myReader[2]);
mys_aljibe.contacto = myReader[3].ToString();
mys_aljibe.id_central = Convert.ToInt32(myReader[4]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(mys_aljibe);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_bloque_horario getObjectz_bloque_horario(System.Int32 myID)
{
z_bloque_horario myz_bloque_horario = new z_bloque_horario();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_bloque_horario,hora_inicio,hora_termino,descripcion FROM z_bloque_horario WHERE (id_bloque_horario=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_bloque_horario.id_bloque_horario = Convert.ToInt32(myReader[0]);
myz_bloque_horario.hora_inicio = Convert.ToDateTime(myReader[1]);
myz_bloque_horario.hora_termino = Convert.ToDateTime(myReader[2]);
myz_bloque_horario.descripcion = myReader[3].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myz_bloque_horario);
}
public static int FormularioServicioSegurosMaterialApoyo(
int idExpediente,
string seguros,
string compania,
string especieAseg,
string fotos,
string muestras,
string videos,
string otros,
string descripcionOtros
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_seguros_material_apoyo(id_expediente, seguros, compania, especieAseg, muestras, videos, otros, descripcionOtros, fotos) ";
reqSQL += "VALUES (" + idExpediente + ", '" + seguros + "', '" + compania + "', '" + especieAseg + "', '" + muestras + "', '" + videos + "', '" + otros + "', '" + descripcionOtros + "', '" + fotos + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_preinforme getObjectz_preinforme(System.Int32 myID)
{
z_preinforme myz_preinforme = new z_preinforme();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_preinforme,codigo_llamado,preinforme FROM z_preinforme WHERE (id_preinforme=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_preinforme.id_preinforme = Convert.ToInt32(myReader[0]);
myz_preinforme.codigo_llamado = Convert.ToInt32(myReader[1]);
myz_preinforme.preinforme = myReader[2].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myz_preinforme);
}
public static int FormularioServicioEspecificacionPersonal(
int idExpediente,
string gradoAcargo,
string companiaAcargo,
string nombreAcargo,
string gradoEstadistica,
string companiaEstadistica,
string nombreEstadistica,
string nombreVBCompania
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_especificacion_personal(id_expediente, gradoAcargo, companiaAcargo, nombreAcargo, gradoEstadistica, companiaEstadistica, nombreEstadistica, nombreVBCompania) ";
reqSQL += "VALUES (" + idExpediente + ", '" + gradoAcargo + "', '" + companiaAcargo + "', '" + nombreAcargo + "', '" + gradoEstadistica + "', '" + companiaEstadistica + "', '" + nombreEstadistica + "', '" + nombreVBCompania + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
public static int FormularioServicioDatosGrilla(
int idExpediente,
string nombreJefeHogar,
string rut,
string propietario,
string arrendatario,
string allegado,
string otro,
string direccion,
string adultos,
string menores,
string vivienda,
string enseres,
string vehiculo
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_datos_grilla(id_expediente, nombreJefeHogar, rut, propietario, arrendatario, allegado, otro, direccion, adultos, menores, vivienda, enseres, vehiculo) ";
reqSQL += "VALUES (" + idExpediente + ", '" + nombreJefeHogar + "', '" + rut + "', '" + propietario + "', '" + arrendatario + "', '" + allegado + "', '" + otro + "', '" + direccion + "', '" + adultos + "', '" + menores + "', '" + vivienda + "', '" + enseres + "', '" + vehiculo + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
public static int FormuarioServicioExistian(
int idExpediente,
string explosivos,
string gases,
string liquidos,
string solidos,
string veneno,
string radioactivos,
string corrosivos,
string oxidantes,
string varios,
string noClasificados,
string nombreProductos
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formuario_servicio_existian(id_expediente, explosivos, gases, liquidos, solidos, veneno, radioactivos, corrosivos, oxidantes, varios, noClasificados, nombreProductos) ";
reqSQL += "VALUES (" + idExpediente + ", '" + explosivos + "', '" + gases + "', '" + liquidos + "', '" + solidos + "', '" + veneno + "', '" + radioactivos + "', '" + corrosivos + "', '" + oxidantes + "', '" + varios + "', '" + noClasificados + "', '" + nombreProductos + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
public static int FormularioServicioPresenciaGas(
int idExpediente,
string cilindro,
string kilogramosCilindro,
string estanque,
string kilogramosPorMetroCubicoEstanque,
string caneria,
string ciudad,
string licuado,
string natural,
string otro,
string descripcionOtro,
string companiaDistribuidora
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_presencia_gas(id_expediente, cilindro, kilogramosCilindro, estanque, kilogramosPorMetroCubicoEstanque, caneria, ciudad, licuado, cnatural, otro, descripcionOtro, companiaDistribuidora) ";
reqSQL += "VALUES (" + idExpediente + ", '" + cilindro + "', '" + kilogramosCilindro + "', '" + estanque + "', '" + kilogramosPorMetroCubicoEstanque + "', '" + caneria + "', '" + ciudad + "', '" + licuado + "', '" + natural + "', '" + otro + "', '" + descripcionOtro + "', '" + companiaDistribuidora + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
public static int FormularioServicioOrigenCausaFuego(
int idExpediente,
string origenFuego,
string causaFuego,
string salvamiento,
string lesionadosMuertos
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_origen_causa_fuego(id_expediente, origenFuego, causaFuego, salvamiento, lesionadosMuertos) ";
reqSQL += "VALUES (" + idExpediente + ", '" + origenFuego + "', '" + causaFuego + "', '" + salvamiento + "', '" + lesionadosMuertos + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
public s_sector getObjects_sector_area(int id_area)
{
s_sector mys_sector = new s_sector();
CnxBase myBase = new CnxBase();
string reqSQL = string.Format("SELECT id_sector,id_areas,descripcion FROM s_sector WHERE trim(both ',' from substring(id_areas, '.?{0}.?'))='{0}'", id_area);
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mys_sector.id_sector = Convert.ToInt32(myReader[0]);
mys_sector.id_areas = myReader[1].ToString();
mys_sector.descripcion = myReader[2].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mys_sector);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public s_central getObjects_central(System.Int32 myID)
{
s_central mys_central = new s_central();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_central,nombre,telefono FROM s_central WHERE (id_central=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mys_central.id_central = Convert.ToInt32(myReader[0]);
mys_central.nombre = myReader[1].ToString();
mys_central.telefono = myReader[2].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(mys_central);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public a_agenda_detalle getObjecta_agenda_detalle(System.Int32 myID)
{
a_agenda_detalle mya_agenda_detalle = new a_agenda_detalle();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_subcat,nombre,telefono,id_empresa FROM a_agenda_detalle WHERE (id_empresa=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mya_agenda_detalle.id_subcat = Convert.ToInt32(myReader[0]);
mya_agenda_detalle.nombre = myReader[1].ToString();
mya_agenda_detalle.telefono = myReader[2].ToString();
mya_agenda_detalle.id_empresa = Convert.ToInt32(myReader[3]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mya_agenda_detalle);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public a_agenda_cat getObjecta_agenda_cat(System.Int32 myID)
{
a_agenda_cat mya_agenda_cat = new a_agenda_cat();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_cat,nombre,ref_espacial,tabla,orden FROM a_agenda_cat WHERE (id_cat=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mya_agenda_cat.id_cat = Convert.ToInt32(myReader[0]);
mya_agenda_cat.nombre = myReader[1].ToString();
mya_agenda_cat.ref_espacial = Convert.ToBoolean(myReader[2]);
mya_agenda_cat.tabla = myReader[3].ToString();
mya_agenda_cat.orden = Convert.ToInt32(myReader[4]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mya_agenda_cat);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public bitacora_gestion getObjectbitacora_gestion(System.Int32 myID)
{
bitacora_gestion mybitacora_gestion = new bitacora_gestion();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_evento,fecha,id_operadora1,id_operadora2,evento FROM bitacora_gestion WHERE (id_evento=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mybitacora_gestion.id_evento = Convert.ToInt32(myReader[0]);
mybitacora_gestion.fecha = Convert.ToDateTime(myReader[1]);
mybitacora_gestion.id_operadora1 = Convert.ToInt32(myReader[2]);
mybitacora_gestion.id_operadora2 = Convert.ToInt32(myReader[3]);
mybitacora_gestion.evento = myReader[4].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mybitacora_gestion);
}
public int FormularioRescateEncabezado(int idExpediente,
string fechaEmergencia,
string horaInicio,
string horaLlegadaPrimerCarro,
string horaLlegadaCarroRescate,
string horaTermino,
int correlativoCompania,
int correlativoCBPA,
string clasificacionAccidente,
string clasificacionZona,
string tipoDeVia,
string estadoAtmosferico,
string sector,
int frenteNumero,
string esquina,
string comuna)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO formulario_rescate_encabezado(id_expediente, fecha_emergencia, hora_inicio, hora_llegada_primer_carro, hora_llegada_carro_rescate, hora_termino, correlativo_compania, correlativo_cbpa, clasificacion_accidente, clasificacion_zona, tipo_de_via, estado_atmosferico, sector, frente_numero, esquina, comuna) ";
reqSQL += "VALUES (" + idExpediente + ", '" + fechaEmergencia + "', '" + horaInicio + "', '" + horaLlegadaPrimerCarro + "', '" + horaLlegadaCarroRescate + "', '" + horaTermino + "', '" + correlativoCompania + "', '" + correlativoCBPA + "', '" + clasificacionAccidente + "', '" + clasificacionZona + "', '" + tipoDeVia + "', '" + estadoAtmosferico + "', '" + sector + "', " + frenteNumero + ", '" + esquina + "', '" + comuna + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public k_grifos getObjectk_grifos(System.Int32 myID)
{
k_grifos myk_grifos = new k_grifos();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT gid,identifica,comuna_,direccion,geom FROM k_grifos WHERE (gid=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myk_grifos.gid = Convert.ToInt32(myReader[0]);
myk_grifos.identifica = Convert.ToInt32(myReader[1]);
myk_grifos.comuna_ = myReader[2].ToString();
myk_grifos.direccion = myReader[3].ToString();
myk_grifos.the_geom = myReader[4].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myk_grifos);
}
public int FormularioRescateServicioMedico(int idExpediente,
string concurrio,
string acargo,
string unidadSamu,
string unidadSapu,
string unidadPrivado,
string unidadOtro)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO formulario_rescate_servicio_medico(id_expediente, concurrio, acargo, unidad_samu, unidad_sapu, unidad_privado, unidad_otro) ";
reqSQL += "VALUES (" + idExpediente + ", '" + concurrio + "', '" + acargo + "', '" + unidadSamu + "', '" + unidadSapu + "', '" + unidadPrivado + "', '" + unidadOtro + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public f_ferias getObjectf_ferias(System.String myID)
{
f_ferias myf_ferias = new f_ferias();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT gid,id,comuna,nombre,desde,hasta,dia_1,dia_2,the_geom FROM f_ferias WHERE (the_geom='" + myID + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myf_ferias.gid = Convert.ToInt32(myReader[0]);
myf_ferias.id = Convert.ToInt32(myReader[1]);
myf_ferias.comuna = myReader[2].ToString();
myf_ferias.nombre = myReader[3].ToString();
myf_ferias.desde = myReader[4].ToString();
myf_ferias.hasta = myReader[5].ToString();
myf_ferias.dia_1 = myReader[6].ToString();
myf_ferias.dia_2 = myReader[7].ToString();
myf_ferias.the_geom = myReader[8].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myf_ferias);
}
public int FormularioRescateVehiculosInvolucrados(int idExpediente,
string tipo,
string marca,
string modelo,
string patente,
string conductor,
string ciConductor,
string acompanante1,
string ciAcompanante1,
string acompanante2,
string ciAcompanante2)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO formulario_rescate_vehiculos_involucrados(id_expediente, tipo, marca, modelo, patente, conductor, ci_conductor, acompanante_1, ci_acompanante_1, acompanante_2, ci_acompanante_2) ";
reqSQL += "VALUES (" + idExpediente + ", '" + tipo + "', '" + marca + "', '" + modelo + "', '" + patente + "', '" + conductor + "', '" + ciConductor + "', '" + acompanante1 + "', '" + ciAcompanante1 + "', '" + acompanante2 + "', '" + ciAcompanante2 + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public p_paradero getObjectp_paradero(System.Int32 myID)
{
p_paradero myp_paradero = new p_paradero();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT gid,id,avenida,sgc1,sgc2,the_geom FROM p_paradero WHERE (gid=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myp_paradero.gid = Convert.ToInt32(myReader[0]);
myp_paradero.id = Convert.ToInt32(myReader[1]);
myp_paradero.avenida = myReader[2].ToString();
myp_paradero.sgc1 = Convert.ToInt64(myReader[3]);
myp_paradero.sgc2 = myReader[4].ToString();
myp_paradero.the_geom = myReader[5].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myp_paradero);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_oficial_cia getObjectz_oficial_cia(System.Int32 myID)
{
z_oficial_cia myz_oficial_cia = new z_oficial_cia();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_oficial, id_voluntario, general FROM z_oficial_cia WHERE (id_oficial_cia=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_oficial_cia.id_oficial_cia = Convert.ToInt32(myReader[0]);
myz_oficial_cia.id_oficial = Convert.ToInt32(myReader[1]);
myz_oficial_cia.id_voluntario = Convert.ToInt32(myReader[2]);
myz_oficial_cia.general = Convert.ToBoolean(myReader[3]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myz_oficial_cia);
}
public z_guardia getObjectz_guardia(string myID)
{
z_guardia myz_guardia = new z_guardia();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_guardia,tipo_oficial,oficial,responsabilidades,mostrar FROM z_guardia WHERE (tipo_oficial='" + myID + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_guardia.id_guardia = Convert.ToInt32(myReader[0]);
myz_guardia.tipo_oficial = myReader[1].ToString();
myz_guardia.oficial = myReader[2].ToString();
myz_guardia.responsabilidades = myReader[3].ToString();
myz_guardia.mostrar = Convert.ToBoolean(myReader[4]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myz_guardia);
}
public s_sector getObjects_sector_comuna(string comuna)
{
s_sector mys_sector = new s_sector();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_sector,id_areas,descripcion FROM s_sector WHERE (descripcion='" + comuna + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mys_sector.id_sector = Convert.ToInt32(myReader[0]);
mys_sector.id_areas = myReader[1].ToString();
mys_sector.descripcion = myReader[2].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mys_sector);
}
public z_cargos getComandanteReemplazo(int orden)
{
var myz_cargos = new z_cargos();
var myBase = new CnxBase();
string reqSQL =
"SELECT id_cargo,id_voluntario,grado,orden_antiguedad,cargo_antiguedad,llamado_oficial, reemplaza_a FROM z_cargos WHERE (grado=1 and orden_antiguedad>" +
orden + " and reemplaza_a=0 and activo=true) order by orden_antiguedad limit 1";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
var myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_cargos.id_cargo = Convert.ToInt32(myReader[0]);
myz_cargos.id_voluntario = Convert.ToInt32(myReader[1]);
myz_cargos.grado = Convert.ToInt32(myReader[2]);
myz_cargos.orden_antiguedad = Convert.ToInt32(myReader[3]);
myz_cargos.cargo_antiguedad = Convert.ToInt32(myReader[4]);
myz_cargos.llamado_oficial = Convert.ToInt32(myReader[5]);
myz_cargos.reemplaza_a = Convert.ToInt32(myReader[6]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr + reqSQL));
}
return(myz_cargos);
}
public static int FormularioServicioLugarInicioFuego(
int idExpediente,
string numeroPiso,
string living,
string bano,
string comedor,
string bodega,
string cocina,
string patio,
string dormitorio,
string otro,
string descripcionOtro
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_lugar_inicio_fuego(id_expediente, numeroPiso, living, bano, comedor, bodega, cocina, patio, dormitorio, otro, descripcionOtro) ";
reqSQL += "VALUES (" + idExpediente + ", '" + numeroPiso + "', '" + living + "', '" + bano + "', '" + comedor + "', '" + bodega + "', '" + cocina + "', '" + patio + "', '" + dormitorio + "', '" + otro + "', '" + descripcionOtro + "')";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
ret = myCommand.ExecuteNonQuery();
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
