Ejemplo n.º 1
0
        /// <summary>
        /// Send SMS for Approval
        /// </summary>
        /// <param name="reqId"></param>
        /// <param name="paxName"></param>
        /// <param name="approvalURI"></param>
        public void SendSMSforApproval(string hoddetails, TravelRequestMasterModels sodRequest, List <TravelRequestHotelDetailModels> hotelInfo, string appURI, string rejURI)
        {
            var smsText = ConfigurationManager.AppSettings["smsApprovalOnlyHotel"].ToString().Replace("@Hodname", hoddetails.Split(',')[1]);

            smsText = smsText.Replace("@PaxName", sodRequest.Title + " " + sodRequest.RequestedEmpName);
            smsText = smsText.Replace("@Sector", hotelInfo[0].City);
            smsText = smsText.Replace("@CheckInDate", hotelInfo[0].CheckInDate.ToString("dd/MMM/yyyy"));
            smsText = smsText.Replace("@CheckOutDate", hotelInfo[0].CheckOutDate.ToString("dd/MMM/yyyy"));
            smsText = smsText.Replace("@ReqId", sodRequest.TravelRequestId.ToString());
            smsText = smsText.Replace("@BookigFor", "Only Hotel booking");
            smsText = smsText.Replace("[AppQueryString]", appURI);
            smsText = smsText.Replace("[RejQueryString]", rejURI);
            smsText = System.Uri.EscapeDataString(smsText);
            smsText = smsText.Replace("25", "");
            //Send SMS
            var smsLogModel = new SodApproverSMSLogModels();

            smsLogModel.TrRequestId  = sodRequest.TravelRequestId;
            smsLogModel.EmpCode      = hoddetails.Split(',')[4];
            smsLogModel.EmpName      = hoddetails.Split(',')[1];
            smsLogModel.EmailID      = hoddetails.Split(',')[0];
            smsLogModel.MobileNo     = "7982641262";//hoddetails.Split(',')[3];
            smsLogModel.Source       = "Only Hotel";
            smsLogModel.SMSText      = smsText;
            smsLogModel.DeliveryDate = DateTime.Now;
            var status = SmsNotification.SmsNotifications.SendSmsViaApi(smsText, hoddetails.Split(',')[3]);

            smsLogModel.IsDelivered = status.Equals(true) ? true : false;
            _userRepository.SaveApproverSMSLog(smsLogModel);
        }
Ejemplo n.º 2
0
        /// <summary>
        /// Save Data in Sod ravel Request Mster-Standby NPR Model
        /// If Revenue say "No with SandBy"
        /// </summary>
        /// <param name="trMasterList"></param>
        /// <param name="strPNR"></param>
        /// <returns></returns>
        public bool SaveRejectwithStandByPNR(TravelRequestMasterModels sodRequestsList, string pnr)
        {
            var objRejectList = new TravelRequestMasterModels_RejectwithStandByPNR
            {
                TravelRequestId  = sodRequestsList.TravelRequestId,
                BookingFor       = sodRequestsList.BookingFor,
                RequestedEmpId   = sodRequestsList.RequestedEmpId,
                RequestedEmpCode = sodRequestsList.RequestedEmpCode,
                Title            = sodRequestsList.Title,
                RequestedEmpName = sodRequestsList.RequestedEmpName,
                Email            = sodRequestsList.EmailId,
                MobileNo         = sodRequestsList.Phno,
                Pnr                     = pnr.Split('|')[0],
                PnrAmount               = Convert.ToDecimal(pnr.Split('|')[1]),
                PNRCreateddate          = DateTime.Now,
                PNRCreatedby            = "Revenue Dept.",
                IsAmountPaidByTraveller = sodRequestsList.IsAmountPaidByTraveller,
                IsHotelRequired         = sodRequestsList.IsHotelRequired,
                IsOKtoBoard             = sodRequestsList.IsOKtoBoard,
                HotelApproval           = sodRequestsList.HotelApproval,
                SJSCHodEmailId          = sodRequestsList.SJSCHodEmailId,
                IsVendorBooking         = sodRequestsList.IsVendorBooking,
                IsSJSC                  = sodRequestsList.IsSJSC
            };
            var s = _sodApproverRepositorty.SaveRejectwithStandByPNR_Revenue(objRejectList);

            return(true);
        }
        /// <summary>
        /// Close Booking Request After Rejection of the Request from HOD
        /// Stand By Case
        /// </summary>
        /// <param name="trRequest"></param>
        /// <returns></returns>
        public int CloseSodBookingRequest_HOD(TravelRequestMasterModels trRequest)
        {
            //Booking Request Master for Close Request
            var closeItem = _context.TravelRequestMasterModel.Where(o => o.TravelRequestId == trRequest.TravelRequestId).ToList();

            if (closeItem.Count() > 0)
            {
                foreach (var p in closeItem)
                {
                    p.BookingStatus = trRequest.BookingStatus;
                    p.StatusDate    = trRequest.StatusDate;
                }
            }
            return(_context.SaveChanges());
        }
