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 } } }