Exemplo n.º 1
0
        public static Classroom getProperClassroom(int size, int time)
        {
            SqlConnection con = new SqlConnection();

            con.ConnectionString = "server=ELAINEC-HP\\SQLEXPRESS;database=Schedule;Trusted_Connection=SSPI";
            con.Open();
            String sql = "select top 1 * " +
                         "from classroom" +
                         "where classroomSize>" + size.ToString() + "AND substring(occupied," + time.ToString() + ",1)=0" +
                         "order by classroomSize ASC";
            SqlDataAdapter adapter = new SqlDataAdapter(sql, con);
            DataTable      table   = new DataTable();

            adapter.Fill(table);
            con.Close();
            Classroom classroom = new Classroom(Convert.ToInt32(table.Rows[0]["classroomId"]),
                                                table.Rows[0]["classroomName"].ToString(),
                                                table.Rows[0]["classroomType"].ToString(),
                                                Convert.ToInt32(table.Rows[0]["classroomSize"]));

            return(classroom);
        }
Exemplo n.º 2
0
        public static Classroom getClassroomById(int id)
        {
            Classroom result = new Classroom();

            return(result);
        }