//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;
}