Esempio n. 1
0
        /// <summary>
        /// Get Booking History details by TrId
        /// </summary>
        /// <param name="trId"></param>
        /// <returns></returns>
        public Dictionary <string, object> GetDetailOfBookingHistoryByTrId(String trId)
        {
            var sodRequestsList    = new List <TravelRequestMasterModels>();
            var sodflightList      = new List <FlightDetailModels>();
            var passengerMealsList = new List <PassengerMealAllocationModels>();

            var dicList = new Dictionary <string, object>();

            dicList            = _sodApproverRepositorty.GetSodBookingInfoForPNR(Convert.ToInt64(trId));
            sodRequestsList    = dicList["bookingInfo"] as List <TravelRequestMasterModels>;
            sodflightList      = dicList["flightInfo"] as List <FlightDetailModels>;
            passengerMealsList = dicList["mealsInfo"] as List <PassengerMealAllocationModels>;

            //Check Meal Option from Old allocation
            if (passengerMealsList.Count == 0)
            {
                //Add Passenger meal Option for SOD Flights
                foreach (var item in sodflightList)
                {
                    var passengerMealsListItem = new PassengerMealAllocationModels();
                    passengerMealsListItem.TravelRequestId = item.TravelRequestId;
                    passengerMealsListItem.Sector          = item.OriginPlace + "-" + item.DestinationPlace;
                    passengerMealsListItem.MealType        = sodRequestsList[0].Meals;
                    passengerMealsListItem.PassengerId     = 0;
                    passengerMealsList.Add(passengerMealsListItem);
                }
            }

            var fcount = 0;

            foreach (var item in sodflightList)
            {
                fcount++;
                var sector = item.OriginPlace + "-" + item.DestinationPlace;
                foreach (var m in passengerMealsList)
                {
                    if (m.Sector == sector && fcount == m.PassengerId)
                    {
                        item.Meals = m.MealType;
                    }
                    if (m.Sector == sector && m.PassengerId == 0)
                    {
                        if (item.Meals != null)
                        {
                            item.Meals = item.Meals + "," + m.MealType;
                        }
                        else
                        {
                            item.Meals = m.MealType;
                        }
                    }
                }
            }
            return(dicList);
        }
Esempio n. 2
0
        public JsonResult GetBookingInfo()
        {
            var trId = Request.QueryString["trId"].ToString();
            //Display Request wise view details
            var sodRequestsList    = new List <TravelRequestMasterModels>();
            var sodflightList      = new List <FlightDetailModels>();
            var passengerList      = new List <PassengerDetailModels>();
            var passengerMealsList = new List <PassengerMealAllocationModels>();
            var hotelList          = new List <TravelRequestHotelDetailModels>();

            var dicList = new Dictionary <string, object>();

            dicList            = _sodApproverRepositorty.GetSodBookingInfoForPNR(Convert.ToInt64(trId));
            sodRequestsList    = dicList["bookingInfo"] as List <TravelRequestMasterModels>;
            sodflightList      = dicList["flightInfo"] as List <FlightDetailModels>;
            passengerList      = dicList["passInfo"] as List <PassengerDetailModels>;
            passengerMealsList = dicList["mealsInfo"] as List <PassengerMealAllocationModels>;
            hotelList          = dicList["hotelInfo"] as List <TravelRequestHotelDetailModels>;
            //Check Meal Option from Old allocation
            if (passengerMealsList.Count == 0)
            {
                //Add Passenger meal Option for SOD Flights
                foreach (var item in sodflightList)
                {
                    var passengerMealsListItem = new PassengerMealAllocationModels();
                    passengerMealsListItem.TravelRequestId = item.TravelRequestId;
                    passengerMealsListItem.Sector          = item.OriginPlace + "-" + item.DestinationPlace;
                    passengerMealsListItem.MealType        = sodRequestsList[0].Meals;
                    passengerMealsListItem.PassengerId     = 0;

                    passengerMealsList.Add(passengerMealsListItem);
                }
            }

            var fcount = 0;

            foreach (var item in sodflightList)
            {
                fcount++;
                var sector = item.OriginPlace + "-" + item.DestinationPlace;
                foreach (var m in passengerMealsList)
                {
                    if (m.Sector == sector && fcount == m.PassengerId)
                    {
                        item.Meals = m.MealType;
                    }
                    if (m.Sector == sector && m.PassengerId == 0)
                    {
                        if (item.Meals != null)
                        {
                            item.Meals = item.Meals + "," + m.MealType;
                        }
                        else
                        {
                            item.Meals = m.MealType;
                        }
                    }
                }
            }

            return(Json(dicList, JsonRequestBehavior.AllowGet));
        }
