//Update in DB
public void Update(TransactionFeeCarHotel transactionFee)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_UpdateTransactionFeeCarHotel_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,
transactionFee.PolicyLocationId,
adminUserGuid,
transactionFee.VersionNumber
);
}
public ActionResult Delete(int cid, int tid)
{
//Get Item From Database
TransactionFeeClientFeeGroup transactionFeeClientFeeGroup = new TransactionFeeClientFeeGroup();
transactionFeeClientFeeGroup = transactionFeeClientFeeGroupRepository.GetItem(cid, tid);
//Check Exists
if (transactionFeeClientFeeGroup == null)
{
ViewData["ActionMethod"] = "DeleteGet";
return(View("RecordDoesNotExistError"));
}
ClientFeeGroupTransactionFeeCarHotelVM clientFeeGroupTransactionFeeCarHotelVM = new ClientFeeGroupTransactionFeeCarHotelVM();
clientFeeGroupTransactionFeeCarHotelVM.TransactionFeeClientFeeGroup = transactionFeeClientFeeGroup;
ClientFeeGroup clientFeeGroup = new ClientFeeGroup();
clientFeeGroup = clientFeeGroupRepository.GetGroup(cid);
clientFeeGroupTransactionFeeCarHotelVM.ClientFeeGroup = clientFeeGroup;
TransactionFeeCarHotel transactionFeeCarHotel = new TransactionFeeCarHotel();
transactionFeeCarHotel = transactionFeeCarHotelRepository.GetItem(tid);
transactionFeeCarHotelRepository.EditForDisplay(transactionFeeCarHotel);
clientFeeGroupTransactionFeeCarHotelVM.TransactionFeeCarHotel = transactionFeeCarHotel;
return(View(clientFeeGroupTransactionFeeCarHotelVM));
}
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
TransactionFeeCarHotel transactionFee = new TransactionFeeCarHotel();
transactionFee = transactionFeeCarHotelRepository.GetItem(id);
//Check Exists
if (transactionFee == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
TransactionFeeCarHotelVM transactionFeeCarHotelVM = new TransactionFeeCarHotelVM();
transactionFeeCarHotelRepository.EditForDisplay(transactionFee);
transactionFeeCarHotelVM.TransactionFee = transactionFee;
return(View(transactionFeeCarHotelVM));
}
public TransactionFeeCarHotelVM(TransactionFeeCarHotel transactionFee,
IEnumerable <SelectListItem> travelIndicators,
IEnumerable <SelectListItem> policyLocations,
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;
TravelIndicators = travelIndicators;
PolicyLocations = policyLocations;
BookingSources = bookingSources;
ChargeTypes = chargeTypes;
BookingOriginations = bookingOriginations;
TransactionTypes = transactionTypes;
FeeCategories = feeCategories;
TravelerBackOfficeTypes = travelerBackOfficeTypes;
TripTypeClassifications = tripTypeClassifications;
TicketPriceCurrencies = ticketPriceCurrencies;
FeeCurrencies = feeCurrencies;
}
public ClientFeeGroupTransactionFeeCarHotelVM(TransactionFeeClientFeeGroup transactionFeeClientFeeGroup, ClientFeeGroup clientFeeGroup, TransactionFeeCarHotel transactionFeeCarHotel, int feeTypeId, string feeTypeDisplayName, string feeTypeDisplayNameShort)
{
TransactionFeeClientFeeGroup = transactionFeeClientFeeGroup;
ClientFeeGroup = clientFeeGroup;
TransactionFeeCarHotel = transactionFeeCarHotel;
FeeTypeId = feeTypeId;
FeeTypeDisplayName = feeTypeDisplayName;
FeeTypeDisplayNameShort = feeTypeDisplayNameShort;
}
//Delete From DB
public void Delete(TransactionFeeCarHotel transactionFee)
{
string adminUserGuid = HttpContext.Current.User.Identity.Name.Split(new[] { '|' })[0];
db.spDesktopDataAdmin_DeleteTransactionFeeCarHotel_v1(
transactionFee.TransactionFeeId,
adminUserGuid,
transactionFee.VersionNumber
);
}
public ActionResult Create(TransactionFeeCarHotelVM transactionFeeCarHotelVM)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
//Get TransactionFee Info
TransactionFeeCarHotel transactionFeeCarHotel = new TransactionFeeCarHotel();
transactionFeeCarHotel = transactionFeeCarHotelVM.TransactionFee;
//Update Model From Form + Validate against DB
try
{
UpdateModel <TransactionFee>(transactionFeeCarHotel, "TransactionFee");
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Database Update
try
{
transactionFeeCarHotelRepository.Add(transactionFeeCarHotel);
}
catch (SqlException ex)
{
//Non-Unique Name
if (ex.Message == "NonUniqueName")
{
return(View("NonUniqueNameError"));
}
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", "TransactionFee"));
}
public ActionResult Edit(TransactionFeeCarHotelVM transactionFeeVM)
{
//Check Access Rights to Domain
if (!hierarchyRepository.AdminHasDomainWriteAccess(groupName))
{
ViewData["Message"] = "You do not have access to this item";
return(View("Error"));
}
TransactionFeeCarHotel transactionFee = new TransactionFeeCarHotel();
transactionFee = transactionFeeCarHotelRepository.GetItem(transactionFeeVM.TransactionFee.TransactionFeeId);
//Check Exists
if (transactionFee == null)
{
ViewData["ActionMethod"] = "EditPost";
return(View("RecordDoesNotExistError"));
}
//Update Model from Form
try
{
UpdateModel(transactionFee, "TransactionFee");
}
catch
{
string n = "";
foreach (ModelState modelState in ViewData.ModelState.Values)
{
foreach (ModelError error in modelState.Errors)
{
n += error.ErrorMessage;
}
}
ViewData["Message"] = "ValidationError : " + n;
return(View("Error"));
}
//Database Update
try
{
transactionFeeCarHotelRepository.Update(transactionFee);
}
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", "TransactionFee"));
}
public ActionResult Delete(int id, FormCollection collection)
{
//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
TransactionFeeCarHotel transactionFee = new TransactionFeeCarHotel();
transactionFee = transactionFeeCarHotelRepository.GetItem(id);
//Check Exists
if (transactionFee == null)
{
ViewData["ActionMethod"] = "DeletePost";
return(View("RecordDoesNotExistError"));
}
//Delete Item
try
{
transactionFee.VersionNumber = Int32.Parse(collection["TransactionFee.VersionNumber"]);
transactionFeeCarHotelRepository.Delete(transactionFee);
}
catch (SqlException ex)
{
//Versioning Error - go to standard versionError page
if (ex.Message == "SQLVersioningError")
{
ViewData["ReturnURL"] = "/TransactionFeeCarHotel.mvc/Delete/" + transactionFee.TransactionFeeId.ToString();
return(View("VersionError"));
}
//Restraint Error - go to standard DeleteError page
if (ex.Message == "SQLDeleteError")
{
ViewData["ReturnURL"] = "/TransactionFeeCarHotel.mvc/Delete/" + transactionFee.TransactionFeeId.ToString();
return(View("DeleteError"));
}
LogRepository logRepository = new LogRepository();
logRepository.LogError(ex.Message);
//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"));
}
//Return
return(RedirectToAction("List", "TransactionFee"));
}
// GET: View A Single TransactionFeeCarHotel
public ActionResult View(int id)
{
//Get Item From Database
TransactionFeeCarHotel transactionFee = new TransactionFeeCarHotel();
transactionFee = transactionFeeCarHotelRepository.GetItem(id);
//Check Exists
if (transactionFee == null)
{
ViewData["ActionMethod"] = "ViewGet";
return(View("RecordDoesNotExistError"));
}
TransactionFeeCarHotelVM transactionFeeCarHotelVM = new TransactionFeeCarHotelVM();
transactionFeeCarHotelRepository.EditForDisplay(transactionFee);
transactionFeeCarHotelVM.TransactionFee = transactionFee;
return(View(transactionFeeCarHotelVM));
}
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;
}
// GET: Create A Single Transaction Fee
public ActionResult Create(int productId)
{
//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);
if (product == null || productId < 2 || productId > 3)
{
ViewData["ActionMethod"] = "CreateGet";
return(View("RecordDoesNotExistError"));
}
TransactionFeeCarHotelVM transactionFeeVM = new TransactionFeeCarHotelVM();
TransactionFeeCarHotel transactionFeeCarHotel = new TransactionFeeCarHotel();
transactionFeeCarHotel.ProductName = product.ProductName;
transactionFeeCarHotel.ProductId = product.ProductId;
transactionFeeCarHotel.IncursGSTFlagNonNullable = false;
transactionFeeVM.TransactionFee = transactionFeeCarHotel;
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");
//Location is used in CarHotel only
PolicyLocationRepository policyLocationRepository = new PolicyLocationRepository();
transactionFeeVM.PolicyLocations = new SelectList(policyLocationRepository.GetAllPolicyLocations().ToList(), "PolicyLocationId", "PolicyLocationName");
return(View(transactionFeeVM));
}