static void Main(string[] args)
{
Student student_1 = new Student("Pesho", 20, 5.5);
Student student_2 = new Student("Mimi", 18, 4.5);
ClassRoom myClass = new ClassRoom();
myClass.Create(student_1);
myClass.Create(student_2);
myClass.Show("Mimi");
myClass.Show("Pesho");
myClass.Show("Peter");
Console.ReadLine();
Console.ReadKey();
}
public List <ClassRoom> GetClassByTeacher(int teacherID)
{
List <ClassRoom> cRoom = new List <ClassRoom>();
SqlConnection aConnection = DBMgr.GetSQLConnection();
try
{
aConnection.Open();
SqlCommand myCmnd = aConnection.CreateCommand();
ClassRoom c = new ClassRoom();
myCmnd.CommandText = @"select * from Class inner join Class_Teacher On Class.ID = Class_Teacher.ClassID where TeacherID=" + teacherID.ToString();
SqlDataReader aReader = myCmnd.ExecuteReader();
while (aReader.Read())
{
c.ID = Int32.Parse(aReader["ID"].ToString());
c.Name = aReader["Name"].ToString();
c.Number = Int32.Parse(aReader["Number"].ToString());
cRoom.Add(c);
}
aReader.Close();
}
catch (SqlException se)
{
aConnection.Close();
throw (se);
}
aConnection.Close();
return(cRoom);
}
public List <ClassRoom> GetClasses()
{
List <ClassRoom> classRooms = new List <ClassRoom>();
SqlConnection aConnection = DBMgr.GetSQLConnection();
try
{
aConnection.Open();
SqlCommand myCmnd = aConnection.CreateCommand();
myCmnd.CommandText = @"Select ID, Name, Number, Name + '-' + cast (Number as nvarchar) as Description from Class";
SqlDataReader aReader = myCmnd.ExecuteReader();
while (aReader.Read())
{
ClassRoom cRooms = new ClassRoom();
cRooms.ID = Int32.Parse(aReader["ID"].ToString());
cRooms.Name = aReader["Name"].ToString();
cRooms.Desc = aReader["Description"].ToString();
cRooms.Number = Int32.Parse(aReader["Number"].ToString());
classRooms.Add(cRooms);
}
aReader.Close();
}
catch (SqlException se)
{
aConnection.Close();
throw (se);
}
aConnection.Close();
return(classRooms);
}
