//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyAirMissedSavingsThresholdGroupItemLanguage policyAirMissedSavingsThresholdGroupItemLanguage)
{
//Add LanguageName
if (policyAirMissedSavingsThresholdGroupItemLanguage.LanguageCode != null)
{
LanguageRepository languageRepository = new LanguageRepository();
Language language = new Language();
language = languageRepository.GetLanguage(policyAirMissedSavingsThresholdGroupItemLanguage.LanguageCode);
if (language != null)
{
policyAirMissedSavingsThresholdGroupItemLanguage.LanguageName = language.LanguageName;
}
}
//Add PolicyGroupName
PolicyAirMissedSavingsThresholdGroupItemRepository policyAirMissedSavingsThresholdGroupItemRepository = new PolicyAirMissedSavingsThresholdGroupItemRepository();
PolicyAirMissedSavingsThresholdGroupItem policyAirMissedSavingsThresholdGroupItem = new PolicyAirMissedSavingsThresholdGroupItem();
policyAirMissedSavingsThresholdGroupItem = policyAirMissedSavingsThresholdGroupItemRepository.GetPolicyAirMissedSavingsThresholdGroupItem(policyAirMissedSavingsThresholdGroupItemLanguage.PolicyAirMissedSavingsThresholdGroupItemId);
if (policyAirMissedSavingsThresholdGroupItem != null)
{
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyAirMissedSavingsThresholdGroupItem.PolicyGroupId);
//policyAirMissedSavingsThresholdGroupItemRepository.EditItemForDisplay(policyAirMissedSavingsThresholdGroupItem);
policyAirMissedSavingsThresholdGroupItemLanguage.PolicyGroupName = policyGroup.PolicyGroupName;
policyAirMissedSavingsThresholdGroupItemLanguage.PolicyGroupId = policyAirMissedSavingsThresholdGroupItem.PolicyGroupId;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelCapRateGroupItem policyHotelCapRateGroupItem)
{
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyHotelCapRateGroupItem.PolicyGroupId);
policyHotelCapRateGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//Currency
if (policyHotelCapRateGroupItem.CurrencyCode != null)
{
string currencyCode = policyHotelCapRateGroupItem.CurrencyCode;
CurrencyRepository currencyRepository = new CurrencyRepository();
Currency currency = new Currency();
currency = currencyRepository.GetCurrency(currencyCode);
policyHotelCapRateGroupItem.CurrencyName = currency.Name;
}
//PolicyLocation
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(policyHotelCapRateGroupItem.PolicyLocationId);
if (policyLocation != null)
{
policyHotelCapRateGroupItem.PolicyLocation = policyLocation.PolicyLocationName;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyCountryGroupItem policyCountryGroupItem)
{
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyCountryGroupItem.PolicyGroupId);
policyCountryGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//PolicyCountryStatus
if (policyCountryGroupItem.PolicyCountryStatusId != null)
{
int policyCountryStatusId = (int)policyCountryGroupItem.PolicyCountryStatusId;
PolicyCountryStatusRepository policyCountryStatusRepository = new PolicyCountryStatusRepository();
PolicyCountryStatus policyCountryStatus = new PolicyCountryStatus();
policyCountryStatus = policyCountryStatusRepository.GetPolicyCountryStatus(policyCountryStatusId);
if (policyCountryStatus != null)
{
policyCountryGroupItem.PolicyCountryStatusDescription = policyCountryStatus.PolicyCountryStatusDescription;
}
}
//CountryName
CountryRepository countryRepository = new CountryRepository();
Country country = new Country();
country = countryRepository.GetCountry(policyCountryGroupItem.CountryCode);
if (country != null)
{
policyCountryGroupItem.CountryName = country.CountryName;
}
}
//Export Items to CSV
public byte[] Export(int id)
{
StringBuilder sb = new StringBuilder();
//Add Headers
List <string> headers = new List <string>();
headers.Add("Policy Group Name");
headers.Add("City Name");
headers.Add("City Code");
headers.Add("PolicyCityStatusDescription");
headers.Add("Enabled Flag");
headers.Add("Enabled Date");
headers.Add("Expiry Date");
headers.Add("Travel Date Valid From");
headers.Add("Travel Date Valid To");
headers.Add("Inherit From Parent Flag");
headers.Add("Creation TimeStamp");
headers.Add("Last Update Time Stamp");
headers.Add("Advice");
sb.AppendLine(String.Join(",", headers.Select(x => x.ToString()).ToArray()));
//Add Items
List <PolicyCityGroupItem> policyCityGroupItems = db.PolicyCityGroupItems.Where(x => x.PolicyGroupId == id).ToList();
foreach (PolicyCityGroupItem item in policyCityGroupItems)
{
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(item.PolicyGroupId);
string PolicyGroupName = policyGroup.PolicyGroupName;
int adviceCount = 0;
string date_format = "MM/dd/yy HH:mm";
string short_date_format = "yyyy/MM/dd";
sb.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12}",
!string.IsNullOrEmpty(PolicyGroupName) ? PolicyGroupName : "",
!string.IsNullOrEmpty(item.City.Name) ? item.City.Name : "",
!string.IsNullOrEmpty(item.CityCode) ? item.CityCode : "",
!string.IsNullOrEmpty(item.PolicyCityStatus.PolicyCityStatusDescription) ? item.PolicyCityStatus.PolicyCityStatusDescription: "",
item.EnabledFlag == true ? "True" : "False",
item.EnabledDate.HasValue ? item.EnabledDate.Value.ToString(short_date_format) : "",
item.ExpiryDate.HasValue ? item.ExpiryDate.Value.ToString(short_date_format) : "",
item.TravelDateValidFrom.HasValue ? item.TravelDateValidFrom.Value.ToString(short_date_format) : "",
item.TravelDateValidTo.HasValue ? item.TravelDateValidTo.Value.ToString(short_date_format) : "",
item.InheritFromParentFlag == true ? "True" : "False",
item.CreationTimestamp.HasValue ? item.CreationTimestamp.Value.ToString(date_format) : "",
item.LastUpdateTimestamp.HasValue ? item.LastUpdateTimestamp.Value.ToString(date_format) : "",
adviceCount > 0 ? "True" : "False"
);
sb.Append(Environment.NewLine);
}
return(Encoding.ASCII.GetBytes(sb.ToString()));
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelPropertyGroupItem policyHotelPropertyGroupItem)
{
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyHotelPropertyGroupItem.PolicyGroupId);
policyHotelPropertyGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//PolicyHotelStatus
if (policyHotelPropertyGroupItem.PolicyHotelStatusId != null)
{
int policyHotelStatusId = (int)policyHotelPropertyGroupItem.PolicyHotelStatusId;
PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository();
PolicyHotelStatus policyHotelStatus = new PolicyHotelStatus();
policyHotelStatus = policyHotelStatusRepository.GetPolicyHotelStatus(policyHotelStatusId);
policyHotelPropertyGroupItem.PolicyHotelStatus = policyHotelStatus.PolicyHotelStatusDescription;
}
//HarpHotel
HarpHotelRepository harpHotelRepository = new HarpHotelRepository();
HarpHotel harpHotel = new HarpHotel();
harpHotel = harpHotelRepository.GetHarpHotel(policyHotelPropertyGroupItem.HarpHotelId);
if (harpHotel != null)
{
policyHotelPropertyGroupItem.HarpHotelName = harpHotel.HarpHotelName;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyAirParameterGroupItem policyAirParameterGroupItem)
{
//populate new PolicyAirParameterGroupItem with PolicyGroupName
if (policyAirParameterGroupItem.PolicyGroupId != 0)
{
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyAirParameterGroupItem.PolicyGroupId);
policyAirParameterGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyHotelVendorGroupItem policyHotelVendorGroupItem)
{
//PolicyHotelStatusDescription
if (policyHotelVendorGroupItem.PolicyHotelStatusId != null)
{
int policyHotelStatusId = (int)policyHotelVendorGroupItem.PolicyHotelStatusId;
PolicyHotelStatusRepository policyHotelStatusRepository = new PolicyHotelStatusRepository();
PolicyHotelStatus policyHotelStatus = new PolicyHotelStatus();
policyHotelStatus = policyHotelStatusRepository.GetPolicyHotelStatus(policyHotelStatusId);
policyHotelVendorGroupItem.PolicyHotelStatus = policyHotelStatus.PolicyHotelStatusDescription;
}
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyHotelVendorGroupItem.PolicyGroupId);
policyHotelVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
policyHotelVendorGroupItem.PolicyGroupId = policyGroup.PolicyGroupId;
//SupplierName
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(policyHotelVendorGroupItem.SupplierCode, policyHotelVendorGroupItem.ProductId);
if (supplier != null)
{
policyHotelVendorGroupItem.SupplierName = supplier.SupplierName;
}
//PolicyLocationName
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(policyHotelVendorGroupItem.PolicyLocationId);
if (policyLocation != null)
{
policyHotelVendorGroupItem.PolicyLocationName = policyLocation.PolicyLocationName;
}
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(policyHotelVendorGroupItem.ProductId);
if (product != null)
{
policyHotelVendorGroupItem.ProductName = product.ProductName;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicySupplierServiceInformation policySupplierServiceInformation)
{
//PolicySupplierServiceInformationType
PolicySupplierServiceInformationTypeRepository policySupplierServiceInformationTypeRepository = new PolicySupplierServiceInformationTypeRepository();
PolicySupplierServiceInformationType policySupplierServiceInformationType = new PolicySupplierServiceInformationType();
policySupplierServiceInformationType = policySupplierServiceInformationTypeRepository.GetPolicySupplierServiceInformationType(policySupplierServiceInformation.PolicySupplierServiceInformationTypeId);
if (policySupplierServiceInformationType != null)
{
policySupplierServiceInformation.PolicySupplierServiceInformationTypeDescription = policySupplierServiceInformationType.PolicySupplierServiceInformationTypeDescription;
}
//Supplier
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(policySupplierServiceInformation.SupplierCode, policySupplierServiceInformation.ProductId);
if (supplier != null)
{
policySupplierServiceInformation.SupplierName = supplier.SupplierName;
}
//Product
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(policySupplierServiceInformation.ProductId);
if (product != null)
{
policySupplierServiceInformation.ProductName = product.ProductName;
}
//EnabledFlag is nullable
if (policySupplierServiceInformation.EnabledFlag != true)
{
policySupplierServiceInformation.EnabledFlag = false;
}
policySupplierServiceInformation.EnabledFlagNonNullable = (bool)policySupplierServiceInformation.EnabledFlag;
//PolicyGroup
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policySupplierServiceInformation.PolicyGroupId);
policySupplierServiceInformation.PolicyGroupName = policyGroup.PolicyGroupName;
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyAirCabinGroupItem policyAirCabinGroupItem)
{
//populate new PolicyAirCabinGroupItem with PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyAirCabinGroupItem.PolicyGroupId);
if (policyGroup != null)
{
policyAirCabinGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
}
//AirlineCabin
AirlineCabinRepository airlineCabinRepository = new AirlineCabinRepository();
AirlineCabin airlineCabin = new AirlineCabin();
airlineCabin = airlineCabinRepository.GetAirlineCabin(policyAirCabinGroupItem.AirlineCabinCode);
if (airlineCabin != null)
{
policyAirCabinGroupItem.AirlineCabinDefaultDescription = airlineCabin.AirlineCabinDefaultDescription;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicyCarTypeGroupItem policyCarTypeGroupItem)
{
//PolicyGroupName
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyCarTypeGroupItem.PolicyGroupId);
policyCarTypeGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
//CarStatus
PolicyCarStatusRepository policyCarStatusRepository = new PolicyCarStatusRepository();
PolicyCarStatus policyCarStatus = new PolicyCarStatus();
policyCarStatus = policyCarStatusRepository.GetPolicyCarStatus(policyCarTypeGroupItem.PolicyCarStatusId);
policyCarTypeGroupItem.PolicyCarStatusDescription = policyCarStatus.PolicyCarStatusDescription;
//CarType Category
CarTypeCategoryRepository carTypeCategoryRepository = new CarTypeCategoryRepository();
CarTypeCategory carTypeCategory = new CarTypeCategory();
carTypeCategory = carTypeCategoryRepository.GetCarTypeCategory(policyCarTypeGroupItem.CarTypeCategoryId);
if (carTypeCategory != null)
{
policyCarTypeGroupItem.CarTypeCategoryName = carTypeCategory.CarTypeCategoryName;
}
//PolicyLocation
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(policyCarTypeGroupItem.PolicyLocationId);
if (policyLocation != null)
{
policyCarTypeGroupItem.PolicyLocation = policyLocation.PolicyLocationName;
}
}
//Add Data From Linked Tables for Display
public void EditItemForDisplay(PolicySupplierDealCode policySupplierDealCode)
{
//PolicySupplierDealCodeType
PolicySupplierDealCodeTypeRepository policySupplierDealCodeTypeRepository = new PolicySupplierDealCodeTypeRepository();
PolicySupplierDealCodeType policySupplierDealCodeType = new PolicySupplierDealCodeType();
policySupplierDealCodeType = policySupplierDealCodeTypeRepository.GetPolicySupplierDealCodeType(policySupplierDealCode.PolicySupplierDealCodeTypeId);
if (policySupplierDealCodeType != null)
{
policySupplierDealCode.PolicySupplierDealCodeTypeDescription = policySupplierDealCodeType.PolicySupplierDealCodeTypeDescription;
}
//GDS
GDSRepository gdsRepository = new GDSRepository();
GDS gds = new GDS();
gds = gdsRepository.GetGDS(policySupplierDealCode.GDSCode);
if (gds != null)
{
policySupplierDealCode.GDSName = gds.GDSName;
}
//PolicyLocation
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation((int)policySupplierDealCode.PolicyLocationId);
if (policyLocation != null)
{
policySupplierDealCode.PolicyLocationName = policyLocation.PolicyLocationName;
}
//Supplier
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(policySupplierDealCode.SupplierCode, policySupplierDealCode.ProductId);
if (supplier != null)
{
policySupplierDealCode.SupplierName = supplier.SupplierName;
}
//EnabledFlag is nullable
if (policySupplierDealCode.EnabledFlag != true)
{
policySupplierDealCode.EnabledFlag = false;
}
policySupplierDealCode.EnabledFlagNonNullable = (bool)policySupplierDealCode.EnabledFlag;
//OSIFlag is nullable
if (policySupplierDealCode.OSIFlag != true)
{
policySupplierDealCode.OSIFlag = false;
}
policySupplierDealCode.OSIFlagNonNullable = (bool)policySupplierDealCode.OSIFlag;
//Product
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(policySupplierDealCode.ProductId);
if (product != null)
{
policySupplierDealCode.ProductName = product.ProductName;
}
//PolicyGroup
PolicyGroupRepository policyGroupRepository = new PolicyGroupRepository();
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policySupplierDealCode.PolicyGroupId);
policySupplierDealCode.PolicyGroupName = policyGroup.PolicyGroupName;
//Tour Code Type
TourCodeTypeRepository tourCodeTypeRepository = new TourCodeTypeRepository();
TourCodeType tourCodeType = tourCodeTypeRepository.GetTourCodeType(policySupplierDealCode.TourCodeTypeId ?? 0);
if (tourCodeType != null)
{
policySupplierDealCode.TourCodeType = tourCodeType;
}
}
