public int altaAlumno(Business.Entities.Alumno al) { string nombre = al.Nombre; string apellido = al.Apellido; string dni = al.Dni; string legajo = al.Legajo; string telefono = al.Telefono; string mail = al.Email; int tipo = (int)al.TipoUsuario; try { Conexion.getInstance().Connect(); SqlCommand cmd = new SqlCommand("insert into dbo.Persona(nombre,apellido,legajo,dni,telefono,mail)" + " values('" + nombre + "','" + apellido + "','" + legajo + "','" + dni + "','" + telefono + "','" + mail + "'); select SCOPE_IDENTITY()", Conexion.getInstance().Conection); int idPersona = Convert.ToInt32(cmd.ExecuteScalar()); Conexion.getInstance().Disconnect(); return(idPersona); } catch (Exception e) { Conexion.getInstance().Disconnect(); return(-1); } }
public Business.Entities.Alumno buscarAlumnoPorId(int id) { try { int idper = id; Conexion.getInstance().Connect(); Business.Entities.Alumno al; SqlCommand cmd = new SqlCommand("select * from dbo.Persona where idPersona='" + idper + "'", Conexion.getInstance().Conection); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string nombre = reader.GetString(0); string apellido = reader.GetString(1); string legajo = reader.GetString(2); string dni = reader.GetString(3); string telefono = reader.GetString(4); string mail = reader.GetString(5); int idp = (int)reader.GetValue(6); al = new Business.Entities.Alumno(nombre, apellido, legajo, dni, mail, telefono); al.IDPersona = idp; Conexion.getInstance().Disconnect(); return(al); } catch (Exception e) { Conexion.getInstance().Disconnect(); return(null); } }
public Business.Entities.Alumno buscarAlumno(string legajo) { try { Conexion.getInstance().Connect(); Business.Entities.Alumno al; SqlCommand cmd = new SqlCommand("select * from dbo.Persona where CONVERT(VARCHAR,legajo)='" + legajo + "'", Conexion.getInstance().Conection); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); String nombre = reader.GetString(0); String apellido = reader.GetString(1); String dni = reader.GetString(3); String telefono = reader.GetString(4); String mail = reader.GetString(5); al = new Business.Entities.Alumno(nombre, apellido, legajo, dni, mail, telefono); Conexion.getInstance().Disconnect(); return(al); } catch (Exception e) { Conexion.getInstance().Disconnect(); return(null); } }
public Business.Entities.Alumno buscarAlumno(string legajo) { try { Conexion.getInstance().Connect(); Business.Entities.Alumno al; SqlCommand cmd = new SqlCommand("select * from dbo.Persona pe inner join dbo.Usuario us on pe.idPersona=us.idPersona where CONVERT(VARCHAR,legajo)='" + legajo + "'", Conexion.getInstance().Conection); SqlDataReader reader = cmd.ExecuteReader(); reader.Read(); string nombre = reader.GetString(0); string apellido = reader.GetString(1); string dni = reader.GetString(3); string telefono = reader.GetString(4); string mail = reader.GetString(5); int id = (int)reader.GetValue(6); string usu = reader.GetString(7); string cont = reader.GetString(8); al = new Business.Entities.Alumno(nombre, apellido, legajo, dni, mail, telefono); al.NombreUsuario = usu; al.Contraseña = cont; al.IDPersona = id; Conexion.getInstance().Disconnect(); return(al); } catch (Exception e) { Conexion.getInstance().Disconnect(); return(null); } }
public static int altaAlumno(Business.Entities.Alumno al) { Business.Entities.Alumno alu = buscarAlumno(al.Legajo); if (alu == null) { return(Data.Database.AlumnoDB.getInstance().altaAlumno(al)); } return(-1); }
public static bool modi(Alumno alu) { int idP = ABMUsuario.buscarIdpersonaPorUsuario(alu.NombreUsuario); if (idP == 0 || idP == alu.IDPersona) { Business.Entities.Alumno al = buscarAlumno(alu.Legajo); if (al == null || al.IDPersona == alu.IDPersona) { return(Data.Database.AlumnoDB.getInstance().modi(alu)); } } return(false); }
public List <Business.Entities.Alumno> listarAlumnosPorLegajo(string lega) { try { Conexion.getInstance().Connect(); List <Business.Entities.Alumno> alumnos = new List <Business.Entities.Alumno>(); string legajo = "%" + lega + "%"; SqlCommand cmd = new SqlCommand("select * from dbo.Persona pe inner join dbo.Usuario us on pe.idPersona=us.idPersona where tipoUsuario=1 AND CONVERT(VARCHAR,legajo) like '" + legajo + "'", Conexion.getInstance().Conection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { String nombre = reader.GetString(0); String apellido = reader.GetString(1); String legaj = reader.GetString(2); String dni = reader.GetString(3); String telefono = reader.GetString(4); String mail = reader.GetString(5); int id = (int)reader.GetValue(6); String usu = reader.GetString(7); String cont = reader.GetString(8); Business.Entities.Alumno al = new Business.Entities.Alumno(nombre, apellido, legaj, dni, mail, telefono); al.NombreUsuario = usu; al.Contraseña = cont; al.IDPersona = id; alumnos.Add(al); } Conexion.getInstance().Disconnect(); return(alumnos); } catch (Exception e) { Conexion.getInstance().Disconnect(); return(null); } }
public static int altaAlumno(Business.Entities.Alumno al) { return(Data.Database.AlumnoDB.getInstance().altaAlumno(al)); }