public AlunoController(AlunoDAO alunoDAO, IHostingEnvironment hosting, AulaDAO aulaDAO, ExercicioDAO exercicioDAO, TreinoDAO treinoDAO, AvisosDAO avisosDAO)
{
_alunoDAO = alunoDAO;
_hosting = hosting;
_aulaDAO = aulaDAO;
_exercicioDAO = exercicioDAO;
_treinoDAO = treinoDAO;
_avisosDAO = avisosDAO;
}
public List <Aula> getAulasUser(string email)
{
List <Aula> a = new ArrayList <Aula>();
AulaDAO ad = new AulaDAO();
var dbCon = db.Instance();
dbCon.DataBaseName = "sportsmanager";
if (dbCon.IsConnect())
{
var cmd = new MySqlCommand();
cmd.Connection = dbCon.Connection;
cmd.CommandText = "SELECT cod_aula FROM FREQUENTA WHERE email = @em";
cmd.Connection.Open();
cmd.Prepare();
cmd.Parameters.AddWithValue("@em", email);
cmd.ExecuteNonQuery();
var reader = cmd.ExecuteReader();
while (reader.read())
{
Aula tmp = ad.get(reader.GetInt32(0));
a.add(tmp);
}
dbCon.Close();
}
return(a);
}
public AulaController(AulaDAO aulaDAO, ProfessorDAO professorDAO)
{
_aulaDAO = aulaDAO;
_professorDAO = professorDAO;
}
public AulaController(AulaDAO aulaDAO)
{
_aulaDAO = aulaDAO;
}
public AulaBUS(AulaDAO IDAO)
{
_IDAO = IDAO;
}
public Aula()
{
this.listSalitas = AulaDAO.SelectAll();
}
public AulaController()
{
DAO = new AulaDAO();
SugereProximoId = true;
}