private void btnUpdate_Click(object sender, EventArgs e) { using (var context = new Session3Entities()) { var findArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); if (findArrival == null) { MessageBox.Show("Please confirm arrival and hotel booking first!"); } else { var findBooking = (from x in context.Hotel_Booking where x.userIdFK == _user.userId select x).FirstOrDefault(); if (findBooking != null) { Hide(); (new UpdateInfo(_user)).ShowDialog(); Close(); } else { MessageBox.Show("Please book a hotel first!"); } } } }
private void btnHotel_Click(object sender, EventArgs e) { using (var context = new Session3Entities()) { var findArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); if (findArrival == null) { MessageBox.Show("Please confirm arrival first before booking!"); } else { var findBooking = (from x in context.Hotel_Booking where x.userIdFK == _user.userId select x).FirstOrDefault(); if (findBooking == null) { Hide(); (new HotelSelection(_user)).ShowDialog(); Close(); } else { MessageBox.Show("Booking for hotel was completed!"); } } } }
private void btnCreate_Click(object sender, EventArgs e) { if (cbCountry.SelectedItem == null || string.IsNullOrWhiteSpace(txtUserID.Text) || string.IsNullOrWhiteSpace(txtPassword.Text) || string.IsNullOrWhiteSpace(txtRePassword.Text)) { MessageBox.Show("Please ensure all fields are filled!"); } else if (txtPassword.Text != txtRePassword.Text) { MessageBox.Show("Passwords do not match!"); } else if (txtUserID.TextLength < 8) { MessageBox.Show("Ensure there are at least 8 characters for User ID!"); } else if (!Regex.IsMatch(txtUserID.Text, "^[a-zA-Z0-9]+$")) { MessageBox.Show("Ensure only letters and numeric characters in User ID!"); } else { using (var context = new Session3Entities()) { var findUser = (from x in context.Users where x.userId == txtUserID.Text select x).FirstOrDefault(); if (findUser != null) { MessageBox.Show("User ID used!"); } else { var newUser = new User() { countryName = cbCountry.SelectedItem.ToString(), userId = txtUserID.Text, userTypeIdFK = 2, passwd = txtPassword.Text }; context.Users.Add(newUser); context.SaveChanges(); MessageBox.Show("Successfully added user!"); Hide(); (new LoginForm()).ShowDialog(); Close(); } } } }
private void btnBook_Click(object sender, EventArgs e) { var getTotalCap = int.Parse(lblDelegates.Text) + int.Parse(lblCompetitors.Text); var bookedCap = originalSingle + (originalDouble * 2); if (bookedCap < getTotalCap) { MessageBox.Show("Please ensure number of rooms booked are enough for all visitors!"); } else { var boolCheck = true; foreach (DataGridViewRow item in dataGridView1.Rows) { if (Convert.ToInt32(dataGridView1[2, item.Index].Value) < Convert.ToInt32(dataGridView1[3, item.Index].Value)) { boolCheck = false; } } if (boolCheck == false) { MessageBox.Show("Hotel will not have enough rooms for desired amount!"); } else { using (var context = new Session3Entities()) { var newBooking = new Hotel_Booking() { hotelIdFK = _hotelID, numSingleRoomsRequired = originalSingle, numDoubleRoomsRequired = originalDouble, userIdFK = _user.userId }; context.Hotel_Booking.Add(newBooking); context.SaveChanges(); var getHotel = (from x in context.Hotels where x.hotelId == _hotelID select x).FirstOrDefault(); getHotel.numSingleRoomsBooked += originalSingle; getHotel.numDoubleRoomsBooked += originalDouble; context.SaveChanges(); MessageBox.Show("Hotel booking successful!"); Close(); } } } }
private void btnPan_Click(object sender, EventArgs e) { (new HotelBooking(_user, 2)).ShowDialog(); using (var context = new Session3Entities()) { var findBooking = (from x in context.Hotel_Booking where x.userIdFK == _user.userId select x).FirstOrDefault(); if (findBooking != null) { Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } } }
private void btnConfirm_Click(object sender, EventArgs e) { if (!rb22.Checked && !rb23.Checked) { MessageBox.Show("Please select a date!"); } else if (dataGridView1.CurrentCell == null) { MessageBox.Show("Please select a time!"); } else if (dataGridView1.CurrentCell.Style.BackColor == Color.Black) { MessageBox.Show("Please select another timing that is not blacked out!"); } else { var newArrival = new Arrival() { arrivalTime = dataGridView1.CurrentCell.Value.ToString(), number19seat = int.Parse(lbl19.Text), number42seat = int.Parse(lbl42.Text), numberCars = int.Parse(lblCar.Text), numberHead = (int)nudHead.Value, numberDelegate = (int)nudDelegates.Value, numberCompetitors = (int)nudCompetitors.Value, userIdFK = _user.userId }; if (rb22.Checked) { newArrival.arrivalDate = DateTime.Parse("22 July 2020"); } else if (rb23.Checked) { newArrival.arrivalDate = DateTime.Parse("23 July 2020"); } using (var context = new Session3Entities()) { context.Arrivals.Add(newArrival); context.SaveChanges(); MessageBox.Show("Successfully confirmed arrival!"); } Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } }
private void HotelBooking_Load(object sender, EventArgs e) { dataGridView1.Rows.Clear(); using (var context = new Session3Entities()) { var findArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); arrivalDate = findArrival.arrivalDate; daysToSpend = (endDate - arrivalDate).Days; lblCompetitors.Text = findArrival.numberCompetitors.ToString(); lblDelegates.Text = findArrival.numberDelegate.ToString(); var getHotel = (from x in context.Hotels where x.hotelId == _hotelID select x).FirstOrDefault(); lblHotelName.Text = getHotel.hotelName; if (findArrival.numberCompetitors % 2 != 0) { originalDouble = findArrival.numberCompetitors / 2; originalSingle = findArrival.numberDelegate + 1; } else { originalDouble = findArrival.numberCompetitors / 2; originalSingle = findArrival.numberDelegate; } var singleRow = new List <string>() { "Single", getHotel.singleRate.ToString(), (getHotel.numSingleRoomsTotal - getHotel.numSingleRoomsBooked).ToString(), originalSingle.ToString(), (getHotel.singleRate * originalSingle * daysToSpend).ToString() }; var doubleRow = new List <string>() { "Double", getHotel.doubleRate.ToString(), (getHotel.numDoubleRoomsTotal - getHotel.numDoubleRoomsBooked).ToString(), originalDouble.ToString(), (getHotel.doubleRate * originalDouble * daysToSpend).ToString() }; dataGridView1.Rows.Add(singleRow.ToArray()); dataGridView1.Rows.Add(doubleRow.ToArray()); CalculateTotal(); } }
private void LoadData(int hotelID) { dataGridView1.Rows.Clear(); using (var context = new Session3Entities()) { var getHotelBookings = (from x in context.Hotel_Booking where x.hotelIdFK == hotelID select x); foreach (var item in getHotelBookings) { var newRow = new List <string>() { item.User.countryName, item.numSingleRoomsRequired.ToString(), item.numDoubleRoomsRequired.ToString() }; dataGridView1.Rows.Add(newRow.ToArray()); } } }
private void btnConfirm_Click(object sender, EventArgs e) { using (var context = new Session3Entities()) { var findArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); if (findArrival == null) { Hide(); (new ConfirmArrival(_user)).ShowDialog(); Close(); } else { MessageBox.Show("Arrival has been confirmed!"); } } }
private void CreateAccount_Load(object sender, EventArgs e) { cbCountry.Items.Clear(); var countries = new List <string>() { "Brunei", "Cambodia", "Indonesia", "Laos", "Malaysia", "Myanmar", "Philippines", "Singapore", "Thailand", "Vietnam" }; using (var context = new Session3Entities()) { var getRegistered = (from x in context.Users where x.userTypeIdFK == 2 select x.countryName); foreach (var item in getRegistered) { countries.Remove(item); } } cbCountry.Items.AddRange(countries.ToArray()); }
private void btnLogin_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(txtUserID.Text) || string.IsNullOrWhiteSpace(txtPassword.Text)) { MessageBox.Show("Please fill up all fields!"); } else { using (var context = new Session3Entities()) { var findUser = (from x in context.Users where x.userId == txtUserID.Text select x).FirstOrDefault(); if (findUser == null) { MessageBox.Show("User does not exist!"); } else if (findUser.passwd != txtPassword.Text) { MessageBox.Show("Password incorrect!"); } else { MessageBox.Show($"Welcome {findUser.countryName}!"); if (findUser.userTypeIdFK == 1) { Hide(); (new AdminMain()).ShowDialog(); Close(); } else { Hide(); (new CountryMain(findUser)).ShowDialog(); Close(); } } } } }
private void LoadChart() { chart1.Series.Clear(); chart1.Series.Add("Delegates"); chart1.Series.Add("Competitors"); chart1.Series[0].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.StackedColumn; chart1.Series[1].ChartType = System.Windows.Forms.DataVisualization.Charting.SeriesChartType.StackedColumn; using (var context = new Session3Entities()) { var attendees = (from x in context.Arrivals select x); if (cbType.SelectedItem == null || cbType.SelectedItem.ToString() == "No Filter") { foreach (var item in attendees) { var idx1 = chart1.Series[0].Points.AddXY(item.User.countryName, item.numberDelegate + item.numberHead); var idx2 = chart1.Series[1].Points.AddXY(item.User.countryName, item.numberCompetitors); chart1.Series[0].Points[idx1].Label = (item.numberDelegate + item.numberHead).ToString(); chart1.Series[1].Points[idx2].Label = item.numberCompetitors.ToString(); } } else if (cbType.SelectedItem.ToString() == "Delegates") { foreach (var item in attendees) { var idx1 = chart1.Series[0].Points.AddXY(item.User.countryName, item.numberDelegate + item.numberHead); chart1.Series[0].Points[idx1].Label = (item.numberDelegate + item.numberHead).ToString(); } } else { foreach (var item in attendees) { var idx2 = chart1.Series[1].Points.AddXY(item.User.countryName, item.numberCompetitors); chart1.Series[1].Points[idx2].Label = item.numberCompetitors.ToString(); } } } }
private void UpdateInfo_Load(object sender, EventArgs e) { dataGridView1.Rows.Clear(); using (var context = new Session3Entities()) { var findArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); arrivalDate = findArrival.arrivalDate; daysToSpend = (endDate - arrivalDate).Days; nudCompetitors.Value = findArrival.numberCompetitors; nudDelegates.Value = findArrival.numberDelegate; nudHead.Value = findArrival.numberHead; var getBooking = (from x in context.Hotel_Booking where x.userIdFK == _user.userId select x).FirstOrDefault(); originalSingle = getBooking.numSingleRoomsRequired; originalDouble = getBooking.numDoubleRoomsRequired; var singleRow = new List <string>() { "Single", getBooking.Hotel.singleRate.ToString(), (getBooking.Hotel.numSingleRoomsTotal - getBooking.Hotel.numSingleRoomsBooked).ToString(), getBooking.numSingleRoomsRequired.ToString(), "", (getBooking.Hotel.singleRate * getBooking.numSingleRoomsRequired * daysToSpend).ToString() }; var doubleRow = new List <string>() { "Double", getBooking.Hotel.doubleRate.ToString(), (getBooking.Hotel.numDoubleRoomsTotal - getBooking.Hotel.numDoubleRoomsBooked).ToString(), getBooking.numDoubleRoomsRequired.ToString(), "", (getBooking.Hotel.doubleRate * getBooking.numDoubleRoomsRequired * daysToSpend).ToString() }; dataGridView1.Rows.Add(singleRow.ToArray()); dataGridView1.Rows.Add(doubleRow.ToArray()); CalculateTotal(); } }
private void btnUpdate_Click(object sender, EventArgs e) { var getTotalCap = (int)nudCompetitors.Value + (int)nudDelegates.Value; var bookedCap = originalSingle + (originalDouble * 2); if (bookedCap < getTotalCap) { MessageBox.Show("Please ensure number of rooms booked are enough for all visitors!"); } else { var boolCheck = true; foreach (DataGridViewRow item in dataGridView1.Rows) { if (dataGridView1[4, item.Index].Value.ToString() != "") { if (Convert.ToInt32(dataGridView1[2, item.Index].Value) < Convert.ToInt32(dataGridView1[4, item.Index].Value)) { boolCheck = false; } } else { if (Convert.ToInt32(dataGridView1[2, item.Index].Value) < Convert.ToInt32(dataGridView1[3, item.Index].Value)) { boolCheck = false; } } } if (boolCheck == false) { MessageBox.Show("Hotel will not have enough rooms for desired amount!"); } else { using (var context = new Session3Entities()) { var findArrival = (from x in context.Arrivals where x.userIdFK == _user.userId select x).FirstOrDefault(); findArrival.numberHead = (int)nudHead.Value; findArrival.numberCompetitors = (int)nudCompetitors.Value; findArrival.numberDelegate = (int)nudDelegates.Value; context.SaveChanges(); var findBooking = (from x in context.Hotel_Booking where x.userIdFK == _user.userId select x).FirstOrDefault(); findBooking.numSingleRoomsRequired = originalSingle; findBooking.numDoubleRoomsRequired = originalDouble; context.SaveChanges(); var findHotel = (from x in context.Hotels where x.hotelId == findBooking.hotelIdFK select x).FirstOrDefault(); foreach (DataGridViewRow item in dataGridView1.Rows) { if (dataGridView1[0, item.Index].Value.ToString() == "Single") { if (dataGridView1[4, item.Index].Value.ToString() != "") { if (findHotel.numSingleRoomsBooked == Convert.ToInt32(dataGridView1[4, item.Index].Value)) { findHotel.numSingleRoomsBooked = Convert.ToInt32(dataGridView1[4, item.Index].Value); } else { findHotel.numSingleRoomsBooked = findHotel.numSingleRoomsBooked - Convert.ToInt32(dataGridView1[3, item.Index].Value) + Convert.ToInt32(dataGridView1[4, item.Index].Value); } } } else { if (dataGridView1[4, item.Index].Value.ToString() != "") { if (findHotel.numDoubleRoomsBooked == Convert.ToInt32(dataGridView1[4, item.Index].Value)) { findHotel.numDoubleRoomsBooked = Convert.ToInt32(dataGridView1[4, item.Index].Value); } else { findHotel.numDoubleRoomsBooked = findHotel.numDoubleRoomsBooked - Convert.ToInt32(dataGridView1[3, item.Index].Value) + Convert.ToInt32(dataGridView1[4, item.Index].Value); } } } } context.SaveChanges(); MessageBox.Show("Update Info and Booking successful!"); Hide(); (new CountryMain(_user)).ShowDialog(); Close(); } } } }
private void ArrivalSummary_Load(object sender, EventArgs e) { var newRow = new List <string>() { "9am", "10am", "11am", "12pm", "1pm", "2pm", "3pm", "4pm" }; var listAllowed22 = new List <string>() { "9am", "11am", "12pm", "3pm", "4pm" }; var listAllowed23 = new List <string>() { "10am", "11am", "1pm", "2pm", "3pm" }; dataGridView1.Rows.Add(newRow.ToArray()); dataGridView2.Rows.Add(newRow.ToArray()); foreach (DataGridViewRow row in dataGridView1.Rows) { foreach (DataGridViewColumn cell in dataGridView1.Columns) { if (!listAllowed22.Contains(dataGridView1[cell.Index, row.Index].Value.ToString())) { dataGridView1[cell.Index, row.Index].Style.BackColor = Color.Black; } } } foreach (DataGridViewRow row in dataGridView2.Rows) { foreach (DataGridViewColumn cell in dataGridView2.Columns) { if (!listAllowed23.Contains(dataGridView2[cell.Index, row.Index].Value.ToString())) { dataGridView2[cell.Index, row.Index].Style.BackColor = Color.Black; } } } var july22 = DateTime.Parse("22 July 2020"); var july23 = DateTime.Parse("23 July 2020"); foreach (DataGridViewRow row in dataGridView1.Rows) { foreach (DataGridViewColumn cell in dataGridView1.Columns) { var timing = dataGridView1[cell.Index, row.Index].Value.ToString(); using (var context = new Session3Entities()) { var get22Arrival = (from x in context.Arrivals where x.arrivalDate == july22 && x.arrivalTime == timing select x); var sb = new StringBuilder(dataGridView1[cell.Index, row.Index].Value.ToString()); foreach (var item in get22Arrival) { sb.Append($"\n\n{item.User.countryName}\n({item.numberCars + item.number42seat + item.number19seat} Veh)"); } dataGridView1[cell.Index, row.Index].Value = sb.ToString(); } } } foreach (DataGridViewRow row in dataGridView2.Rows) { foreach (DataGridViewColumn cell in dataGridView2.Columns) { var timing = dataGridView2[cell.Index, row.Index].Value.ToString(); using (var context = new Session3Entities()) { var get23Arrival = (from x in context.Arrivals where x.arrivalDate == july23 && x.arrivalTime == timing select x); var sb = new StringBuilder(dataGridView2[cell.Index, row.Index].Value.ToString()); foreach (var item in get23Arrival) { sb.Append($"\n\n{item.User.countryName}\n({item.numberCars + item.number42seat + item.number19seat} Veh)"); } dataGridView2[cell.Index, row.Index].Value = sb.ToString(); } } } }