private void btnViewBookings_Click(object sender, EventArgs e)
{
ViewBookings viewBookings = new ViewBookings(); //opens a form called Menu
this.Hide(); //hides the previous form
viewBookings.ShowDialog(); //opens the form
this.Close(); //closes the form
}
private void icnEditSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txtBoxEditName.Text.Trim()) || string.IsNullOrEmpty(txtBoxEditBookingEmail.Text.Trim()))
{
const string RequiredFieldsError = "Fields can not be empty";
const string caption = "Empty Fields";
var result = MessageBox.Show(RequiredFieldsError, caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
if (comboBoxEditUnder4.SelectedIndex != 0 || comboBoxEditChild.SelectedIndex != 0 || comboBoxEditTeen.SelectedIndex != 0 ||
comboBoxEditAdult.SelectedIndex != 0 || comboBoxEditSenior.SelectedIndex != 0)
{
if (editTotal > total || editTotal == total)
{
if (txtBoxEditPaymentType.Text == "Credit Card")
{
string UpdatePayment = "Original Price: £" + total.ToString("F") + Environment.NewLine + "New Payment: £" + (editTotal + editTotal * CreditCardFee).ToString("F")
+ Environment.NewLine + Environment.NewLine + "Remaining Cost to be paid: £" + ((editTotal + editTotal * CreditCardFee) - total).ToString("F")
+ Environment.NewLine + Environment.NewLine + "Confirm?";
string captionUpdatePayment = "Payment";
var resultUpdatePayment = MessageBox.Show(UpdatePayment, captionUpdatePayment, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (resultUpdatePayment == DialogResult.Yes)
{
con.Open(); // Opens the connection
cmd = new SqlCommand("UPDATE dbo.Bookings SET Name=@Name, BookingEmail=@BookingEmail, Movie=@Movie, MovieTime=@MovieTime, TicketPrice=@TicketPrice, PaymentType=@PaymentType, Email=@Email, Under4Tickets=@Under4Tickets, ChildTickets=@ChildTickets, TeenTickets=@TeenTickets, AdultTickets=@AdultTickets, SeniorTickets=@SeniorTickets WHERE BookingID=@BookingID", con);
cmd.Parameters.AddWithValue("@BookingID", BookingID); // Stores the ID collected from the command to the @ID variable
cmd.Parameters.AddWithValue("@Name", txtBoxEditName.Text);
cmd.Parameters.AddWithValue("@BookingEmail", txtBoxEditBookingEmail.Text);
cmd.Parameters.AddWithValue("@Movie", comboBoxEditMovieNames.SelectedItem); // Stores the Password collected from the command to the @Password variable
cmd.Parameters.AddWithValue("@MovieTime", comboBoxEditMovieTimes.SelectedItem);
cmd.Parameters.AddWithValue("@TicketPrice", lblEditFinalPrice.Text);
cmd.Parameters.AddWithValue("@PaymentType", txtBoxEditPaymentType.Text);
cmd.Parameters.AddWithValue("@Email", Login.Email);
cmd.Parameters.AddWithValue("@Under4Tickets", comboBoxEditUnder4.SelectedItem);
cmd.Parameters.AddWithValue("@ChildTickets", comboBoxEditChild.SelectedItem);
cmd.Parameters.AddWithValue("@TeenTickets", comboBoxEditTeen.SelectedItem);
cmd.Parameters.AddWithValue("@AdultTickets", comboBoxEditAdult.SelectedItem);
cmd.Parameters.AddWithValue("@SeniorTickets", comboBoxEditSenior.SelectedItem);
cmd.ExecuteNonQuery(); // Executes the query (Non query is for UPDATE, INSERT AND DELETE statements)
MessageBox.Show("Booking Updated Successfully");
con.Close();
const string LogoutConfirmation = "Would you like to return to the View Booking page to view your Booking?";
const string caption = "View Booking?";
var result = MessageBox.Show(LogoutConfirmation, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ViewBookings viewBookings = new ViewBookings(); //opens a form called Menu
this.Hide(); //hides the previous form
viewBookings.ShowDialog(); //opens the form
this.Close(); //closes the form
}
else
{
Menu menu = new Menu(); //opens a form called Menu
this.Hide(); //hides the previous form
menu.ShowDialog(); //opens the form
this.Close(); //closes the form
}
}
}
else
{
string UpdatePayment = "Original Price: £" + total.ToString("F") + Environment.NewLine + "New Payment: £" + (editTotal + editTotal * PaypalFee).ToString("F")
+ Environment.NewLine + Environment.NewLine + "Remaining Cost to be paid: £" + ((editTotal + editTotal * PaypalFee) - total).ToString("F")
+ Environment.NewLine + Environment.NewLine + "Confirm?";
string captionUpdatePayment = "Payment";
var resultUpdatePayment = MessageBox.Show(UpdatePayment, captionUpdatePayment, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (resultUpdatePayment == DialogResult.Yes)
{
con.Open(); // Opens the connection
cmd = new SqlCommand("UPDATE dbo.Bookings SET Name=@Name, BookingEmail=@BookingEmail, Movie=@Movie, MovieTime=@MovieTime, TicketPrice=@TicketPrice, PaymentType=@PaymentType, Email=@Email, Under4Tickets=@Under4Tickets, ChildTickets=@ChildTickets, TeenTickets=@TeenTickets, AdultTickets=@AdultTickets, SeniorTickets=@SeniorTickets WHERE BookingID=@BookingID", con);
cmd.Parameters.AddWithValue("@BookingID", BookingID); // Stores the ID collected from the command to the @ID variable
cmd.Parameters.AddWithValue("@Name", txtBoxEditName.Text);
cmd.Parameters.AddWithValue("@BookingEmail", txtBoxEditBookingEmail.Text);
cmd.Parameters.AddWithValue("@Movie", comboBoxEditMovieNames.SelectedItem); // Stores the Password collected from the command to the @Password variable
cmd.Parameters.AddWithValue("@MovieTime", comboBoxEditMovieTimes.SelectedItem);
cmd.Parameters.AddWithValue("@TicketPrice", lblEditFinalPrice.Text);
cmd.Parameters.AddWithValue("@PaymentType", txtBoxEditPaymentType.Text);
cmd.Parameters.AddWithValue("@Email", Login.Email);
cmd.Parameters.AddWithValue("@Under4Tickets", comboBoxEditUnder4.SelectedItem);
cmd.Parameters.AddWithValue("@ChildTickets", comboBoxEditChild.SelectedItem);
cmd.Parameters.AddWithValue("@TeenTickets", comboBoxEditTeen.SelectedItem);
cmd.Parameters.AddWithValue("@AdultTickets", comboBoxEditAdult.SelectedItem);
cmd.Parameters.AddWithValue("@SeniorTickets", comboBoxEditSenior.SelectedItem);
cmd.ExecuteNonQuery(); // Executes the query (Non query is for UPDATE, INSERT AND DELETE statements)
MessageBox.Show("Booking Updated Successfully");
con.Close();
const string LogoutConfirmation = "Would you like to return to the View Booking page to view your Booking?";
const string caption = "View Booking?";
var result = MessageBox.Show(LogoutConfirmation, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ViewBookings viewBookings = new ViewBookings(); //opens a form called Menu
this.Hide(); //hides the previous form
viewBookings.ShowDialog(); //opens the form
this.Close(); //closes the form
}
else
{
Menu menu = new Menu(); //opens a form called Menu
this.Hide(); //hides the previous form
menu.ShowDialog(); //opens the form
this.Close(); //closes the form
}
}
}
}
if (total > editTotal)
{
if (txtBoxEditPaymentType.Text == "Credit Card")
{
string UpdatePaymentplus = "Original Price: £" + total.ToString("F") + Environment.NewLine + "New Payment: £" + (editTotal + editTotal * CreditCardFee).ToString("F")
+ Environment.NewLine + Environment.NewLine + "You will be refunded: £" + (total - (editTotal + editTotal * CreditCardFee)).ToString("F")
+ Environment.NewLine + Environment.NewLine + "Confirm?";
string captionUpdatePaymentplus = "Confirm?";
var resultUpdatePaymentplus = MessageBox.Show(UpdatePaymentplus, captionUpdatePaymentplus, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (resultUpdatePaymentplus == DialogResult.Yes)
{
con.Open(); // Opens the connection
cmd = new SqlCommand("UPDATE dbo.Bookings SET Name=@Name, BookingEmail=@BookingEmail, Movie=@Movie, MovieTime=@MovieTime, TicketPrice=@TicketPrice, PaymentType=@PaymentType, Email=@Email, Under4Tickets=@Under4Tickets, ChildTickets=@ChildTickets, TeenTickets=@TeenTickets, AdultTickets=@AdultTickets, SeniorTickets=@SeniorTickets WHERE BookingID=@BookingID", con);
cmd.Parameters.AddWithValue("@BookingID", BookingID); // Stores the ID collected from the command to the @ID variable
cmd.Parameters.AddWithValue("@Name", txtBoxEditName.Text);
cmd.Parameters.AddWithValue("@BookingEmail", txtBoxEditBookingEmail.Text);
cmd.Parameters.AddWithValue("@Movie", comboBoxEditMovieNames.SelectedItem); // Stores the Password collected from the command to the @Password variable
cmd.Parameters.AddWithValue("@MovieTime", comboBoxEditMovieTimes.SelectedItem);
cmd.Parameters.AddWithValue("@TicketPrice", lblEditFinalPrice.Text);
cmd.Parameters.AddWithValue("@PaymentType", txtBoxEditPaymentType.Text);
cmd.Parameters.AddWithValue("@Email", Login.Email);
cmd.Parameters.AddWithValue("@Under4Tickets", comboBoxEditUnder4.SelectedItem);
cmd.Parameters.AddWithValue("@ChildTickets", comboBoxEditChild.SelectedItem);
cmd.Parameters.AddWithValue("@TeenTickets", comboBoxEditTeen.SelectedItem);
cmd.Parameters.AddWithValue("@AdultTickets", comboBoxEditAdult.SelectedItem);
cmd.Parameters.AddWithValue("@SeniorTickets", comboBoxEditSenior.SelectedItem);
cmd.ExecuteNonQuery(); // Executes the query (Non query is for UPDATE, INSERT AND DELETE statements)
MessageBox.Show("Record Updated Successfully");
con.Close();
const string LogoutConfirmation = "Would you like to return to the View Booking page to view your Booking?";
const string caption = "View Booking?";
var result = MessageBox.Show(LogoutConfirmation, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ViewBookings viewBookings = new ViewBookings(); //opens a form called Menu
this.Hide(); //hides the previous form
viewBookings.ShowDialog(); //opens the form
this.Close(); //closes the form
}
else
{
Menu menu = new Menu(); //opens a form called Menu
this.Hide(); //hides the previous form
menu.ShowDialog(); //opens the form
this.Close(); //closes the form
}
}
else
{
const string LogoutConfirmation = "Payment Cancelled, you have not been charged";
const string caption = "Payment";
var result = MessageBox.Show(LogoutConfirmation, caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
string UpdatePaymentplus = "Original Price: £" + total.ToString("F") + Environment.NewLine + "New Payment: £" + (editTotal + editTotal * PaypalFee).ToString("F")
+ Environment.NewLine + Environment.NewLine + "You will be refunded: £" + (total - (editTotal + editTotal * PaypalFee)).ToString("F")
+ Environment.NewLine + Environment.NewLine + "Confirm?";
string captionUpdatePaymentplus = "Confirm?";
var resultUpdatePaymentplus = MessageBox.Show(UpdatePaymentplus, captionUpdatePaymentplus, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (resultUpdatePaymentplus == DialogResult.Yes)
{
con.Open(); // Opens the connection
cmd = new SqlCommand("UPDATE dbo.Bookings SET Name=@Name, BookingEmail=@BookingEmail, Movie=@Movie, MovieTime=@MovieTime, TicketPrice=@TicketPrice, PaymentType=@PaymentType, Email=@Email, Under4Tickets=@Under4Tickets, ChildTickets=@ChildTickets, TeenTickets=@TeenTickets, AdultTickets=@AdultTickets, SeniorTickets=@SeniorTickets WHERE BookingID=@BookingID", con);
cmd.Parameters.AddWithValue("@BookingID", BookingID); // Stores the ID collected from the command to the @ID variable
cmd.Parameters.AddWithValue("@Name", txtBoxEditName.Text);
cmd.Parameters.AddWithValue("@BookingEmail", txtBoxEditBookingEmail.Text);
cmd.Parameters.AddWithValue("@Movie", comboBoxEditMovieNames.SelectedItem); // Stores the Password collected from the command to the @Password variable
cmd.Parameters.AddWithValue("@MovieTime", comboBoxEditMovieTimes.SelectedItem);
cmd.Parameters.AddWithValue("@TicketPrice", lblEditFinalPrice.Text);
cmd.Parameters.AddWithValue("@PaymentType", txtBoxEditPaymentType.Text);
cmd.Parameters.AddWithValue("@Email", Login.Email);
cmd.Parameters.AddWithValue("@Under4Tickets", comboBoxEditUnder4.SelectedItem);
cmd.Parameters.AddWithValue("@ChildTickets", comboBoxEditChild.SelectedItem);
cmd.Parameters.AddWithValue("@TeenTickets", comboBoxEditTeen.SelectedItem);
cmd.Parameters.AddWithValue("@AdultTickets", comboBoxEditAdult.SelectedItem);
cmd.Parameters.AddWithValue("@SeniorTickets", comboBoxEditSenior.SelectedItem);
cmd.ExecuteNonQuery(); // Executes the query (Non query is for UPDATE, INSERT AND DELETE statements)
MessageBox.Show("Record Updated Successfully");
con.Close();
const string LogoutConfirmation = "Would you like to return to the View Booking page to view your Booking?";
const string caption = "View Booking?";
var result = MessageBox.Show(LogoutConfirmation, caption, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
ViewBookings viewBookings = new ViewBookings(); //opens a form called Menu
this.Hide(); //hides the previous form
viewBookings.ShowDialog(); //opens the form
this.Close(); //closes the form
}
else
{
Menu menu = new Menu(); //opens a form called Menu
this.Hide(); //hides the previous form
menu.ShowDialog(); //opens the form
this.Close(); //closes the form
}
}
else
{
const string LogoutConfirmation = "Payment Cancelled, you have not been charged";
const string caption = "Payment";
var result = MessageBox.Show(LogoutConfirmation, caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
else
{
const string NoTickets = "No tickets selected, please select at least 1 ticket to continue";
const string caption = "No ticket";
var result = MessageBox.Show(NoTickets, caption, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}