public AirlineProfile()
{
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_name_to_countryid.Add(country.Name, country.Id);
}
foreach (Country country in countries)
{
map_countryid_to_name.Add(country.Id, country);
}
CreateMap <AirlineDTO, AirlineCompany>().ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.Id))
.ForMember(dest => dest.Name, opt => opt.MapFrom(src => src.Name))
.ForMember(dest => dest.Country_Id, opt => opt.MapFrom(src => map_name_to_countryid[src.Country_Name]))
.ForMember(dest => dest.User_Id, opt => opt.MapFrom(src => src.User_Id))
.ForMember(dest => dest.User, opt => opt.MapFrom(src => src.User))
.ReverseMap()
.ForPath(dest => dest.Id, opt => opt.MapFrom(src => src.Id))
.ForPath(dest => dest.Name, opt => opt.MapFrom(src => src.Name))
.ForPath(dest => dest.Country_Name, opt => opt.MapFrom(src => map_countryid_to_name[src.Country_Id].Name))
.ForPath(dest => dest.User_Id, opt => opt.MapFrom(src => src.User_Id))
.ForPath(dest => dest.User, opt => opt.MapFrom(src => src.User));
}
public AirlineFlightProfile()
{
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_countryid_to_name.Add(country.Id, country);
}
foreach (Country country in countries)
{
map_name_to_countryid.Add(country.Name, country.Id);
}
IList <AirlineCompany> airlines = airlineDAOPGSQL.GetAll();
foreach (AirlineCompany airline in airlines)
{
map_company_name_to_company.Add(airline.Name, airline);
}
CreateMap <Flight, AirlineFlightDTO>().ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.Id))
.ForMember(dest => dest.AirlineCompanyName, opt => opt.MapFrom(src => src.Airline_Company.Name))
.ForMember(dest => dest.OrigionCountry, opt => opt.MapFrom(src => map_countryid_to_name[src.Origin_Country_Id].Name))
.ForMember(dest => dest.DestinationCountry, opt => opt.MapFrom(src => map_countryid_to_name[src.Destination_Country_Id].Name))
.ForMember(dest => dest.Departure_Time, opt => opt.MapFrom(src => src.Departure_Time))
.ForMember(dest => dest.Landing_Time, opt => opt.MapFrom(src => src.Landing_Time))
.ForMember(dest => dest.RemainingTickets, opt => opt.MapFrom(src => src.Remaining_Tickets))
.ReverseMap()
.ForPath(dest => dest.Airline_Company_Id, opt => opt.MapFrom(src => map_company_name_to_company[src.AirlineCompanyName].Id))
.ForPath(dest => dest.Origin_Country_Id, opt => opt.MapFrom(src => map_name_to_countryid[src.OrigionCountry]))
.ForPath(dest => dest.Destination_Country_Id, opt => opt.MapFrom(src => map_name_to_countryid[src.DestinationCountry]))
.ForPath(dest => dest.Airline_Company, opt => opt.MapFrom(src => map_company_name_to_company[src.AirlineCompanyName]));
}
public AirlineReducedProfile()
{
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_countryid_to_name.Add(country.Id, country);
}
CreateMap <AirlineCompany, AirlineReducedDTO>().ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.Id))
.ForMember(dest => dest.Name, opt => opt.MapFrom(src => src.Name))
.ForMember(dest => dest.Country_Name, opt => opt.MapFrom(src => map_countryid_to_name[src.Country_Id].Name));
}
public static string returnNameFromId(long id)
{
CountryDAOPGSQL countryDAOPGSQL = new CountryDAOPGSQL();
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
if (country.Id == id)
{
return(country.Name);
}
}
return(null);
}
public static long ReturnIdFromName(string name)
{
CountryDAOPGSQL countryDAOPGSQL = new CountryDAOPGSQL();
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
if (country.Name == name)
{
return(country.Id);
}
}
return(0);
}
public AirlineCompanyProfile()
{
List <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_country_id_to_name.Add(country.ID, country.Name);
}
CreateMap <AirlineCompanies, AirlineCompanyDTO>().ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.ID))
.ForMember(dest => dest.CompanyName, opt => opt.MapFrom(src => src.Name))
.ForMember(dest => dest.CountryName, opt => opt.MapFrom(src => map_country_id_to_name[src.CountryId]))
.ForMember(dest => dest.UserId, opt => opt.MapFrom(src => src.UserId))
.ForMember(dest => dest.User, opt => opt.MapFrom(src => src.User));
}
public CustomerFlightProfile()
{
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_countryid_to_name.Add(country.Id, country);
}
foreach (Country country in countries)
{
map_name_to_countryid.Add(country.Name, country.Id);
}
CreateMap <Flight, CustomerFlightDTO>().ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.Id))
.ForMember(dest => dest.AirlineCompanyName, opt => opt.MapFrom(src => src.Airline_Company.Name))
.ForMember(dest => dest.OrigionCountry, opt => opt.MapFrom(src => map_countryid_to_name[src.Origin_Country_Id].Name))
.ForMember(dest => dest.DestinationCountry, opt => opt.MapFrom(src => map_countryid_to_name[src.Destination_Country_Id].Name))
.ForMember(dest => dest.Departure_Time, opt => opt.MapFrom(src => src.Departure_Time))
.ForMember(dest => dest.Landing_Time, opt => opt.MapFrom(src => src.Landing_Time))
.ReverseMap();
}
public FlightProfile()
{
List <AirlineCompanies> airlineCompanies = AirlineCompaniesDAOPGSQL.GetAll();
foreach (AirlineCompanies airline in airlineCompanies)
{
map_airlineCompany_id_to_name.Add(airline.ID, airline.Name);
}
List <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_country_id_to_name.Add(country.ID, country.Name);
}
CreateMap <Flights, FlightDTO>().ForMember(dest => dest.ID, opt => opt.MapFrom(src => src.ID))
.ForMember(dest => dest.AirlineCompanyName, opt => opt.MapFrom(src => map_airlineCompany_id_to_name[src.AirlineCompanyId]))
.ForMember(dest => dest.OriginCountryName, opt => opt.MapFrom(src => map_country_id_to_name[src.OriginCountryId]))
.ForMember(dest => dest.DestinationCountryName, opt => opt.MapFrom(src => map_country_id_to_name[src.DestinationCountryId]))
.ForMember(dest => dest.DepartureTime, opt => opt.MapFrom(src => src.DepartureTime))
.ForMember(dest => dest.LandingTime, opt => opt.MapFrom(src => src.LandingTime))
.ForMember(dest => dest.RemainingTickets, opt => opt.MapFrom(src => src.RemainingTickets));
}
public TicketProfile()
{
IList <Country> countries = countryDAOPGSQL.GetAll();
foreach (Country country in countries)
{
map_countryid_to_name.Add(country.Id, country);
}
CreateMap <Ticket, TicketDTO>().ForMember(dest => dest.Id, opt => opt.MapFrom(src => src.Id))
.ForMember(dest => dest.Flight_Id, opt => opt.MapFrom(src => src.Flight_Id))
.ForMember(dest => dest.AirlineCompanyName, opt => opt.MapFrom(src => src.Flight.Airline_Company.Name))
.ForMember(dest => dest.OrigionCountry, opt => opt.MapFrom(src => map_countryid_to_name[src.Flight.Origin_Country_Id].Name))
.ForMember(dest => dest.DestinationCountry, opt => opt.MapFrom(src => map_countryid_to_name[src.Flight.Destination_Country_Id].Name))
.ForMember(dest => dest.Departure_Time, opt => opt.MapFrom(src => src.Flight.Departure_Time))
.ForMember(dest => dest.Landing_Time, opt => opt.MapFrom(src => src.Flight.Landing_Time))
.ForMember(dest => dest.First_Name, opt => opt.MapFrom(src => src.Customer.First_Name))
.ForMember(dest => dest.Last_Name, opt => opt.MapFrom(src => src.Customer.Last_Name))
.ForMember(dest => dest.Address, opt => opt.MapFrom(src => src.Customer.Address))
.ForMember(dest => dest.Phone_No, opt => opt.MapFrom(src => src.Customer.Phone_No))
.ReverseMap();
}