public User SeleccionarPorId(string id, out string mensaje) { mensaje = ""; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", Utils.QuitarDominio(id)); DataRow query = (from result in obj.ExecuteQuery(Queries.Default.SeleccionarAlumno, itemListDictionary).AsEnumerable() select result).FirstOrDefault(); if (query != null) { return(MappeoOrigen(query)); } else { mensaje = Mensajes.Default.SeleccionarAlumno; } } } catch (Exception ex) { Logger.ExLogger(ex); mensaje = Mensajes.Default.Excepcion; } return(null); }
private bool ValidarResolucionRetiro(string id, out string mensaje) { mensaje = ""; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", id); DataRow query = (from result in obj.ExecuteQuery(Queries.Default.ValidarResolucionRetiro, itemListDictionary).AsEnumerable() select result).FirstOrDefault(); if (query != null) { mensaje = query[0].ToString() == "0" ? "" : Mensajes.Default.ValidarResolucionRetiro; return(query[0].ToString() == "0"); } else { mensaje = Mensajes.Default.ValidarResolucionRetiro; } } } catch (Exception ex) { Logger.ExLogger(ex); mensaje = Mensajes.Default.Excepcion; } return(false); }
public string[] ObtenerTutor(string alumno, out string mensaje) { mensaje = ""; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", alumno); DataRow query = (from result in obj.ExecuteQuery(Queries.Default.SeleccionarTutor, itemListDictionary).AsEnumerable() select result).FirstOrDefault(); if (query != null) { return(DecodificarTutor(query)); } else { mensaje = Mensajes.Default.SeleccionarTutor; } } } catch (Exception ex) { Logger.ExLogger(ex); mensaje = Mensajes.Default.Excepcion; } return(null); }
public Curso Seleccionar(Curso item) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary parametros = new ListDictionary(); parametros.Add("Cur_ID", item.Id); parametros.Add("per_ID", item.IdPersona); DataRow result = (from hojaVida in obj.ExecuteQuery(Queries.Default.SeleccionarCurso, parametros).AsEnumerable() select hojaVida ).FirstOrDefault(); if (result != null) { return(MapToItem(result)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
private bool ValidarNivel(int nivel, string carrera, string plan, string especialidad, out string mensaje) { mensaje = ""; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", carrera); itemListDictionary.Add("@p2", plan); itemListDictionary.Add("@p3", especialidad); DataRow query = (from result in obj.ExecuteQuery(Queries.Default.ValidarNivel, itemListDictionary).AsEnumerable() select result).FirstOrDefault(); if (query != null) { mensaje = nivel >= int.Parse(query[0].ToString()) ? "" : Mensajes.Default.ValidarNivel; return(nivel >= int.Parse(query[0].ToString())); } else { mensaje = Mensajes.Default.ValidarNivel; } } } catch (Exception ex) { Logger.ExLogger(ex); mensaje = Mensajes.Default.Excepcion; } return(false); }
public List <Materia> SeleccionarListaMaterias(string carrera, string plan, string especialidad, string tipo) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", carrera); itemListDictionary.Add("@p2", plan); itemListDictionary.Add("@p3", especialidad); var query = obj.ExecuteQuery(Queries.Default.SeleccionarListaMaterias, itemListDictionary).AsEnumerable(); List <Materia> result = new List <Materia>(); string[] tipoD = DecodificarTipoPasantia(tipo); foreach (var item in query) { result.Add(MappeoOrigen(item)); } return(result.Where(i => tipoD.Contains(i.Tipo)).ToList()); } } catch (Exception ex) { Logger.ExLogger(ex); } return(new List <Materia>()); }
public List <Curso> SeleccionarCursos(int idPersona) { List <Curso> result = new List <Curso>(); try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("PER_ID", idPersona); var query = obj.ExecuteQuery(Queries.Default.ObtenerTodosLosCursosPorPersona, itemListDictionary); if (query != null) { foreach (DataRow item in query.Rows) { result.Add(MapToItem(item)); } } } } catch (Exception ex) { Logger.ExLogger(ex); } return(result); }
public KeyValuePair <int, string> ObtenerCarreraSegunSAES(string idSaes) { string nombreSaes = string.Empty; int? codigoBolsaEmpleo = 0; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary Saes = new ListDictionary(); Saes.Add("SAES", idSaes); var result = obj.ExecuteQuery(Queries.Default.SeleccionCarreraSAESBolsaEmpleo, Saes).AsEnumerable(); if (result.Count() > 0) { var item = result.FirstOrDefault(); codigoBolsaEmpleo = item.Field <int?>("CAR_BE"); nombreSaes = item.Field <string>("CAR_SAES_NOMBRE"); } } return(new KeyValuePair <int, string>(codigoBolsaEmpleo.Value, nombreSaes)); } catch (Exception ex) { Logger.ExLogger(ex); throw ex; } }
public List <Pais> SeleccionarListaPaises() { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); var query = obj.ExecuteQuery(Queries.Default.SeleccionarPaises, itemListDictionary).AsEnumerable(); List <Pais> result = new List <Pais>(); foreach (var item in query) { result.Add(MappeoOrigen(item)); } return(result); } } catch (Exception ex) { Logger.ExLogger(ex); } return(new List <Pais>()); }
public HojaVida SeleccionarCamposEditablesPorMatricula(string matricula) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary hojaVidaLD = new ListDictionary(); hojaVidaLD.Add("PER_MATRICULA", matricula); DataRow result = (from hojaVida in obj.ExecuteQuery(Queries.Default.SeleccionarHojaVida, hojaVidaLD).AsEnumerable() select hojaVida ).FirstOrDefault(); if (result != null) { return(MapToItem(result)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public List <UsuarioEmpresa> SeleccionarTodos() { List <UsuarioEmpresa> usuarios = new List <UsuarioEmpresa>(); try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); DataTable query = obj.ExecuteQuery(Queries.Default.ObtenerTodosLosUsuarios, itemListDictionary); if (query != null) { foreach (DataRow item in query.Rows) { usuarios.Add(MappeoOrigen(item)); } } } } catch (Exception ex) { Logger.ExLogger(ex); throw ex; } return(usuarios); }
public int ObtenerNivel(string matricula, string carrera, string plan, string especialidad, out string mensaje) { mensaje = ""; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", matricula); itemListDictionary.Add("@p2", carrera); itemListDictionary.Add("@p3", plan); itemListDictionary.Add("@p4", especialidad); DataRow query = (from result in obj.ExecuteQuery(Queries.Default.SeleccionarNivel, itemListDictionary).AsEnumerable() select result).FirstOrDefault(); if (query != null && query[0].ToString() != "") { return(int.Parse(query[0].ToString())); } else { mensaje = Mensajes.Default.SeleccionarNivel; } } } catch (Exception ex) { Logger.ExLogger(ex); mensaje = Mensajes.Default.Excepcion; } return(-1); }
public List <Materia> SeleccionarListaMateriasSupervision(string matricula) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", matricula); var query = obj.ExecuteQuery(Queries.Default.SeleccionarListaMateriasSupervision, itemListDictionary).AsEnumerable(); List <Materia> result = new List <Materia>(); foreach (var item in query) { result.Add(MappeoSupervision(item)); } return(result.ToList()); } } catch (Exception ex) { Logger.ExLogger(ex); } return(new List <Materia>()); }
public UsuarioEmpresa SeleccionarPorUserNamePasswordEmpresa(string username, string password) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("UserName", username); itemListDictionary.Add("Password", password); DataRow query = (from empresa in obj.ExecuteQuery(Queries.Default.ObtenerUsuarioPorUserNamePasswordEmpresa, itemListDictionary).AsEnumerable() select empresa).FirstOrDefault(); if (query != null) { return(MappeoOrigen(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
private bool ValidarDeudas(string id, out string mensaje) { mensaje = ""; bool result = true; try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("id", id); var query = obj.ExecuteQuery(Queries.Default.ValidarDeudas, itemListDictionary).AsEnumerable(); if (query != null) { foreach (DataRow d in query) { if (d[1].ToString().Trim() == "F") { if (d[2].ToString().ToLower().IndexOf("cuota morosa") != -1) { result = false; mensaje = Mensajes.Default.ValidarDeudas; break; } } } return(result); } else { mensaje = Mensajes.Default.ValidarDeudas; } } } catch (Exception ex) { Logger.ExLogger(ex); mensaje = Mensajes.Default.Excepcion; } return(false); }
public bool ExisteHojaVida(string matricula) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary hojaVidaLD = new ListDictionary(); hojaVidaLD.Add("PER_Matricula", matricula); var result = obj.ExecuteQuery(Queries.Default.VerificaExistenciaHojaVida, hojaVidaLD).AsEnumerable(); if (result.Count() > 0) { return(true); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(false); }
public bool ExisteCurso(int idCurso) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary parametros = new ListDictionary(); parametros.Add("CUR_ID", idCurso); var result = obj.ExecuteQuery(Queries.Default.VerificarExistenciaCurso, parametros).AsEnumerable(); if (result.Count() > 0) { return(true); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(false); }
public List <CatalogoValor> SeleccionarPorId(int id) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("VAL_TIPO", id); List <DataRow> query = (from catalogo in obj.ExecuteQuery(Queries.Default.SeleccionarValores, itemListDictionary).AsEnumerable() select catalogo).ToList(); if (query != null) { return(MappeoOrigen(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public Materia SeleccionarPorIdSupervision(string id, string matricula) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", id); itemListDictionary.Add("@p2", matricula); DataRow query = (from materia in obj.ExecuteQuery(Queries.Default.SeleccionarMateriaPorIdSupervision, itemListDictionary).AsEnumerable() select materia).FirstOrDefault(); if (query != null) { return(MappeoSupervision(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public Materia Seleccionar(Materia item) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.SAES)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("@p1", item.ID); DataRow query = (from materia in obj.ExecuteQuery(Queries.Default.SeleccionarMateria, itemListDictionary).AsEnumerable() select materia).FirstOrDefault(); if (query != null) { return(MappeoOrigen(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public OfertaLaboral SeleccionarPorId(int id) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("OFE_ID", id); DataRow query = (from oferta in obj.ExecuteQuery(Queries.Default.ObtenerOfertasPorId, itemListDictionary).AsEnumerable() select oferta).FirstOrDefault(); if (query != null) { return(MappeoOrigen(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public Empresa SeleccionarPorId(int id) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("emp_id", id); DataRow query = (from empresa in obj.ExecuteQuery(Queries.Default.SeleccionarEmpresa, itemListDictionary).AsEnumerable() select empresa).FirstOrDefault(); if (query != null) { return(MappeoOrigen(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public Academico SeleccionarPorMatricula(string matricula) { try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(Constants.DBConnectionType.BEMPLEO)) { ListDictionary itemListDictionary = new ListDictionary(); itemListDictionary.Add("matricula", matricula); DataRow query = (from academico in obj.ExecuteQuery(Queries.Default.SeleccionarEstudianteSAES, itemListDictionary).AsEnumerable() select academico).FirstOrDefault(); if (query != null) { return(MappeoOrigen(query)); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(null); }
public int ObtenerHorasActuales(PasantiasPreProfesionales item) { queries.DBConnectionType dbcontype; string queryUpsert; string querySelect; ObtenerParametrosConexion(item.TipoPasantiaEnum, out dbcontype, out queryUpsert, out querySelect); try { using (db.DBConnectorSwitch obj = new db.DBConnectorSwitch(dbcontype)) { ListDictionary notaSelect = new ListDictionary(); notaSelect.Add("@p1", item.Matricula); notaSelect.Add("@p2", item.CodigoDeMateria); DataRow queryS = (from nota in obj.ExecuteQuery(querySelect, notaSelect).AsEnumerable() select nota).FirstOrDefault(); if (queryS != null && queryS[0].ToString() != "") { return(int.Parse(queryS[0].ToString())); } else { return(0); } } } catch (Exception ex) { Logger.ExLogger(ex); } return(-1); }