Ejemplo n.º 4
0
        /// <summary>
        /// Reject Sod Booking Request
        /// </summary>
        /// <returns></returns>
        public JsonResult RejectSodBookingRequest(string travelReqId)
        {
            var jsonmsg     = string.Empty;
            var bookingType = string.Empty;
            var strHoldPNR  = string.Empty;

            if ((travelReqId.Split(',')[0] == "undefined") || (travelReqId.Split(',')[0] == ""))
            {
                return(Json("Invalid record.", JsonRequestBehavior.AllowGet));
            }
            var approvalList = new TravelRequestApprovalModels()
            {
                TravelRequestId       = Convert.ToInt64(travelReqId.Split(',')[0]),
                ApprovedByEmpId       = Convert.ToInt32(Session["EmpId"].ToString()),
                RevenueApprovedStatus = 2,//for reject
                RevenueApprovedDate   = System.DateTime.Now,
                Comment = travelReqId.Split(',')[4]
            };
            //Check Duplicate PNR
            var chkpnr = Services.ADO.SodCommonServices.CheckDuplicatePNR(Convert.ToInt64(travelReqId.Split(',')[0]), 1);

            if (!chkpnr.Equals("0"))
            {
                return(Json("Sorry : PNR has been already generated for this Booking Request ID-" + travelReqId.Split(',')[0] + ".Rejection is not allowed.\n Existing PNR No. :" + chkpnr, JsonRequestBehavior.AllowGet));
            }

            //Get Data to show for rejection
            var sodRequestsList    = new List <TravelRequestMasterModels>();
            var sodflightList      = new List <FlightDetailModels>();
            var passengerList      = new List <PassengerDetailModels>();
            var approvalInfoList   = new List <TravelRequestApprovalModels>();
            var passengerMealsList = new List <PassengerMealAllocationModels>();
            var hotelList          = new List <TravelRequestHotelDetailModels>();
            var s = _sodApproverRepositorty.RejectSodBookingRequest_Revenue(approvalList);

            if (s >= 1)
            {
                var dicList = new Dictionary <string, object>();
                dicList            = _sodApproverRepositorty.GetSodBookingInfoForPNR(Convert.ToInt64(travelReqId.Split(',')[0]));
                sodRequestsList    = dicList["bookingInfo"] as List <TravelRequestMasterModels>;
                sodflightList      = dicList["flightInfo"] as List <FlightDetailModels>;
                passengerList      = dicList["passInfo"] as List <PassengerDetailModels>;
                approvalInfoList   = dicList["approvalInfo"] as List <TravelRequestApprovalModels>;
                passengerMealsList = dicList["mealsInfo"] as List <PassengerMealAllocationModels>;
                hotelList          = dicList["hotelInfo"] as List <TravelRequestHotelDetailModels>;
                bookingType        = sodRequestsList[0].SodBookingTypeId == 1 ? "SOD" : "NON-SOD";

                //by lata (to gnerate standby PNR and send Email notification
                if (travelReqId.Split(',')[5] == "1")
                {
                    sodRequestsList[0].BookingFor = "standby";
                    var pnr = NavitaireServices.Generate_PNR(sodRequestsList, sodflightList, passengerList, passengerMealsList);
                    pnr = pnr + "|0001.11";
                    var pnrc = "Your Standby PNR is :" + pnr.Split('|')[0];
                    //insert value in sodtravelrequestmaster_reject with standbyPNR
                    SaveRejectwithStandByPNR(sodRequestsList[0], pnr);

                    sendNotification_RejectStandby(sodRequestsList, sodflightList, passengerList, passengerMealsList, hotelList, travelReqId.Split(',')[0], pnrc);
                }
                //Hold PNR
                if (sodRequestsList[0].IsAmountPaidByTraveller.Equals(true))
                {
                    strHoldPNR = ConfigurationManager.AppSettings["strHOLDPNRPassenger"].Trim();
                }
                else
                {
                    strHoldPNR = "";
                }
                //Send Rejection Email Notification
                var emailSubject      = bookingType + " " + "Booking Request Notification Rejection through Revenue and Itinerary :" + System.DateTime.Now.ToString("dd-MMM-yyyy-hh:mm:ss");
                var emailTemplateName = "SodBookingRequest_Rejection_User.html";
                var emailCredentials  = EmailCredentials(emailSubject, emailTemplateName, sodRequestsList, sodflightList, passengerList, passengerMealsList, hotelList, travelReqId.Split(',')[0].ToString(), strHoldPNR);

                if (approvalInfoList[0].IsMandatoryTravel == 1)
                {
                    emailCredentials.TemplateFilePath = emailCredentials.TemplateFilePath.Replace("[Team]", "Revenue Dept. and forwarded to C-Level Approval.");
                }
                else if (approvalInfoList[0].IsMandatoryTravel == 0)
                {
                    emailCredentials.TemplateFilePath = emailCredentials.TemplateFilePath.Replace("[Team]", "Revenue Dept. and the booking request has been closed.");
                }

                TempData["emailData"] = emailCredentials;
                TempData["emailId"]   = sodRequestsList[0].EmailId.Trim();

                //Check If Mandatory for send email
                if (approvalInfoList[0].IsMandatoryTravel == 1)
                {
                    emailSubject      = bookingType + " " + "Booking Request Notification Rejection through Revenue and Itinerary :" + System.DateTime.Now.ToString("dd-MMM-yyyy-hh:mm:ss");
                    emailTemplateName = "SodBookingRequestNotificationTemplate_HOD.html";

                    //Send Notification to C-Level: Need C- Level Approval Email Template
                    var      counter  = 0;
                    var      emailids = _sodApproverRepositorty.GetCXOMailId(sodRequestsList[0].CLevelApprover1, sodRequestsList[0].CLevelApprover2);
                    string[] arr      = emailids.Split('|');

                    if (arr.Length == 2)
                    {
                        counter = 1;
                    }
                    else if (arr.Length == 4)
                    {
                        counter = 2;
                    }

                    for (int i = 0; i <= counter; i++)
                    {
                        var skey = new StringBuilder();
                        skey.Append(sodRequestsList[0].TravelRequestId.ToString() + ",");
                        skey.Append(sodRequestsList[0].EmailId.Trim() + ",");
                        skey.Append(sodRequestsList[0].SodBookingTypeId.ToString() + ",");
                        skey.Append(sodRequestsList[0].BookingFor.Trim() + ",");
                        skey.Append(arr[i] + ",");
                        skey.Append(sodRequestsList[0].IsMandatoryTravel.ToString() + ",RN");

                        var uri1 = ConfigurationManager.AppSettings["emailApprovalPathcxo"].Trim() + "?str=" + CipherURL.Encrypt(skey + "&type=a");
                        var uri2 = ConfigurationManager.AppSettings["emailApprovalPathcxo"].Trim() + "?str=" + CipherURL.Encrypt(skey + "&type=r");

                        var approvaltype = "Please help to accord your Acceptance or Rejection.";
                        var appLink      = "<table><tr style='font-family:Arial;'><td style='width:110px; height:25px; background-color:#04B431;text-align:center;border-radius:5px'><a name='app' style='color:#fff; text-decoration:none;' href='" + uri1 + "'>Acceptance</a></td> <td>&nbsp;</td> <td style='width:110px; height:25px; background-color:#b33;text-align:center;border-radius:5px'><a name='rej' style='color:#fff; text-decoration:none;' href='" + uri2 + "'>Rejection</a> </td></tr></table>";

                        //Wrap link in template
                        emailCredentials = EmailCredentials(emailSubject, emailTemplateName, sodRequestsList, sodflightList, passengerList, passengerMealsList, hotelList, travelReqId.Split(',')[0].ToString(), strHoldPNR);
                        var templateData = emailCredentials.TemplateFilePath;
                        var hodName      = "Sir/Madam";

                        templateData = templateData.Replace("[approvaltype]", approvaltype);
                        templateData = templateData.Replace("[appLink]", appLink);
                        templateData = templateData.Replace("[hodName]", hodName);
                        emailCredentials.TemplateFilePath = templateData;
                        i = i + 1;
                        EmailNotifications.SendBookingRequestNotificationTo_Requester(emailCredentials, arr[i]);
                    }
                    jsonmsg = bookingType + " " + "booking request has been rejected and has been sent to CXO Panel.";
                }
                else if (approvalInfoList[0].IsMandatoryTravel == 0)
                {
                    //This methos also can be used by Revenue dept to close the Booking Request
                    var trRequestMaster = new TravelRequestMasterModels()
                    {
                        TravelRequestId = Convert.ToInt64(travelReqId.Split(',')[0]),
                        BookingStatus   = "Close",
                        StatusDate      = System.DateTime.Now
                    };
                    var c = _sodApproverRepositorty.CloseSodBookingRequest_HOD(trRequestMaster);
                    jsonmsg = bookingType + " " + "booking request has been rejected and the request has been closed.";
                }
            }
            return(Json(s >= 1 ? jsonmsg : string.Empty, JsonRequestBehavior.AllowGet));
        }