public static string selectBecaUser(int idUser)
{
string result = "";
storedProcedure sp = new storedProcedure("ConnectionString");
string queryprom = "select promedio from alumno where idAlumno = " + idUser + "";
List <string> lsp = sp.recuperaRegistros(queryprom);
float prom = float.Parse(lsp[0]);
string querybeca = "select b.idBeca,b.nombreBeca from beca as b where b.promedio <= " + prom + " and b.idBeca not in (select distinct ba.idBeca from becasAlumnos as ba where ba.idAlumno = " + idUser + " and ba.idBeca = b.idBeca )";
List <string> lsb = sp.recuperaRegistros(querybeca);
if (lsb.Count > 0)
{
for (int i = 0; i < lsb.Count; i = i + 2)
{
result += "<h3><label>Beca:" + lsb[i + 1] + " </label><img src='images/images.jpg' heit='40px' width='40px' style='margin-left: 90px;' onclick='JavaScript:solicitar(" + lsb[i + 0] + ");'/>Solicitar</h3>";
}
}
else
{
result = "<h2>No hay becas disponibles en este momento</h2>";
}
return(result);
}
public static bool validarUsuario(string email, string password)
{
storedProcedure sp = new storedProcedure("ConnectionString");
bool resultado = true;
string query = "select idAlumno,nombreCompleto from alumno as al inner join" +
" usuarioRol as ur on ur.idUsuario = al.idAlumno" +
" where al.usuario = '" + email + "'and contrasena = '" + password + "'";
List <string> listaUser = sp.recuperaRegistros(query);
if (listaUser.Count > 0)
{
int idUser = int.Parse(listaUser[0]);
string emailq = listaUser[1];
HttpContext.Current.Session["cve"] = idUser;
HttpContext.Current.Session["nombre"] = emailq;
HttpContext.Current.Session["logged"] = true;
resultado = true;
}
else
{
resultado = false;
}
return(resultado);
}
public static List <AutoComplete> grupo(string term)
{
List <AutoComplete> resultado = new List <AutoComplete>();
List <string> obtener = new List <string>();
AutoComplete ac;
string query = "";
term = term.ToLower();
storedProcedure sp = new storedProcedure("ConnectionString");
query = "select idgrupo,grupo from grupo where grupo like '%" + term + "%'";
obtener = sp.recuperaRegistros(query);
if (obtener != null && obtener.Count > 0)
{
for (int i = 0; i < obtener.Count; i += 6)
{
ac = new AutoComplete();
ac.ID = obtener[i];
ac.nombre = obtener[i + 1];
resultado.Add(ac);
}
}
else
{
resultado.Add(new AutoComplete {
ID = "", nombre = "No se encontraron resultados"
});
}
return(resultado);
}
public static string obtenerTabla(int origen)
{
string tabla = "<table id='tablam'><thead><tr><th style='padding: 10px;'>Descripcion</th><th style='padding: 10px;'>Editar</th><th style='padding: 10px;'>Eliminar</th></tr></thead><tbod>";
string query = "";
storedProcedure sp = new storedProcedure("ConnectionString");
if (origen == 1)
{
query = "select nombreBeca,modificar,eliminar from view_beca";
}
else if (origen == 2)
{
query = "select * from view_grupo";
}
else if (origen == 3)
{
query = "select * from view_carrera";
}
else if (origen == 4)
{
query = "select * from view_tiposb";
}
List <string> ls = sp.recuperaRegistros(query);
for (int i = 0; i < ls.Count; i = i + 3)
{
tabla += "<tr><td>" + ls[i + 0] + "</td><td>" + ls[i + 1] + "</td><td>" + ls[i + 2] + "</td></tr>";
}
tabla += "</tbody></table>";
return(tabla);
}
public static List <string> obtenerDatosUser(int iduser)
{
storedProcedure sp = new storedProcedure("ConnectionString");
string query = "select nombreCompleto,promedio,carrera,grupo from alumno as a inner join carrera as c" +
" on c.idCarrera = a.iCarrera inner join grupo as g on g.idgrupo = a.idGrupo" +
" where a.idAlumno = " + iduser + "";
List <string> lsalumno = sp.recuperaRegistros(query);
return(lsalumno);
}
public static List <string> selectUser(int idUser)
{
string result = "";
storedProcedure sp = new storedProcedure("ConnectionString");
string query = "select a.usuario,a.contrasena,r.idrol,c.idCarrera,c.carrera,g.idgrupo,g.grupo,a.promedio from alumno as a inner join " +
" carrera as c on c.idCarrera = a.iCarrera inner join " +
" grupo as g on g.idgrupo = a.idGrupo inner join usuarioRol as ur" +
" on ur.idUsuario = a.idAlumno inner join rol as r on r.idRol = ur.idRol" +
" where idAlumno = " + idUser + "";
List <string> listaUser = sp.recuperaRegistros(query);
return(listaUser);
}
public static string cargarCombo()
{
string combo = "<select id='ss'>";
storedProcedure sp = new storedProcedure("ConnectionString");
string querycombo = "select distinct idTipoBeca, tipoBeca from tipoBeca";
List <string> lsbeca = sp.recuperaRegistros(querycombo);
for (int i = 0; i < lsbeca.Count; i = i = i + 2)
{
combo += "<option value='" + lsbeca[i + 0] + "'>" + lsbeca[i + 1] + "</option>";
}
combo += "</select>";
return(combo);
}
public static string consulBeca(int iduser)
{
storedProcedure sp = new storedProcedure("ConnectionString");
string tabla = "<table id='tablam'><thead><tr><th style='padding: 10px;'>Beca Solicitada</th><th style='padding: 10px;'>Eliminar</th></tr></thead><tbod>";
string querybe = "select ba.idBecasAlumnos,b.idBeca,b.nombreBeca from beca as b" +
" inner join becasAlumnos as ba " +
" on ba.idBeca = b.idBeca and ba.idAlumno = " + iduser + "";
List <string> lsbe = sp.recuperaRegistros(querybe);
for (int i = 0; i < lsbe.Count; i = i + 3)
{
tabla += "<tr><td style='padding: 10px;'>" + lsbe[i + 2] + "</td><td style='padding: 10px;'><label onclick='JavaScript:eliminarS(" + lsbe[i + 0] + ")'>X</label></td></tr>";
}
tabla += "</tbody></table>";
return(tabla);
}
