private void Back_Click(object sender, EventArgs e)
{
this.Hide();
CountryRepresentativeMainMenu countryRepresentativeMainMenu = new CountryRepresentativeMainMenu(users);
countryRepresentativeMainMenu.Show();
}
private void Login_Click(object sender, EventArgs e)
{
using (var db = new Session3Entities())
{
var ID = UID.Text;
var pass = Pass.Text;
var q = db.Users.Where(x => x.userId == ID && x.passwd == pass).FirstOrDefault();
if (q != null)
{
//Only administrators and country representatives
//can successfully login via this screen.
if (q.userTypeIdFK == 1)
{
//When a user successfully logs in, they will be
//automatically re‐directed to the appropriate main menu for that type of user.
AdminMainMenu adminMainMenu = new AdminMainMenu(q);
this.Hide();
adminMainMenu.Show();
}
else
{
//When a user successfully logs in, they will be
//automatically re‐directed to the appropriate main menu for that type of user.
CountryRepresentativeMainMenu countryRepresentativeMainMenu = new CountryRepresentativeMainMenu(q);
this.Hide();
countryRepresentativeMainMenu.Show();
}
}
else
{
MessageBox.Show("Invalid User!");
}
}
}
private void UpdateInfoBooking_Load(object sender, EventArgs e)
{
timer1.Start();
using (var db = new Session3Entities())
{
var q = db.Arrivals.Where(x => x.userIdFK == users.userId).FirstOrDefault();
if (q == null)
{
MessageBox.Show("Please Book Something First!");
this.Hide();
CountryRepresentativeMainMenu countryRepresentativeMainMenu = new CountryRepresentativeMainMenu(users);
countryRepresentativeMainMenu.Show();
}
else
{
var q2 = db.Hotel_Booking.Where(x => x.userIdFK == users.userId).FirstOrDefault();
dataGridView1.DataSource = CDTU(q2);
HOD.Value = q.numberHead;
Dels.Text = q.numberDelegate.ToString();
Comps.Text = q.numberCompetitors.ToString();
}
}
}
private void book_Click(object sender, EventArgs e)
{
using (var db = new Session3Entities())
{
var q = db.Arrivals.Where(x => x.userIdFK == users.userId).FirstOrDefault();
//If user first time creating arrivals
if (q == null)
{
Arrival arrival = new Arrival();
if (jul22.Checked == true)
{
arrival.arrivalDate = DateTime.Parse("22 July 2020");
}
else if (jul23.Checked == true)
{
arrival.arrivalDate = DateTime.Parse("23 July 2020");
}
else
{
MessageBox.Show("Choose Date!");
return;
}
arrival.userIdFK = users.userId;
if (time == null)
{
MessageBox.Show("You have chosen an invalid timing!");
return;
}
arrival.arrivalTime = time;
if (numericUpDown1.Value > 1)
{
MessageBox.Show("Invalid Head of Deligates!");
return;
}
arrival.numberHead = (int)numericUpDown1.Value;
try
{
arrival.numberDelegate = int.Parse(Dels.Text);
arrival.numberCompetitors = int.Parse(Comps.Text);
}
catch
{
MessageBox.Show("Invalid Deligates or competitors");
return;
}
arrival.numberCars = int.Parse(carHeadDel.Text);
arrival.number19seat = int.Parse(seat19.Text);
arrival.number42seat = int.Parse(seat42.Text);
db.Arrivals.Add(arrival);
try
{
db.SaveChanges();
MessageBox.Show("Success!");
this.Hide();
CountryRepresentativeMainMenu countryRepresentativeMainMenu = new CountryRepresentativeMainMenu(users);
countryRepresentativeMainMenu.Show();
}
catch (Exception es)
{
MessageBox.Show(es.ToString());
}
}
//User has created and come back to change
else
{
if (jul22.Checked == true)
{
q.arrivalDate = DateTime.Parse("22 July 2020");
}
else if (jul23.Checked == true)
{
q.arrivalDate = DateTime.Parse("23 July 2020");
}
else
{
MessageBox.Show("Choose Date!");
return;
}
if (time == null)
{
MessageBox.Show("You have chosen an invalid timing!");
return;
}
q.arrivalTime = time;
if (numericUpDown1.Value > 1)
{
MessageBox.Show("Invalid Head of Deligates!");
return;
}
q.numberHead = (int)numericUpDown1.Value;
try
{
q.numberDelegate = int.Parse(Dels.Text);
q.numberCompetitors = int.Parse(Comps.Text);
}
catch
{
MessageBox.Show("Invalid Deligates or competitors");
return;
}
q.numberCars = int.Parse(carHeadDel.Text);
q.number19seat = int.Parse(seat19.Text);
q.number42seat = int.Parse(seat42.Text);
try
{
db.SaveChanges();
MessageBox.Show("Success!");
this.Hide();
CountryRepresentativeMainMenu countryRepresentativeMainMenu = new CountryRepresentativeMainMenu(users);
countryRepresentativeMainMenu.Show();
}
catch (Exception es)
{
MessageBox.Show(es.ToString());
}
}
}
}
private void update_Click(object sender, EventArgs e)
{
if (dataGridView1.Rows[0].Cells["Rooms Required"].Value != null && dataGridView1.Rows[1].Cells["Rooms Required"].Value != null)
{
var singleR = dataGridView1.Rows[0].Cells["Rooms Required"].Value.ToString();
var doubleR = dataGridView1.Rows[1].Cells["Rooms Required"].Value.ToString();
using (var db = new Session3Entities())
{
var q2 = db.Hotel_Booking.Where(x => x.userIdFK == users.userId).FirstOrDefault();
oldD = q2.numDoubleRoomsRequired;
oldS = q2.numSingleRoomsRequired;
if (int.Parse(singleR) <= q2.Hotel.numSingleRoomsTotal - q2.Hotel.numSingleRoomsBooked)
{
q2.numSingleRoomsRequired = int.Parse(singleR);
q2.Hotel.numSingleRoomsBooked -= oldS;
q2.Hotel.numSingleRoomsBooked += int.Parse(singleR);
}
else
{
MessageBox.Show("Invalid Amount of Single Rooms!");
return;
}
if (int.Parse(doubleR) <= q2.Hotel.numDoubleRoomsTotal - q2.Hotel.numDoubleRoomsBooked)
{
q2.numDoubleRoomsRequired = int.Parse(doubleR);
q2.Hotel.numDoubleRoomsBooked -= oldD;
q2.Hotel.numDoubleRoomsBooked += int.Parse(doubleR);
}
else
{
MessageBox.Show("Invalid Amount of Double Rooms!");
return;
}
var q = db.Arrivals.Where(x => x.userIdFK == users.userId).FirstOrDefault();
if (HOD.Value > 1)
{
MessageBox.Show("Invalid Head of Delegate");
return;
}
q.numberHead = (int)HOD.Value;
try
{
q.numberDelegate = int.Parse(Dels.Text);
q.numberCompetitors = int.Parse(Comps.Text);
}
catch
{
MessageBox.Show("Invalid Delegates or Competitors");
return;
}
try
{
db.SaveChanges();
MessageBox.Show("Success!");
this.Hide();
CountryRepresentativeMainMenu countryRepresentativeMainMenu = new CountryRepresentativeMainMenu(users);
countryRepresentativeMainMenu.Show();
}
catch (Exception es)
{
MessageBox.Show(es.ToString());
}
}
}
}
