private async void done_button_Click(object sender, EventArgs e) { using (var db = new Session3Entities()) { if (!(dgvlist[0].RoomsRequired > dgvlist[0].AvailableNoOfRooms)) { if (!(dgvlist[1].RoomsRequired > dgvlist[1].AvailableNoOfRooms)) { if (((dgvlist[1].RoomsRequired * 2) + dgvlist[0].RoomsRequired) >= Totalpeople) { try { Hotel_Booking hb = new Hotel_Booking() { bookingId = (from a in db.Hotel_Booking orderby a.bookingId descending select a.bookingId).First() + 1, hotelIdFK = hotelID, userIdFK = LoggedIn.userId, numDoubleRoomsRequired = dgvlist[1].RoomsRequired, numSingleRoomsRequired = dgvlist[0].RoomsRequired }; db.Hotel_Booking.Add(hb); await db.SaveChangesAsync(); } catch { Hotel_Booking hb = new Hotel_Booking() { bookingId = 1, hotelIdFK = hotelID, userIdFK = LoggedIn.userId, numDoubleRoomsRequired = dgvlist[1].RoomsRequired, numSingleRoomsRequired = dgvlist[0].RoomsRequired }; db.Hotel_Booking.Add(hb); await db.SaveChangesAsync(); } } else { MessageBox.Show("Not Enough Rooms for arrivals"); } } else { MessageBox.Show("Error, more rooms requested than available"); } } else { MessageBox.Show("Error, more rooms requested than available"); } } }
private async void create_account_box_Click(object sender, EventArgs e) { var regexItem = new Regex("^[a-zA-Z0-9 ]*$"); if (user_box.Text.Length >= 8) { using (var db = new Session3Entities()) { if (regexItem.IsMatch(user_box.Text)) { if (!(from a in db.Users select a.userId).ToList().Contains(user_box.Text)) { if (password_box.Text == password_again_box.Text) { User user = new User() { userId = user_box.Text, countryName = country_combo.Text, passwd = password_box.Text, userTypeIdFK = 2 }; db.Users.Add(user); await db.SaveChangesAsync(); button2_Click(null, null); } else { MessageBox.Show("Passwords do not match!!"); } } else { MessageBox.Show("userid already exists!!!"); } } else { MessageBox.Show("User ID cannot contain special characters"); } } } else { MessageBox.Show("UserID must have 8 or more characters!!"); } }