public TicketExchangeSelectionViewModel TicketingExchangeSelectionGetSeats(TicketExchangeSelectionInputModel inputModel)
{
TicketExchangeSelectionViewModel viewModel = new TicketExchangeSelectionViewModel(true);
TalentTicketExchange ticketExchange = new TalentTicketExchange();
ticketExchange.Dep.Customer = inputModel.CustomerNumber;
ticketExchange.Dep.ProductCode = inputModel.ProductCode;
ticketExchange.Settings = Environment.Settings.DESettings;
ticketExchange.Settings.Cacheing = false;
ErrorObj err = ticketExchange.GetTicketExchangeSeatSelectionForProduct();
viewModel.Error = Data.PopulateErrorObject(err, ticketExchange.ResultDataSet, ticketExchange.Settings, null);
if (!viewModel.Error.HasError)
{
if (ticketExchange.ResultDataSet.Tables["TicketExchangeCustomerSeats"].Rows.Count > 0 && ticketExchange.ResultDataSet.Tables["TicketExchangeProductInfomation"].Rows.Count > 0)
{
// Product setting Values from TicketExchangeProductInfomation
viewModel = Data.PopulateObjectFromRow <TicketExchangeSelectionViewModel>(ticketExchange.ResultDataSet.Tables["TicketExchangeProductInfomation"].Rows[0], viewModel);
// List of seats from TicketExchangeCustomerSeats
viewModel.TicketExchangeSeatList = Data.PopulateObjectListFromTable <TicketExchangeItem>(ticketExchange.ResultDataSet.Tables["TicketExchangeCustomerSeats"]);
// Initialise original status from call.
viewModel.setOriginalWorkProperties();
}
}
return(viewModel);
}
public TicketExchangeViewModel TicketingExchangeSelectionConfirm(TicketExchangeInputModel inputModel)
{
TicketExchangeViewModel viewModel = new TicketExchangeViewModel(true);
TalentTicketExchange ticketExchange = new TalentTicketExchange();
ticketExchange.Dep.ListingCustomer = inputModel.ListingCustomerNumber;
ticketExchange.Settings = Environment.Settings.DESettings;
ticketExchange.Settings.Cacheing = false;
int ticketItemCount = 0;
foreach (TicketExchangeItem ticketExchangeSeat in inputModel.Tickets)
{
// Map ticket details
DETicketExchangeItem deTicketExchangeItem = new DETicketExchangeItem();
deTicketExchangeItem.ProductCode = ticketExchangeSeat.ProductCode;
deTicketExchangeItem.SeatedCustomerNo = ticketExchangeSeat.SeatedCustomerNo;
deTicketExchangeItem.PaymentOwnerCustomerNo = ticketExchangeSeat.PaymentOwnerCustomerNo;
deTicketExchangeItem.FaceValuePrice = ticketExchangeSeat.FaceValuePrice;
deTicketExchangeItem.OriginalPrice = ticketExchangeSeat.OriginalSalePrice;
deTicketExchangeItem.RequestedPrice = ticketExchangeSeat.RequestedPrice;
deTicketExchangeItem.Fee = ticketExchangeSeat.Fee;
deTicketExchangeItem.FeeType = ticketExchangeSeat.FeeType;
deTicketExchangeItem.PotentialEarning = ticketExchangeSeat.PotentialEarning;
deTicketExchangeItem.Status = ticketExchangeSeat.Status;
string[] comments = new string[2];
comments[0] = ticketExchangeSeat.Comment1;
comments[1] = ticketExchangeSeat.Comment2;
deTicketExchangeItem.Comments = comments;
// Map seat details
DESeatDetails seat = new DESeatDetails();
seat.Stand = ticketExchangeSeat.StandCode;
seat.Area = ticketExchangeSeat.AreaCode;
seat.Row = ticketExchangeSeat.RowNo;
seat.Seat = ticketExchangeSeat.SeatNo;
seat.AlphaSuffix = ticketExchangeSeat.AlphaSuffix;
deTicketExchangeItem.SeatDetails = seat;
ticketExchange.Dep.TicketExchangeItems.Add(deTicketExchangeItem);
ticketItemCount = ticketItemCount + 1;
}
ErrorObj err = ticketExchange.SubmitTicketExchangeAction();
viewModel.Error = Data.PopulateErrorObject(err, ticketExchange.ResultDataSet, ticketExchange.Settings, null, true);
if (!viewModel.Error.HasError)
{
if (ticketExchange.ResultDataSet.Tables["TicketExchange"].Rows.Count > 0)
{
viewModel = Data.PopulateObjectFromRow <TicketExchangeViewModel>(ticketExchange.ResultDataSet.Tables["TicketExchange"].Rows[0], viewModel);
}
return(viewModel);
}
return(viewModel);
}
public TicketExchangeDefaultsViewModel GetTicketExchangeDefaults(TicketExchangeDefaultsInputModel inputModel)
{
_settings = Environment.Settings.DESettings;
_pageResource.BusinessUnit = _settings.BusinessUnit;
_pageResource.PartnerCode = _settings.Partner;
_pageResource.PageCode = Environment.Settings.Page;
_pageResource.KeyCode = Environment.Settings.Page;
_pageResource.FrontEndConnectionString = _settings.FrontEndConnectionString;
int YearsOfPastProductsToShow = Data.Validation.CheckForDBNull_Int(_pageResource.get_Attribute("YearsOfPastProductsToShow", "ENG", true));
TicketExchangeDefaultsViewModel viewModel = new TicketExchangeDefaultsViewModel(true);
TalentTicketExchange ticketExchange = new TalentTicketExchange();
ticketExchange.Dep.ProductCode = inputModel.ProductCode;
ticketExchange.Dep.ReturnAllProducts = inputModel.ReturnAllProducts;
ticketExchange.Settings = _settings;
ErrorObj err = ticketExchange.GetTicketExchangeDefaults();
viewModel.Error = Data.PopulateErrorObject(err, ticketExchange.ResultDataSet, ticketExchange.Settings, 3);
if (!viewModel.Error.HasError)
{
if (ticketExchange.ResultDataSet.Tables["ProductTESummary"].Rows.Count > 0)
{
// Product setting Values from "ProductTESummary"
viewModel = Data.PopulateObjectFromRow <TicketExchangeDefaultsViewModel>(ticketExchange.ResultDataSet.Tables["ProductTESummary"].Rows[0], viewModel);
// List of stand ae area defaults from "StandAreaTESummary"
if (ticketExchange.ResultDataSet.Tables["StandAreaTESummary"].Rows.Count > 0)
{
viewModel.TicketExchangeStandAreaDefaultsList = Data.PopulateObjectListFromTable <TicketExchangeStandAreaDefaults>(ticketExchange.ResultDataSet.Tables["StandAreaTESummary"]);
}
var ProductCodeDateDescriptionMask = (viewModel.GetPageText("ProductCodeDateDescriptionMask"));
viewModel.TicketExchangeProductsList = GetTicketExchangeProducts(YearsOfPastProductsToShow, ProductCodeDateDescriptionMask);
}
}
return(viewModel);
}
public TicketExchangeConfirmViewModel TicketingExchangeDefaultsConfirm(TicketExchangeDefaultsConfirmInputModel inputModel)
{
TicketExchangeConfirmViewModel viewModel = new TicketExchangeConfirmViewModel(true);
TalentTicketExchange ticketExchange = new TalentTicketExchange();
ticketExchange.Dep.ProductCode = inputModel.ProductCode;
ticketExchange.Dep.AllowTicketExchangePurchase = inputModel.AllowTicketExchangePurchase;
ticketExchange.Dep.AllowTicketExchangeReturn = inputModel.AllowTicketExchangeReturn;
ticketExchange.Dep.MinimumResalePrice = inputModel.MinimumResalePrice;
ticketExchange.Dep.MaximumResalePrice = inputModel.MaximumResalePrice;
ticketExchange.Dep.ClubFee = inputModel.ClubFee;
ticketExchange.Dep.ClubFeePercentageOrFixed = inputModel.ClubFeePercentageOrFixed;
ticketExchange.Dep.MinMaxBoundaryPercentageOrFixed = inputModel.MinMaxBoundaryPercentageOrFixed;
ticketExchange.Dep.CustomerRetainsPrerequisite = inputModel.CustomerRetainsPrerequisite;
ticketExchange.Dep.CustomerRetainsMaxLimit = inputModel.CustomerRetainsMaxLimit;
// davetodo add rest of fields here
ticketExchange.Settings = Environment.Settings.DESettings;
ticketExchange.Settings.Cacheing = false;
foreach (TicketExchangeStandAreaDefaults sad in inputModel.StandAreaDefaults)
{
// Map stand and area defaults
DETicketExchangeStandAreaDefaults desad = new DETicketExchangeStandAreaDefaults();
desad.StandAreaStandCode = sad.StandCode;
desad.StandAreaAreaCode = sad.AreaCode;
desad.StandAreaAllowTicketExchangePurchaseFlag = Utilities.convertToBool(sad.AllowTicketExchangePurchase);
desad.StandAreaAllowTicketExchangeReturnFlag = Utilities.convertToBool(sad.AllowTicketExchangeReturn);
ticketExchange.Dep.NumberOfStandAreas = ticketExchange.Dep.NumberOfStandAreas + 1;
ticketExchange.Dep.StandAreaDefaults.Add(desad);
}
ErrorObj err = ticketExchange.UpdateTicketExchangeDefaults();
viewModel.Error = Data.PopulateErrorObject(err, ticketExchange.ResultDataSet, ticketExchange.Settings, null, true);
return(viewModel);
}
public TicketExchangeProductsViewModel GetTicketExchangeProductsListForCustomer(TicketExchangeProductsInputModel inputModel)
{
TicketExchangeProductsViewModel viewModel = new TicketExchangeProductsViewModel(true);
TalentTicketExchange ticketExchange = new TalentTicketExchange();
ticketExchange.Dep.Customer = inputModel.CustomerNumber;
ticketExchange.Dep.FromDate = inputModel.FromDate;
ticketExchange.Settings = Environment.Settings.DESettings;
ErrorObj err = ticketExchange.GetTicketExchangeProductsListForCustomer();
viewModel.Error = Data.PopulateErrorObject(err, ticketExchange.ResultDataSet, ticketExchange.Settings, 3);
if (!viewModel.Error.HasError)
{
// List of product values from TicketExchangeProductSummary
viewModel.TicketExchangeProductSummaryList = Data.PopulateObjectListFromTable <TicketExchangeProductSummary>(ticketExchange.ResultDataSet.Tables["TicketExchangeProductSummary"]);
// Total for this customer from TicketExchangeSummary
if (ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows.Count > 0)
{
viewModel.TotalExpiredOnTicketExchange = Utilities.CheckForDBNull_Int(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalExpiredOnTicketExchange"]);
viewModel.TotalPendingOnTicketExchange = Utilities.CheckForDBNull_Int(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalPendingOnTicketExchange"]);
viewModel.TotalSoldOnTicketExchange = Utilities.CheckForDBNull_Int(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalSoldOnTicketExchange"]);
viewModel.TotalReSalePricePending = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalReSalePricePending"]);
viewModel.TotalReSalePriceExpired = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalReSalePriceExpired"]);
viewModel.TotalReSalePriceSold = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalReSalePriceSold"]);
viewModel.TotalPotentialEarningPricePending = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalPotentialEarningPricePending"]);
viewModel.TotalPotentialEarningPriceExpired = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalPotentialEarningPriceExpired"]);
viewModel.TotalPotentialEarningPriceSold = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalPotentialEarningPriceSold"]);
viewModel.TotalHandlingFeePending = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalHandlingFeePending"]);
viewModel.TotalHandlingFeeExpired = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalHandlingFeeExpired"]);
viewModel.TotalHandlingFeeSold = Utilities.CheckForDBNull_Decimal(ticketExchange.ResultDataSet.Tables["TicketExchangeSummary"].Rows[0]["TotalHandlingFeeSold"]);
}
}
return(viewModel);
}
