private void Search_For_Passenger_Click_1(object sender, EventArgs e)
{
Validation_Class v = new Validation_Class();
if (v.PhoneNumber(Passenger_PhoneNumber_textBox.Text))
{
DataTable P = controllerObj.Get_Passenger_id(Passenger_PhoneNumber_textBox.Text);
if (P == null) //we need to store Passenger's information
{
Passenger_Email_textBox.Visible = true;
Passenger_Gender_comboBox.Visible = true;
label4.Visible = true;
label5.Visible = true;
label2.Visible = true;
pictureBox4.Visible = true;
pictureBox2.Visible = true;
pictureBox3.Visible = true;
panel1.Visible = true;
panel2.Visible = true;
panel3.Visible = true;
Passenger_Gender_comboBox.Visible = true;
Passenger_Name_textBox.Visible = true;
Done_Button.Visible = true;
Search_For_Passenger.Visible = false;
MessageBox.Show("It is the first time for that Passenger So Get his information first ");
}
else
{
MessageBox.Show("We have already the information of that Passenger and reservation done succesfully ");
int result = controllerObj.Insert_Passenger_Trip((int)P.Rows[0][0], Trip_Id, Num_Of_Seats, Trip_Total_Price);
}
}
}
private void complaintadding_Click(object sender, EventArgs e)
{
Validation_Class v = new Validation_Class();
if (pID.Text == "" || Tid.Text == "" || !v.Is_Empty(complaintdiscpribtion.Text))
{
MessageBox.Show("all values are required ");
}
else if (v.IsPositiveNumber(Tid.Text) && v.PhoneNumber(pID.Text))
{
DataTable passengerid = controllerObj.Get_Passenger_id(pID.Text);
if (passengerid == null)
{
MessageBox.Show("No passenger with this Phone number exists ");
}
else if (Convert.ToInt32(controllerObj.CheckTripID(Tid.Text)) == 0)
{
MessageBox.Show("No trip with this ID exists ");
}
else if (Convert.ToInt32(controllerObj.PassengerinTrip(passengerid.Rows[0][0].ToString(), Tid.Text)) == 0)
{
MessageBox.Show("This passenger is not in this Bus trip ");
}
else
{
DataTable dt1 = controllerObj.DriverOfWeeklTrip(Tid.Text);
string driverid = dt1.Rows[0][0].ToString();
int res = controllerObj.AddComplaint(Tid.Text, passengerid.Rows[0][0].ToString(), complaintdiscpribtion.Text, driverid);
if (res == 1)
{
MessageBox.Show("Complaint's added successfully !");
}
}
}
}
private void Done_Button_Click(object sender, EventArgs e)
{
Validation_Class v = new Validation_Class();
if (v.Check_Name(Passenger_Name_textBox.Text) && v.PhoneNumber(Passenger_PhoneNumber_textBox.Text) /*v.IsValidEmail(Passenger_Email_textBox.Text) &&*/)
{
int result = controllerObj.Insert_Passenger(Passenger_Name_textBox.Text, Passenger_PhoneNumber_textBox.Text, Passenger_Email_textBox.Text, Passenger_Gender_comboBox.Text);
if (result == 1)
{
MessageBox.Show("Insertion done succesfully");
Passenger_Name_textBox.Text = "";
Passenger_Email_textBox.Text = "";
Passenger_Gender_comboBox.Text = "";
DataTable P = controllerObj.Get_Passenger_id(Passenger_PhoneNumber_textBox.Text);
result = controllerObj.Insert_Passenger_Trip((int)P.Rows[0][0], Trip_Id, Num_Of_Seats, Trip_Total_Price);
Passenger_PhoneNumber_textBox.Text = "";
}
else
{
MessageBox.Show("Insertion Failed"); //shouldn't appear to the user
}
}
}