public IEnumerable<StudentModel> GetAllStudents() { List<StudentModel> students = new List<StudentModel>(); sqlConnection1.Open(); var reader = GetDatabaseResults("SELECT * FROM STUDENTS"); if(reader.HasRows) { while(reader.Read()) { var First_Name = reader.GetString(0); var Last_Name = reader.GetString(1); var User = reader.GetString(3); var Password = reader.GetString(4); var student = new StudentModel { First_Name = First_Name, Last_Name = Last_Name, User = User, Password = Password }; students.Add(student); } } sqlConnection1.Close(); return students; }
public StudentModel GetStudentUser(string username) { var queryString = string.Format("SELECT First_Name, Last_Name, Student_ID, username, password FROM Students WHERE username = '******'", username); var student = new StudentModel(); sqlConnection1.Open(); var reader = GetDatabaseResults(queryString); if (reader.HasRows) { while (reader.Read()) { var First_Name = reader.GetString(0); var Last_Name = reader.GetString(1); var Student_ID = reader.GetInt32(2); var User = reader.GetString(3); var Password = reader.GetString(4); student = new StudentModel { First_Name = First_Name, Last_Name = Last_Name, Student_ID = Student_ID, User = User, Password = Password }; } } sqlConnection1.Close(); return student; }