Esempio n. 3
0
        /// <summary>
        /// Generate PNR and Send Emal Notification
        /// </summary>
        /// <param name="travelReqId"></param>
        /// <param name="emailId"></param>
        /// <returns></returns>
        private string GeneratePNR(Int64 travelReqId, string emailId)
        {
            //Generate PNR For Approver or HOD
            string strHoldPNR         = ConfigurationManager.AppSettings["strHOLDPNR"].Trim();
            var    sodRequestsList    = new List <TravelRequestMasterModels>();
            var    sodflightList      = new List <FlightDetailModels>();
            var    passengerList      = new List <PassengerDetailModels>();
            var    passengerMealsList = new List <PassengerMealAllocationModels>();
            var    hotelList          = new List <TravelRequestHotelDetailModels>();

            var dicList = new Dictionary <string, object>();

            dicList            = _sodApproverRepositorty.GetSodBookingInfoForPNR(travelReqId);
            sodRequestsList    = dicList["bookingInfo"] as List <TravelRequestMasterModels>;
            sodflightList      = dicList["flightInfo"] as List <FlightDetailModels>;
            passengerList      = dicList["passInfo"] as List <PassengerDetailModels>;
            passengerMealsList = dicList["mealsInfo"] as List <PassengerMealAllocationModels>;
            hotelList          = dicList["hotelInfo"] as List <TravelRequestHotelDetailModels>;

            var reqType = sodRequestsList[0].SodBookingTypeId == 1 ? "SOD" : "NON-SOD";

            //Check Meal Option from Old allocation
            if (passengerMealsList.Count == 0)
            {
                //Add Passenger meal Option for SOD Flights
                foreach (var item in sodflightList)
                {
                    var passengerMealsListItem = new PassengerMealAllocationModels();
                    passengerMealsListItem.TravelRequestId = item.TravelRequestId;
                    passengerMealsListItem.Sector          = item.OriginPlace + "-" + item.DestinationPlace;
                    passengerMealsListItem.MealType        = sodRequestsList[0].Meals;
                    passengerMealsListItem.PassengerId     = 0;
                    passengerMealsList.Add(passengerMealsListItem);
                }
            }
            var pnr = NavitaireServices.Generate_PNR(sodRequestsList, sodflightList, passengerList, passengerMealsList);

            pnr = pnr + "|Close";
            //Update in database
            var c = _sodApproverRepositorty.UpdatePnr(pnr, travelReqId);

            if (c > 0)
            {
                var pnrc = pnr.Split('|')[0];
                if (sodRequestsList[0].IsAmountPaidByTraveller.Equals(true))
                {
                    //Get PNR Booking Time
                    var pnrInfo           = _sodApproverRepositorty.GetPNRAmountAndTime(sodRequestsList[0].TravelRequestId);
                    var holdAmount        = float.Parse(pnrInfo.Split('|')[1]);
                    var holdAmounts       = string.Format("{0:0.00}", holdAmount).ToString();
                    var pnrGenerationTime = Convert.ToDateTime(pnrInfo.Split('|')[2]);

                    //Get Hold Time
                    var holdDateTime = CommonWebMethod.CommonWebMethods.GetHoldBookingDateTime(sodRequestsList[0].SodBookingTypeId, sodRequestsList[0].BookingFor, sodflightList[0].TravelDate, sodflightList[0].DepartureTime, pnrGenerationTime);
                    var HoldTime     = holdDateTime.ToString("t");
                    var HoldDate     = holdDateTime.ToString("dd/MMM/yyyy");
                    var strholdDT    = HoldTime + " dated " + HoldDate;
                    strHoldPNR = strHoldPNR.Replace("[holdDT]", strholdDT);
                    strHoldPNR = strHoldPNR.Replace("[pnrAmt]", holdAmounts);
                    pnrc       = pnrc + "." + strHoldPNR;
                }
                else
                {
                    strHoldPNR = "";
                }

                //Send Email Notification
                var emailSubject           = reqType + " " + "Booking Request Notification Acceptance through Revenue and Itinerary :" + System.DateTime.Now.ToString("dd-MMM-yyyy-hh:mm:ss");
                var emailTemplateName_User = "******";
                var emailCredentials       = EmailCredentials(emailSubject, emailTemplateName_User, sodRequestsList, sodflightList, passengerList, passengerMealsList, hotelList, travelReqId.ToString(), "");
                emailCredentials.TemplateFilePath = emailCredentials.TemplateFilePath.Replace("[PNR]", pnrc);
                EmailNotifications.SendBookingRequestNotificationTo_Requester(emailCredentials, sodRequestsList[0].EmailId.Trim());
            }

            return(pnr.Split('|')[0].Trim().ToString());
        }