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