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