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