private void btnGenerateTicket_Click(object sender, EventArgs e)
{
this.Hide();
frmGenerateTicket frm = new frmGenerateTicket(emp);
frm.Show();
}
private void btnsubmitTicket_Click(object sender, EventArgs e)
{
Database db = new Database();
if (txtPassengerID.Text.Equals("") || txtSeatNo.Text.Equals("") || txtFare.Equals(""))
{
MessageBox.Show("Error! passenger id, seat or fare is empty!");
}
else
{
Coach findCoach = new Coach();
foreach (Coach coach in coaches)
{
if (coach.getCoachId() == int.Parse(cmboCoachType.Text))
{
findCoach = coach;
}
}
try
{
if (db.getBookedSeatsInCoachCount(scheduleDateLog.getSerialNo(), findCoach.getCoachId()) < findCoach.getNoOfSeats())
{
int seat_no = int.Parse(txtSeatNo.Text);
if (db.isSeatBooked(seat_no, findCoach, scheduleDateLog))
{
MessageBox.Show("Error! seat is already booked.");
return;
}
Ticket ticket = new Ticket();
ticket.setSeat(int.Parse(txtSeatNo.Text));
passenger.setPid(int.Parse(txtPassengerID.Text));
ticket.setPassenger(passenger);
ticket.setFare(int.Parse(txtFare.Text));
Station srcStation = new Station();
Station dstStation = new Station();
foreach (Station station in stations)
{
if (station.getName().Equals(cmboSourceStation.Text))
{
srcStation = station;
}
if (station.getName().Equals(cmboDestinationStation.Text))
{
dstStation = station;
}
}
ticket.setSource(srcStation);
ticket.setDestination(dstStation);
ticket.setCoach(findCoach);
scheduleDateLog = db.getScheduleDateLog(int.Parse(cmboScheduleID.Text), date.Value);
ticket.setScheduleDateLog(scheduleDateLog);
if (db.addTicket(ticket))
{
ticket.setId(db.getTicketId(ticket));
scheduleDateLog.setSeatsBooked(scheduleDateLog.getSeatsBooked() + 1);
txtSeatsBooked.Text = "" + scheduleDateLog.getSeatsBooked();
if (db.updateBookedTicketsCount(scheduleDateLog))
{
MessageBox.Show("Ticket successfully added!");
this.Hide();
frmGenerateTicket frm = new frmGenerateTicket(active, ticket);
frm.Show();
}
else
{
MessageBox.Show("Unable to update booked seats counter!");
}
}
else
{
MessageBox.Show("Unable to add ticket!");
}
}
else
{
MessageBox.Show("All seats are booked in this coach!");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}