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_Click(object sender, EventArgs e) { Validation_Class v = new Validation_Class(); if (v.IsValidEmail(Email_textbox.Text) && v.Is_Empty(Password_textbox.Text)) { DataTable employee = controllerObj.Get_Employee_byEmail(Email_textbox.Text); if (employee == null) { MessageBox.Show("There is no Employee with the Provided Email"); } else { string pass = v.Decrypt_PassWord(employee.Rows[0][5].ToString()); if (pass == Password_textbox.Text) { string type = employee.Rows[0][11].ToString(); /*Customer Service * Contract Administrator * IT Administrator * Receptionist*/ this.Hide(); if (type == "Contract Administrator") { ContractAdministrator _Administrator = new ContractAdministrator(); _Administrator.Show(); } else if (type == "IT Administrator") { ITAdministrator t_Administrator = new ITAdministrator(); t_Administrator.Show(); } else if (type == "Customer Service") { CS_Main_Functions CS = new CS_Main_Functions(this, Convert.ToInt32(employee.Rows[0][0])); CS.Show(); } else if (type == "Receptionist") { Inquiries_about_trips I = new Inquiries_about_trips(this); I.Show(); } } else { MessageBox.Show("Wrong Password"); Password_textbox.Text = ""; } } } }
private void button1_Click(object sender, EventArgs e) { Validation_Class v = new Validation_Class(); if (v.Is_Empty(textBox1.Text)) { if (Convert.ToInt32(controllerObj.CheckPromoCodeName(textBox1.Text)) == 0) { MessageBox.Show("There is no promo code with this name !"); } else { int res = controllerObj.RemovePromoCode(textBox1.Text); if (res == 1) { MessageBox.Show("Promo code is removed Successfully !"); } } } }
private void confirmAddPromo_Click(object sender, EventArgs e) { Validation_Class v = new Validation_Class(); if (v.Is_Empty(PC_name.Text) && v.IsPositiveNumber(WT_id.Text)) { if (Convert.ToInt32(controllerObj.CheckPromoCodeName(PC_name.Text)) == 1) { MessageBox.Show("This name is already taken"); } else if (Convert.ToInt32(controllerObj.CheckWTID(WT_id.Text)) == 0) { MessageBox.Show("Weekly trip ID is invalid !"); } else { controllerObj.AddPromoCode(PC_name.Text, discount.Value.ToString(), LoggedinEmployee); controllerObj.AddPromoToWT(PC_name.Text, WT_id.Text); MessageBox.Show("Promo Code is 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 } } }
private void Search_Click(object sender, EventArgs e) { Validation_Class v = new Validation_Class(); if (v.Is_Empty(location1) && v.Is_Empty(location2) && v.Is_Empty(Time_TimePicker.Text) && v.Two_Dates(DateTime.Today, Date_TimePicker.Value)) { T = controllerObj.Check(location1, location2, Date_TimePicker.Value.DayOfWeek.ToString(), Time_TimePicker.Value.TimeOfDay, Date_TimePicker.Value); if (T != null) { Trip_Price = (int)T.Rows[0][1]; ID_B = (int)T.Rows[0][0]; //if The Bus Trip was Found, Then there will be passengers in this trip Object Seatsum = controllerObj.Count_Current_seats(ID_B); DataTable Num = controllerObj.Find_Num_Of_Seats_in_the_Bus(ID_B); // check number of seats in this trip if ((int)Num.Rows[0][0] - Convert.ToInt32(Seatsum) > Seats_Numeric.Value) { MessageBox.Show("There is an available trip ,You can reserve for Passenger now "); //Calculate the total money the passenger should pay Total_Price = Trip_Price * (int)Seats_Numeric.Value; //check frist if the promo code valid for this trip or not DataTable P = controllerObj.Check_Promo_Code_Validation(PromoCode_textBox.Text, ID_B); Discount = (int)P.Rows[0][0]; if (P != null) { Total_Price = Total_Price - Convert.ToInt16(Total_Price * (Discount / 100.0)); MessageBox.Show("Promo Code is Applied succefully"); } else if (PromoCode_textBox.Text != "") { MessageBox.Show("Promo Code is not valid for this trip"); } MessageBox.Show("Total Price is " + Total_Price.ToString()); Insert_Passenger_information p = new Insert_Passenger_information(this, (int)Seats_Numeric.Value, ID_B, Total_Price); p.Show(); } else { MessageBox.Show("Sorry, but the trip is fully booked"); } } else { dT = controllerObj.Find_Weekly_Trips(location1, location2, Date_TimePicker.Value.DayOfWeek.ToString(), Time_TimePicker.Value.TimeOfDay); if (dT != null) { Trip_Price = (int)dT.Rows[0][1]; ID_W = (int)dT.Rows[0][0]; DataTable Numseats_W = controllerObj.Find_Num_Of_Seats_in_the_Bus_Using_IDW(ID_W); if ((int)Numseats_W.Rows[0][0] < Seats_Numeric.Value) { MessageBox.Show("Too much number of seats ,Can't reserve for that passenger "); } else { int result = controllerObj.Insert_Bus_Trip(Date_TimePicker.Value, ID_W); T = controllerObj.Check(location1, location2, Date_TimePicker.Value.DayOfWeek.ToString(), Time_TimePicker.Value.TimeOfDay, Date_TimePicker.Value); ID_B = (int)T.Rows[0][0]; if (result == 1) { MessageBox.Show("there is an available trip ,You can reserve for Passenger now "); //Calculate the total money the passenger should pay Total_Price = Trip_Price * (int)Seats_Numeric.Value; //check frist if the promo code valid for this trip or not DataTable P = controllerObj.Check_Promo_Code_Validation(PromoCode_textBox.Text, ID_B); if (P != null) { Discount = (int)P.Rows[0][0]; Total_Price = Total_Price - Convert.ToInt16(Total_Price * (Discount / 100.0)); MessageBox.Show("Promo Code is Applied succefully"); } else if (PromoCode_textBox.Text != "") { MessageBox.Show("Promo Code is not valid for this trip"); } MessageBox.Show("Total Price is " + Total_Price.ToString()); Insert_Passenger_information p = new Insert_Passenger_information(this, (int)Seats_Numeric.Value, ID_B, Total_Price); p.Show(); } else { MessageBox.Show("Insertion failed"); } } } else { MessageBox.Show("Sorry,There is no Trip available so You can't reserve for the passenger"); } } } }