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!!");
}
}