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) { } }
private void button1_Click(object sender, EventArgs e) { listBox1.Items.Clear(); updatingrooms(); groupBox1.Visible = true; ClientsInfo ClientsInfo = new ClientsInfo(); ClientsInfo.Checkin = monthCalendar1.SelectionStart.ToString("M/d/yyyy"); date1 = monthCalendar1.SelectionStart.ToString("M/d/yyyy"); date2 = monthCalendar2.SelectionStart.ToString("M/d/yyyy"); ClientsInfo.Checkout = monthCalendar2.SelectionStart.ToString("M/d/yyyy"); try { foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value.ToString().Trim().Equals(comboBox1.Text.Trim()) && row.Cells[3].Value.ToString().Trim().Equals("1") && row.Cells[6].Value.ToString().Trim().Equals(comboBox2.Text.Trim()) && row.Cells[7].Value.ToString().Trim().Equals(numericUpDown1.Text.Trim()) && row.Cells[8].Value.ToString().Trim().Equals(numericUpDown2.Text.Trim())) { Roomnum = row.Cells[2].Value; listBox1.Items.Add("Room Number: " + row.Cells[2].Value.ToString() + " *Price per night " + row.Cells[9].Value.ToString() + "€"); } } } catch { if (listBox1.Items.Count > 0) { label7.Visible = true; checkavailability(); } else { label7.Visible = false; MessageBox.Show("No room Found"); } } }