using System;

public class Program

{

        private void Booking_Load(object sender, System.EventArgs e)

        {

            LoadControlsRoom();

            DisplayDefaultRoom();

        }

​

        // Load dataset to datagridviewroom

        public void LoadDataRoom(String query)

        {

            using (MySqlConnection conn = new MySqlConnection(DBConn.ConnectionString))

            {

                try

                {

                    // Connect to database

                    conn.Open();

                    using (MySqlDataAdapter bookingRoomTableAdapter = new MySqlDataAdapter(query, conn))

                    {

                        // Populate a new data set to datagridview

                        DataSet bookingRoomDS = new DataSet();

                        bookingRoomTableAdapter.Fill(bookingRoomDS, "room_reservation");

                        dataGridViewRoom.DataSource = bookingRoomDS;

                        dataGridViewRoom.DataMember = "room_reservation";

                        // Hide ID and make readable table headers

                        dataGridViewRoom.Columns[0].Visible = false;

                        dataGridViewRoom.Columns[1].HeaderText = "Fornavn";

                        dataGridViewRoom.Columns[2].HeaderText = "Etternavn";

                        dataGridViewRoom.Columns[3].HeaderText = "Rom";

                        dataGridViewRoom.Columns[3].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;

                        dataGridViewRoom.Columns[4].HeaderText = "Innsjekket";

                        dataGridViewRoom.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;

                        dataGridViewRoom.Columns[5].HeaderText = "Romtype";

                        dataGridViewRoom.Columns[6].HeaderText = "Ankomst";

                        dataGridViewRoom.Columns[6].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;

                        dataGridViewRoom.Columns[7].HeaderText = "Avreise";

                        dataGridViewRoom.Columns[7].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;

                        dataGridViewRoom.Columns[8].HeaderText = "Merknad";

                    }

                }

                // Catch exceptions and display in labelStatus

                catch (Exception ex) { this.labelStatus.Text = ex.Message; }

                // Make sure connection is closed

                finally

                {

                    if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); }

                }

            }

        }

        // Default room display (monthly)

        public void DisplayDefaultRoom()

        {

            // Find this weeks start date and convert to readable format for MySQL

            DateTime today = DateTime.Today;

            DateTime startofmonth = new DateTime(today.Year, today.Month, 1);

            DateTime endofmonth = startofmonth.AddMonths(1).AddDays(-1);

            string startdate = startofmonth.ToString("yyyy-MM-dd");

            string enddate = endofmonth.ToString("yyyy-MM-dd");

            query = "SELECT * FROM room_reservation_active " +

                    "WHERE (datefrom BETWEEN '" + startdate + "' AND '" + enddate + "' " +

                    "OR dateto BETWEEN '" + startdate + "' AND '" + enddate + "')";

            LoadDataRoom(query);

        }

}