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