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