//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(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(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;
}
}
//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("Location Name");
headers.Add("Location Code");
headers.Add("Currency Name");
headers.Add("Currency Code");
headers.Add("Hotel Cap Rate Amount");
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("Tax Inclusive 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 <PolicyHotelCapRateGroupItem> policyHotelCapRateGroupItems = db.PolicyHotelCapRateGroupItems.Where(x => x.PolicyGroupId == id).ToList();
foreach (PolicyHotelCapRateGroupItem item in policyHotelCapRateGroupItems)
{
//Edit Item
EditItemForDisplay(item);
//Location
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(item.PolicyLocationId);
if (policyLocation != null)
{
policyLocationRepository.EditForDisplay(policyLocation);
}
//Advice Count
int adviceCount = 0;
PolicyHotelCapRateGroupItemLanguageRepository policyHotelCapRateGroupItemLanguageRepository = new PolicyHotelCapRateGroupItemLanguageRepository();
List <PolicyHotelCapRateGroupItemLanguage> policyHotelCapRateGroupItemLanguages = policyHotelCapRateGroupItemLanguageRepository.GetItems(item.PolicyHotelCapRateItemId);
if (policyHotelCapRateGroupItemLanguages != null)
{
adviceCount = policyHotelCapRateGroupItemLanguages.Count();
}
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},{13},{14}",
!string.IsNullOrEmpty(item.PolicyGroupName) ? item.PolicyGroupName : "",
!string.IsNullOrEmpty(policyLocation.LocationName) ? policyLocation.LocationName : "",
!string.IsNullOrEmpty(policyLocation.LocationCode) ? policyLocation.LocationCode : "",
!string.IsNullOrEmpty(item.CurrencyName) ? item.CurrencyName : "",
!string.IsNullOrEmpty(item.CurrencyCode) ? item.CurrencyCode : "",
item.CapRate.HasValue ? item.CapRate.Value.ToString() : "",
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.TaxInclusiveFlag == 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(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;
}
}
//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("Deal Code Value");
headers.Add("Deal Code Description");
headers.Add("Deal Code Type Description");
headers.Add("Location Name");
headers.Add("Location Code");
headers.Add("GDS Name ");
headers.Add("Product Name");
headers.Add("Supplier Name");
headers.Add("Supplier Code");
headers.Add("Travel Indicator Description");
headers.Add("Travel Indicator");
headers.Add("Endorsement");
headers.Add("Endorsement Override");
headers.Add("OSI 1");
headers.Add("Enabled Flag");
headers.Add("Enabled Date");
headers.Add("Expiry Date");
headers.Add("Creation TimeStamp");
headers.Add("Last Update Time Stamp");
sb.AppendLine(String.Join(",", headers.Select(x => x.ToString()).ToArray()));
//Add Items
List <PolicySupplierDealCode> policySupplierDealCodes = db.PolicySupplierDealCodes.Where(x => x.PolicyGroupId == id).ToList();
foreach (PolicySupplierDealCode item in policySupplierDealCodes)
{
//Edit Item
EditItemForDisplay(item);
//Location
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation(Int32.Parse(item.PolicyLocationId.ToString()));
if (policyLocation != null)
{
policyLocationRepository.EditForDisplay(policyLocation);
}
//TravelIndicator
TravelIndicatorRepository travelIndicatorRepository = new TravelIndicatorRepository();
TravelIndicator travelIndicator = new TravelIndicator();
if (item.TravelIndicator != null)
{
travelIndicator = travelIndicatorRepository.GetTravelIndicator(item.TravelIndicator);
}
//PolicySupplierDealCodeOSI
PolicySupplierDealCodeOSI policySupplierDealCodeOSI = null;
if (item.PolicySupplierDealCodeOSIs != null)
{
policySupplierDealCodeOSI = item.PolicySupplierDealCodeOSIs.FirstOrDefault();
}
string date_format = "MM/dd/yy HH:mm";
sb.AppendFormat("{0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19}",
!string.IsNullOrEmpty(item.PolicyGroupName) ? item.PolicyGroupName : "",
!string.IsNullOrEmpty(item.PolicySupplierDealCodeValue) ? item.PolicySupplierDealCodeValue : "",
!string.IsNullOrEmpty(item.PolicySupplierDealCodeDescription) ? item.PolicySupplierDealCodeDescription : "",
!string.IsNullOrEmpty(item.PolicySupplierDealCodeTypeDescription) ? item.PolicySupplierDealCodeTypeDescription : "",
!string.IsNullOrEmpty(policyLocation.LocationName) ? policyLocation.LocationName : "",
!string.IsNullOrEmpty(policyLocation.LocationCode) ? policyLocation.LocationCode : "",
!string.IsNullOrEmpty(item.GDSName) ? item.GDSName : "",
!string.IsNullOrEmpty(item.ProductName) ? item.ProductName : "",
!string.IsNullOrEmpty(item.SupplierName) ? item.SupplierName : "",
!string.IsNullOrEmpty(item.SupplierCode) ? item.SupplierCode : "",
//Valid when Deal Code Type = Tour Code
travelIndicator != null && !string.IsNullOrEmpty(travelIndicator.TravelIndicatorDescription) ? travelIndicator.TravelIndicatorDescription : "",
item.TravelIndicator != null && !string.IsNullOrEmpty(item.TravelIndicator) ? item.TravelIndicator : "",
item.Endorsement != null && !string.IsNullOrEmpty(item.Endorsement) ? item.Endorsement : "",
item.EndorsementOverride != null && !string.IsNullOrEmpty(item.EndorsementOverride) ? item.EndorsementOverride : "",
policySupplierDealCodeOSI != null ? policySupplierDealCodeOSI.PolicySupplierDealCodeOSIDescription : "",
item.EnabledFlag == true ? "True" : "False",
item.EnabledDate.HasValue ? item.EnabledDate.Value.ToString(date_format) : "",
item.ExpiryDate.HasValue ? item.ExpiryDate.Value.ToString(date_format) : "",
item.CreationTimestamp.HasValue ? item.CreationTimestamp.Value.ToString(date_format) : "",
item.LastUpdateTimestamp.HasValue ? item.LastUpdateTimestamp.Value.ToString(date_format) : ""
);
sb.Append(Environment.NewLine);
}
return(Encoding.ASCII.GetBytes(sb.ToString()));
}
public void EditForDisplay(TransactionFeeCarHotel transactionFee)
{
TravelIndicatorRepository travelIndicatorRepository = new TravelIndicatorRepository();
TravelIndicator travelIndicator = new TravelIndicator();
travelIndicator = travelIndicatorRepository.GetTravelIndicator(transactionFee.TravelIndicator);
if (travelIndicator != null)
{
transactionFee.TravelIndicatorDescription = travelIndicator.TravelIndicatorDescription;
}
CurrencyRepository currencyRepository = new CurrencyRepository();
Currency currency = new Currency();
currency = currencyRepository.GetCurrency(transactionFee.FeeCurrencyCode);
if (currency != null)
{
transactionFee.FeeCurrencyName = currency.Name;
}
currency = currencyRepository.GetCurrency(transactionFee.TicketPriceCurrencyCode);
if (currency != null)
{
transactionFee.TicketPriceCurrencyName = currency.Name;
}
BookingSourceRepository bookingSourceRepository = new BookingSourceRepository();
BookingSource bookingSource = new BookingSource();
bookingSource = bookingSourceRepository.GetBookingSource(transactionFee.BookingSourceCode);
if (bookingSource != null)
{
transactionFee.BookingSourceDescription = bookingSource.BookingSourceDescription;
}
BookingOriginationRepository bookingOriginationRepository = new BookingOriginationRepository();
BookingOrigination bookingOrigination = new BookingOrigination();
bookingOrigination = bookingOriginationRepository.GetBookingOrigination(transactionFee.BookingOriginationCode);
if (bookingOrigination != null)
{
transactionFee.BookingOriginationCode = bookingOrigination.BookingOriginationCode;
}
ChargeTypeRepository chargeTypeRepository = new ChargeTypeRepository();
ChargeType chargeType = new ChargeType();
chargeType = chargeTypeRepository.GetChargeType(transactionFee.ChargeTypeCode);
if (bookingOrigination != null)
{
transactionFee.ChargeTypeDescription = chargeType.ChargeTypeDescription;
}
TravelerBackOfficeTypeRepository travelerBackOfficeTypeRepository = new TravelerBackOfficeTypeRepository();
TravelerBackOfficeType travelerBackOfficeType = new TravelerBackOfficeType();
travelerBackOfficeType = travelerBackOfficeTypeRepository.GetTravelerBackOfficeType(transactionFee.TravelerClassCode);
if (travelerBackOfficeType != null)
{
transactionFee.TravelerBackOfficeTypeDescription = travelerBackOfficeType.TravelerBackOfficeTypeDescription;
}
if (transactionFee.ProductId != null)
{
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct((int)transactionFee.ProductId);
if (product != null)
{
transactionFee.ProductName = product.ProductName;
//Supplier
if (!String.IsNullOrEmpty(transactionFee.SupplierCode))
{
SupplierRepository supplierRepository = new SupplierRepository();
Supplier supplier = new Supplier();
supplier = supplierRepository.GetSupplier(transactionFee.SupplierCode, (int)transactionFee.ProductId);
if (supplier != null)
{
transactionFee.SupplierName = supplier.SupplierName;
}
}
}
}
if (transactionFee.PolicyLocationId != null)
{
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
PolicyLocation policyLocation = new PolicyLocation();
policyLocation = policyLocationRepository.GetPolicyLocation((int)transactionFee.PolicyLocationId);
if (policyLocation != null)
{
transactionFee.PolicyLocationName = policyLocation.PolicyLocationName;
}
}
//IncursGSTFlag is nullable
if (transactionFee.IncursGSTFlag != true)
{
transactionFee.IncursGSTFlag = false;
}
transactionFee.IncursGSTFlagNonNullable = (bool)transactionFee.IncursGSTFlag;
}
