public List<Semester> GetAllSemesters()
{
try
{
List<Semester> semester = new List<Semester>();
connection.Open();
string semesterQuery = "select * from t_Semester";
command.CommandText = semesterQuery;
SqlDataReader semesterReader = command.ExecuteReader();
while (semesterReader.Read())
{
Semester aSemester = new Semester();
aSemester.SemesterId = Convert.ToInt16(semesterReader[0].ToString());
aSemester.SemesterName = semesterReader[1].ToString();
semester.Add(aSemester);
}
return semester;
}
finally
{
connection.Close();
}
}
public Semester GetSemester(int id)
{
List<Semester>semesters=new List<Semester>();
semesters = GetAllSemesters();
Semester aSemester = new Semester();
foreach (Semester semester in semesters)
{
if(semester.SemesterId==id)
{
aSemester.SemesterId = semester.SemesterId;
aSemester.SemesterName = semester.SemesterName;
return aSemester;
}
}
return aSemester;
}
