//Add to DB - Override used on first login when HttpContext is unavailable public void LogApplicationUsageFirstLogin(int applicationEventID, string clientSubUnitGuid, string travelerGuid, string additionalInformation, string cardIdentifier, int?creditCardTypeID, bool eventStatus, string systemUserGuid) { /* * applicationEventID * 3 Exit Application * 7 System User Logged In * 8 System User Viewed Credit Card * 11 Create Credit Card * 12 Update Credit Card * 13 Delete Credit Card * 14 Add Role * 15 Remove Role * 16 Application Error */ HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); db.spDesktopDataAdmin_InsertApplicationUsage_v1( Settings.ApplicationName(), Settings.ApplicationVersion(), null, GetComputerName(), systemUserGuid, null, null, applicationEventID, clientSubUnitGuid, travelerGuid, additionalInformation, cardIdentifier, creditCardTypeID, eventStatus ); }
//Update Team public void UpdateLocationAddress(Location location, Address address) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; HierarchyDC db2 = new HierarchyDC(Settings.getConnectionString()); db2.spDesktopDataAdmin_UpdateLocationAddress_v1( location.LocationId, location.LocationName, location.CountryRegionId, location.VersionNumber, address.FirstAddressLine, address.SecondAddressLine, address.CityName, address.CountyName, address.StateProvinceCode, address.LatitudeDecimal, address.LongitudeDecimal, address.MappingQualityCode, address.PostalCode, address.ReplicatedFromClientMaintenanceFlag, address.CountryCode, adminUserGuid ); }
//Delete Item public void Delete(CreditCard creditCard) { LogRepository logRepository = new LogRepository(); string computerName = logRepository.GetComputerName(); string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; using (TransactionScope ts = TransactionUtils.CreateTransactionScope()) { using (ccdbDC creditCardDatabase = new ccdbDC(ConfigurationManager.ConnectionStrings["CreditCardDatabase"].ConnectionString)) { creditCardDatabase.spDesktopDataAdmin_DeleteCreditCard_v1(creditCard.CreditCardToken); } using (HierarchyDC desktopDatabase = new HierarchyDC(Settings.getConnectionString())) { desktopDatabase.spDesktopDataAdmin_DeleteClientTopUnitCreditCard_v1( creditCard.CreditCardId, adminUserGuid, creditCard.VersionNumber, Settings.ApplicationName(), Settings.ApplicationVersion(), null, computerName, null, null, 13, null, null, null ); } ts.Complete(); } }
//Where Used: TransactionFeeClientFeeGroup public TransactionFeeCarHotel IsTransactionFeeCarHotel(int transactionFeeId) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); var result = (from n in db.spDesktopDataAdmin_SelectTransactionFeeCarHotel_v1(transactionFeeId) select new TransactionFeeCarHotel { TransactionFeeId = n.TransactionFeeId, ProductName = n.ProductName, TransactionFeeDescription = n.TransactionFeeDescription, PolicyLocationName = n.PolicyLocationName, TravelIndicatorDescription = n.TravelIndicatorDescription, BookingSourceDescription = n.BookingSourceDescription, BookingOriginationDescription = n.BookingOriginationDescription, ChargeTypeDescription = n.ChargeTypeDescription, TransactionTypeCode = n.TransactionTypeCode, FeeCategory = n.FeeCategory, TravelerClassCode = n.TravelerClassCode, SupplierName = n.SupplierName, MinimumFeeCategoryQuantity = n.MinimumFeeCategoryQuantity, MaximumFeeCategoryQuantity = n.MaximumFeeCategoryQuantity, MinimumTicketPrice = n.MinimumTicketPrice, MaximumTicketPrice = n.MaximumTicketPrice, TicketPriceCurrencyCode = n.TicketPriceCurrencyCode, IncursGSTFlag = n.IncursGSTFlag, TripTypeClassificationDescription = n.TripTypeClassificationDescription, EnabledDate = n.EnabledDate, ExpiryDate = n.ExpiryDate, FeeAmount = n.FeeAmount, FeePercent = n.FeePercent, FeeCurrencyCode = n.FeeCurrencyCode }).FirstOrDefault(); return(result); }
public CreditCard GetCreditCardClientTopUnit(int creditCardId) { //CreditCardClientTopUnit differes from other CreditCards as it has no link table, the Id is stored in the CreditCard table HierarchyDC db2 = new HierarchyDC(Settings.getConnectionString()); return(db2.CreditCards.SingleOrDefault(c => (c.CreditCardId == creditCardId))); }
public ActionResult DefaultProfileIdentifierExist(string systemUserGuid) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); string result = db.fnDesktopDataAdmin_GetSystemUserDefaultProfile_v1(systemUserGuid).ToString(); return(Json(result)); }
//Where Used: TransactionFeeClientFeeGroup public TransactionFeeVM IsTransactionFeeAir(int transactionFeeId) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); TransactionFeeAir transactionFeeAir = new TransactionFeeAir(); PolicyRouting policyRouting = new PolicyRouting(); TransactionFeeAirRepository transactionFeeAirRepository = new TransactionFeeAirRepository(); transactionFeeAir = transactionFeeAirRepository.GetItem(transactionFeeId); PolicyRoutingRepository policyRoutingRepository = new PolicyRoutingRepository(); policyRouting = policyRoutingRepository.GetPolicyRouting((int)transactionFeeAir.PolicyRoutingId); policyRoutingRepository.EditPolicyRouting(policyRouting); TransactionFeeVM transactionFeeVM = new TransactionFeeVM(); transactionFeeVM.TransactionFee = transactionFeeAir; transactionFeeVM.Name = policyRouting.Name; transactionFeeVM.FromGlobalFlag = policyRouting.FromGlobalFlag; transactionFeeVM.FromCode = policyRouting.FromCode; transactionFeeVM.ToGlobalFlag = policyRouting.ToGlobalFlag; transactionFeeVM.ToCode = policyRouting.ToCode; transactionFeeVM.RoutingViceVersaFlag = policyRouting.RoutingViceVersaFlag; return(transactionFeeVM); /* var result = (from n in db.spDesktopDataAdmin_SelectTransactionFeeAir_v1(transactionFeeId) * select * new TransactionFeeAir * { * TransactionFeeId = n.TransactionFeeId, * ProductName = n.ProductName, * TransactionFeeDescription = n.TransactionFeeDescription, * TravelIndicatorDescription = n.TravelIndicatorDescription, * BookingSourceDescription = n.BookingSourceDescription, * BookingOriginationDescription = n.BookingOriginationDescription, * ChargeTypeDescription = n.ChargeTypeDescription, * TransactionTypeCode = n.TransactionTypeCode, * FeeCategory = n.FeeCategory, * TravelerClassCode = n.TravelerClassCode, * SupplierName = n.SupplierName, * MinimumFeeCategoryQuantity = n.MinimumFeeCategoryQuantity, * MaximumFeeCategoryQuantity = n.MaximumFeeCategoryQuantity, * MinimumTicketPrice = n.MinimumTicketPrice, * MaximumTicketPrice = n.MaximumTicketPrice, * TicketPriceCurrencyCode = n.TicketPriceCurrencyCode, * IncursGSTFlag = n.IncursGSTFlag, * TripTypeClassificationDescription = n.TripTypeClassificationDescription, * EnabledDate = n.EnabledDate, * ExpiryDate = n.ExpiryDate, * FeeAmount = n.FeeAmount, * FeePercent = n.FeePercent, * FeeCurrencyCode = n.FeeCurrencyCode, * PolicyRoutingId = n.PolicyRoutingId * }).FirstOrDefault(); * return result;*/ }
//Where Used: Team public City IsValidCityCode(string cityCode) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); return((from n in db.Cities where n.CityCode.Equals(cityCode) select n).FirstOrDefault()); }
//Where Used: Team public TravelPort IsValidTravelPortCode(string travelPortCode) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); return((from n in db.TravelPorts where n.TravelPortCode.Equals(travelPortCode) select n).FirstOrDefault()); }
//get the parent Product of a SubProduct public Product GetSubProductProduct(int subProductId) { HierarchyDC db2 = new HierarchyDC(Settings.getConnectionString()); Product product = new Product(); product.ProductId = db.SubProducts.First(a => a.SubProductId == subProductId).ProductId; product.ProductName = db2.Products.First(a => a.ProductId == product.ProductId).ProductName; return(product); }
//Check if current user has Write Access to a SystemUser //Updated to allow an LoggedIn user to alter other SystemUsers //the only 2 fields that can be edited are Location+Language // public bool HasWriteAccessToSystemUser(string id) // { //string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; //var result = (bool)db.fnDesktopDataAdmin_GetWriteAccessToSystemUser_v1(id, adminUserGuid); //return result; //return true; // } //Check if current user has Write Access to SystemUsers Roles //Based on MaintenanceAdminRole public AdministratorRoleHierarchyLevelTypeSystemUser GetUserRole(int aId, int hId, string userGuid) { HierarchyDC db1 = new HierarchyDC(Settings.getConnectionString()); return(db1.AdministratorRoleHierarchyLevelTypeSystemUsers.SingleOrDefault( c => (c.SystemUserGuid == userGuid && c.AdministratorRoleId == aId && c.HierarchyLevelTypeId == hId ))); }
//Delete From DB public void DeleteLocationAddress(Location location) { HierarchyDC db2 = new HierarchyDC(Settings.getConnectionString()); string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db2.spDesktopDataAdmin_DeleteLocation_v1( location.LocationId, adminUserGuid, location.VersionNumber ); }
//similar to GetAvailableServicingOptions but we only have CSU GUID public List <ServicingOption> GetAvailableServicingOptionsClientSubUnit(string clientSubUnitGuid) { HierarchyDC db2 = new HierarchyDC(Settings.getConnectionString()); return((from n in db2.spDDAWizard_SelectClientSubUnitAvailableServicingOptions_v1(clientSubUnitGuid) select new ServicingOption { ServicingOptionId = n.ServicingOptionId, ServicingOptionName = n.ServicingOptionName }).ToList()); }
//Get the 3 HFLF OPtions that exist for a groupId public List <ServicingOption> GetServicingOptionsHFLFSelectList(int servicingOptionGroupId) { HierarchyDC db2 = new HierarchyDC(Settings.getConnectionString()); return((from n in db2.spDesktopDataAdmin_SelectServicingOptionsHFLF_v1(servicingOptionGroupId) select new ServicingOption { ServicingOptionId = n.ServicingOptionId, ServicingOptionName = n.ServicingOptionName }).ToList()); }
//Where Used: ClientWizard.Policies public Country IsValidCountry(string countryName) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); CountryRepository supplierRepository = new CountryRepository(); var result = (from n in db.Countries where n.CountryName.Equals(countryName) select n).FirstOrDefault(); return(result); }
//Delete From DB public void Delete(Team team) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; HierarchyDC teamDC = new HierarchyDC(Settings.getConnectionString()); teamDC.spDesktopDataAdmin_DeleteTeam_v1( team.TeamId, adminUserGuid, team.VersionNumber ); }
//Add Data From Linked Tables for Display /*public void EditForDisplay(CreditCardClientAccount creditCardClientAccount) * { * CreditCardRepository creditCardRepository = new CreditCardRepository(); * CreditCard creditCard = new CreditCard(); * creditCard = creditCardRepository.GetCreditCard(creditCardClientAccount.CreditCardId); * if (creditCard != null) * { * creditCardClientAccount.CreditCardHolderName = creditCard.CreditCardHolderName; * } * * ClientAccountRepository clientAccountRepository = new ClientAccountRepository(); * ClientAccount clientAccount = new ClientAccount(); * clientAccount = clientAccountRepository.GetClientAccount(creditCardClientAccount.ClientAccountNumber, creditCardClientAccount.SourceSystemCode); * if (clientAccount != null) * { * creditCardClientAccount.ClientAccountName = clientAccount.ClientAccountName; * } * * } */ //Add CreditCard for ClientAccount public void Add(CreditCard creditCard, string can, string ssc) { LogRepository logRepository = new LogRepository(); string computerName = logRepository.GetComputerName(); string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; string maskedCreditCardNumber = creditCard.CreditCardNumber.Substring(creditCard.CreditCardNumber.Length - 4).PadLeft(creditCard.CreditCardNumber.Length, '*'); string maskedCVVNumber = (!string.IsNullOrEmpty(creditCard.CVV)) ? new string('*', creditCard.CVV.Length) : string.Empty; string creditCardToken = ""; //Valid To Date Should Be End Of Month DateTime creditCardValidTo = new DateTime(creditCard.CreditCardValidTo.Year, creditCard.CreditCardValidTo.Month, 1).AddMonths(1).AddDays(-1); using (TransactionScope ts = TransactionUtils.CreateTransactionScope()) { using (ccdbDC creditCardDatabase = new ccdbDC(ConfigurationManager.ConnectionStrings["CreditCardDatabase"].ConnectionString)) { creditCardDatabase.spDesktopDataAdmin_InsertCreditCard_v1(creditCard.CreditCardNumber, creditCard.CVV, ref creditCardToken); } using (HierarchyDC desktopDatabase = new HierarchyDC(Settings.getConnectionString())) { desktopDatabase.spDesktopDataAdmin_InsertClientAccountCreditCard_v1( ssc, can, creditCardToken, maskedCreditCardNumber, maskedCVVNumber, creditCard.CreditCardValidFrom, creditCardValidTo, creditCard.CreditCardIssueNumber, creditCard.CreditCardHolderName, creditCard.CreditCardVendorCode, creditCard.ClientTopUnitGuid, creditCard.CreditCardTypeId, creditCard.ProductId, creditCard.SupplierCode, adminUserGuid, Settings.ApplicationName(), Settings.ApplicationVersion(), null, computerName, null, null, creditCard.ClientSubUnitGuid, null, null ); } ts.Complete(); } }
//Get PseudoCityOrOfficeIds by GDSCode based on SystemUser and logged in user public List <ValidPseudoCityOrOfficeIdJSON> GetSystemUserPseudoCityOrOfficeIdsByGDSCode(string systemUserGuid, string gdsCode) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; return((from n in db.fnDesktopDataAdmin_SelectSystemUserValidPseudoCityOrOfficeIds_v1(systemUserGuid, gdsCode, adminUserGuid).OrderBy(x => x.PseudoCityOrOfficeId) select new ValidPseudoCityOrOfficeIdJSON { PseudoCityOrOfficeId = n.PseudoCityOrOfficeId.ToString().Trim(), GDSCode = n.GDSCode } ).ToList()); }
//Where Used: PolicyAirVendorGroupItem public List <PolicyRoutingJSON> IsValidPolicyRoutingFromTo(string fromTo, string codeType) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); var result = from n in db.fnDesktopDataAdmin_SelectPolicyRoutingFromTo_v1() where n.Code.Equals(fromTo) && n.CodeType.Equals(codeType) select new PolicyRoutingJSON { Code = n.Code, Name = n.Name, Parent = n.Parent, CodeType = n.CodeType }; return(result.ToList()); }
//Where Used: MerchantFeeClientFeeGroup public MerchantFee IsMerchantFee(int merchantFeeId) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); var result = (from n in db.spDesktopDataAdmin_SelectMerchantFee_v1(merchantFeeId) select new MerchantFee { CountryName = n.CountryName, CreditCardVendorName = n.CreditCardVendorName, MerchantFeePercent = n.MerchantFeePercent, ProductName = n.ProductName, SupplierName = n.SupplierName }).FirstOrDefault(); return(result); }
//Edit CreditCard public void Edit(CreditCardEditable creditCard) { LogRepository logRepository = new LogRepository(); string computerName = logRepository.GetComputerName(); string maskedCVVNumber = creditCard.MaskedCVVNumber; string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; //Valid To Date Should Be End Of Month (Removed v19.0.1 for MNG Cards that expire mid month) //DateTime creditCardValidTo = new DateTime(creditCard.CreditCardValidTo.Year, creditCard.CreditCardValidTo.Month, 1).AddMonths(1).AddDays(-1); if (creditCard.MaskedCVVNumber == null && creditCard.CVV != null) { maskedCVVNumber = new string('*', creditCard.CVV.Length); using (ccdbDC creditCardDatabase = new ccdbDC(ConfigurationManager.ConnectionStrings["CreditCardDatabase"].ConnectionString)) { creditCardDatabase.spDesktopDataAdmin_UpdateCreditCardCVVNumber_v1(creditCard.CreditCardToken, creditCard.CVV); } } using (HierarchyDC desktopDatabase = new HierarchyDC(Settings.getConnectionString())) { desktopDatabase.spDesktopDataAdmin_UpdateCreditCard_v1( creditCard.CreditCardId, creditCard.CreditCardValidFrom, creditCard.CreditCardValidTo, creditCard.CreditCardIssueNumber, creditCard.CreditCardHolderName, creditCard.CreditCardTypeId, creditCard.ProductId, creditCard.SupplierCode, maskedCVVNumber, adminUserGuid, creditCard.VersionNumber, Settings.ApplicationName(), Settings.ApplicationVersion(), null, computerName, null, null, creditCard.ClientSubUnitGuid, creditCard.TravelerTypeGuid, null ); } }
//Where Used: Third Party User public bool IsValidPartner(int?partnerId, string partnerName) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); var result = (from n in db.Partners where n.PartnerName.Equals(partnerName) && n.PartnerId == partnerId select n).FirstOrDefault(); if (result != null) { return(true); } else { return(false); } }
//Where Used: ClientWizard.Policies public Country IsValidAdminUserCountry(string countryName) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); CountryRepository supplierRepository = new CountryRepository(); string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; var result = (from n in db.spDesktopDataAdmin_SelectSystemUserCountry_v1(countryName, adminUserGuid) select new Country { CountryCode = n.CountryCode, CountryName = n.CountryName }).FirstOrDefault(); //var result = (from n in db.spDesktopDataAdmin_SelectSystemUserCountry_v1(countryName, adminUserGuid) // n).FirstOrDefault(); return(result); }
//Where Used: Location //checks if country is valid based on users LocationRole public Location IsValidLocation(string locationName) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); var l = (from n in db.Locations where (n.LocationName == locationName) select n).FirstOrDefault(); if (l != null) { Location location = new Location(); location.LocationId = l.LocationId; RolesRepository rolesRepository = new RolesRepository(); if (rolesRepository.HasWriteAccessToLocation(location.LocationId)) { return(location); //return after one item added } } return(null); //return empty list }
//Where Used: Location //checks if country is valid based on users LocationRole public Country IsValidCountryWithLocations(string countryName) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); HierarchyRepository hierarchyRepository = new HierarchyRepository(); RolesRepository rolesRepository = new RolesRepository(); //gives a list of locations for the country var locations = from c in db.Countries join cr in db.CountryRegions on c.CountryCode equals cr.CountryCode join loc in db.Locations on cr.CountryRegionId equals loc.CountryRegionId into outer from loc in outer.DefaultIfEmpty() where ((c.CountryName == countryName)) select loc; List <Country> countries = new List <Country>(); int?locationId; foreach (Location loc in locations.ToList()) // Loop through List with foreach { if (loc == null) { locationId = null; } else { locationId = loc.LocationId; } if (rolesRepository.HasWriteAccessToLocation(locationId)) { Country country = new Country(); country = (from c in db.Countries where c.CountryName == countryName select c).FirstOrDefault(); //countries.Add(loc.CountryRegion.Country); return(country); //return after one item added } } return(null); //return empty list }
//Update Team public void UpdateTeam(Team team) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; HierarchyDC teamDC = new HierarchyDC(Settings.getConnectionString()); teamDC.spDesktopDataAdmin_UpdateTeam_v1( team.TeamId, team.TeamName, team.TeamEmail, team.TeamPhoneNumber, team.TeamQueue, team.TeamTypeCode, team.CityCode, team.HierarchyType, team.HierarchyCode, adminUserGuid, team.VersionNumber ); }
/// <summary> /// Validate GDS Command Format against the database /// </summary> /// <param name="GDSCommandFormat"></param> /// <param name="GDSCode"></param> /// <returns></returns> public string IsValidGDSCommandFormat(string GDSCommandFormat, string GDSCode) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); string TID = null; switch (GDSCode) { case "1G": case "1V": TID = (from n in db.ClientProfileTravelportGDSFormats where n.DefaultGDSCommandFormat == GDSCommandFormat && n.GDSCode == GDSCode select n.TravelIndustryDesignatorValue).FirstOrDefault(); break; default: return("true"); //Don't validate yet } return((TID != null) ? "true" : "false"); }
//Add to DB public int AddTeam(Team team) { string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; int? teamId = -1; HierarchyDC teamDC = new HierarchyDC(Settings.getConnectionString()); teamDC.spDesktopDataAdmin_InsertTeam_v1( ref teamId, team.TeamName, team.TeamEmail, team.TeamPhoneNumber, team.TeamQueue, team.TeamTypeCode, team.CityCode, team.HierarchyType, team.HierarchyCode, adminUserGuid ); return((int)teamId); }
//Add to DB public void LogApplicationUsage(int applicationEventID, string clientSubUnitGuid, string travelerGuid, string additionalInformation, string cardIdentifier, int?creditCardTypeID, bool eventStatus) { /* * applicationEventID * 3 Exit Application * 7 System User Logged In * 8 System User Viewed Credit Card * 11 Create Credit Card * 12 Update Credit Card * 13 Delete Credit Card * 14 Add Role * 15 Remove Role * 16 Application Error */ HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); //These items are the same for every event string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0]; db.spDesktopDataAdmin_InsertApplicationUsage_v1( Settings.ApplicationName(), Settings.ApplicationVersion(), null, GetComputerName(), adminUserGuid, null, null, applicationEventID, clientSubUnitGuid, travelerGuid, additionalInformation, cardIdentifier, creditCardTypeID, eventStatus ); }
//Where Used: APISCountry //trying to insert this item, must check if already exists //if available return true, if already exists return false public bool IsValidAPISCountries(string originCountryCode, string destinationCountryCode) { HierarchyDC db = new HierarchyDC(Settings.getConnectionString()); List <APISCountry> apisCountries = new List <APISCountry>(); var result = from n in db.APISCountries where n.OriginCountryCode.Trim().Equals(originCountryCode) && n.DestinationCountryCode.Equals(destinationCountryCode) select n; apisCountries = result.ToList(); if (apisCountries.Count > 0) { return(false); //already in use } else { return(true); } }