private void BUS_Insert_btn_Click(object sender, EventArgs e)
{
Validation_Class v = new Validation_Class();
if (v.Is_Empty(EngineNo_TB.Text) && v.Check_Name(Manufacturer_TB.Text) && v.Check_Name(Model_TB.Text))
{
if (v.IsPositiveNumber(ModelYear_TB.Text))
{
int modelYear = Convert.ToInt32(ModelYear_TB.Text);
if (modelYear < 2010 || modelYear > 2021)
{
Message_Form message = new Message_Form();
message.Title("Please Enter Model Year");
message.Title_Color(Color.Red);
message.Extra_Message("Between 2010 and 2021");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
if (v.Two_Dates(DateTime.Today, RDate_Picker.Value) && v.Check_Name(Department_TB.Text) && v.Is_Empty(License_TB.Text))
{
string engineNO = EngineNo_TB.Text;
string mac = Manufacturer_TB.Text;
string model = Model_TB.Text;
DateTime Rdate = RDate_Picker.Value;
string department = Department_TB.Text;
string type = Type_CB.SelectedItem.ToString();
string licnece = License_TB.Text;
int seats = Convert.ToInt32(Seats_Numeric.Value);
int result = controller.Insert_Bus(modelYear, engineNO, mac, model, Rdate, department, licnece, type, seats);
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Inserting this Bus");
message.Title_Color(Color.Red);
message.Show();
}
else
{
Message_Form message = new Message_Form();
Object id = controller.Last_Bus_ID();
message.Title("Bus was added with ID = " + id.ToString());
message.Show();
}
}
}
}
}
private void BUS_Delete_btn_Click(object sender, EventArgs e)
{
if (Bus == null)
{
Message_Form message = new Message_Form();
message.Title("Please Enter a Valid License Number");
message.Title_Color(Color.Red);
message.Show();
return;
}
Object Count;
if (Bus.Rows[0][8].ToString() == "Rent")
{
Count = controller.Search_Bus_In_Rent(Convert.ToInt32(Bus.Rows[0][0]));
if (Convert.ToInt32(Count) > 0)
{
Message_Form message = new Message_Form();
message.Title("Cannot Delete this Bus Beacuse");
message.Title_Color(Color.Red);
message.Extra_Message("It has a Rent Contract");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
}
else
{
Count = controller.Search_Bus_In_AD(Convert.ToInt32(Bus.Rows[0][0]));
if (Convert.ToInt32(Count) > 0)
{
Message_Form message = new Message_Form();
message.Title("Cannot Delete this Bus Beacuse");
message.Title_Color(Color.Red);
message.Extra_Message("It has a AD Contract");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
Count = controller.Search_Bus_In_WeeklyTrip(Convert.ToInt32(Bus.Rows[0][0]));
if (Convert.ToInt32(Count) > 0)
{
Message_Form message = new Message_Form();
message.Title("Cannot Delete this Bus Beacuse");
message.Title_Color(Color.Red);
message.Extra_Message("There is Upcoming Trips with this Bus");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
}
int result = controller.Delete_Bus(Bus.Rows[0][7].ToString());
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Deleting this Bus");
message.Title_Color(Color.Red);
message.Show();
}
else
{
Message_Form message = new Message_Form();
message.Title("The Bus is Deleted Successfully");
message.Show();
}
}
private void Weekly_Update_btn_Click(object sender, EventArgs e)
{
Validation_Class v = new Validation_Class();
if (v.Check_Name(Start_Point_tb.Text) && v.Check_Name(End_Point_tb.Text) && v.IsPositiveNumber(PriceAns_tb.Text))
{
Start = Start_Point_tb.Text;
End = End_Point_tb.Text;
Price = Convert.ToInt32(PriceAns_tb.Text);
Day = DayAns_CB.SelectedItem.ToString();
Time = TimeAns_Picker.Value.TimeOfDay;
if (v.PhoneNumber(Driver_Phone_tb.Text))
{
if (Av == 1)
{
if (Phone == Driver_Phone_tb.Text)
{
int result = controller.Update_Weeklytrip(Start, End, WeekTripID, -1
, Price, Day, Time, Av);
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Updating this Weekly Trip");
message.Title_Color(Color.Red);
message.Show();
}
else
{
this.Close();
Message_Form message = new Message_Form();
Object id = controller.Last_WeeklyTrip_ID();
message.Title("Weekly Trip was Updated Successfully");
message.Show();
}
}
else
{
DataTable Driver = controller.Search_Driver(Driver_Phone_tb.Text);
if (Driver == null)
{
Message_Form message = new Message_Form();
message.Title("The Driver is not Found");
message.Title_Color(Color.Red);
message.Show();
return;
}
else
{
int driverid = Convert.ToInt32(Driver.Rows[0][0].ToString());
DataTable DriverTrips = controller.Search_Weekly_Trips_Driver(driverid, Day);
if (DriverTrips != null)
{
if (DriverTrips.Rows.Count > 1)
{
Message_Form message = new Message_Form();
message.Title("The Driver already make two Trips on this day");
message.Title_Color(Color.Red);
message.Show();
return;
}
else if (DriverTrips.Rows.Count == 1)
{
TimeSpan t = Convert.ToDateTime(DriverTrips.Rows[0][5].ToString()).TimeOfDay;
TimeSpan constant = new TimeSpan(5, 0, 0);
TimeSpan a = t.Add(constant);
TimeSpan s = t.Subtract(constant);
if (Time < a && Time > s)
{
Message_Form message = new Message_Form();
message.Title("The Driver already make Trips in");
message.Title_Color(Color.Red);
message.Extra_Message("the same day and the time is not Sufficent");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
if (Start != DriverTrips.Rows[0][2].ToString() || End != DriverTrips.Rows[0][1].ToString())
{
Message_Form message = new Message_Form();
message.Title("The Driver already make Trips in");
message.Title_Color(Color.Red);
message.Extra_Message("Another Place at the same day");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
}
}
int result = controller.Update_Weeklytrip(Start, End, WeekTripID, driverid, Price, Day, Time, Av);
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Updating this Weekly Trip");
message.Title_Color(Color.Red);
message.Show();
}
else
{
this.Close();
Message_Form message = new Message_Form();
Object id = controller.Last_WeeklyTrip_ID();
message.Title("Weekly Trip was Updated Successfully");
message.Show();
}
}
}
}
else
{
int result = controller.Update_Weeklytrip(Start, End, WeekTripID, 0, Price, Day, Time, Av);
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Updating this Weekly Trip");
message.Title_Color(Color.Red);
message.Show();
}
else
{
this.Close();
Message_Form message = new Message_Form();
Object id = controller.Last_WeeklyTrip_ID();
message.Title("Weekly Trip was Updated Successfully");
message.Show();
}
}
}
}
}
private void Weekly_Insert_btn_Click(object sender, EventArgs e)
{
string start, end, day;
TimeSpan time;
int price;
int Available;
Validation_Class v = new Validation_Class();
if (v.Check_Name(Start_Point_tb.Text) && v.Check_Name(End_Point_tb.Text) && v.IsPositiveNumber(PriceAns_tb.Text))
{
if (Start_Point_tb.Text == End_Point_tb.Text)
{
Message_Form message = new Message_Form();
message.Title("Start Point Can't be the same as the End Point");
message.Title_Color(Color.Red);
message.Show();
return;
}
start = Start_Point_tb.Text;
end = End_Point_tb.Text;
day = DayAns_CB.Text;
time = TimeAns_Picker.Value.TimeOfDay;
price = Convert.ToInt32(PriceAns_tb.Text);
if (Available_CheckBox.Checked == true)
{
Available = 0;
int result = controller.Insert_WeeklyTrip_WithoutDriver(start, end, day, time, price, Available);
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Inserting this Weekly Trip");
message.Title_Color(Color.Red);
message.Extra_Message("There is another WeeklyTrip with Same Paramters");
message.Show();
return;
}
else
{
Message_Form message = new Message_Form();
Object id = controller.Last_WeeklyTrip_ID();
message.Title("Weekly Trip was added with ID = " + id.ToString());
message.Extra_Message("NOTE: This weekly trip has no Driver");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
}
else if (v.PhoneNumber(Driver_Phone_tb.Text))
{
Available = 1;
DataTable Driver = controller.Search_Driver(Driver_Phone_tb.Text);
if (Driver == null)
{
Message_Form message = new Message_Form();
message.Title("The Driver is not Found");
message.Title_Color(Color.Red);
message.Show();
return;
}
else
{
int driverid = Convert.ToInt32(Driver.Rows[0][0].ToString());
DataTable DriverTrips = controller.Search_Weekly_Trips_Driver(driverid, day);
if (DriverTrips != null)
{
if (DriverTrips.Rows.Count > 1)
{
Message_Form message = new Message_Form();
message.Title("The Driver already make two Trips on this day");
message.Title_Color(Color.Red);
message.Show();
return;
}
else if (DriverTrips.Rows.Count == 1)
{
TimeSpan t = Convert.ToDateTime(DriverTrips.Rows[0][5].ToString()).TimeOfDay;
TimeSpan constant = new TimeSpan(5, 0, 0);
TimeSpan a = t.Add(constant);
TimeSpan s = t.Subtract(constant);
if (time < a && time > s)
{
Message_Form message = new Message_Form();
message.Title("The Driver already make Trips in");
message.Title_Color(Color.Red);
message.Extra_Message("the same day and the time is not Sufficent");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
if (start != DriverTrips.Rows[0][2].ToString() || end != DriverTrips.Rows[0][1].ToString())
{
Message_Form message = new Message_Form();
message.Title("The Driver already make Trips in");
message.Title_Color(Color.Red);
message.Extra_Message("Another Place at the same day");
message.Extra_Message_Color(Color.Red);
message.Show();
return;
}
}
}
int result = controller.Insert_WeeklyTrip_WithDriver(start, end, driverid, day, time, price, Available);
if (result == 0)
{
Message_Form message = new Message_Form();
message.Title("There was an Error Inserting this Weekly Trip");
message.Title_Color(Color.Red);
message.Extra_Message("There is another WeeklyTrip with Same Paramters");
message.Show();
return;
}
else
{
Message_Form message = new Message_Form();
Object id = controller.Last_WeeklyTrip_ID();
message.Title("Weekly Trip was added with ID = " + id.ToString());
message.Show();
return;
}
}
}
}
}