// GET: View A TransactionFeeClientFeeGroup
public ActionResult View(int cid, int tid)
{
//Get Item From Database
TransactionFeeClientFeeGroup transactionFeeClientFeeGroup = new TransactionFeeClientFeeGroup();
transactionFeeClientFeeGroup = transactionFeeClientFeeGroupRepository.GetItem(cid, tid);
//Check Exists
if (transactionFeeClientFeeGroup == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
ClientFeeGroupTransactionFeeAirVM clientFeeGroupTransactionFeeAirVM = new ClientFeeGroupTransactionFeeAirVM();
ClientFeeGroup clientFeeGroup = new ClientFeeGroup();
clientFeeGroup = clientFeeGroupRepository.GetGroup(cid);
clientFeeGroupTransactionFeeAirVM.ClientFeeGroup = clientFeeGroup;
TransactionFeeAir transactionFeeAir = new TransactionFeeAir();
transactionFeeAir = transactionFeeAirRepository.GetItem(tid);
transactionFeeAirRepository.EditForDisplay(transactionFeeAir);
clientFeeGroupTransactionFeeAirVM.TransactionFeeAir = transactionFeeAir;
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = policyRoutingRepository.GetPolicyRouting((int)transactionFeeAir.PolicyRoutingId);
policyRoutingRepository.EditForDisplay(policyRouting);
clientFeeGroupTransactionFeeAirVM.PolicyRouting = policyRouting;
return(View(clientFeeGroupTransactionFeeAirVM));
}
// GET: /CreatePolicyRouting
public ActionResult CreatePolicyRouting(int id)
{
//Get PolicyAirVendorGroupItem
FareRestriction fareRestriction = new FareRestriction();
fareRestriction = fareRestrictionRepository.GetFareRestriction(id);
//Check Exists
if (fareRestriction == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToReferenceInfo())
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//populate new PolicyAirVendorGroupItem with known PolicyGroup Information
fareRestrictionRepository.EditForDisplay(fareRestriction);
PolicyRouting policyRouting = new PolicyRouting();
FareRestrictionViewModel fareRestrictionViewModel = new FareRestrictionViewModel(fareRestriction, policyRouting);
//Show 'Create' Form
return(View(fareRestrictionViewModel));
}
public void Edit(PolicyMessageGroupItemAir policyMessageGroupItemAir, PolicyRouting policyRouting)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdatePolicyMessageGroupItemAir_v1(
policyMessageGroupItemAir.PolicyMessageGroupItemId,
policyMessageGroupItemAir.PolicyMessageGroupItemName,
policyMessageGroupItemAir.SupplierCode,
policyMessageGroupItemAir.EnabledFlag,
policyMessageGroupItemAir.EnabledDate,
policyMessageGroupItemAir.ExpiryDate,
policyMessageGroupItemAir.TravelDateValidFrom,
policyMessageGroupItemAir.TravelDateValidTo,
policyRouting.Name,
policyRouting.FromGlobalFlag,
policyRouting.FromGlobalRegionCode,
policyRouting.FromGlobalSubRegionCode,
policyRouting.FromCountryCode,
policyRouting.FromCityCode,
policyRouting.FromTravelPortCode,
policyRouting.FromTraverlPortTypeId,
policyRouting.ToGlobalFlag,
policyRouting.ToGlobalRegionCode,
policyRouting.ToGlobalSubRegionCode,
policyRouting.ToCountryCode,
policyRouting.ToCityCode,
policyRouting.ToTravelPortCode,
policyRouting.ToTravelPortTypeId,
policyRouting.RoutingViceVersaFlag,
adminUserGuid,
policyMessageGroupItemAir.VersionNumber
);
}
// GET: /View
public ActionResult View(string id, string sCode, int rId = 0)
{
//Check Parameters
if (id == null || rId == null || sCode == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//Check Exists
AirlineClassCabin airlineClassCabin = new AirlineClassCabin();
airlineClassCabin = airlineClassCabinRepository.GetAirlineClassCabin(id, sCode, rId);
if (airlineClassCabin == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//
airlineClassCabinRepository.EditForDisplay(airlineClassCabin);
//add the PolicyRouting information
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = policyRoutingRepository.GetPolicyRouting(airlineClassCabin.PolicyRoutingId);
AirlineClassCabinViewModel airlineClassCabinViewModel = new AirlineClassCabinViewModel(airlineClassCabin, policyRouting);
//Show 'Create' Form
return(View(airlineClassCabinViewModel));
}
public ActionResult Delete(string id, string sCode, int rId)
{
//Check Exists
AirlineClassCabin airlineClassCabin = new AirlineClassCabin();
airlineClassCabin = airlineClassCabinRepository.GetAirlineClassCabin(id, sCode, rId);
if (airlineClassCabin == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToReferenceInfo())
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Add Linked Table Info
airlineClassCabinRepository.EditForDisplay(airlineClassCabin);
//add the PolicyRouting information
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = policyRoutingRepository.GetPolicyRouting(airlineClassCabin.PolicyRoutingId);
AirlineClassCabinViewModel airlineClassCabinViewModel = new AirlineClassCabinViewModel(airlineClassCabin, policyRouting);
//Show 'Create' Form
return(View(airlineClassCabinViewModel));
}
// GET: /View
public ActionResult View(int id)
{
//Get PolicyAirVendorGroupItem
PolicyAirVendorGroupItem policyAirVendorGroupItem = new PolicyAirVendorGroupItem();
policyAirVendorGroupItem = policyAirVendorGroupItemRepository.GetPolicyAirVendorGroupItem(id);
//Check Exists
if (policyAirVendorGroupItem == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
//populate new PolicyAirVendorGroupItem with known PolicyGroup Information
policyAirVendorGroupItemRepository.EditItemForDisplay(policyAirVendorGroupItem);
//Policy Group
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyAirVendorGroupItem.PolicyGroupId);
//add the PolicyRouting information
PolicyRouting policyRouting = policyRoutingRepository.GetPolicyRouting(policyAirVendorGroupItem.PolicyRoutingId);
policyRoutingRepository.EditForDisplay(policyRouting);
PolicyAirVendorGroupItemVM policyAirVendorGroupItemViewModel = new PolicyAirVendorGroupItemVM(policyGroup, policyAirVendorGroupItem, policyRouting);
//Show 'Create' Form
return(View(policyAirVendorGroupItemViewModel));
}
//Update in DB
public void Update(AirlineClassCabin airlineClassCabin, PolicyRouting policyRouting)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateAirlineClassCabin_v1(
airlineClassCabin.AirlineClassCode,
airlineClassCabin.SupplierCode,
airlineClassCabin.PolicyRoutingId,
airlineClassCabin.ProductId,
airlineClassCabin.AirlineCabinCode,
policyRouting.Name,
policyRouting.FromGlobalFlag,
policyRouting.FromGlobalRegionCode,
policyRouting.FromGlobalSubRegionCode,
policyRouting.FromCountryCode,
policyRouting.FromCityCode,
policyRouting.FromTravelPortCode,
policyRouting.FromTraverlPortTypeId,
policyRouting.ToGlobalFlag,
policyRouting.ToGlobalRegionCode,
policyRouting.ToGlobalSubRegionCode,
policyRouting.ToCountryCode,
policyRouting.ToCityCode,
policyRouting.ToTravelPortCode,
policyRouting.ToTravelPortTypeId,
policyRouting.RoutingViceVersaFlag,
adminUserGuid,
airlineClassCabin.VersionNumber
);
}
// GET: /View
public ActionResult View(int id)
{
//Check Exists
FareRestriction fareRestriction = new FareRestriction();
fareRestriction = fareRestrictionRepository.GetFareRestriction(id);
if (fareRestriction == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
fareRestrictionRepository.EditForDisplay(fareRestriction);
//add the PolicyRouting information
PolicyRouting policyRouting = new PolicyRouting();
if (fareRestriction.RoutingId != null)
{
policyRouting = policyRoutingRepository.GetPolicyRouting((int)fareRestriction.RoutingId);
policyRoutingRepository.EditForDisplay(policyRouting);
}
FareRestrictionViewModel fareRestrictionViewModel = new FareRestrictionViewModel(fareRestriction, policyRouting);
//Show View
return(View(fareRestrictionViewModel));
}
public TransactionFeeAirVM(TransactionFeeAir transactionFee, PolicyRouting policyRouting,
IEnumerable <SelectListItem> travelIndicators,
IEnumerable <SelectListItem> bookingSources,
IEnumerable <SelectListItem> bookingOriginations,
IEnumerable <SelectListItem> chargeTypes,
IEnumerable <SelectListItem> transactionTypes,
IEnumerable <SelectListItem> feeCategories,
IEnumerable <SelectListItem> travelerBackOfficeTypes,
IEnumerable <SelectListItem> tripTypeClassifications,
IEnumerable <SelectListItem> ticketPriceCurrencies,
IEnumerable <SelectListItem> feeCurrencies
)
{
TransactionFee = transactionFee;
PolicyRouting = policyRouting;
TravelIndicators = travelIndicators;
BookingSources = bookingSources;
ChargeTypes = chargeTypes;
BookingOriginations = bookingOriginations;
TransactionTypes = transactionTypes;
FeeCategories = feeCategories;
TravelerBackOfficeTypes = travelerBackOfficeTypes;
TripTypeClassifications = tripTypeClassifications;
TicketPriceCurrencies = ticketPriceCurrencies;
FeeCurrencies = feeCurrencies;
}
public PolicyMessageGroupItemAirVM(PolicyMessageGroupItemAir policyMessageGroupItemAir, int policyGroupId, string policyGroupName, PolicyRouting policyRouting)
{
PolicyMessageGroupItemAir = policyMessageGroupItemAir;
PolicyGroupId = policyGroupId;
PolicyGroupName = policyGroupName;
PolicyRouting = policyRouting;
}
//Edit
public void Update(PolicyAirParameterGroupItem policyAirParameterGroupItem, PolicyRouting policyRouting)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdatePolicyAirParameterGroupItem_v1(
policyAirParameterGroupItem.PolicyAirParameterGroupItemId,
policyAirParameterGroupItem.PolicyAirParameterTypeId,
policyAirParameterGroupItem.PolicyAirParameterValue,
policyAirParameterGroupItem.EnabledFlag,
policyAirParameterGroupItem.EnabledDate,
policyAirParameterGroupItem.ExpiryDate,
policyAirParameterGroupItem.TravelDateValidFrom,
policyAirParameterGroupItem.TravelDateValidTo,
policyAirParameterGroupItem.PolicyGroupId,
policyRouting.Name,
policyRouting.FromGlobalFlag,
policyRouting.FromGlobalRegionCode,
policyRouting.FromGlobalSubRegionCode,
policyRouting.FromCountryCode,
policyRouting.FromCityCode,
policyRouting.FromTravelPortCode,
policyRouting.FromTraverlPortTypeId,
policyRouting.ToGlobalFlag,
policyRouting.ToGlobalRegionCode,
policyRouting.ToGlobalSubRegionCode,
policyRouting.ToCountryCode,
policyRouting.ToCityCode,
policyRouting.ToTravelPortCode,
policyRouting.ToTravelPortTypeId,
policyRouting.RoutingViceVersaFlag,
adminUserGuid,
policyAirParameterGroupItem.VersionNumber
);
}
public ActionResult View(int id)
{
PolicyMessageGroupItemAir policyMessageGroupItemAir = new PolicyMessageGroupItemAir();
policyMessageGroupItemAir = policyMessageGroupItemAirRepository.GetPolicyMessageGroupItemAir(id);;
//Check Exists
if (policyMessageGroupItemAir == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyMessageGroupItemAir.PolicyGroupId);
PolicyMessageGroupItemAirVM policyMessageGroupItemAirVM = new PolicyMessageGroupItemAirVM();
policyMessageGroupItemAirVM.PolicyGroupName = policyGroup.PolicyGroupName;
policyMessageGroupItemAirVM.PolicyGroupId = policyGroup.PolicyGroupId;
policyMessageGroupItemAirVM.PolicyMessageGroupItemAir = policyMessageGroupItemAir;
//add the PolicyRouting information
PolicyRouting policyRouting = policyRoutingRepository.GetPolicyRouting((int)policyMessageGroupItemAir.PolicyRoutingId);
policyRoutingRepository.EditForDisplay(policyRouting);
policyMessageGroupItemAirVM.PolicyRouting = policyRouting;
return(View(policyMessageGroupItemAirVM));
}
public void Add(PolicyRouting policyRouting)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
int? policyRoutingId = new Int32();
db.spDesktopDataAdmin_InsertPolicyRouting_v1(
ref policyRoutingId,
policyRouting.Name,
policyRouting.FromGlobalFlag,
policyRouting.FromGlobalRegionCode,
policyRouting.FromGlobalSubRegionCode,
policyRouting.FromCountryCode,
policyRouting.FromCityCode,
policyRouting.FromTravelPortCode,
policyRouting.FromTraverlPortTypeId,
policyRouting.ToGlobalFlag,
policyRouting.ToGlobalRegionCode,
policyRouting.ToGlobalSubRegionCode,
policyRouting.ToCountryCode,
policyRouting.ToCityCode,
policyRouting.ToTravelPortCode,
policyRouting.ToTravelPortTypeId,
policyRouting.RoutingViceVersaFlag,
adminUserGuid
);
policyRouting.PolicyRoutingId = (int)policyRoutingId;
}
public ActionResult Delete(int id)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return View("Error");
}
//Get Item From Database
TransactionFeeAir transactionFee = new TransactionFeeAir();
transactionFee = transactionFeeAirRepository.GetItem(id);
//Check Exists
if (transactionFee == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return View("RecordDoesNotExistError");
}
TransactionFeeAirVM transactionFeeAirVM = new TransactionFeeAirVM();
transactionFeeAirRepository.EditForDisplay(transactionFee);
transactionFeeAirVM.TransactionFee = transactionFee;
PolicyRouting policyRouting = new PolicyRouting();
if (transactionFee.PolicyRoutingId != null)
{
policyRouting = policyRoutingRepository.GetPolicyRouting((int)transactionFee.PolicyRoutingId);
policyRoutingRepository.EditPolicyRouting(policyRouting);
}
transactionFeeAirVM.PolicyRouting = policyRouting;
return View(transactionFeeAirVM);
}
// GET: View A Single TransactionFeeAir
public ActionResult View(int id)
{
//Get Item From Database
TransactionFeeAir transactionFee = new TransactionFeeAir();
transactionFee = transactionFeeAirRepository.GetItem(id);
//Check Exists
if (transactionFee == null)
{
ViewData["ActionMethod"] = "ViewGet";
return View("RecordDoesNotExistError");
}
TransactionFeeAirVM transactionFeeAirVM = new TransactionFeeAirVM();
transactionFeeAirRepository.EditForDisplay(transactionFee);
transactionFeeAirVM.TransactionFee = transactionFee;
PolicyRouting policyRouting = new PolicyRouting();
if (transactionFee.PolicyRoutingId != null)
{
policyRouting = policyRoutingRepository.GetPolicyRouting((int)transactionFee.PolicyRoutingId);
policyRoutingRepository.EditPolicyRouting(policyRouting);
}
transactionFeeAirVM.PolicyRouting = policyRouting;
return View(transactionFeeAirVM);
}
//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;*/
}
// GET: Create A Single ClientFee
public ActionResult Create()
{
int productId = 1;
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return View("Error");
}
ProductRepository productRepository = new ProductRepository();
Product product = new Product();
product = productRepository.GetProduct(productId);
TransactionFeeAirVM transactionFeeVM = new TransactionFeeAirVM();
TransactionFeeAir transactionFee = new TransactionFeeAir();
transactionFee.ProductName = product.ProductName;
transactionFee.ProductId = product.ProductId;
transactionFee.IncursGSTFlagNonNullable = false;
transactionFeeVM.TransactionFee = transactionFee;
TravelIndicatorRepository travelIndicatorRepository = new TravelIndicatorRepository();
transactionFeeVM.TravelIndicators = new SelectList(travelIndicatorRepository.GetAllTravelIndicators().ToList(), "TravelIndicator1", "TravelIndicatorDescription");
BookingSourceRepository bookingSourceRepository = new BookingSourceRepository();
transactionFeeVM.BookingSources = new SelectList(bookingSourceRepository.GetAllBookingSources().ToList(), "BookingSourceCode", "BookingSourceCode");
BookingOriginationRepository bookingOriginationRepository = new BookingOriginationRepository();
transactionFeeVM.BookingOriginations = new SelectList(bookingOriginationRepository.GetAllBookingOriginations().ToList(), "BookingOriginationCode", "BookingOriginationCode");
ChargeTypeRepository chargeTypeRepository = new ChargeTypeRepository();
transactionFeeVM.ChargeTypes = new SelectList(chargeTypeRepository.GetAllChargeTypes().ToList(), "ChargeTypeCode", "ChargeTypeDescription");
TransactionTypeRepository transactionTypeRepository = new TransactionTypeRepository();
transactionFeeVM.TransactionTypes = new SelectList(transactionTypeRepository.GetAllTransactionTypes().ToList(), "TransactionTypeCode", "TransactionTypeCode");
FeeCategoryRepository feeCategoryRepository = new FeeCategoryRepository();
transactionFeeVM.FeeCategories = new SelectList(feeCategoryRepository.GetAllFeeCategories().ToList(), "FeeCategory1", "FeeCategory1");
TravelerBackOfficeTypeRepository travelerBackOfficeTypeRepository = new TravelerBackOfficeTypeRepository();
transactionFeeVM.TravelerBackOfficeTypes = new SelectList(travelerBackOfficeTypeRepository.GetAllTravelerBackOfficeTypes().ToList(), "TravelerBackOfficeTypeCode", "TravelerBackOfficeTypeDescription");
TripTypeClassificationRepository tripTypeClassificationRepository = new TripTypeClassificationRepository();
transactionFeeVM.TripTypeClassifications = new SelectList(tripTypeClassificationRepository.GetAllTripTypeClassifications().ToList(), "TripTypeClassificationId", "TripTypeClassificationDescription");
CurrencyRepository currencyRepository = new CurrencyRepository();
transactionFeeVM.TicketPriceCurrencies = new SelectList(currencyRepository.GetAllCurrencies().ToList(), "CurrencyCode", "Name");
transactionFeeVM.FeeCurrencies = new SelectList(currencyRepository.GetAllCurrencies().ToList(), "CurrencyCode", "Name");
PolicyRouting policyRouting = new PolicyRouting();
policyRouting.FromGlobalFlag = false;
policyRouting.ToGlobalFlag = false;
transactionFeeVM.PolicyRouting = policyRouting;
return View(transactionFeeVM);
}
// GET: /Create
public ActionResult Create(int id)
{
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(id);;
//Check Exists
if (policyGroup == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(id))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
PolicyAirVendorGroupItem policyAirVendorGroupItem = new PolicyAirVendorGroupItem();
//Populate List of PolicyAirStatuses
PolicyAirStatusRepository policyAirStatusRepository = new PolicyAirStatusRepository();
SelectList policyAirStatuses = new SelectList(policyAirStatusRepository.GetAllPolicyAirStatuses().ToList(), "PolicyAirStatusId", "PolicyAirStatusDescription");
ViewData["PolicyAirStatusList"] = policyAirStatuses;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName");
ViewData["ProductList"] = products;
//Populate List of AirVendorRankings
SelectList airVendorRankings = new SelectList(policyAirVendorGroupItemRepository.AirVendorRankings().ToList(), "Value", "Text", policyAirVendorGroupItem.AirVendorRanking);
ViewData["AirVendorRankings"] = airVendorRankings;
//populate new PolicyAirVendorGroupItem with known PolicyGroup Information
policyAirVendorGroupItem.PolicyGroupId = id;
policyAirVendorGroupItem.PolicyGroupName = policyGroup.PolicyGroupName;
PolicyRouting policyRouting = new PolicyRouting();
policyRouting.FromGlobalFlag = false;
policyRouting.ToGlobalFlag = false;
PolicyAirVendorGroupItemVM policyAirVendorGroupItemViewModel = new PolicyAirVendorGroupItemVM(policyGroup, policyAirVendorGroupItem, policyRouting);
//Show 'Create' Form
return(View(policyAirVendorGroupItemViewModel));
}
// GET: /View
public ActionResult View(int policyGroupId, int policyAirParameterGroupItemId, string languageCode)
{
PolicyAirParameterGroupItemLanguageVM policyAirParameterGroupItemLanguageVM = new PolicyAirParameterGroupItemLanguageVM();
//Check Item Exists
PolicyAirParameterGroupItemLanguage policyAirParameterGroupItemLanguage = new PolicyAirParameterGroupItemLanguage();
policyAirParameterGroupItemLanguage = policyAirParameterGroupItemLanguageRepository.GetItem(
policyAirParameterGroupItemId,
languageCode
);
if (policyAirParameterGroupItemLanguage == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check Policy Exists
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyGroupId);
if (policyGroup == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check PolicyAirParameterGroupItem Exists
PolicyAirParameterGroupItem policyAirParameterGroupItem = new PolicyAirParameterGroupItem();
policyAirParameterGroupItem = policyAirParameterGroupItemRepository.GetPolicyAirParameterGroupItem(policyAirParameterGroupItemId);
if (policyAirParameterGroupItem == null)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
//Policy Routing
PolicyRouting policyRouting = policyRoutingRepository.GetPolicyRouting(policyAirParameterGroupItem.PolicyRoutingId ?? 0);
if (policyRouting != null)
{
policyRoutingRepository.EditForDisplay(policyRouting);
policyAirParameterGroupItem.PolicyRouting = policyRouting;
}
//Policy Group
policyGroupRepository.EditGroupForDisplay(policyGroup);
policyAirParameterGroupItemLanguageVM.PolicyGroup = policyGroup;
policyAirParameterGroupItemLanguageVM.PolicyAirParameterGroupItem = policyAirParameterGroupItem;
policyAirParameterGroupItemLanguageVM.PolicyAirParameterGroupItemLanguage = policyAirParameterGroupItemLanguage;
return(View(policyAirParameterGroupItemLanguageVM));
}
public ClientFeeGroupTransactionFeeAirVM(TransactionFeeClientFeeGroup transactionFeeClientFeeGroup, ClientFeeGroup clientFeeGroup, TransactionFeeAir transactionFeeAir, PolicyRouting policyRouting, int feeTypeId, string feeTypeDisplayName, string feeTypeDisplayNameShort)
{
TransactionFeeClientFeeGroup = transactionFeeClientFeeGroup;
ClientFeeGroup = clientFeeGroup;
TransactionFeeAir = transactionFeeAir;
PolicyRouting = policyRouting;
FeeTypeId = feeTypeId;
FeeTypeDisplayName = feeTypeDisplayName;
FeeTypeDisplayNameShort = feeTypeDisplayNameShort;
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get PolicyAirVendorGroupItem
PolicyAirVendorGroupItem policyAirVendorGroupItem = new PolicyAirVendorGroupItem();
policyAirVendorGroupItem = policyAirVendorGroupItemRepository.GetPolicyAirVendorGroupItem(id);
//Check Exists
if (policyAirVendorGroupItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyAirVendorGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Populate List of PolicyAirStatuses
PolicyAirStatusRepository policyAirStatusRepository = new PolicyAirStatusRepository();
SelectList policyAirStatuses = new SelectList(policyAirStatusRepository.GetAllPolicyAirStatuses().ToList(), "PolicyAirStatusId", "PolicyAirStatusDescription");
ViewData["PolicyAirStatusList"] = policyAirStatuses;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName", policyAirVendorGroupItem.ProductId);
ViewData["ProductList"] = products;
//Populate List of Products
SelectList airVendorRankings = new SelectList(policyAirVendorGroupItemRepository.AirVendorRankings().ToList(), "Value", "Text", policyAirVendorGroupItem.AirVendorRanking);
ViewData["AirVendorRankings"] = airVendorRankings;
//populate new PolicyAirVendorGroupItem with known PolicyGroup Information
policyAirVendorGroupItemRepository.EditItemForDisplay(policyAirVendorGroupItem);
//Policy Group
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyAirVendorGroupItem.PolicyGroupId);
//Add the PolicyRouting information
PolicyRouting policyRouting = policyRoutingRepository.GetPolicyRouting(policyAirVendorGroupItem.PolicyRoutingId);
PolicyAirVendorGroupItemVM policyAirVendorGroupItemViewModel = new PolicyAirVendorGroupItemVM(policyGroup, policyAirVendorGroupItem, policyRouting);
//Show 'Edit' Form
return(View(policyAirVendorGroupItemViewModel));
}
// GET: /Edit
public ActionResult Edit(string id, string sCode, int?rId)
{
//Check Parameters
int policyRoutingId;
if (!Int32.TryParse(rId.ToString(), out policyRoutingId))
{
ViewData["Message"] = "Incorrect Paramters";
return(View("Error"));
}
//Check Exists
AirlineClassCabin airlineClassCabin = new AirlineClassCabin();
airlineClassCabin = airlineClassCabinRepository.GetAirlineClassCabin(id, sCode, policyRoutingId);
if (airlineClassCabin == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToReferenceInfo())
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Populate List of Languages
LanguageRepository languageRepository = new LanguageRepository();
SelectList languages = new SelectList(languageRepository.GetAllLanguages().ToList(), "LanguageCode", "LanguageName");
ViewData["LanguageList"] = languages;
//Populate List of Products
ProductRepository productRepository = new ProductRepository();
SelectList products = new SelectList(productRepository.GetAllProducts().ToList(), "ProductId", "ProductName");
ViewData["ProductList"] = products;
//Add Linked Table Info
airlineClassCabinRepository.EditForDisplay(airlineClassCabin);
//add the PolicyRouting information
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = policyRoutingRepository.GetPolicyRouting(airlineClassCabin.PolicyRoutingId);
AirlineClassCabinViewModel airlineClassCabinViewModel = new AirlineClassCabinViewModel(airlineClassCabin, policyRouting);
return(View(airlineClassCabinViewModel));
}
public ActionResult Edit(PolicyMessageGroupItemAirVM policyMessageGroupItemAirVM)
{
int policyGroupId = policyMessageGroupItemAirVM.PolicyMessageGroupItemAir.PolicyGroupId;
int policyMessageGroupItemId = policyMessageGroupItemAirVM.PolicyMessageGroupItemAir.PolicyMessageGroupItemId;
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyGroupId);;
PolicyMessageGroupItemAir policyMessageGroupItemAir = new PolicyMessageGroupItemAir();
policyMessageGroupItemAir = policyMessageGroupItemAirRepository.GetPolicyMessageGroupItemAir(policyMessageGroupItemId);;
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = policyMessageGroupItemAirVM.PolicyRouting;
//Check Exists
if (policyMessageGroupItemAir == null || policyRouting == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroupMessages(policyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Edit Routing
policyRoutingRepository.EditPolicyRouting(policyRouting);
try
{
policyMessageGroupItemAirRepository.Edit(policyMessageGroupItemAirVM.PolicyMessageGroupItemAir, policyRouting);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List", "PolicyMessageGroupItem", new { id = policyGroupId }));
}
public CommissionableRouteItemVM(
CommissionableRouteItem commissionableRouteItem,
//CommissionableRouteGroup commissionableRouteGroup,
PolicyRouting policyRouting,
Supplier supplier,
Product product)
{
CommissionableRouteItem = commissionableRouteItem;
//CommissionableRouteGroup = commissionableRouteGroup;
PolicyRouting = policyRouting;
Product = product;
Supplier = supplier;
}
public ActionResult Create(PolicyAirParameterGroupItemVM policyAirParameterGroupItemViewModel, string btnSubmit)
{
//Get PolicyRouting Info
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = policyAirParameterGroupItemViewModel.PolicyRouting;
//Get PolicyAirParameterGroupItem Info
PolicyAirParameterGroupItem policyAirParameterGroupItem = new PolicyAirParameterGroupItem();
policyAirParameterGroupItem = policyAirParameterGroupItemViewModel.PolicyAirParameterGroupItem;
PolicyGroup policyGroup = new PolicyGroup();
policyGroup = policyGroupRepository.GetGroup(policyAirParameterGroupItem.PolicyGroupId);
//Check Exists
if (policyGroup == null)
{
ViewData["ActionMethod"] = "CreatePost";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyAirParameterGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Edit Routing
policyRoutingRepository.EditPolicyRouting(policyRouting);
//Save To DB
try
{
policyAirParameterGroupItemRepository.Add(policyAirParameterGroupItem, policyRouting);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List", new { id = policyGroup.PolicyGroupId }));
}
public ActionResult Edit(FareRestrictionViewModel fareRestrictionViewModel)
{
//Get PolicyRouting Info
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = fareRestrictionViewModel.PolicyRouting;
policyRoutingRepository.EditPolicyRouting(policyRouting);
FareRestriction fareRestriction = new FareRestriction();
fareRestriction = fareRestrictionRepository.GetFareRestriction(fareRestrictionViewModel.FareRestriction.FareRestrictionId);
//Check Exists
if (fareRestriction == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToReferenceInfo())
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
try{
fareRestrictionRepository.Update(fareRestriction, policyRouting);
}
catch (SqlException ex)
{
//Versioning Error
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/FareRestriction.mvc/Edit/" + fareRestriction.FareRestrictionId.ToString();
return(View("VersionError"));
}
//Generic Error
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
//Success
return(RedirectToAction("List"));
}
public ActionResult Create(AirlineClassCabinViewModel airlineClassCabinViewModel, string btnSubmit)
{
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToReferenceInfo())
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Get PolicyRouting Info
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = airlineClassCabinViewModel.PolicyRouting;
//Get PolicyAirlineGroupItem Info
AirlineClassCabin airlineClassCabin = new AirlineClassCabin();
airlineClassCabin = airlineClassCabinViewModel.AirlineClassCabin;
//Edit Routing
policyRoutingRepository.EditPolicyRouting(policyRouting);
try
{
airlineClassCabinRepository.Add(airlineClassCabin, policyRouting);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
return(RedirectToAction("List"));
//Send to new form based on submit button pressed
//switch (btnSubmit)
//{
// case "Save":
// return RedirectToAction("List");
// default:
// return RedirectToAction("CreatePolicyRouting", new { id = airlineClassCabin.AirlineClassCode });
// }
}
public ActionResult Create(FareRestrictionViewModel fareRestrictionViewModel, string btnSubmit)
{
//AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToReferenceInfo())
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Get PolicyRouting Info
PolicyRouting policyRouting = new PolicyRouting();
policyRouting = fareRestrictionViewModel.PolicyRouting;
//Get PolicyAirVendorGroupItem Info
FareRestriction fareRestriction = new FareRestriction();
fareRestriction = fareRestrictionViewModel.FareRestriction;
//Edit Routing
policyRoutingRepository.EditPolicyRouting(policyRouting);
try
{
fareRestrictionRepository.Add(fareRestriction, policyRouting);
}
catch (SqlException ex)
{
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
ViewData["Message"] = "There was a problem with your request, please see the log file or contact an administrator for details";
return(View("Error"));
}
//Send to new form based on submit button pressed
switch (btnSubmit)
{
case "Save":
return(RedirectToAction("List"));
default:
return(RedirectToAction("CreatePolicyRouting", new { id = fareRestriction.FareRestrictionId }));
}
}
//Add to DB
public void Update(TransactionFeeAir transactionFee, PolicyRouting policyRouting)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateTransactionFeeAir_v1(
transactionFee.TransactionFeeId,
transactionFee.TransactionFeeDescription,
transactionFee.TravelIndicator,
transactionFee.BookingSourceCode,
transactionFee.BookingOriginationCode,
transactionFee.ChargeTypeCode,
transactionFee.TransactionTypeCode,
transactionFee.FeeCategory,
transactionFee.TravelerClassCode,
transactionFee.SupplierCode,
transactionFee.MinimumFeeCategoryQuantity,
transactionFee.MaximumFeeCategoryQuantity,
transactionFee.MinimumTicketPrice,
transactionFee.MaximumTicketPrice,
transactionFee.TicketPriceCurrencyCode,
transactionFee.TripTypeClassificationId,
transactionFee.TemplateFeeFlag,
transactionFee.EnabledDate,
transactionFee.ExpiryDate,
transactionFee.IncursGSTFlagNonNullable,
transactionFee.FeeAmount,
transactionFee.FeeCurrencyCode,
transactionFee.FeePercent,
policyRouting.Name,
policyRouting.FromGlobalFlag,
policyRouting.FromGlobalRegionCode,
policyRouting.FromGlobalSubRegionCode,
policyRouting.FromCountryCode,
policyRouting.FromCityCode,
policyRouting.FromTravelPortCode,
policyRouting.FromTraverlPortTypeId,
policyRouting.ToGlobalFlag,
policyRouting.ToGlobalRegionCode,
policyRouting.ToGlobalSubRegionCode,
policyRouting.ToCountryCode,
policyRouting.ToCityCode,
policyRouting.ToTravelPortCode,
policyRouting.ToTravelPortTypeId,
policyRouting.RoutingViceVersaFlag,
adminUserGuid,
transactionFee.VersionNumber
);
}
// GET: /Edit
public ActionResult Edit(int id)
{
//Get PolicyAirCabinGroupItem
PolicyAirCabinGroupItem policyAirCabinGroupItem = new PolicyAirCabinGroupItem();
policyAirCabinGroupItem = policyAirCabinGroupItemRepository.GetPolicyAirCabinGroupItem(id);
//Check Exists
if (policyAirCabinGroupItem == null)
{
ViewData["ActionMethod"] = "EditGet";
return(View("RecordDoesNotExistError"));
}
//Check AccessRights
RolesRepository rolesRepository = new RolesRepository();
if (!rolesRepository.HasWriteAccessToPolicyGroup(policyAirCabinGroupItem.PolicyGroupId))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Populate List of AirlineCabins
AirlineCabinRepository airlineCabinRepository = new AirlineCabinRepository();
SelectList airlineCabins = new SelectList(airlineCabinRepository.GetAllAirlineCabins().ToList(), "AirlineCabinCode", "AirlineCabinDefaultDescription");
ViewData["AirlineCabinCodeList"] = airlineCabins;
policyAirCabinGroupItemRepository.EditItemForDisplay(policyAirCabinGroupItem);
PolicyGroup policyGroup = policyGroupRepository.GetGroup(policyAirCabinGroupItem.PolicyGroupId);
//Add the PolicyRouting information
PolicyRouting policyRouting = new PolicyRouting();
if (policyAirCabinGroupItem.PolicyRoutingId != null)
{
policyRouting = policyRoutingRepository.GetPolicyRouting((int)policyAirCabinGroupItem.PolicyRoutingId);
policyRoutingRepository.EditPolicyRouting(policyRouting);
}
//Show Edit Form
PolicyAirCabinGroupItemViewModel policyAirCabinGroupItemViewModel = new PolicyAirCabinGroupItemViewModel(policyGroup, policyAirCabinGroupItem, policyRouting);
return(View(policyAirCabinGroupItemViewModel));
}
