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