public List <GradeLetterModel> GetAllGrades()
{
string query = "SELECT *from GradeTable where id!=10 order by id";
_command = new SqlCommand(query, _connection);
_connection.Open();
_sqlDataReader = _command.ExecuteReader();
List <GradeLetterModel> listOfItems = new List <GradeLetterModel>();
while (_sqlDataReader.Read())
{
GradeLetterModel item = new GradeLetterModel();
item.Id = Convert.ToInt32(_sqlDataReader["id"]);
item.GradeLetter = _sqlDataReader["Grade"].ToString();
listOfItems.Add(item);
}
_connection.Close();
return(listOfItems);
}
//-----------------------------------------------------------
public List <GradeLetterModel> GradeLetter()
{
query = "SELECT * FROM GradeLetterTable";
Command = new SqlCommand(query, Connection);
List <GradeLetterModel> gradeLetterList = new List <GradeLetterModel>();
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
GradeLetterModel gradeLetter = new GradeLetterModel();
gradeLetter.Id = Convert.ToInt32(Reader["Id"]);
gradeLetter.GradeLetter = Reader["GradeLetter"].ToString();
gradeLetterList.Add(gradeLetter);
}
Connection.Close();
return(gradeLetterList);
}
