private void cancel_Click(object sender, EventArgs e)
{
int ticketno = (int)CancelTickCB.SelectedValue;
int passengerno = controllerObj.passengerno(userno);
int p1 = controllerObj.DeleteTicket(ticketno);
int p2 = controllerObj.DeletePassenger(passengerno);
if (p1 != 0 && p2 != 0)
{
MessageBox.Show("Ticket has been canceled successfully!");
MyTickDGV.DataSource = controllerObj.ViewTicketsinformation(userno);
MyTickDGV.Refresh();
MyTickDGV.ReadOnly = true;
MyTickDGV.AllowUserToAddRows = false;
MyTickDGV.AllowUserToDeleteRows = false;
CancelTickCB.DataSource = controllerObj.ViewTicketsCB(userno);
CancelTickCB.DisplayMember = "ticket_no";
CancelTickCB.ValueMember = "ticket_no";
}
else
{
MessageBox.Show("Error while Ticket Cancelation!");
}
}
private void viewall_Click(object sender, EventArgs e)
{
MyTickDGV.DataSource = controllerObj.ViewAllTickets();
MyTickDGV.Refresh();
MyTickDGV.ReadOnly = true;
MyTickDGV.AllowUserToAddRows = false;
MyTickDGV.AllowUserToDeleteRows = false;
}
public ViewAndCancelEmp(int id)
{
InitializeComponent();
controllerObj = new Controller();
empno = id;
MyTickDGV.DataSource = controllerObj.ViewAllTickets();
MyTickDGV.Refresh();
MyTickDGV.ReadOnly = true;
MyTickDGV.AllowUserToAddRows = false;
MyTickDGV.AllowUserToDeleteRows = false;
}
private void view_Click(object sender, EventArgs e)
{
if (Date.Text != "yyyy-mm-dd")
{
MyTickDGV.DataSource = controllerObj.ViewAllTicketsDate(Date.Text);
MyTickDGV.Refresh();
MyTickDGV.ReadOnly = true;
MyTickDGV.AllowUserToAddRows = false;
MyTickDGV.AllowUserToDeleteRows = false;
}
else
{
MessageBox.Show("Please Select a Valid Date!");
}
}
public MyTickets(int usernum)
{
InitializeComponent();
controllerObj = new Controller();
userno = usernum;
MyTickDGV.DataSource = controllerObj.ViewTicketsinformation(userno);
MyTickDGV.Refresh();
MyTickDGV.ReadOnly = true;
MyTickDGV.AllowUserToAddRows = false;
MyTickDGV.AllowUserToDeleteRows = false;
CancelTickCB.DataSource = controllerObj.ViewTicketsCB(userno);
CancelTickCB.DisplayMember = "ticket_no";
CancelTickCB.ValueMember = "ticket_no";
}
private void cancel_Click_1(object sender, EventArgs e)
{
int ticketno = (int)ticketID.Value;
int passengerno = controllerObj.passengernofromticket(ticketno);
int p1 = controllerObj.DeleteTicket(ticketno);
int p2 = controllerObj.DeletePassenger(passengerno);
if (p1 != 0 && p2 != 0)
{
MessageBox.Show("Ticket has been canceled successfully!");
MyTickDGV.DataSource = controllerObj.ViewAllTickets();
MyTickDGV.Refresh();
MyTickDGV.ReadOnly = true;
MyTickDGV.AllowUserToAddRows = false;
MyTickDGV.AllowUserToDeleteRows = false;
}
else
{
MessageBox.Show("Errorr while Ticket Cancelation!");
}
}
