Ejemplo n.º 1
0
        private void LabelupdatingTimer_Tick(object sender, EventArgs e)
        {
            label7.Text = "Redirecting in (" + i + ")";
            i           = i - 1;

            if (i < 0)
            {
                LabelupdatingTimer.Stop();

                MessageBox.Show("Thank you for your booking, Have a nice day.");

                this.Hide();
                Checkininfo Checkininfo = new Checkininfo();
                Checkininfo.textBox1.Text = sixDigitNumber;

                Checkininfo.textBox2.Text = textBox5.Text;

                Checkininfo.textBox3.Text = RoomID.ToString();



                Checkininfo.textBox4.Text = textBox7.Text;
                Checkininfo.textBox5.Text = textBox6.Text;

                Checkininfo.Show();
            }
        }
Ejemplo n.º 2
0
        private void listBox1_MouseDoubleClick(object sender, MouseEventArgs e)
        {
            string first_string  = listBox1.SelectedItem.ToString();
            string second_string = string.Empty;
            string third_string  = listBox1.SelectedItem.ToString();
            string four_string   = string.Empty;


            DialogResult dialogResult = MessageBox.Show("Are you sure you want to book this room?", "Booking this Room", MessageBoxButtons.YesNo);

            if (dialogResult == DialogResult.Yes)
            {
                SqlConnection sqlcon = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename=" + "C:\\Users\\" + Environment.UserName + "\\Documents\\hoteldatabase.mdf" + ";Integrated Security=True;Connect Timeout=30");

                sqlcon.Open();


                SqlCommand cmd = new SqlCommand("Select * from Rooms where Hotel = '" + comboBox1.Text.Trim() + "' and RoomNumber = '" + Roomnum + "'");


                cmd.CommandType = System.Data.CommandType.Text;
                cmd.Connection  = sqlcon;

                SqlDataReader reader = cmd.ExecuteReader();

                reader.Read();

                ClientsInfo ClientsInfo = new ClientsInfo();
                Checkininfo Checkininfo = new Checkininfo();
                ClientsInfo.RoomID = Int32.Parse(reader[0].ToString());


                sqlcon.Close();

                ClientsInfo.textBox5.Text = monthCalendar2.SelectionStart.ToString("d/M/yyyy");
                ClientsInfo.textBox6.Text = comboBox1.Text;
                ClientsInfo.textBox7.Text = monthCalendar1.SelectionStart.ToString("d/M/yyyy");



                this.Hide();

                ClientsInfo.Show();
            }
            else if (dialogResult == DialogResult.No)
            {
            }
        }