public void UpdateTable()
{
reservationTable.Clear();
reservationTable = DBFacade.GetReservations();
for (int i = 0; i < reservationTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(reservationTable.Rows[i]["ID"].ToString());
Guid flightID = Guid.Parse(reservationTable.Rows[i]["FlightID"].ToString());
Flight flight = ServiceFactory.GetFlights().GetFlightByID(flightID);
Guid passengerID = Guid.Parse(reservationTable.Rows[i]["PassengerID"].ToString());
Passenger passenger = ServiceFactory.GetPassengers().GetPassengerByID(passengerID);
Guid staffID = Guid.Parse(reservationTable.Rows[i]["StaffID"].ToString());
Staff staff = ServiceFactory.GetStaffs().GetStaffByID(staffID);
DateTime reservationTime = DateTime.Parse(reservationTable.Rows[i]["ReservationTime"].ToString());
String cancelTimeStr = reservationTable.Rows[i]["cancelTime"].ToString();
Nullable <DateTime> cancelTime = null;
if (!cancelTimeStr.Equals(""))
{
cancelTime = DateTime.Parse(cancelTimeStr);
}
uint seatNumber = uint.Parse(reservationTable.Rows[i]["SeatNumber"].ToString());
ReservationState state = Utilities.StringToReservationState(reservationTable.Rows[i]["State"].ToString());
reservations.Add(new Reservation(ID, flight, passenger, staff, seatNumber, reservationTime, state, cancelTime));
}
}
public void UpdateFlight(Guid flightID, FlightState newState, Nullable <DateTime> newActualDepartureDate, Nullable <DateTime> newActualArrivalDate)
{
Flight f = ServiceFactory.GetFlights().GetFlightByID(flightID);
f.flightState = newState;
f.actualArrivalDate = newActualArrivalDate;
f.actualDepartureDate = newActualDepartureDate;
DBFacade.UpdateFlight(flightID, newState.ToString(), newActualDepartureDate, newActualArrivalDate);
MessageBox.Show(" بروزرسانی با موفقیت اضافه شد");
}
public void AddAirplane(String name, Guid companyID, uint capacity)
{
Airplane airplane = new Airplane(name, capacity);
ServiceFactory.GetAirplanes().AddAirplane(airplane);
Guid airplaneID = DBFacade.InsertAirplaneAndReturnID(name, companyID, capacity);
airplane.ID = airplaneID;
MessageBox.Show("هواپیما با موفقیت اضافه شد");
}
public void AddAirport(String name, Location location)
{
Airport airport = new Airport(name, location);
ServiceFactory.GetAirports().AddAirport(airport);
Guid airportID = DBFacade.InsertAirportAndReturnID(name, location);
airport.SetID(airportID);
MessageBox.Show("فرودگاه با موفقیت اضافه شد");
}
public void AddCompany(String name)
{
Company company = new Company(name);
ServiceFactory.GetCompanies().AddCompany(company);
Guid companyID = DBFacade.InsertCompanyAndReturnID(name);
company.SetID(companyID);
MessageBox.Show("شرکت با موفقیت اضافه شد");
}
private Passenger CreateAndInsertPassenger(String fName, String lName, uint age, Gender gender, String nationalCode)
{
Passenger passenger = new Passenger(fName, lName, age, gender, nationalCode);
ServiceFactory.GetPassengers().AddPassenger(passenger);
Guid passengerID = DBFacade.InsertPassengerAndReturnID(fName, lName, age, gender.ToString(), nationalCode);
passenger.SetID(passengerID);
return(passenger);
}
public void UpdateTable()
{
companies.Clear();
companyTable = DBFacade.GetCompanies();
for (int i = 0; i < companyTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(companyTable.Rows[i]["ID"].ToString());
String name = companyTable.Rows[i]["Name"].ToString();
companies.Add(new Company(ID, name));
}
}
public void UpdateTable()
{
staffTable.Clear();
staffTable = DBFacade.GetStaffs();
for (int i = 0; i < staffTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(staffTable.Rows[i]["ID"].ToString());
String fName = staffTable.Rows[i]["FirstName"].ToString();
String lName = staffTable.Rows[i]["LastName"].ToString();
Rank rank = Utilities.StringToRank(staffTable.Rows[i]["Rank"].ToString());
staffs.Add(Utilities.CreateStaff(rank, fName, lName, ID));
}
}
public void UpdateTable()
{
planeTable.Clear();
planeTable = DBFacade.GetAirplanes();
for (int i = 0; i < planeTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(planeTable.Rows[i]["ID"].ToString());
uint capacity = uint.Parse(planeTable.Rows[i]["capacity"].ToString());
String name = planeTable.Rows[i]["name"].ToString();
planes.Add(new Airplane(ID, name, capacity));
}
}
public void UpdateTable()
{
flightTable.Clear();
flightTable = DBFacade.GetFlights();
AllAirplanes allPlanes = ServiceFactory.GetAirplanes();
AllAirports allAirports = ServiceFactory.GetAirports();
for (int i = 0; i < flightTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(flightTable.Rows[i]["ID"].ToString());
Guid planeID = Guid.Parse(flightTable.Rows[i]["planeID"].ToString());
Airplane airplane = allPlanes.GetPlaneByID(planeID);
Guid originID = Guid.Parse(flightTable.Rows[i]["originAirportID"].ToString());
Airport origin = allAirports.GetAirportByID(originID);
Guid destinationID = Guid.Parse(flightTable.Rows[i]["destinationAirportID"].ToString());
Airport destination = allAirports.GetAirportByID(destinationID);
DateTime arrivalDate = DateTime.Parse(flightTable.Rows[i]["arrivalDate"].ToString());
DateTime departureDate = DateTime.Parse(flightTable.Rows[i]["departureDate"].ToString());
String actualArrivalDateStr = flightTable.Rows[i]["actualArrivalDate"].ToString();
Nullable <DateTime> actualArrivalDate = null;
if (!actualArrivalDateStr.Equals(""))
{
actualArrivalDate = DateTime.Parse(actualArrivalDateStr);
}
String actualDepartureDateStr = flightTable.Rows[i]["actualDepartureDate"].ToString();
Nullable <DateTime> actualDepartureDate = null;
if (!actualDepartureDateStr.Equals(""))
{
actualDepartureDate = DateTime.Parse(actualDepartureDateStr);
}
String flightStateStr = flightTable.Rows[i]["State"].ToString();
FlightState flightState = Utilities.StringToFlightState(flightStateStr);
uint cost = uint.Parse(flightTable.Rows[i]["Cost"].ToString());
flights.Add(new Flight(ID, airplane, origin, destination, departureDate, arrivalDate, actualDepartureDate, actualArrivalDate, flightState, cost));
}
}
public void AddFlight(Guid planeID, Guid originAirportID, Guid destinationAirportID, DateTime departureDate, DateTime arrivalDate, uint cost)
{
Airport origin = ServiceFactory.GetAirports().GetAirportByID(originAirportID);
Airport destination = ServiceFactory.GetAirports().GetAirportByID(destinationAirportID);
Airplane plane = ServiceFactory.GetAirplanes().GetPlaneByID(planeID);
Flight flight = new Flight(plane, origin, destination, departureDate, arrivalDate, cost);
ServiceFactory.GetFlights().AddFlight(flight);
Guid flightID = DBFacade.InsertFlightAndReturnID(planeID, originAirportID, destinationAirportID, departureDate, arrivalDate, cost);
flight.SetID(flightID);
MessageBox.Show("پرواز با موفقیت اضافه شد");
}
public void UpdateTable()
{
passengers.Clear();
passengerTable = DBFacade.GetPassengers();
for (int i = 0; i < passengerTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(passengerTable.Rows[i]["ID"].ToString());
string fName = passengerTable.Rows[i]["FirstName"].ToString();
string lName = passengerTable.Rows[i]["LastName"].ToString();
uint age = uint.Parse(passengerTable.Rows[i]["Age"].ToString());
Gender gender = Utilities.StringToGender(passengerTable.Rows[i]["Gender"].ToString());
string nationalCode = passengerTable.Rows[i]["NationalCode"].ToString();
passengers.Add(new Passenger(ID, fName, lName, age, gender, nationalCode));
}
}
public void UpdateTable()
{
airports.Clear();
airpotTable = DBFacade.GetAirports();
for (int i = 0; i < airpotTable.Rows.Count; i++)
{
Guid ID = Guid.Parse(airpotTable.Rows[i]["ID"].ToString());
String name = airpotTable.Rows[i]["name"].ToString();
String country = airpotTable.Rows[i]["country"].ToString();
String city = airpotTable.Rows[i]["city"].ToString();
Location location = new Location(country, city);
airports.Add(new Airport(ID, name, location));
}
}
public void AddStaff(String username, String password, String fName, String lName, Rank rank)
{
Staff staff = Utilities.CreateStaff(rank, fName, lName);
ServiceFactory.GetStaffs().AddStaff(staff);
Nullable <Guid> staffID = DBFacade.InsertNewUserAndReturnStaffID(username, password, fName, lName, rank.ToString());
if (staffID != null)
{
staff.SetID((Guid)staffID);
MessageBox.Show("کاربر با موفقیت اضافه شد");
}
else
{
MessageBox.Show("خطا در ثبت");
}
}
private void CreateAndInsertReservation(Flight flight, Passenger passenger, Staff salesman, uint seatNumber)
{
//TODO: I must set time to time inserted in DB
Reservation reservation = new Reservation(flight, passenger, salesman, seatNumber, new DateTime(), ReservationState.Resereved, null);
ServiceFactory.GetReservations().AddReservation(reservation);
Nullable <Guid> reservationID = DBFacade.InsertReservationAndReturnID(flight.GetID(), passenger.GetID(), currentStaff.GetID(), seatNumber);
if (reservationID != null)
{
reservation.SetID((Guid)reservationID);
MessageBox.Show("رزرو با موافقیت انجام شد");
}
else
{
MessageBox.Show("خطا در رزرو");
}
}
public List <bool> GetSeatsFlag(Guid flightID)
{
Flight f = ServiceFactory.GetFlights().GetFlightByID(flightID);
uint flightCapacity = f.airplane.capacity;
List <uint> freeSeats = DBFacade.GetFreeSeats(flightID);
List <bool> seatsFlag = new List <bool>((int)flightCapacity);
for (int i = 0; i < flightCapacity; ++i)
{
seatsFlag.Add(false);
foreach (uint j in freeSeats)
{
if (j == i + 1)
{
seatsFlag[i] = true;
break;
}
}
}
return(seatsFlag);
}
public void CancelReservation(Guid reservationID)
{
//ServiceFactory.GetReserations().RemoveReservationByID(reservationID);
DBFacade.CancelReservation(reservationID);
}
public bool IsUserValid(String username, String password)
{
return(DBFacade.IsUserValid(username, password));
}
private void CreateAndSetStaff(String username)
{
currentStaff = DBFacade.GetStaffByUsername(username);
}