private void Button4_Click(System.Object sender, System.EventArgs e) { DGV.Rows.Clear(); SeatCapacity.Clear(); BookingNo.Clear(); SC2.Clear(); SeatAvailability.Clear(); RadioButton1.Checked = false; RadioButton2.Checked = false; RNo.Text = "Select"; BusSerialNo.Text = "Select"; }
public void btnclear_Click(System.Object sender, System.EventArgs e) { Rno.Text = "Select"; cmbstartpoint.Text = ""; cmbdestination.Text = ""; BusSerialNo.Text = "Select"; BusNumber.Text = "Select"; BusType.Text = "Select"; BusReservation.Text = "Select"; Arrivaltime.Value = Convert.ToDateTime(DateTime.Now); Departuretime.Value = Convert.ToDateTime(DateTime.Now); SeatCapacity.Clear(); S1.Clear(); S2.Clear(); SeatAvailability.Clear(); SC2.Clear(); }
public void FormControls(string CLR) { if (CLR == "CLR") { BusSerialNo.Clear(); BusNumber.Text = "Select"; BusRoute.Text = "Select"; BusType.Text = "Select"; BusReservation.Text = "Select"; BusSerialNo.Enabled = false; BusNumber.Enabled = false; BusRoute.Enabled = false; BusType.Enabled = false; BusReservation.Enabled = false; SeatCapacity.Clear(); btnsave.Enabled = false; btnedit.Enabled = false; btndelete.Enabled = false; btnadd.Enabled = true; btnfind.Enabled = true; Left1.Enabled = false; Right1.Enabled = false; } if (CLR == "Save") { btnsave.Enabled = true; btnadd.Enabled = false; btnfind.Enabled = false; btndelete.Enabled = false; btnedit.Enabled = false; BusNumber.Enabled = true; BusRoute.Enabled = true; BusType.Enabled = true; BusReservation.Enabled = true; BusNumber.Focus(); } }
/** * Returns a SeatCapacity object, separated into * a count of each SeatType */ public SeatCapacity GetSeatCapacities(int venueId) { var capacity = new SeatCapacity(); var allSeats = _seatRepository .Collection() .Where(seat => seat.VenueId == venueId) .ToList(); capacity.Budget = allSeats .Where(seat => seat.SeatType.Equals(SeatType.Budget)) .Count(); capacity.Moderate = allSeats .Where(seat => seat.SeatType == SeatType.Moderate) .Count(); capacity.Premier = allSeats .Where(seat => seat.SeatType == SeatType.Premier) .Count(); capacity.Total = allSeats.Count(); return(capacity); }
public SeatCapacity GetSeatsRemaining(int performanceId) { var capacity = new SeatCapacity(); capacity.Budget = _reservationRepository.Collection() .Where(res => res.PerformanceId == performanceId) .Where(res => res.Seat.SeatType == SeatType.Budget) .Where(res => res.IsTaken == false) .Count(); capacity.Moderate = _reservationRepository.Collection() .Where(res => res.PerformanceId == performanceId) .Where(res => res.Seat.SeatType == SeatType.Moderate) .Where(res => res.IsTaken == false) .Count(); capacity.Premier = _reservationRepository.Collection() .Where(res => res.PerformanceId == performanceId) .Where(res => res.Seat.SeatType == SeatType.Premier) .Where(res => res.IsTaken == false) .Count(); return(capacity); }
private SeatCapacity CountRemainingReservations(Performance performance) { SeatCapacity capacity = new SeatCapacity(); return(reservationService.GetSeatsRemaining(performance.Id)); }
private void Button3_Click(System.Object sender, System.EventArgs e) { //Try DialogResult res = MessageBox.Show("Do U Want To Cancel Waiting Booking?", "Cancel Booking?", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (res == DialogResult.Yes) { if (string.IsNullOrEmpty(BookingNo.Text.Trim())) { MessageBox.Show("Give Booking No.."); } else { string CN2 = null; con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=Bus_System;Integrated Security=True"); con.Open(); cmd = new SqlCommand("Select max(CancellationNo) From Cancellation", con); dr = cmd.ExecuteReader(); dr.Read(); if ((!object.ReferenceEquals(dr[0], DBNull.Value))) { t = Convert.ToInt32(dr[0]) + 1; } else { t = 1; } CN2 = t.ToString(); dr.Close(); cmd = new SqlCommand("Select * From APaymentPassenger Where BookingNo=" + BookingNo.Text + "", con); dr = cmd.ExecuteReader(); dr.Read(); string a1 = null; string a2 = null; string a3 = null; string a4 = null; string a5 = null; string a6 = null; string a7 = null; a1 = dr.GetValue(0).ToString(); a2 = dr.GetValue(1).ToString(); a3 = dr.GetValue(2).ToString(); a4 = dr.GetValue(6).ToString(); a5 = dr.GetValue(7).ToString(); a6 = dr.GetValue(8).ToString(); a7 = dr.GetValue(9).ToString(); dr.Close(); cmd = new SqlCommand("Insert Into Cancellation Values(" + CN2 + ",'" + a1 + "','" + a2 + "','" + a3 + "','" + DateAndTime.Today + " " + DateAndTime.TimeOfDay + "','" + a4 + "','" + a5 + "','" + a6 + "','" + a7 + "','" + Strings.Format(Arrivaltime.Value, "hh:MM:ss tt") + "')", con); cmd.ExecuteNonQuery(); cmd = new SqlCommand("Delete From APassengerDetails Where BookingNo=" + BookingNo.Text + "", con); cmd.ExecuteNonQuery(); cmd = new SqlCommand("Delete From APaymentPassenger Where BookingNo=" + BookingNo.Text + "", con); cmd.ExecuteNonQuery(); MessageBox.Show("Done"); con.Close(); DGV.Rows.Clear(); SeatCapacity.Clear(); BookingNo.Clear(); SC2.Clear(); SeatAvailability.Clear(); RadioButton1.Checked = false; RadioButton2.Checked = false; } } else { MessageBox.Show("Not Cancelled"); } //Catch ex As Exception // MsgBox("Nothing Selected..!") //End Try }