void showAllByPassport()
{
Passenger passenger = new Passenger();
List <Passenger> passengerlist;
PassengerServices passengerServices = new PassengerServices();
String passportno = searchTextbox.Text;
passenger.Passport_No = passportno;
passengerlist = passengerServices.GetListByPassport(passenger);
passengerGridView.DataSource = passengerlist;
passengerGridView.Columns[2].Width = 200;
passengerGridView.Columns[2].HeaderText = "Name";
passengerGridView.Columns[1].Visible = false;
//passengerGridView.Columns[2].HeaderText = "Passport No";
passengerGridView.Columns[0].Visible = false;
passengerGridView.Columns[3].Visible = false;
passengerGridView.Columns[4].Visible = false;
passengerGridView.Columns[5].Visible = false;
passengerGridView.Columns[6].Visible = false;
passengerGridView.Columns[7].Visible = false;
passengerGridView.Columns[8].Visible = false;
passengerGridView.Columns[9].Visible = false;
passengerGridView.Columns[10].Visible = false;
passengerGridView.Columns[11].Visible = false;
}
void showAllByName()
{
Passenger passenger = new Passenger();
List <Passenger> passengerlist;
PassengerServices passengerServices = new PassengerServices();
String agentname = agentGridView.CurrentRow.Cells[0].Value.ToString();
passenger.Agent_name = agentname;
passengerlist = passengerServices.GetListByAgent(passenger);
passengerGridView.DataSource = passengerlist;
passengerGridView.Columns[2].Width = 200;
passengerGridView.Columns[2].HeaderText = "Name";
passengerGridView.Columns[1].Width = 200;
passengerGridView.Columns[1].HeaderText = "Passport No";
passengerGridView.Columns[0].Visible = false;
passengerGridView.Columns[3].Visible = false;
passengerGridView.Columns[4].Visible = false;
passengerGridView.Columns[5].Visible = false;
passengerGridView.Columns[6].Visible = false;
passengerGridView.Columns[7].Visible = false;
passengerGridView.Columns[8].Visible = false;
passengerGridView.Columns[9].Visible = false;
passengerGridView.Columns[10].Visible = false;
passengerGridView.Columns[11].Visible = false;
// passengerGridView.Columns[12].Visible = true;
}
private void deletepassengergridview_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
Passenger passenger = new Passenger();
PassengerServices passengerServices = new PassengerServices();
String passportNo = deletepassengergridview.CurrentRow.Cells[2].Value.ToString();
passenger.Passport_No = passportNo;
if (passengerServices.Remove(passenger) == 1)
{
MessageBox.Show("Successfully Deleted");
}
}
private void passengergridview_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
Passenger passenger = new Passenger();
PassengerServices passengerServices = new PassengerServices();
String passportNo = passengergridview.CurrentRow.Cells[2].Value.ToString();
passenger.Passport_No = passportNo;
PassengerDetails passengerDetails = new PassengerDetails(passengerServices.GetByPassport(passenger));
this.Hide();
passengerDetails.Closed += (s, args) => this.Close();
passengerDetails.Show();
}
private void passengerGridView_CellClick(object sender, DataGridViewCellEventArgs e)
{
Passenger passenger = new Passenger();
PassengerServices passengerServices = new PassengerServices();
String passportno = searchTextbox.Text;
passenger.Passport_No = passportno;
UpdatePassengerDetails updatepasengerdetails = new UpdatePassengerDetails(passengerServices.GetByPassport(passenger));
this.Hide();
updatepasengerdetails.Closed += (s, args) => this.Close();
updatepasengerdetails.Show();
}
private void updatePassenger()
{
Passenger passenger = new Passenger();
if (passportTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Passport Number.");
}
else
{
if (nameTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Name.");
}
else
{
if (dateofbirthTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Date Of Birth.");
}
else
{
if (addressTextBox.Text.ToString() == "")
{
MessageBox.Show("Enter Address.");
}
else
{
if (expireDateTextBox.ToString() == "")
{
MessageBox.Show("Enter Expire Date.");
}
else
{
if (entryDateTextBox.ToString() == "")
{
MessageBox.Show("Enter Entry Date.");
}
else
{
try
{
passenger.Passport_No = passportTextBox.Text;
}
catch (Exception)
{
MessageBox.Show("Already Exist.");
}
passenger.Name = nameTextBox.Text;
passenger.Date_of_birth = dateofbirthTextBox.Text;
passenger.Address = addressTextBox.Text;
passenger.Fathers_name = FathersNameTextBox.Text;
passenger.Mobile_No = mobileNoTextBox.Text;
passenger.Expire_date = expireDateTextBox.Text;
passenger.Entry_Date = entryDateTextBox.Text;
passenger.Agent_name = AgentNameComboBox.Text;
passenger.Company_Name = CompanyNameComboBox.Text;
passenger.Serial_no = SerialNoTextBox.Text;
passenger.Status = StatusComboBox.Text;
PassengerServices passengerservice = new PassengerServices();
if (passengerservice.Update(passenger) == 1)
{
MessageBox.Show("Successfully Inserted");
}
}
}
}
}
}
}
}
