public BusManagemenet(Login l)
{
InitializeComponent();
BusTable2.AutoGenerateColumns = false;
this.l = l;
br = new BusRepo();
lr = new LoginRepo();
}
public MainMenuForm1(Login l)
{
InitializeComponent();
this.l = l;
br = new BusRepo();
cr = new CustomerRepo();
seatlist.Clear();
//nonacseatpanel.Refresh();
//acseatpanel.Refresh();
}
private void rtxtSearch_TextChanged(object sender, EventArgs e)
{
this.dgvBus.AutoGenerateColumns = false;
try
{
this.dgvBus.DataSource = BusRepo.LiveSearchBus(this.rtxtSearch.Text);
}
catch (Exception exception)
{
Console.WriteLine("Something went wrong!" + exception.Message);
}
this.dgvBus.ClearSelection();
this.dgvBus.Refresh();
}
public DALUnitOfWork()
{
vygCtx = new VoyageContext();
BusExpeditionPocos = new BusExpeditionRepo(vygCtx);
BusPocos = new BusRepo(vygCtx);
BusTypePocos = new BusTypeRepo(vygCtx);
DriverPocos = new DriverRepo(vygCtx);
HostPocos = new HostRepo(vygCtx);
PersonPocos = new PersonRepo(vygCtx);
RoutePocos = new RouteRepo(vygCtx);
SeatInformationPocos = new SeatInformationRepo(vygCtx);
TicketPocos = new TicketRepo(vygCtx);
}
private void FillBusDataGridView()
{
this.dgvBus.AutoGenerateColumns = false;
try
{
this.dgvBus.DataSource = BusRepo.ShowAll();
}
catch (Exception e)
{
MessageBox.Show("Something went wrong!" + e.Message);
}
this.dgvBus.ClearSelection();
this.dgvBus.Refresh();
}
private void deleteBusBtn_Click(object sender, EventArgs e)
{
if (this.dgvBus.SelectedRows.Count < 1)
{
MessageBox.Show("No data selected");
return;
}
if (MessageBox.Show("Are you sure you want to delete?", caption: "Confirmation", MessageBoxButtons.YesNo,
MessageBoxIcon.Warning) == DialogResult.No)
{
return;
}
try
{
//MessageBox.Show("hello");
//when delete button is clicked the bus will be null to route table since it is foreign key
bool ifBusSetsToNullInRoute = RouteRepo.SetNullToBusNum(this.rtxtPhn.Text);
if (ifBusSetsToNullInRoute)
{
try
{
bool ifBusDeleted = BusRepo.Delete(this.rtxtPhn.Text);
if (ifBusDeleted)
{
MessageBox.Show("Deleted Successfully!\nBus associated with routes is inactivated");
ClearBusInput();
this.invisibleBusNoText.Text = "";
this.FillBusDataGridView();
}
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when deleting the bus");
}
}
}
catch (Exception exception)
{
MessageBox.Show("Something went wrong when setting bus number to null to route\n" + exception);
}
}
private void FillDropDownFromDb() //Used to Fill the Drop Down List with bus_no
{
try
{
string[] buses = BusRepo.GetUnassignedBuses();
foreach (string s in buses)
{
this.cmbBusNo.Items.Add(s);
}
}
catch (Exception e)
{
Console.WriteLine("Something went wrong in drop down!" + e);
}
}
private void FillDropDownFromDb() //Used to Fill the Drop Down List with bus_no
{
this.cmbBus.Items.Clear();
try
{
List <Bus> buses = BusRepo.GetAll();
int i;
for (i = 0; i < buses.Count; i++)
{
for (int j = 0; j < 1; j++)
{
this.cmbBus.Items.Add(buses[i].BusNo);
}
}
}
catch (Exception e)
{
Console.WriteLine("Something went wrong in drop down!" + e);
}
}
private void DeleteBtn_Click(object sender, EventArgs e)
{
Customer cm = new Customer();
cm.Name = this.CustomerNameTb.Text;
cm.PhoneNumber = this.PhoneTB.Text;
cm.From = tablefrom;
cm.To = tableto;
cm.BusId = tablebusid;
cm.Date = tabledate;
cm.Time = tabletime;
cm.Type = tabletype;
cm.SeatNumber = tableseatnumber;
cm.Fare = Convert.ToInt32(tablefare);
string [] seatnumbers = tableseatnumber.Split(',');
if (cr.DeleteCustomer(cm))
{
MessageBox.Show("Deleted");
this.ShowAllBtn_Click(sender, e);
int i = 0;
Bus b = new Bus();
BusRepo br = new BusRepo();
while (seatnumbers[i] != "")
{
b = br.GetBus(tablebusid, tabledate, tabletime);
br.updatefordelete(b, seatnumbers[i]);
i++;
}
MessageBox.Show(b.NumberOfSeats + " " + seatnumbers.Length);
b.NumberOfSeats = (b.NumberOfSeats + seatnumbers.Length - 1);
br.UpdateNumberSeat(b);
}
else
{
MessageBox.Show("Can Not Delete");
}
}
private void SeatBookBtn_Click(object sender, EventArgs e)
{
br = new BusRepo();
CustomerDetailsPanel.Visible = true;
FromToPanel.Visible = false;
WelcomePanel.Visible = false;
BusTablePanel.Visible = false;
Bus b = new Bus();
b = br.GetBus(tablebusid, tablebusname, tabledate, tabletime, tableavailableseats, tablefare);
if (b.Type == "AC")
{
acseatpanel.Visible = true;
nonacseatpanel.Visible = false;
if (b.A1 == 1)
{
A1btn.Enabled = false;
}
else
{
A1btn.Enabled = true;
}
if (b.A2 == 1)
{
A2btn.Enabled = false;
}
else
{
A2btn.Enabled = true;
}
if (b.A3 == 1)
{
A3btn.Enabled = false;
}
else
{
A3btn.Enabled = true;
}
//if (b.A4 == 1) { A4btn.Enabled = false; } else { A4btn.Enabled = true; }
if (b.B1 == 1)
{
B1btn.Enabled = false;
}
else
{
B1btn.Enabled = true;
}
if (b.B2 == 1)
{
B2btn.Enabled = false;
}
else
{
B2btn.Enabled = true;
}
if (b.B3 == 1)
{
B3btn.Enabled = false;
}
else
{
B3btn.Enabled = true;
}
//if (b.B4 == 1) { B4btn.Enabled = false; } else { B4btn.Enabled = true; }
if (b.C1 == 1)
{
C1btn.Enabled = false;
}
else
{
C1btn.Enabled = true;
}
if (b.C2 == 1)
{
C2btn.Enabled = false;
}
else
{
C2btn.Enabled = true;
}
if (b.C3 == 1)
{
C3btn.Enabled = false;
}
else
{
C3btn.Enabled = true;
}
//if (b.C4 == 1) { C4btn.Enabled = false; } else { C4btn.Enabled = true; }
if (b.D1 == 1)
{
D1btn.Enabled = false;
}
else
{
D1btn.Enabled = true;
}
if (b.D2 == 1)
{
D2btn.Enabled = false;
}
else
{
D2btn.Enabled = true;
}
if (b.D3 == 1)
{
D3btn.Enabled = false;
}
else
{
D3btn.Enabled = true;
}
//if (b.D4 == 1) { D4btn.Enabled = false; } else { D4btn.Enabled = true; }
if (b.E1 == 1)
{
E1btn.Enabled = false;
}
else
{
E1btn.Enabled = true;
}
if (b.E2 == 1)
{
E2btn.Enabled = false;
}
else
{
E2btn.Enabled = true;
}
if (b.E3 == 1)
{
E3btn.Enabled = false;
}
else
{
E3btn.Enabled = true;
}
//if (b.E4 == 1) { E4btn.Enabled = false; } else { E4btn.Enabled = true; }
if (b.F1 == 1)
{
F1btn.Enabled = false;
}
else
{
F1btn.Enabled = true;
}
if (b.F2 == 1)
{
F2btn.Enabled = false;
}
else
{
F2btn.Enabled = true;
}
if (b.F3 == 1)
{
F3btn.Enabled = false;
}
else
{
F3btn.Enabled = true;
}
//if (b.F4 == 1) { F4btn.Enabled = false; } else { F4btn.Enabled = true; }
if (b.G1 == 1)
{
G1btn.Enabled = false;
}
else
{
G1btn.Enabled = true;
}
if (b.G2 == 1)
{
G2btn.Enabled = false;
}
else
{
G2btn.Enabled = true;
}
if (b.G3 == 1)
{
G3btn.Enabled = false;
}
else
{
G3btn.Enabled = true;
}
//if (b.G4 == 1) { G4btn.Enabled = false; } else { G4btn.Enabled = true; }
if (b.H1 == 1)
{
H1btn.Enabled = false;
}
else
{
H1btn.Enabled = true;
}
if (b.H2 == 1)
{
H2btn.Enabled = false;
}
else
{
H2btn.Enabled = true;
}
if (b.H3 == 1)
{
H3btn.Enabled = false;
}
else
{
H3btn.Enabled = true;
}
//if (b.H4 == 1) { H4btn.Enabled = false; } else { H4btn.Enabled = true; }
}
else if (b.Type == "Non-AC")
{
acseatpanel.Visible = false;
nonacseatpanel.Visible = true;
if (b.A1 == 1)
{
A1Button.Enabled = false;
}
else
{
A1Button.Enabled = true;
}
if (b.A2 == 1)
{
A2Button.Enabled = false;
}
else
{
A2Button.Enabled = true;
}
if (b.A3 == 1)
{
A3Button.Enabled = false;
}
else
{
A3Button.Enabled = true;
}
if (b.A4 == 1)
{
A4Button.Enabled = false;
}
else
{
A4Button.Enabled = true;
}
if (b.B1 == 1)
{
B1Button.Enabled = false;
}
else
{
B1Button.Enabled = true;
}
if (b.B2 == 1)
{
B2Button.Enabled = false;
}
else
{
B2Button.Enabled = true;
}
if (b.B3 == 1)
{
B3Button.Enabled = false;
}
else
{
B3Button.Enabled = true;
}
if (b.B4 == 1)
{
B4Button.Enabled = false;
}
else
{
B4Button.Enabled = true;
}
if (b.C1 == 1)
{
C1Button.Enabled = false;
}
else
{
C1Button.Enabled = true;
}
if (b.C2 == 1)
{
C2Button.Enabled = false;
}
else
{
C2Button.Enabled = true;
}
if (b.C3 == 1)
{
C3Button.Enabled = false;
}
else
{
C3Button.Enabled = true;
}
if (b.C4 == 1)
{
C4Button.Enabled = false;
}
else
{
C4Button.Enabled = true;
}
if (b.D1 == 1)
{
D1Button.Enabled = false;
}
else
{
D1Button.Enabled = true;
}
if (b.D2 == 1)
{
D2Button.Enabled = false;
}
else
{
D2Button.Enabled = true;
}
if (b.D3 == 1)
{
D3Button.Enabled = false;
}
else
{
D3Button.Enabled = true;
}
if (b.D4 == 1)
{
D4Button.Enabled = false;
}
else
{
D4Button.Enabled = true;
}
if (b.E1 == 1)
{
E1Button.Enabled = false;
}
else
{
E1Button.Enabled = true;
}
if (b.E2 == 1)
{
E2Button.Enabled = false;
}
else
{
E2Button.Enabled = true;
}
if (b.E3 == 1)
{
E3Button.Enabled = false;
}
else
{
E3Button.Enabled = true;
}
if (b.E4 == 1)
{
E4Button.Enabled = false;
}
else
{
E4Button.Enabled = true;
}
if (b.F1 == 1)
{
F1Button.Enabled = false;
}
else
{
F1Button.Enabled = true;
}
if (b.F2 == 1)
{
F2Button.Enabled = false;
}
else
{
F2Button.Enabled = true;
}
if (b.F3 == 1)
{
F3Button.Enabled = false;
}
else
{
F3Button.Enabled = true;
}
if (b.F4 == 1)
{
F4Button.Enabled = false;
}
else
{
F4Button.Enabled = true;
}
if (b.G1 == 1)
{
G1Button.Enabled = false;
}
else
{
G1Button.Enabled = true;
}
if (b.G2 == 1)
{
G2Button.Enabled = false;
}
else
{
G2Button.Enabled = true;
}
if (b.G3 == 1)
{
G3Button.Enabled = false;
}
else
{
G3Button.Enabled = true;
}
if (b.G4 == 1)
{
G4Button.Enabled = false;
}
else
{
G4Button.Enabled = true;
}
if (b.H1 == 1)
{
H1Button.Enabled = false;
}
else
{
H1Button.Enabled = true;
}
if (b.H2 == 1)
{
H2Button.Enabled = false;
}
else
{
H2Button.Enabled = true;
}
if (b.H3 == 1)
{
H3Button.Enabled = false;
}
else
{
H3Button.Enabled = true;
}
if (b.H4 == 1)
{
H4Button.Enabled = false;
}
else
{
H4Button.Enabled = true;
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
int busIdExist = BusRepo.SearchBusId(this.rtxtPhn.ToString());
if (this.invisibleBusNoText.Text != "") //this is for update purpose
{
//string busNumber = this.Bus.BusNo;
if (!UpdateFillEntity())
{
return;
}
else
{
UpdateFillEntity();
if (this.Bus.TypeId == "Non AC")
{
this.Bus.TypeId = "NON-AC";
}
this.Bus.TypeId = BusTypeRepo.GetBusTypeForBus(this.Bus.TypeId);
bool updateSignal = BusRepo.Update(this.Bus, this.invisibleBusNoText.Text);
if (updateSignal)
{
MessageBox.Show("Bus Updated Successuflly!!");
ClearBusInput();
this.invisibleBusNoText.Text = "";
this.FillBusDataGridView();
}
}
}
else //this is for insert purpose
{
if (!FillEntity())
{
return;
}
else if (FillEntity())
{
int checkBusNumberExist = BusRepo.CheckBusNumber(this.Bus.BusNo);
if (checkBusNumberExist == 1)
{
MessageBox.Show("The Bus Number already Exists. Create a New One!");
}
else
{
if (this.Bus.TypeId == "Non AC")
{
this.Bus.TypeId = "NON-AC";
}
this.Bus.TypeId = BusTypeRepo.GetBusTypeForBus(this.Bus.TypeId);
bool insertSignal = BusRepo.Insert(this.Bus);
if (insertSignal)
{
MessageBox.Show("Bus Created Successuflly!!");
ClearBusInput();
this.FillBusDataGridView();
}
}
}
}
}
