public static void GuardaPatente(string patente, int tipo, string descripcion)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_REGISTRA_AUTO";
cmd.Parameters.AddWithValue("@patente", patente);
cmd.Parameters.AddWithValue("@tipo", tipo);
cmd.Parameters.AddWithValue("@des", descripcion);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static void Activa_Inicio(string usuario, string clave, string nueva_clave)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ACTIVA_INICIO_USUARIO";
cmd.Parameters.AddWithValue("@USUARIO", usuario);
cmd.Parameters.AddWithValue("@CONTRASEÑA_ACTUAL", clave);
cmd.Parameters.AddWithValue("@NUEVA_CONTRASEÑA", nueva_clave);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static Personas GetPersonapasaporte(string pasaporte)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_BUSCA_PERSONA_PASAPORTE";
cmd.Parameters.AddWithValue("@pasaporte", pasaporte);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
Personas persona = null;
if (dt.Rows.Count > 0)
{
persona = new Personas();
persona.Id = Int32.Parse(dt.Rows[0]["id_persona"].ToString());
persona.Nombre = dt.Rows[0]["Nombre"].ToString();
persona.Rut = Int32.Parse(dt.Rows[0]["rut"].ToString());
persona.Apellido = dt.Rows[0]["APELLIDOPATERNO"].ToString();
}
return(persona);
}
catch (Exception)
{
throw;
}
}
public static string ActualizRL(RelacionLaboral rl)
{
try
{
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_RELACION_LABORAL_ACTUALIZA";
cmd.Parameters.AddWithValue("@correlativo", rl.correlativo);
if (rl.idContrato == null || rl.idContrato == "0")
{
cmd.Parameters.AddWithValue("@idContrato", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@idContrato", rl.idContrato);
}
cmd.Parameters.AddWithValue("respuesta", rl.Respuesta);
cmd.ExecuteNonQuery();
return("ok");
}
catch (SqlException exp)
{
return(exp.Message.ToString());
}
}
public static void ModificaPatenteIngreso(string patente, int tipo, string descripcion, int id)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_MODIFICA_AUTO_INGRESO";
cmd.Parameters.AddWithValue("@patente", patente);
cmd.Parameters.AddWithValue("@tipo", tipo);
cmd.Parameters.AddWithValue("@ID_SOLICITUD", id);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static Vehiculo ValidaVehiculo(int idpersonaaprpnada)
{
try
{
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ULTIMO_VEHICULOS";
cmd.Parameters.AddWithValue("@ID_PERSONA_APROBADA", idpersonaaprpnada);
SqlDataReader rdr = cmd.ExecuteReader();
Vehiculo ls_patente = new Vehiculo();
while (rdr.Read())
{
ls_patente.Id = Int32.Parse(rdr["ID_VEHICULO"].ToString());
ls_patente.Patente = rdr["PATENTE"].ToString();
}
cmd.Connection.Close();
cmd.Dispose();
return(ls_patente);
}
catch (Exception)
{
throw;
}
}
public static List <TipoIngreso> GetTipoIngreso()
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_RECUPERA_TIPOS_DE_INGRESO";
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
List <TipoIngreso> ls_tipos = new List <TipoIngreso>();
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
ls_tipos.Add(new TipoIngreso
{
Id = Int32.Parse(item["ID_TIPO_INGRESO"].ToString()),
Nombre = item["nombre"].ToString()
});
}
}
return(ls_tipos);
}
catch (Exception)
{
throw;
}
}
public static string ListarPersonas(string personas)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
string html = "";
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_LISTA_INDUCCION_ACTUALIZADA";
cmd.Parameters.AddWithValue("@personas", personas);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyHtmlNormal(dt);
}
return(html);
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static string GetNombradas(string fecha, string turno)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_LISTA_NOMBRADA";
string html = "";
cmd.Parameters.AddWithValue("@fecha", fecha);
cmd.Parameters.AddWithValue("@turno", turno);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyHtmlNormal(dt);
}
return(html);
}
catch (Exception)
{
return("");
}
}
public static Vehiculo GetVehiculo(String patente)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_BUSCA_PATENTE";
cmd.Parameters.AddWithValue("@PATENTE", patente);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
Vehiculo vehiculo = null;
if (dt.Rows.Count > 0)
{
vehiculo = new Vehiculo();
vehiculo.Id = Int32.Parse(dt.Rows[0]["ID_VEHICULO"].ToString());
vehiculo.Patente = dt.Rows[0]["PATENTE"].ToString();
vehiculo.Tipo = dt.Rows[0]["TIPONOMBRE"].ToString();
}
return(vehiculo);
}
catch (Exception)
{
throw;
}
}
public static string GetUsuarioPerfil(int id)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "PERFIL_USUARIO";
string html = "";
cmd.Parameters.AddWithValue("@ID_USUARIO", id);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyPerfilesUSHtmlNormal(dt);
}
return(html);
}
catch (Exception)
{
throw;
}
}
public static string GetLocacionesPuerto_Html(int puerto)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_BUSCA_PUERTO_LOCACIONES";
string html = "";
cmd.Parameters.AddWithValue("@ID_PUERTO", puerto);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyHtmlNormal(dt);
}
return(html);
}
catch (Exception)
{
throw;
}
}
public static void CambiaEstadoLoc(int puerto, int locacion, int opcion)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ACTUALIZA_LOCACION_ESTADO";
cmd.Parameters.AddWithValue("@ID_PUERTO", puerto);
cmd.Parameters.AddWithValue("@ESTADO", opcion);
cmd.Parameters.AddWithValue("@ID_LOC", locacion);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static Login ValidarAcceso(string usuario, string clave)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_VALIDA_ACCESO";
cmd.Parameters.AddWithValue("@USUARIO", usuario);
cmd.Parameters.AddWithValue("@CLAVE", clave);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
Login Datos_Login = new Login();
Datos_Login.Id = Int32.Parse(dt.Rows[0]["id_usuario"].ToString());
Datos_Login.Nombre = dt.Rows[0]["Nombre"].ToString();
Datos_Login.Perfil = Int32.Parse(dt.Rows[0]["id_perfil"].ToString());
Datos_Login.Inactivo = dt.Rows[0]["CLAVE_INICIAL"].ToString();
return(Datos_Login);
}
catch (Exception)
{
throw;
}
}
public static string GetValidaVehiculo(String patente)
{
string resp = "NOK";
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_VALIDA_PATENTE";
cmd.Parameters.AddWithValue("@PATENTE", patente);
da.Fill(dt);
cmd.Connection.Close();
if (dt.Rows.Count > 0)
{
resp = dt.Rows[0]["MENSAJE"].ToString();
}
}
catch (Exception)
{
throw;
}
return(resp);
}
public static void LocacionGuarda(int puerto, string descripcion, int locacion, string informada)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_LOCACION_PUERTO_INS";
cmd.Parameters.AddWithValue("@DESCRIPCION", descripcion);
cmd.Parameters.AddWithValue("@ID_PUERTO", puerto);
cmd.Parameters.AddWithValue("@ID_LOC", locacion);
cmd.Parameters.AddWithValue("@INFORMADA", informada);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static void ApruebaSolicitud(int id, string idpersona, int id_usuario)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_PERSONAS_APROBADAS";
cmd.Parameters.AddWithValue("@ID_SOLICITUD", id);
cmd.Parameters.AddWithValue("@XML", idpersona);
cmd.Parameters.AddWithValue("@ID_USUARIO", id_usuario);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static void GuardaSolicitud(string puerto, DateTime fechainicio, DateTime fechafin, string tingreso, string empresa, string perxml, string vehiculoxml, int usuario)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_GUARDA_SOLICITUD";
cmd.Parameters.AddWithValue("@puerto", puerto);
cmd.Parameters.AddWithValue("@fechainicio", fechainicio);
cmd.Parameters.AddWithValue("@fechafin", fechafin);
cmd.Parameters.AddWithValue("@tingreso", tingreso);
cmd.Parameters.AddWithValue("@usuario", usuario);
cmd.Parameters.AddWithValue("@empresa", empresa);
cmd.Parameters.AddWithValue("@perxml", perxml);
cmd.Parameters.AddWithValue("@vehiculoxml", vehiculoxml);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static string ValidaIngresoSolicitud(string puerto, DateTime fechainicio, DateTime fechafin, string tingreso, string empresa, string perxml, string vehiculoxml)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_VALIDAR_SOLICITUD";
cmd.Parameters.AddWithValue("@puerto", puerto);
cmd.Parameters.AddWithValue("@fechainicio", fechainicio);
cmd.Parameters.AddWithValue("@fechafin", fechafin);
cmd.Parameters.AddWithValue("@tingreso", tingreso);
cmd.Parameters.AddWithValue("@empresa", empresa);
cmd.Parameters.AddWithValue("@perxml", perxml);
cmd.Parameters.AddWithValue("@vehiculoxml", vehiculoxml);
string html = "";
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveTablaMod(dt, "Quitar");
}
return(html);
}
catch (Exception)
{
throw;
}
}
public static void ModificarPerfiles(int idusuario, int perfil, string accion)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "MODIFICAR_PERFILES";
cmd.Parameters.AddWithValue("@idusuario", idusuario);
cmd.Parameters.AddWithValue("@perfil", perfil);
cmd.Parameters.AddWithValue("@accion", accion);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
}
catch (Exception)
{
throw;
}
}
public static List <Nacionalidad> GetNacionalidad()
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_RECUPERA_NACIONALIDAD";
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
List <Nacionalidad> ls_nacionalidad = new List <Nacionalidad>();
if (dt.Rows.Count > 0)
{
foreach (DataRow item in dt.Rows)
{
ls_nacionalidad.Add(new Nacionalidad
{
Id = Int32.Parse(item["ID_NACIONALIDAD"].ToString()),
Nombre = item["NACIONALIDAD"].ToString()
});
}
}
return(ls_nacionalidad);
}
catch (Exception)
{
throw;
}
}
public static string DevuelveAprobadores(int id, int rut)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_APROBADORES_INGRESO";
string html = "";
cmd.Parameters.AddWithValue("@ID_SOLICITUD", id);
cmd.Parameters.AddWithValue("@RUT", rut);
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyHtmlNormalEditable(dt);
}
return(html);
}
catch (Exception)
{
throw;
}
}
public static string GetVehiculosDia()
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_INGRESOS_VEHICULO";
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
string html = "";
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyHtmlNormal(dt);
}
return(html);
}
catch (Exception)
{
throw;
}
}
public static List <Vehiculo> ListarPatente(int id)
{
try
{
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "LISTA_VEHICULOS_SOL";
cmd.Parameters.AddWithValue("@ID_SOLICITUD", id);
SqlDataReader rdr = cmd.ExecuteReader();
List <Vehiculo> ls_patente = new List <Vehiculo>();
while (rdr.Read())
{
ls_patente.Add(new Vehiculo
{
Id = Int32.Parse(rdr["ID_VEHICULO"].ToString()),
Patente = rdr["PATENTE"].ToString(),
});
}
cmd.Connection.Close();
cmd.Dispose();
return(ls_patente);
}
catch (Exception)
{
throw;
}
}
public static string GetNavesPrincipal_Html()
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_NAVES_LISTAR_ESTADO";
string html = "";
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveBodyHtmlNormalEditable(dt);
}
return(html);
}
catch (Exception)
{
throw;
}
}
public static string ActualizaFecha(DateTime fecha, string personas)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_ACTUALIZA_INDUCCION";
cmd.Parameters.AddWithValue("@fecha", fecha);
cmd.Parameters.AddWithValue("@personas", personas);
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Dispose();
return("ok");
}
catch (Exception ex)
{
return(ex.Message);
}
}
public static Ingreso BuscarIngreso(int rut, string pasaporte)
{
try
{
SqlCommand cmd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "DATOS_MOVIMIENTO";
if (rut == 0)
{
cmd.Parameters.AddWithValue("@RUT", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@RUT", rut);
}
if (pasaporte == "")
{
cmd.Parameters.AddWithValue("@PASAPORTE", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@PASAPORTE", pasaporte);
}
SqlDataReader rdr = cmd.ExecuteReader();
Ingreso aux_ingreso = new Ingreso();
while (rdr.Read())
{
aux_ingreso.Nombre = rdr["NOMBRE"].ToString();
aux_ingreso.Idsolicitud = Int32.Parse(rdr["ID_SOLICITUD"].ToString());
aux_ingreso.Estado = rdr["ESTADO"].ToString();
aux_ingreso.Autorizacion = rdr["AUTORIZACION"].ToString();
aux_ingreso.Puerto = rdr["PUERTO"].ToString();
aux_ingreso.Usuario = rdr["USUARIO"].ToString();
aux_ingreso.Locacion = rdr["LOCACION"].ToString();
aux_ingreso.Nave = rdr["NAVE"].ToString();
aux_ingreso.Inicio = rdr["FECHA_DESDE"].ToString();
aux_ingreso.Fin = rdr["FECHA_HASTA"].ToString();
aux_ingreso.Empresa = rdr["EMPRESA"].ToString();
aux_ingreso.Idaprobado = Int32.Parse(rdr["ID_PERSONA_APROBADA"].ToString());
aux_ingreso.Pasaporte = rdr["PASAPORTE"].ToString();
}
cmd.Connection.Close();
cmd.Dispose();
return(aux_ingreso);
}
catch (Exception)
{
throw;
}
}
public static PERSONAINDUCCION GetPERSONAINDUCCION(int rut, string pasaporte)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_BUSCA_PERSONA_INDUCCION";
if (rut == 0)
{
cmd.Parameters.AddWithValue("@RUT", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@RUT", rut);
}
if (pasaporte == "")
{
cmd.Parameters.AddWithValue("@Pasaporte", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@Pasaporte", pasaporte);
}
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
PERSONAINDUCCION persona = null;
if (dt.Rows.Count > 0)
{
persona = new PERSONAINDUCCION();
persona.Id = Int32.Parse(dt.Rows[0]["id_persona"].ToString());
persona.Nombre = dt.Rows[0]["Nombre"].ToString();
persona.Rut = dt.Rows[0]["RUT"].ToString();
persona.Dv = dt.Rows[0]["DV"].ToString();
persona.Pasaporte = dt.Rows[0]["PASAPORTE"].ToString();
persona.Apellido = dt.Rows[0]["APELLIDOPATERNO"].ToString();
persona.Inactivo = Boolean.Parse(dt.Rows[0]["INACTIVO"].ToString());
persona.estadoInduccion = dt.Rows[0]["ESTADOINDUCCION"].ToString();
persona.fechaInduccion = dt.Rows[0]["FECHAINDUCCION"].ToString();
}
return(persona);
}
catch (Exception)
{
throw;
}
}
public static string RegistraAcceso(int tipo, string ip, int persona_persona_aprobada, string patente, int tipoPago, int detalle, string guia, double toneledas, string pc, string boleta, string motivo, string nave, string lancha, int idempresa, int idsolicitud, int tipoVehiculo, string usuario, string tipoContado, string cantidadHoras, double tara)
{
string idresp = "0";
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "REGISTRA_ACCESO_CLIENTE";
cmd.Parameters.AddWithValue("@MOV_ID_MOVIMIENTO", tipo);
cmd.Parameters.AddWithValue("@IP", "");
cmd.Parameters.AddWithValue("@ID_VEHICULO", patente);
cmd.Parameters.AddWithValue("@ID_PERSONA_APROBADA", persona_persona_aprobada);
cmd.Parameters.AddWithValue("@TIPO_PAGO", tipoPago);
cmd.Parameters.AddWithValue("@DETALLE", detalle);
cmd.Parameters.AddWithValue("@NGUIA", guia);
cmd.Parameters.AddWithValue("@TONELADAS", toneledas);
cmd.Parameters.AddWithValue("@TARA", tara);
cmd.Parameters.AddWithValue("@PC", pc);
cmd.Parameters.AddWithValue("@BOLETA", boleta);
cmd.Parameters.AddWithValue("@MOTIVO", motivo);
cmd.Parameters.AddWithValue("@NAVE", nave);
cmd.Parameters.AddWithValue("@LANCHA", lancha);
cmd.Parameters.AddWithValue("@IDEMPRESA", idempresa);
cmd.Parameters.AddWithValue("@ID_SOLICITUD", idsolicitud);
cmd.Parameters.AddWithValue("@TIPOVEHICULO", tipoVehiculo);
cmd.Parameters.AddWithValue("@USUARIO", usuario);
cmd.Parameters.AddWithValue("@TIPOCONTADO", tipoContado);
cmd.Parameters.AddWithValue("@CANTIDADHORAS", cantidadHoras);
cmd.Parameters.AddWithValue("@IDENTRADA", 0);
cmd.Parameters["@IDENTRADA"].Direction = ParameterDirection.Output;
cmd.ExecuteNonQuery();
idresp = cmd.Parameters["@IDENTRADA"].Value.ToString();
cmd.Connection.Close();
cmd.Dispose();
return(idresp);
}
catch (SqlException ex)
{
return("Error Numero 57-AccesoClienteDAL");
}
}
public static string GetEmpresasActivas(int rut, string nombre)
{
try
{
SqlCommand cmd = new SqlCommand();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
Coneccion param = Parameter.Leer_parametros();
cmd.Connection = new SqlConnection(param.ConString);
cmd.Connection.Open();
cmd.Parameters.Clear();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_EMPRESAS_ACTIVAS";
string html = "";
if (rut == 0)
{
cmd.Parameters.AddWithValue("@rut", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@rut", rut);
}
if (nombre == "")
{
cmd.Parameters.AddWithValue("@NOMBRE", System.DBNull.Value);
}
else
{
cmd.Parameters.AddWithValue("@NOMBRE", nombre);
}
da.Fill(dt);
cmd.Connection.Close();
cmd.Dispose();
if (dt.Rows.Count > 0)
{
html = Util.DevuelveTablaHtml(dt);
}
return(html);
}
catch (Exception)
{
throw;
}
}