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