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