public ModelStudenti getStudentDetails(int idUtilizator) { UserRepository up = new UserRepository(); ModelStudenti user = null; user = up.getStudentDetails(idUtilizator); return(user); }
public List <ModelStudenti> getProfileMembers(int idSpecializare) { SqlConnection conn = db.initializare(); SqlCommand cmd; List <ModelStudenti> listaMembrii = new List <ModelStudenti>(); ModelStudenti membrii = null; try { cmd = new SqlCommand(Query.incarcaMembriiSpecializari, conn); cmd.Parameters.Add(new SqlParameter("idSpecializare", idSpecializare)); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int id = Int32.Parse(reader["id"].ToString()); idSpecializare = Int32.Parse(reader["id_specializare"].ToString()); int idUtilizator = Int32.Parse(reader["id_utilizator"].ToString()); int nrCredite = Int32.Parse(reader["nr_credite"].ToString()); int anStudiu = Int32.Parse(reader["an_studiu"].ToString()); string nume = reader["nume"].ToString(); string prenume = reader["prenume"].ToString(); string numeSpecializare = reader["nume_specializare"].ToString(); membrii = new ModelStudenti(id, idUtilizator, idSpecializare, nrCredite, anStudiu, nume, prenume, numeSpecializare); listaMembrii.Add(membrii); } } else { } } catch (Exception ex) { throw ex; } finally { conn.Dispose(); conn.Close(); } return(listaMembrii); }
public ModelStudenti getStudentDetails(int idUtilizator) { SqlConnection conn = db.initializare(); ModelStudenti user = null; try { cmd = new SqlCommand(Query.getStudentInformation, conn); cmd.Parameters.Add(new SqlParameter("idUtilizator", idUtilizator)); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { idUtilizator = Int32.Parse(reader["id_utilizator"].ToString()); int idSpecializare = Int32.Parse(reader["id_specializare"].ToString()); int anStudiu = Int32.Parse(reader["an_studiu"].ToString()); int numarCredite = Int32.Parse(reader["nr_credite"].ToString()); string numeSpecializare = reader["nume_specializare"].ToString(); user = new ModelStudenti(idUtilizator, numarCredite, anStudiu, numeSpecializare, idSpecializare); } } else { } } catch (Exception ex) { throw ex; } finally { conn.Dispose(); conn.Close(); } return(user); }
public List <ModelStudenti> loadAllStudentsEnroledAtCourseByIdOfCourseAndIdOfType(int idSpecializare, int idMaterie) { SqlConnection conn = db.initializare(); ModelStudenti user = null; List <ModelStudenti> studentList = new List <ModelStudenti>(); try { cmd = new SqlCommand(Query.a, conn); cmd.Parameters.Add(new SqlParameter("idSpecializare", idSpecializare)); cmd.Parameters.Add(new SqlParameter("idMaterie", idMaterie)); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int idUtilizator = Int32.Parse(reader["id_utilizator"].ToString()); string nume = reader["nume"].ToString(); string prenume = reader["prenume"].ToString(); int anStudiu = Int32.Parse(reader["an_studiu"].ToString()); user = new ModelStudenti(idUtilizator, nume, prenume, anStudiu); studentList.Add(user); } } } catch (Exception ex) { throw ex; } finally { conn.Dispose(); conn.Close(); } return(studentList); }
public List <ModelStudenti> getListOfStudentClassById(int idSpecializare, int anStudiu) { SqlConnection conn = db.initializare(); SqlCommand cmd; List <ModelStudenti> colegi = new List <ModelStudenti>(); ModelStudenti coleg = null; try { cmd = new SqlCommand(Query.getListOfStudentClassById, conn); cmd.Parameters.Add(new SqlParameter("idSpecializare", idSpecializare)); cmd.Parameters.Add(new SqlParameter("anStudiu", anStudiu)); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { int idUtilizator = Int32.Parse(reader["id_utilizator"].ToString()); string nume = reader["nume"].ToString(); string prenume = reader["prenume"].ToString(); coleg = new ModelStudenti(idUtilizator, nume, prenume); colegi.Add(coleg); } } } catch (Exception ex) { throw ex; } finally { conn.Dispose(); conn.Close(); } return(colegi); }