public List <TurmaGrid> ToList()
{
List <TurmaGrid> LstTurmas = new List <TurmaGrid>();
using (SQLServer DBContext = new SQLServer())
{
System.Data.SqlClient.SqlDataReader Reader = DBContext.CommandReader(_SQLList);
while (Reader.Read())
{
LstTurmas.Add(new TurmaGrid()
{
Id_Turma = int.Parse(Reader["Id_Turma"].ToString()),
Tx_Curso = Reader["Tx_Curso"].ToString(),
Tx_Professor = Reader["Tx_Professor"].ToString(),
Dt_Inicio = DateTime.Parse(Reader["Dt_Inicio"].ToString()),
Dt_Termino = DateTime.Parse(Reader["Dt_Termino"].ToString()),
St_Concluido = bool.Parse(Reader["St_Concluido"].ToString())
});
}
if (LstTurmas.Count > 0)
{
var LstAulas = new Aula().ToList();
foreach (var item in LstTurmas)
{
var Aulas = LstAulas.Where(x => x.Id_Turma == item.Id_Turma).ToList();
var Avaliacoes = Aulas.Where(x => x.St_Avaliacao).ToList();
item.Tx_Aulas = $"{(Aulas.Where(x=>x.St_Concluida).Count())}/{Aulas.Count}";
item.Tx_Avaliacoes = $"{(Avaliacoes.Where(x => x.St_Concluida).Count())}/{Avaliacoes.Count}";
}
}
}
return(LstTurmas);
}
public List <AulaPresenca> ToList(string TxWhere = "")
{
List <AulaPresenca> LstAulaPresenca = new List <AulaPresenca>();
using (var DBContext = new SQLServer())
{
SqlDataReader Reader = DBContext.CommandReader(_SQLList + TxWhere);
while (Reader.Read())
{
LstAulaPresenca.Add(ReaderToObject(ref Reader));
}
}
return(LstAulaPresenca);
}
internal int GetLastId()
{
int LastId = 0;
using (var DBContext = new SQLServer())
{
var Reader = DBContext.CommandReader("SELECT COALESCE(MAX(Id_Turma), 0) as Id_Turma FROM Turma");
while (Reader.Read())
{
int.TryParse(Reader[0].ToString(), out LastId);
}
}
return(LastId);
}
public List <Professor> ToList(string TxWhere = "")
{
List <Professor> LstProfessor = new List <Professor>();
using (var DBContext = new SQLServer())
{
SqlDataReader Reader = DBContext.CommandReader(_SQLList + TxWhere);
while (Reader.Read())
{
LstProfessor.Add(ReaderToObject(ref Reader));
}
}
return(LstProfessor);
}
public List <Usuario> ToList(string TxWhere = "")
{
List <Usuario> LstUsuario = new List <Usuario>();
using (var DBContext = new SQLServer())
{
SqlDataReader Reader = DBContext.CommandReader(_SQLList + TxWhere);
while (Reader.Read())
{
LstUsuario.Add(ReaderToObject(ref Reader));
}
}
return(LstUsuario);
}
