private void HotelBooking_Load(object sender, EventArgs e) { lblHotelName.Text = _hotel; using (var context = new Session3Entities()) { var getArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); lblCompetitors.Text = getArrival.numberCompetitors.ToString(); lblDelegates.Text = getArrival.numberDelegate.ToString(); LoadDGV(); } }
private void LoadDGV() { dataGridView1.Rows.Clear(); using (var context = new Session3Entities()) { var getArrivalDate = (from x in context.Arrivals where x.userIdFK == _user.userId select x.arrivalDate).FirstOrDefault(); _arrivalDate = getArrivalDate; var getHotelDetails = (from x in context.Hotels where x.hotelName == _hotel select x).FirstOrDefault(); var checkCompetitorRemainder = Int32.Parse(lblCompetitors.Text) % 2; if (checkCompetitorRemainder == 1) { var singleRow = new List <string>() { "Single", getHotelDetails.singleRate.ToString(), (getHotelDetails.numSingleRoomsTotal - getHotelDetails.numSingleRoomsBooked).ToString(), (Int32.Parse(lblDelegates.Text) + 1).ToString(), ((Int32.Parse(lblDelegates.Text) + 1) * (DateTime.Parse("30/07/2020") - getArrivalDate).Days * getHotelDetails.singleRate).ToString() }; var doubleRow = new List <string>() { "Double", getHotelDetails.doubleRate.ToString(), (getHotelDetails.numDoubleRoomsTotal - getHotelDetails.numDoubleRoomsBooked).ToString(), (Int32.Parse(lblCompetitors.Text) / 2).ToString(), ((Int32.Parse(lblCompetitors.Text) / 2) * (DateTime.Parse("30/07/2020") - getArrivalDate).Days * getHotelDetails.doubleRate).ToString() }; dataGridView1.Rows.Add(singleRow.ToArray()); dataGridView1.Rows.Add(doubleRow.ToArray()); } else { var singleRow = new List <string>() { "Single", getHotelDetails.singleRate.ToString(), (getHotelDetails.numSingleRoomsTotal - getHotelDetails.numSingleRoomsBooked).ToString(), (Int32.Parse(lblDelegates.Text)).ToString(), ((Int32.Parse(lblDelegates.Text)) * (DateTime.Parse("30/07/2020") - getArrivalDate).Days * getHotelDetails.singleRate).ToString() }; var doubleRow = new List <string>() { "Double", getHotelDetails.doubleRate.ToString(), (getHotelDetails.numDoubleRoomsTotal - getHotelDetails.numDoubleRoomsBooked).ToString(), (Int32.Parse(lblCompetitors.Text) / 2).ToString(), ((Int32.Parse(lblCompetitors.Text) / 2) * (DateTime.Parse("30/07/2020") - getArrivalDate).Days * getHotelDetails.doubleRate).ToString() }; dataGridView1.Rows.Add(singleRow.ToArray()); dataGridView1.Rows.Add(doubleRow.ToArray()); } } }
private void btnCreate_Click(object sender, EventArgs e) { if (cbCountries.SelectedItem == null || string.IsNullOrWhiteSpace(txtUserID.Text) || string.IsNullOrWhiteSpace(txtPassword.Text) || string.IsNullOrWhiteSpace(txtRePassword.Text)) { MessageBox.Show("Please ensure the field(s) are not empty!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (txtRePassword.Text != txtRePassword.Text) { MessageBox.Show("Passwords do not match!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (txtUserID.Text.Length < 8) { MessageBox.Show("User ID must be at least 8 characters long!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (!Regex.IsMatch(txtUserID.Text, "[a-zA-Z]+[0-9]+")) { MessageBox.Show("User ID must contain 1 upper and lower case with at least 1 numeric!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { using (var context = new Session3Entities()) { var checkID = (from x in context.Users where x.userId == txtUserID.Text select x).FirstOrDefault(); if (checkID != null) { MessageBox.Show("User ID is not available! Please use another User ID", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var newUser = new User() { userId = txtUserID.Text, countryName = cbCountries.SelectedItem.ToString(), passwd = txtRePassword.Text, userTypeIdFK = 2 }; context.Users.Add(newUser); context.SaveChanges(); MessageBox.Show("Account created successfully!", "Create Account", MessageBoxButtons.OK, MessageBoxIcon.Information); Hide(); (new Login()).ShowDialog(); Close(); } } } }
private void btnLogin_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtUserID.Text) || string.IsNullOrWhiteSpace(txtPassword.Text)) { MessageBox.Show("Please ensure the field(s) are not empty!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { using (var context = new Session3Entities()) { var getUser = (from x in context.Users where x.userId == txtUserID.Text select x).FirstOrDefault(); if (getUser == null) { MessageBox.Show("User does not exist!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { if (getUser.passwd != txtPassword.Text) { MessageBox.Show("Password is incorrect!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show($"Welcome {getUser.countryName}!", "Login", MessageBoxButtons.OK, MessageBoxIcon.Information); if (getUser.userTypeIdFK == 1) { this.Hide(); (new AdminMain()).ShowDialog(); this.Close(); } else { Hide(); (new CountryMain(getUser)).ShowDialog(); Close(); } } } } } }
private void LoadCB() { using (var context = new Session3Entities()) { var countries = new List <string>() { "Brunei", "Cambodia", "Indonesia", "Laos", "Malaysia", "Myanmar", "Philippines", "Singapore", "Thailand", "Vietnam" }; var getRegistered = (from x in context.Users where x.userTypeIdFK == 2 select x.countryName).ToList(); foreach (var item in getRegistered) { countries.Remove(item); } cbCountries.Items.AddRange(countries.ToArray()); } }
private void btnBook_Click(object sender, EventArgs e) { using (var context = new Session3Entities()) { var getHotelID = (from x in context.Hotels where x.hotelName == _hotel select x.hotelId).FirstOrDefault(); var newBooking = new Hotel_Booking() { userIdFK = _user.userId, hotelIdFK = getHotelID, numDoubleRoomsRequired = Convert.ToInt32(dataGridView1.Rows[1].Cells[3].Value), numSingleRoomsRequired = Convert.ToInt32(dataGridView1.Rows[0].Cells[3].Value) }; context.Hotel_Booking.Add(newBooking); context.SaveChanges(); MessageBox.Show("Booking successful!"); Close(); } }
private void btnConfirm_Click(object sender, EventArgs e) { using (var context = new Session3Entities()) { if (rbtn22July.Checked) { if (dataGridView1.CurrentCell.Style.BackColor == Color.Black) { MessageBox.Show("Timing is not available for selected date!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var getTiming = dataGridView1.CurrentCell.Value.ToString(); var getArrivalDetails = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); if (getArrivalDetails == null) { var newArrival = new Arrival() { arrivalDate = DateTime.Parse("22/07/2020"), arrivalTime = getTiming, number19seat = Int32.Parse(lbl19Seater.Text), number42seat = Int32.Parse(lbl42Seater.Text), numberCars = Int32.Parse(lblCar.Text), userIdFK = _user.userId, numberHead = Convert.ToInt32(nudHead.Value), numberDelegate = Convert.ToInt32(nudDelegates.Value), numberCompetitors = Convert.ToInt32(nudCompetitors.Value) }; context.Arrivals.Add(newArrival); context.SaveChanges(); MessageBox.Show("Arrival confirmed!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Information); Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } else { getArrivalDetails.arrivalDate = DateTime.Parse("22/07/2020"); getArrivalDetails.arrivalTime = getTiming; getArrivalDetails.number19seat = Int32.Parse(lbl19Seater.Text); getArrivalDetails.number42seat = Int32.Parse(lbl42Seater.Text); getArrivalDetails.numberCars = Int32.Parse(lblCar.Text); getArrivalDetails.numberHead = Convert.ToInt32(nudHead.Value); getArrivalDetails.numberDelegate = Convert.ToInt32(nudDelegates.Value); getArrivalDetails.numberCompetitors = Convert.ToInt32(nudCompetitors.Value); context.SaveChanges(); MessageBox.Show("Arrival updated!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Information); Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } } } else if (rbtn23July.Checked) { if (dataGridView1.CurrentCell.Style.BackColor == Color.Black) { MessageBox.Show("Timing is not available for selected date!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { var getTiming = dataGridView1.CurrentCell.Value.ToString(); var getArrivalDetails = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); if (getArrivalDetails == null) { var newArrival = new Arrival() { arrivalDate = DateTime.Parse("23/07/2020"), arrivalTime = getTiming, number19seat = Int32.Parse(lbl19Seater.Text), number42seat = Int32.Parse(lbl42Seater.Text), numberCars = Int32.Parse(lblCar.Text), userIdFK = _user.userId, numberHead = Convert.ToInt32(nudHead.Value), numberDelegate = Convert.ToInt32(nudDelegates.Value), numberCompetitors = Convert.ToInt32(nudCompetitors.Value) }; context.Arrivals.Add(newArrival); context.SaveChanges(); MessageBox.Show("Arrival confirmed!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Information); Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } else { getArrivalDetails.arrivalDate = DateTime.Parse("23/07/2020"); getArrivalDetails.arrivalTime = getTiming; getArrivalDetails.number19seat = Int32.Parse(lbl19Seater.Text); getArrivalDetails.number42seat = Int32.Parse(lbl42Seater.Text); getArrivalDetails.numberCars = Int32.Parse(lblCar.Text); getArrivalDetails.numberHead = Convert.ToInt32(nudHead.Value); getArrivalDetails.numberDelegate = Convert.ToInt32(nudDelegates.Value); getArrivalDetails.numberCompetitors = Convert.ToInt32(nudCompetitors.Value); context.SaveChanges(); MessageBox.Show("Arrival updated!", "Confirm", MessageBoxButtons.OK, MessageBoxIcon.Information); Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } } } } }