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();
}
}
}
}
