/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public e_carros_usados getObjecte_carros_usados(System.Int32 myID)
{
e_carros_usados mye_carros_usados = new e_carros_usados();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_expediente,id_carro,id_voluntario,num_voluntarios, seis, preinforme, en_jurisdiccion FROM e_carros_usados WHERE (id_carro=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
mye_carros_usados.id_expediente = Convert.ToInt32(myReader[0]);
mye_carros_usados.id_carro = Convert.ToInt32(myReader[1]);
mye_carros_usados.id_voluntario = Convert.ToInt32(myReader[2]);
mye_carros_usados.num_voluntarios = Convert.ToInt32(myReader[3]);
mye_carros_usados.seis = Convert.ToString(myReader[4]);
mye_carros_usados.preinforme = myReader[5].ToString();
mye_carros_usados.en_jurisdiccion = Convert.ToBoolean(myReader[6]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(mye_carros_usados);
}
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_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);
}
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 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);
}
/// <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 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,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);
}
public static int FormularioServicioTipoConstruccion(
int idExpediente,
string numeroPisos,
string hormigon,
string adobe,
string acero,
string mixta,
string madera,
string prefabricado,
string albanileria,
string otro,
string descripcionOtro
)
{
CnxBase myBase = new CnxBase();
int ret = 0;
string reqSQL = "INSERT INTO Formulario_servicio_tipo_construccion(id_expediente, numeroPisos, hormigon, adobe, acero, mixta, madera, prefabricado, albanileria, otro, descripcionOtro) ";
reqSQL += "VALUES (" + idExpediente + ", '" + numeroPisos + "', '" + hormigon + "', '" + adobe + "', '" + acero + "', '" + mixta + "', '" + madera + "', '" + prefabricado + "', '" + albanileria + "', '" + 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);
}
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);
}
public Image getImagen(int id_voluntario)
{
Image ret = null;
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT foto FROM z_voluntarios WHERE id_voluntario=" + id_voluntario;
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read() && myReader[0] != DBNull.Value)
{
NpgsqlTransaction t = myConn.BeginTransaction();
NpgsqlTypes.LargeObjectManager lbm = new NpgsqlTypes.LargeObjectManager(myConn);
NpgsqlTypes.LargeObject lo = lbm.Open(Convert.ToInt32(myReader[0]), NpgsqlTypes.LargeObjectManager.READ);
byte[] buf = new byte[lo.Size()];
buf = lo.Read(lo.Size());
MemoryStream ms = new MemoryStream();
ms.Write(buf, 0, lo.Size());
lo.Close();
t.Commit();
ret = Image.FromStream(ms);
}
myConn.Close();
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(ret);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public k_geoz getObjectk_geoz(System.Int32 myID)
{
k_geoz myk_geoz = new k_geoz();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT gid,id_hoja,id_celda,fila,columna,geoz,geom FROM k_geoz WHERE (gid=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myk_geoz.gid = Convert.ToInt32(myReader[0]);
myk_geoz.id_hoja = Convert.ToInt64(myReader[1]);
myk_geoz.id_celda = myReader[2].ToString();
myk_geoz.fila = myReader[3].ToString();
myk_geoz.columna = Convert.ToInt32(myReader[4]);
myk_geoz.geoz = myReader[5].ToString();
myk_geoz.the_geom = myReader[6].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myk_geoz);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_voluntarios getObjectz_voluntarios(System.Int32 myID)
{
z_voluntarios myz_voluntarios = new z_voluntarios();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_voluntario,id_compania,nombres,apellidos,rut,direccion,fecha_nacimiento,ingreso,num_llamado,comuna,telefono,celular FROM z_voluntarios WHERE (id_voluntario=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_voluntarios.id_voluntario = Convert.ToInt32(myReader[0]);
myz_voluntarios.id_compania = Convert.ToInt32(myReader[1]);
myz_voluntarios.nombres = myReader[2].ToString();
myz_voluntarios.apellidos = myReader[3].ToString();
myz_voluntarios.rut = myReader[4].ToString();
myz_voluntarios.direccion = myReader[5].ToString();
myz_voluntarios.fecha_nacimiento = Convert.ToDateTime(myReader[6]);
myz_voluntarios.ingreso = Convert.ToDateTime(myReader[7]);
myz_voluntarios.num_llamado = Convert.ToInt32(myReader[8]);
myz_voluntarios.comuna = myReader[9].ToString();
myz_voluntarios.telefono = myReader[10].ToString();
myz_voluntarios.celular = myReader[11].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myz_voluntarios);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public k_areas getObjectk_areas(System.Int32 myID)
{
k_areas myk_areas = new k_areas();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT gid,id_area,count,the_geom FROM k_areas WHERE (id_area=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myk_areas.gid = Convert.ToInt32(myReader[0]);
myk_areas.id_area = Convert.ToInt32(myReader[1]);
myk_areas.count = Convert.ToInt64(myReader[2]);
myk_areas.the_geom = myReader[3].ToString();
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw(new Exception(myErr.ToString() + reqSQL));
}
return(myk_areas);
}
/// <summary>
/// get an instance of object
/// </summary>
/// <param name="myID"></param>
public z_interinaje getObjectz_interinaje(System.Int32 myID)
{
z_interinaje myz_interinaje = new z_interinaje();
CnxBase myBase = new CnxBase();
string reqSQL = "SELECT id_interinaje,desde,hasta,id_cargo,id_reemplaza_a,iniciada,terminada FROM z_interinaje WHERE (id_interinaje=" + myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_interinaje.id_interinaje = Convert.ToInt32(myReader[0]);
myz_interinaje.desde = Convert.ToDateTime(myReader[1]);
myz_interinaje.hasta = Convert.ToDateTime(myReader[2]);
myz_interinaje.id_cargo = Convert.ToInt32(myReader[3]);
myz_interinaje.id_reemplaza_a = Convert.ToInt32(myReader[4]);
myz_interinaje.iniciada = Convert.ToBoolean(myReader[5]);
myz_interinaje.terminada = Convert.ToBoolean(myReader[6]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr.ToString() + reqSQL));
}
return(myz_interinaje);
}
/// <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 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 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,geom FROM f_ferias WHERE (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 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);
}
/// <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);
}
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 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);
}
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 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);
}
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 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 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);
}
/// <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);
}
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 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 z_tipo_carro getObjectz_tipo_carro(Int32 myID)
{
z_tipo_carro myz_tipo_carro = new z_tipo_carro();
CnxBase myBase = new CnxBase();
string reqSQL =
"SELECT id_tipo_carro,tipo_carro_letra,tipo_carro_descripcion FROM z_tipo_carro WHERE (id_tipo_carro=" +
myID + ")";
try
{
NpgsqlConnection myConn = myBase.OpenConnection(myBase.cnxString);
NpgsqlCommand myCommand = new NpgsqlCommand(reqSQL, myConn);
NpgsqlDataReader myReader = myCommand.ExecuteReader();
if (myReader.Read())
{
myz_tipo_carro.id_tipo_carro = Convert.ToInt32(myReader[0]);
myz_tipo_carro.tipo_carro_letra = Convert.ToString(myReader[1]);
myz_tipo_carro.tipo_carro_descripcion = Convert.ToString(myReader[2]);
}
myBase.CloseConnection(myConn);
}
catch (Exception myErr)
{
throw (new Exception(myErr + reqSQL));
}
return(myz_tipo_carro);
}
