public PromotionalFareModel GetPromotionalFareCreateModel()
{
GeneralProvider generalProvider = new GeneralProvider();
PromotionalFareModel model = new PromotionalFareModel();
PromotionalFareSector promotionalFareSector = new PromotionalFareSector();
List <PromotionalFareSegment> segments = new List <PromotionalFareSegment>();
PromotionalFareSegment segment = new PromotionalFareSegment();
var cities = generalProvider.GetAirlineCityList();
segment.FromCityList = cities;
segment.ToCityList = cities;
segments.Add(segment);
promotionalFareSector.PromotionalFareSegment = segments;
//promotionalFareSector.CityList = generalProvider.GetAirlineCityList();
promotionalFareSector.AirlinesList = generalProvider.GetInternationAirlinesList(1);
var Airlines = generalProvider.GetInternationAirlinesList(1);
segment.AirlineList = Airlines;
promotionalFareSector.CurrencyList = generalProvider.GetCurrencyList();
model.PromotionalFareSector = promotionalFareSector;
return(model);
}
public string TransferPNRToAgency(int AgentId, int ToAgentId, string GDSNo, string Type, string Remark, int MakerId)
{
int response = 0;
string Message = string.Empty;
try
{
response = entity.Air_PNRAgencyTransfer(AgentId, ToAgentId, GDSNo, Type, Remark, MakerId);
GeneralProvider defaultProvider = new GeneralProvider();
var Agentinfo = defaultProvider.GetAgentById(ToAgentId);
Message = " PNR No [" + GDSNo + "] successufully transfered from Arihant Holidays to " + Agentinfo.AgentName;
return(Message);
}
catch (Exception ex)
{
return(ex.InnerException.Message);
}
}
public ActionResult ViewETicket(long id, ETicketViewModel model1)
{
long PNRid = id;
int agentid = ticketprovider.GetAgentIdbyPNRId(PNRid);
var masterpnrsresult = ticketprovider.GetTicketStatusIdByMPNRId(id);
ETicketViewModel viewmodel;
if (masterpnrsresult.TicketStatusId == 29)
{
viewmodel = ticketprovider.GetB2CMasterInformationForeTicket(id, masterpnrsresult.CreatedBy);
}
else
{
viewmodel = ticketprovider.GetLccMasterInformationForeTicket(id, agentid);
}
viewmodel.PNRList = ticketprovider.GetLccPNRInformationForeTicket(viewmodel.MasterPNRId);
viewmodel.PNRSectorList = ticketprovider.GetAllLccPNRSector(viewmodel.MasterPNRId);
viewmodel.PNRSegmentList = ticketprovider.GetAllLccPNRSegment(viewmodel.MasterPNRId);
viewmodel.PassengerList = ticketprovider.GetAllLccPNRPassenger(id);
viewmodel.ShowFareOnETicket = ticketprovider.ShowFareOnETicket(agentid);
viewmodel.ShowAgentLogoOnETicket = ticketprovider.ShowAgentLogoOnETicket(agentid);
viewmodel.ShowServiceChargeOnETicket = ticketprovider.isLccServiceChargeIncludeInTax(agentid);
string serverPath = Server.MapPath("~") + "Content\\AgentLogo";
string resolved = Path.Combine(serverPath, viewmodel.AgentLogo);
if (!System.IO.File.Exists(resolved))
{
string directoryName = Path.GetDirectoryName(resolved);
resolved = Path.Combine(directoryName, "DefaultLogo.png");
viewmodel.AgentLogo = "DefaultLogo.png";
if (!System.IO.File.Exists(resolved))
{
Images.DefaultLogo.Save(resolved);
}
}
if (!ModelState.IsValid)
{
return(View("eTicket", viewmodel));
}
string body = RenderPartialViewToString("ETicket", viewmodel);
try
{
ATLTravelPortal.Areas.Airline.Repository.GeneralProvider provider = new ATLTravelPortal.Areas.Airline.Repository.GeneralProvider();
Agents agent = provider.GetAgentById(agentid);
EmailEngine.EmailSender.Send(body, agent.Email, model1.txtEmailTo);
ViewData["isEmailSent"] = "Your email is right on the way, you'll get email in a minute.";
}
catch (Exception ex)
{
// ATLTravelPortalAgent.Utility.ErrorLogging.LogException(ex);
ViewData["isEmailSent"] = "Unable to send email";
//swallow everything
}
return(View("eTicket", viewmodel));
}
public PromotionalFareModel GetPromotionalFareSetupEditModel(Int64 promotionalFareId)
{
GeneralProvider generalProvider = new GeneralProvider();
PromotionalFareModel model = new PromotionalFareModel();
PromotionalFareSector promotionalFareSector = new PromotionalFareSector();
Air_PromotionalFares promotionalFares = entity.Air_PromotionalFares.Where(x => x.PromotionalFareId == promotionalFareId).FirstOrDefault();
if (promotionalFares != null)
{
// promotionalFareSector.CityList = generalProvider.GetAirlineCityList();
//promotionalFareSector.AirlinesList = generalProvider.GetInternationAirlinesList(1);
//promotionalFareSector.CurrencyList = generalProvider.GetCurrencyList();
//promotionalFareSector.PromotionalFareId = promotionalFares.PromotionalFareId;
//promotionalFareSector.AirlineId = promotionalFares.AirlineId;
//promotionalFareSector.TourCode = promotionalFares.TourCode;
//promotionalFareSector.CurrencyId = promotionalFares.CurrencyId;
//promotionalFareSector.BICClass = promotionalFares.Class;
//promotionalFareSector.FareBasis = promotionalFares.FareBasis;
//promotionalFareSector.EffectiveFrom = promotionalFares.EffectiveFrom;
//promotionalFareSector.ExpireOn = promotionalFares.ExpireOn;
//promotionalFareSector.NoOfPax = promotionalFares.NoOfPax;
//promotionalFareSector.BaseFare = (decimal)promotionalFares.BaseFare;
//promotionalFareSector.OtherCharges = (decimal)promotionalFares.OtherCharges;
//promotionalFareSector.NoOfPax = promotionalFares.NoOfPax;
var taxes = promotionalFares.Air_PromotionalFareTaxes;
List <PromotionalFareTaxes> promotionalFareTaxesList = new List <PromotionalFareTaxes>();
foreach (var tax in taxes)
{
PromotionalFareTaxes promotionalFareTaxes = new PromotionalFareTaxes()
{
PromotionalFareId = tax.PromotionalFareId,
PromotionalFareTaxId = tax.PromotionalFareTaxId,
TaxName = tax.TaxName,
TaxAmount = tax.TaxAmount
};
promotionalFareTaxesList.Add(promotionalFareTaxes);
}
promotionalFareSector.Taxes = promotionalFareTaxesList;
var segments = promotionalFares.Air_PromotionalFareSegments;
List <PromotionalFareSegment> promotionalFareSegmentList = new List <PromotionalFareSegment>();
foreach (var segment in segments)
{
PromotionalFareSegment promotionalFareSegment = new PromotionalFareSegment()
{
//PromotionalFareId = segment.PromotionalFareId,
//PromotionalFareSegmentId = segment.PromotionalFareSegmentId,
//FromCity = entity.Air_PromotionalFares.Where(x =>x.FromCityId== segment.FromCityId).Select(x=>x.AirlineCities.CityCode).FirstOrDefault(),
//ToCity = entity.Air_PromotionalFares.Where(x => x.ToCityId == segment.ToCityId).Select(x => x.AirlineCities1.CityCode).FirstOrDefault(),
//FromCityId = segment.FromCityId,
//ToCityId = segment.ToCityId,
//DepartureDate = segment.DepartureDate,
//DepartureTime = segment.DepartureTime,
//ArrivalDate = segment.ArrivalDate,
//ArrivalTime = segment.ArrivalTime,
//FlightNo = segment.FlightNo,
//FromCityList=new SelectList( generalProvider.GetAirlineCityList(),"Value","Text",segment.FromCityId),
//ToCityList = new SelectList(generalProvider.GetAirlineCityList(), "Value", "Text", segment.ToCityId)
};
promotionalFareSegmentList.Add(promotionalFareSegment);
}
promotionalFareSector.PromotionalFareSegment = promotionalFareSegmentList;
}
model.PromotionalFareSector = promotionalFareSector;
return(model);
}
public ServiceResponse Save(OfflineBookViewModel models)
{
try
{
int confirmTicketstatus = 24;
var model = models;
long masterpnr = 0;
string bookingref;
using (var ts = new TransactionScope(TransactionScopeOption.Required))
{
ATLTravelPortal.Areas.Airline.Repository.GeneralProvider generalProvider = new GeneralProvider();
var agent = generalProvider.GetAgents(model.UserDetail.AgentId);
bool isByPassDealByBranch = generalProvider.GetBranchSettings(agent.BranchOfficeId, 12);
bool isByPassDealByDistrubutor = generalProvider.GetDistributorSettings(agent.DistributorId, 13);
System.Data.Objects.ObjectParameter BranchaDeal = new System.Data.Objects.ObjectParameter("Amount", 0);
System.Data.Objects.ObjectParameter DistributorDeal = new System.Data.Objects.ObjectParameter("Amount", 0);
var currency = generalProvider.GetCurrencyByCode("NPR");
double totalFareAmount = models.PNRDetails[0].PassengerDetail[0].FareDetail.SellingBaseFare + models.PNRDetails[0].PassengerDetail[0].FareDetail.SellingFSC - models.PNRDetails[0].PassengerDetail[0].FareDetail.DiscountAmount;
var branchDealAmount = _entity.Air_GetBranchDeal
(agent.DistributorId,
model.PNRDetails[0].SegmentDetail.FirstOrDefault().AirlineId, model.PNRDetails[0].SegmentDetail.FirstOrDefault().DepartCityId,
model.PNRDetails[0].SegmentDetail.FirstOrDefault().ArrivalCityId, false, totalFareAmount, currency.CurrencyId, model.PNRDetails[0].SegmentDetail.FirstOrDefault().BIC, BranchaDeal);
var distributorDealAmount = _entity.Air_GetBranchDeal
(agent.AgentId,
model.PNRDetails[0].SegmentDetail.FirstOrDefault().AirlineId, model.PNRDetails[0].SegmentDetail.FirstOrDefault().DepartCityId,
model.PNRDetails[0].SegmentDetail.FirstOrDefault().ArrivalCityId, false, totalFareAmount + (double)BranchaDeal.Value + branchDealAmount, currency.CurrencyId, model.PNRDetails[0].SegmentDetail.FirstOrDefault().BIC, DistributorDeal);
var mpnrDetail = new TBO_MasterPNRs
{
SessionId = model.UserDetail.SessionId.ToString(),
AgentId = model.UserDetail.AgentId,
ServiceProviderId = 5,
Prefix = model.PNRDetails[0].PassengerDetail[0].Prefix.ToString(),
FirstName = model.PNRDetails[0].PassengerDetail[0].FirstName.ToUpper(),
MiddleName = model.PNRDetails[0].PassengerDetail[0].MiddleName,
LastName = model.PNRDetails[0].PassengerDetail[0].LastName.ToUpper(),
TicketStatusId = confirmTicketstatus,
Email = "*****@*****.**",
Phone = model.PNRDetails[0].PassengerDetail[0].Phone,
Address = "104 Level 1 The Chamber, Mumbai",
CreatedBy = model.UserDetail.AppUserId,
CreatedDate = DateTime.UtcNow,
IssuedDate = DateTime.UtcNow,
DispatchedDate = null,
// BookingReference = "AH" + RandomGenerator.GenerateRandomAlphanumeric()
isBranchByPassDeal = isByPassDealByBranch,
isDistributorByPassDeal = isByPassDealByDistrubutor
};
_entity.AddToTBO_MasterPNRs(mpnrDetail);
_entity.SaveChanges();
mpnrDetail.BookingReference = "AH" + RandomGenerator.GenerateRandomAlphanumeric() + mpnrDetail.MPNRId;
_entity.ApplyCurrentValues(mpnrDetail.EntityKey.EntitySetName, mpnrDetail);
_entity.SaveChanges();
masterpnr = mpnrDetail.MPNRId;
bookingref = mpnrDetail.BookingReference;
foreach (var pnrData in model.PNRDetails)
{
var pnrDetail = new TBO_PNRs
{
MPNRId = mpnrDetail.MPNRId,
BookingId = 0,
TicketStatusId = confirmTicketstatus,
RecLoc = pnrData.PNR.ToUpper(),
// BookingSource = pnrData.BookingSource,
};
_entity.AddToTBO_PNRs(pnrDetail);
_entity.SaveChanges();
var sectorDetail = new TBO_PNRsectors
{
MPNRId = mpnrDetail.MPNRId,
PNRId = pnrDetail.PNRId,
PlatingCarrierId = pnrData.SegmentDetail.FirstOrDefault().AirlineId,
DepartCityId = pnrData.SegmentDetail.FirstOrDefault().DepartCityId,
DepartDate = pnrData.SegmentDetail.FirstOrDefault().DepartDate.Value,
DepartTime = pnrData.SegmentDetail.FirstOrDefault().DepartTime.Value,
DestinationCityId = pnrData.SegmentDetail.Last().ArrivalCityId,
ArriveDate = pnrData.SegmentDetail.LastOrDefault().ArrivalDate.Value,
ArriveTime = pnrData.SegmentDetail.FirstOrDefault().ArrivalTime.Value,
StartTerminal = pnrData.SegmentDetail.FirstOrDefault().StartTerminal,
EndTerminal = pnrData.SegmentDetail.LastOrDefault().EndTerminal,
};
_entity.AddToTBO_PNRsectors(sectorDetail);
_entity.SaveChanges();
foreach (var seg in pnrData.SegmentDetail)
{
var segmentDetail = new TBO_PNRsegments
{
MPNRId = mpnrDetail.MPNRId,
PNRId = pnrDetail.PNRId,
SectorId = sectorDetail.SectorId,
AirlineId = seg.AirlineId,
FlightNumber = seg.FlightNumber,
DepartCityId = seg.DepartCityId,
DepartDate = seg.DepartDate.Value,
DepartTime = seg.DepartTime.Value,
ArrivalCityId = seg.ArrivalCityId,
ArrivalDate = seg.ArrivalDate.Value,
ArrivalTime = seg.ArrivalTime.Value,
BIC = seg.BIC,
StartTerminal = seg.StartTerminal,
EndTerminal = seg.EndTerminal,
AirlineRefNumber = seg.AirlineRefNumber.ToUpper(),
VndRemarks = seg.VndRemarks,
FlightDuration =
String.IsNullOrEmpty(seg.Duration)
? (seg.FlightDuration.Hours.ToString() + ":" +
seg.FlightDuration.Minutes.ToString())
: seg.Duration,
Baggage = Baggage.No.ToString(),
FareBasis = null,
FlightKey = null,
NVB = null,
NVA = null
};
_entity.AddToTBO_PNRsegments(segmentDetail);
_entity.SaveChanges();
}
foreach (var paxData in pnrData.PassengerDetail)
{
var paxDetail = new TBO_Passengers();
paxDetail.PNRId = pnrDetail.PNRId;
paxDetail.MPNRId = mpnrDetail.MPNRId;
paxDetail.Prefix = paxData.Prefix.ToString();
paxDetail.FirstName = paxData.FirstName.ToUpper();
paxDetail.MiddleName = paxData.MiddleName;
paxDetail.LastName = paxData.LastName.ToUpper();
paxDetail.Gender = "N/A";
if (!string.IsNullOrEmpty(paxData.DOB.Trim()))
{
paxDetail.DOB = Convert.ToDateTime(paxData.DOB);
}
paxDetail.Nationality = paxData.NationalityId;
paxDetail.Country = paxData.PassportIssuedCountryId;
paxDetail.PassportNumber = paxData.PassportNumber;
paxDetail.PassportExpDate = paxData.PassportExpDate;
paxDetail.Phone = paxData.Phone;
paxDetail.Email = "*****@*****.**";
paxDetail.PassengerTypeId = (int)paxData.PaxType;
paxDetail.FFAirline = paxData.FrequentFlyerAirlineCode != null ? (int?)_entity.Airlines.Where(
x => x.AirlineCode == paxData.FrequentFlyerAirlineCode).
Select(y => y.AirlineId).FirstOrDefault()
: null;
paxDetail.FFNumber = paxData.FrequentFlyerNo != "" ? paxData.FrequentFlyerNo : null;
paxDetail.DOCA = "2nd Floor, Buddha Complex, Swayambhu, Kathmandu, Nepal";
paxDetail.SSR = paxData.Meal != null ? paxData.Meal.Code : null;
paxDetail.SSRDescription =
paxData.Meal != null
? paxData.Meal.Description = paxData.Meal.Code
: null;
paxDetail.SeatName = paxData.Seat != null ? paxData.Seat.Code : null;
paxDetail.SeatDescription =
paxData.Seat != null ? paxData.Seat.Description : null;
paxDetail.UpdatedBy = 1;
paxDetail.UpdatedDate = DateTime.UtcNow;
_entity.AddToTBO_Passengers(paxDetail);
_entity.SaveChanges();
var fareDetail = new TBO_PNRTickets
{
PNRId = pnrDetail.PNRId,
MPNRId = mpnrDetail.MPNRId,
PassengerId = paxDetail.PassengerId,
TicketNumber = paxData.FareDetail.TicketNumber.ToUpper(),
AdditionalTxnFee = paxData.FareDetail.SellingAdditionalTxnFee,
AirlineTransFee = paxData.FareDetail.AirlineTransFee,
BaseFare = paxData.FareDetail.SellingBaseFare,
Tax = paxData.FareDetail.SellingTax,
OtherCharges = paxData.FareDetail.SellingOtherCharges,
ServiceTax = paxData.FareDetail.SellingServiceTax,
MarkupAmount = paxData.FareDetail.MarkupAmount,
CommissionAmount = 0,
DiscountAmount = paxData.FareDetail.CommissionAmount,
Currency = "NPR",
FSC = paxData.FareDetail.SellingFSC,
TicketStatusId = confirmTicketstatus,
TktId = paxData.FareDetail.TicketId,
TourCode = paxData.FareDetail.TourCode,
ValidatingAirline = paxData.FareDetail.ValidatingAirline,
Remarks = paxData.FareDetail.Remarks,
CorporateCode = paxData.FareDetail.CorporateCode,
EndorseMent = paxData.FareDetail.Endorsement,
//value with Rounding
SellingAdditionalTxnFee =
Math.Ceiling(paxData.FareDetail.SellingAdditionalTxnFee),
SellingAirlineTransFee =
Math.Ceiling(paxData.FareDetail.SellingAirlineTransFee),
SellingBaseFare = Math.Ceiling(paxData.FareDetail.SellingBaseFare),
SellingTax = Math.Ceiling(paxData.FareDetail.SellingTax),
SellingOtherCharges =
Math.Ceiling(paxData.FareDetail.SellingOtherCharges),
SellingServiceTax =
Math.Ceiling(paxData.FareDetail.SellingServiceTax),
SellingFSC = Math.Ceiling(paxData.FareDetail.SellingFSC),
BranchDealAmount = (double)BranchaDeal.Value,
DistrubutorDealAmount = (double)DistributorDeal.Value
};
_entity.AddToTBO_PNRTickets(fareDetail);
_entity.SaveChanges();
}
}
ts.Complete();
}
IssueTicket(masterpnr, model.UserDetail.AppUserId);
_entity.SaveChanges();
_entity.Air_UpdateTicketStatusId(masterpnr, "ISSUEPNR", false, model.UserDetail.AppUserId);
_response = new ServiceResponse("Record successfully created!! \n Your Booking Reference No is :" + bookingref, MessageType.Success, true, "Save");
return(_response);
}
catch (Exception ex)
{
_response = new ServiceResponse(ex.Message, MessageType.Exception, false, "Save");
return(_response);
}
}
public AvailableBalanceViewModel GetAccountInfoByAgentId(int agentId)
{
GeneralProvider _provider = new GeneralProvider();
var AvailableBalanceResult = _provider.GetAvailableBalanceForAgent(agentId).ToList();
var Balanceviewmodel = new AvailableBalanceViewModel();
/// For NPR balance
/// //Currency
Balanceviewmodel.CurrencyNPR = AvailableBalanceResult.ElementAtOrDefault(0).CurrencyCode;
Balanceviewmodel.CreditLimitNPR = AvailableBalanceResult.ElementAtOrDefault(0).CreditLimit;
Balanceviewmodel.CurrentBalanceNPR = AvailableBalanceResult.ElementAtOrDefault(0).Amount;
Balanceviewmodel.LeadgerBalanceNPR = AvailableBalanceResult.ElementAtOrDefault(0).LedgerAmount;
/// For USD balance
Balanceviewmodel.CurrencyUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode : "";
Balanceviewmodel.CreditLimitUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).CreditLimit : double.Parse("");
Balanceviewmodel.CurrentBalanceUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).Amount : double.Parse("");
Balanceviewmodel.LeadgerBalanceUSD = AvailableBalanceResult.ElementAtOrDefault(1).CurrencyCode == "USD" ? AvailableBalanceResult.ElementAtOrDefault(1).LedgerAmount : double.Parse("");
/// For INR balance
Balanceviewmodel.CurrencyINR = AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode == "INR" ? AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode : "";
Balanceviewmodel.CreditLimitINR = AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode == "INR" ? AvailableBalanceResult.ElementAtOrDefault(2).CreditLimit : double.Parse("");
Balanceviewmodel.CurrentBalanceINR = AvailableBalanceResult.ElementAtOrDefault(2).CurrencyCode == "INR" ? AvailableBalanceResult.ElementAtOrDefault(2).Amount : double.Parse("");
if (Balanceviewmodel.CurrentBalanceNPR == null)
{
Balanceviewmodel.CurrentBalanceNPR = 0;
}
double minBalance = Balanceviewmodel.CreditLimitNPR.Value * 10 * 0.01; //10 % of Credit limit
if (Balanceviewmodel.CurrentBalanceNPR <= minBalance) //|| Balanceviewmodel.Amount==0)
{
Balanceviewmodel.isLowBalanceNPR = true;
}
else
{
Balanceviewmodel.isLowBalanceNPR = false;
}
double minBalanceUSD = Balanceviewmodel.CreditLimitUSD.Value * 10 * 0.01; //10 % of Credit limit
if (Balanceviewmodel.CurrentBalanceUSD <= minBalance) //|| Balanceviewmodel.Amount==0)
{
Balanceviewmodel.isLowBalanceUSD = true;
}
else
{
Balanceviewmodel.isLowBalanceUSD = false;
}
double minBalanceINR = Balanceviewmodel.CreditLimitINR.Value * 10 * 0.01; //10 % of Credit limit
if (Balanceviewmodel.CurrentBalanceINR <= minBalanceINR) //|| Balanceviewmodel.Amount==0)
{
Balanceviewmodel.isLowBalanceINR = true;
}
else
{
Balanceviewmodel.isLowBalanceINR = false;
}
return(Balanceviewmodel);
}
public List <ETicketViewModel> GetTBOPassengerListByPNRID(long PNRId, int AgentId, bool isServiceChargeIncludeInTaxAmount)
{
GeneralProvider generalProvider = new GeneralProvider();
if (isServiceChargeIncludeInTaxAmount)
{
var result = (from aa in ent.TBO_Passengers
join bb in ent.TBO_PNRTickets on aa.PassengerId equals bb.PassengerId
where (aa.MPNRId == PNRId && aa.IsDeleted == false)
select new ETicketViewModel
{
PassengerId = aa.PassengerId,
PNRName = aa.LastName + ", " + aa.FirstName + " " + (aa.MiddleName ?? "") + "/" + aa.Prefix,
DateOfBirth = aa.DOB,
PassportNumber = aa.PassportNumber,
Email = aa.Email,
Fare = bb.SellingBaseFare, // + bb.MarkupAmount
Tax = bb.SellingTax + bb.ServiceCharge + bb.FSC + bb.AdditionalTxnFee,
TicketNO = bb.TicketNumber,
ServiceCharge = 0,
AirLineName = "", //aa.FFAirline != null ? generalProvider.GetAirlineName(aa.FFAirline.Value) : null,
Currency = bb.Currency,
FrequentFlyerNo = aa.FFNumber,
FrequentFlyerAirlineId = aa.FFAirline ?? 0,
PassengerTypeId = (int)aa.PassengerTypeId,
SSR = aa.SSR,
Discount = bb.DiscountAmount,
BranchDeal = bb.BranchDealAmount,
DistributorDeal = bb.DistrubutorDealAmount,
TotalCalculatedDiscount = (bb.DiscountAmount > 0 ? bb.DiscountAmount : 0 +
(bb.BranchDealAmount < 0 ? Math.Abs(bb.BranchDealAmount) : 0) +
(bb.DistrubutorDealAmount < 0 ? Math.Abs(bb.DistrubutorDealAmount) : 0)),
TotalTranFee = ((bb.DiscountAmount < 0 ? Math.Abs(bb.DiscountAmount) : 0) +
(bb.BranchDealAmount > 0 ? Math.Abs(bb.BranchDealAmount) : 0) +
(bb.DistrubutorDealAmount > 0 ? Math.Abs(bb.DistrubutorDealAmount) : 0))
}).ToList();
return(result);
}
else
{
var result = (from aa in ent.TBO_Passengers
join bb in ent.TBO_PNRTickets on aa.PassengerId equals bb.PassengerId
where (aa.MPNRId == PNRId && aa.IsDeleted == false)
select new ETicketViewModel
{
PassengerId = aa.PassengerId,
PNRName = aa.LastName + ", " + aa.FirstName + " " + (aa.MiddleName ?? "") + "/" + aa.Prefix,
DateOfBirth = aa.DOB,
PassportNumber = aa.PassportNumber,
Email = aa.Email,
Fare = bb.SellingBaseFare, //+ bb.MarkupAmount
Tax = bb.SellingTax + bb.FSC + bb.AdditionalTxnFee,
TicketNO = bb.TicketNumber,
ServiceCharge = bb.ServiceCharge,
AirLineName = "", // aa.FFAirline != null ? generalProvider.GetAirlineName(aa.FFAirline.Value) : null,
Currency = bb.Currency,
FrequentFlyerNo = aa.FFNumber,
FrequentFlyerAirlineId = aa.FFAirline ?? 0,
PassengerTypeId = (int)aa.PassengerTypeId,
SSR = aa.SSR,
Discount = bb.DiscountAmount,
BranchDeal = bb.BranchDealAmount,
DistributorDeal = bb.DistrubutorDealAmount,
TotalCalculatedDiscount = (bb.DiscountAmount > 0 ? bb.DiscountAmount : 0 +
(bb.BranchDealAmount < 0 ? Math.Abs(bb.BranchDealAmount) : 0) +
(bb.DistrubutorDealAmount < 0 ? Math.Abs(bb.DistrubutorDealAmount) : 0)),
TotalTranFee = ((bb.DiscountAmount < 0 ? Math.Abs(bb.DiscountAmount) : 0) +
(bb.BranchDealAmount > 0 ? Math.Abs(bb.BranchDealAmount) : 0) +
(bb.DistrubutorDealAmount > 0 ? Math.Abs(bb.DistrubutorDealAmount) : 0))
}).AsEnumerable();
return(result.ToList());
}
}
