Example #1
0
        public UtilityUI(int pYear, int pMonth)
        {
            InitializeComponent();
            this.Year  = pYear;
            this.Month = pMonth;


            RoomsTableAdapter roomsTableAdapter = new RoomsTableAdapter();

            ApartmentDataSet.RoomsDataTable roomIDs = roomsTableAdapter.CheckRoomForUtilities(new DateTime(Year, Month, 1));

            Console.WriteLine(roomIDs.Count);
            foreach (ApartmentDataSet.RoomsRow row in roomIDs)
            {
                int y = utilitiesTableAdapter.Insert(row.RoomID, row.No, 0, 0, new DateTime(Year, Month, 1), null);
                Console.WriteLine(y);
            }
        }