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