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