public ActionResult UpdateBooking(eBidding obj) { try { int bookingId, PropId; PropId = obj.SelectedPropId; bookingId = obj.iBookingId; eBidBookingResult Robj = BL_Bidding.UpdateBidBooking(bookingId, PropId); if (Robj.Status == "Success") { //var bookingModel = BL_Booking.GetBooking(bookingId); //string Status = "Thanks " + bookingModel.sFirstNameOFR + "! We have recieved your final payment."; //Task.Run(() => MailComponent.SendEmailAsync(bookingModel.sEmailOFR, "", "", "Hotel Selected", Status, null, null, false)); //Task.Run(() => clsUtils.sendSMS(bookingModel.sMobileOFR, Status)); return(RedirectToRoute("GuestInformation", new { bookingId = OneFineRateAppUtil.clsUtils.Encode(Convert.ToString(Robj.ID)) })); } } catch (Exception) { return(RedirectToAction("Index", "Home")); } return(View()); }
public ActionResult UpdateBooking(eBidding obj) { try { int bookingId, PropId; PropId = obj.SelectedPropId; bookingId = obj.iBookingId; eBidBookingResult Robj = BL_Bidding.UpdateBidBooking(bookingId, PropId); if (Robj.Status == "Success") { var bookingModel = BL_Booking.GetBooking(bookingId); string Status = "Thank you " + bookingModel.sTitleOFR + " " + bookingModel.sFirstNameOFR + "! We have recieved your final payment."; Task.Run(() => MailComponent.SendEmail(bookingModel.sEmailOFR, "", "", "Hotel Selected", Status, null, null, false, null, null)); Task.Run(() => clsUtils.sendSMS(bookingModel.sMobileOFR, Status)); Session["Result"] = "Hotel selected successfully!"; return(RedirectToAction("Index")); } } catch (Exception E) { Session["Result"] = "There was an error selecting the hotel. Please try again."; } return(RedirectToAction("Index")); }
public ActionResult UnfinishedHotelNotSelected(long bookingId) { eBidding objdata = new eBidding(); objdata = BL_Bidding.GetSearchedBidHotelsListForUnfinished(bookingId); objdata.iBookingId = (int)bookingId; TempData["BidSearchHotels"] = objdata; return(View(objdata)); }
/// <summary> /// After Final Selection of the bid property after making payment /// </summary> /// <param name="bookingid"></param> /// <param name="propid"></param> /// <param name="bidSearchHotels"></param> /// <returns></returns> public ActionResult GetUpgradeHotelDetails(int bookingid, int propid, string bidSearchHotels) { var obj = new eBidding(); if (Session[bidSearchHotels] != null) //TempData.Keep(); { obj = Session[bidSearchHotels] as eBidding; } var prop = obj.lstBidRoomsData.Where(u => u.iPropId == propid).SingleOrDefault(); BiddingHotelsUpgrade objUpgrade = BL_Bidding.GetHotelUpgradeResult(propid, bookingid); objUpgrade.objBidRoomsData = prop; objUpgrade.iBookingId = bookingid; objUpgrade.iPropId = propid; objUpgrade.BIdUpgradeHotels = "BIdUpgradeHotels" + Guid.NewGuid().ToString(); Session[objUpgrade.BIdUpgradeHotels] = objUpgrade; return(PartialView("BidInfo", objUpgrade)); }
public ActionResult GetUpgradeHotelDetails(int bookingid, int propid) { var obj = new eBidding(); if (TempData["BidSearchHotels"] != null) { TempData.Keep(); obj = TempData["BidSearchHotels"] as eBidding; } var prop = obj.lstBidRoomsData.Where(u => u.iPropId == propid).SingleOrDefault(); BiddingHotelsUpgrade objUpgrade = BL_Bidding.GetHotelUpgradeResult(propid, bookingid); objUpgrade.objBidRoomsData = prop; objUpgrade.iBookingId = bookingid; objUpgrade.iPropId = propid; TempData["BIdUpgradeHotels"] = objUpgrade; return(PartialView("BidInfo", objUpgrade)); }
public ActionResult GetBidSearchedHotels(string bookingId) { int bookId = Convert.ToInt32(clsUtils.Decode(bookingId)); //fetch the data of booking var booking = BL_Booking.GetBooking(bookId); if (booking.iPropId != null) { return(RedirectToAction("Index", "Home")); } eBidding objdata = new eBidding(); objdata = BL_Bidding.GetSearchedBidHotelsListForUnfinished(bookId); if (objdata.lstBidRoomsData.Count > 0) { DataTable dtPropIds = new DataTable(); dtPropIds.Columns.AddRange(new DataColumn[1] { new DataColumn("Id", typeof(int)) }); foreach (var item in objdata.lstBidRoomsData) { DataRow drpropid = dtPropIds.NewRow(); drpropid["Id"] = item.iPropId; dtPropIds.Rows.Add(drpropid); } BL_PropDetails.UpdateViewForConversion("B", dtPropIds, bookId); } objdata.iBookingId = bookId; objdata.BidSearchHotels = "BidSearchHotels" + Guid.NewGuid().ToString(); Session[objdata.BidSearchHotels] = objdata; return(View(objdata)); }
public static eBidding GetSearchedBidHotelsListForUnfinished(long BookingId) { SqlConnection objConn = default(SqlConnection); DataSet ds = new DataSet(); objConn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()); objConn.Open(); eBidding obj = new eBidding(); SqlParameter[] MyParam = new SqlParameter[1]; MyParam[0] = new SqlParameter("@iBookingId", Convert.ToInt32(BookingId)); ds = SqlHelper.ExecuteDataset(objConn, CommandType.StoredProcedure, "uspGetBidHotelsFinalListForUnfinished", MyParam); if (ds.Tables.Count > 0) { if (ds.Tables[1].Rows.Count > 0) { List <BidRoomsData> lstRooms = new List <BidRoomsData>(); List <int> lstPropIDs = new List <int>(); for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { List <BidAmenAppl> lstAppl = new List <BidAmenAppl>(); for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { if (Convert.ToInt32(ds.Tables[0].Rows[j]["iHotelId"]) == Convert.ToInt32(ds.Tables[1].Rows[i]["iPropId"].ToString())) { lstAppl.Add(new BidAmenAppl() { iHotelId = Convert.ToInt32(ds.Tables[0].Rows[j]["iHotelId"]), Amen = Convert.ToString(ds.Tables[0].Rows[j]["Amen"]), Appl = Convert.ToString(ds.Tables[0].Rows[j]["Appl"]) }); } } var a = new BidRoomsData(); a.LastBook = ds.Tables[1].Rows[i]["LastBook"].ToString(); a.Looking = ds.Tables[1].Rows[i]["Looking"] != DBNull.Value ? Convert.ToInt32(ds.Tables[1].Rows[i]["Looking"]) : 0; a.iRank = ds.Tables[1].Rows[i]["iRank"] != DBNull.Value ? Convert.ToInt32(ds.Tables[1].Rows[i]["iRank"]) : 0; a.sHotelName = Convert.ToString(ds.Tables[1].Rows[i]["sHotelName"]); a.sLocality = Convert.ToString(ds.Tables[1].Rows[i]["sLocality"]); //a.sDescription = Convert.ToString(ds.Tables[1].Rows[i]["sDescription"]); a.iStarCategoryId = Convert.ToInt16(ds.Tables[1].Rows[i]["iStarCategoryId"]); a.iPropId = Convert.ToInt32(ds.Tables[1].Rows[i]["iPropId"]); a.dPrice = ds.Tables[1].Rows[i]["dPrice"] != DBNull.Value ? Convert.ToDecimal(ds.Tables[1].Rows[i]["dPrice"]) : 0; a.dDiscPrice = ds.Tables[1].Rows[i]["dDiscPrice"] != DBNull.Value ? Convert.ToDecimal(ds.Tables[1].Rows[i]["dDiscPrice"]) : 0; a.iRoomId = Convert.ToInt32(ds.Tables[1].Rows[i]["iRoomId"]); a.iRPId = Convert.ToInt32(ds.Tables[1].Rows[i]["iRPId"]); a.sImgUrl = Convert.ToString(ds.Tables[1].Rows[i]["sImgUrl"]); a.Discount = Convert.ToDecimal(ds.Tables[1].Rows[i]["Discount"]); a.bUpgrade = ds.Tables[1].Rows[i]["bUpgrade"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[1].Rows[i]["bUpgrade"]) : false; a.Amenity1 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity1"]); a.Amenity2 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity2"]); a.Amenity3 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity3"]); a.Amenity4 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity4"]); a.Amenity5 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity5"]); a.Amenity6 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity6"]); a.Amenity7 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity7"]); a.Amenity8 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity8"]); a.Amenity9 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity9"]); a.Amenity10 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity10"]); a.Amenity11 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity11"]); a.Amenity12 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity12"]); a.Amenity13 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity13"]); a.Amenity14 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity14"]); a.Amenity15 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity15"]); a.Amenity16 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity16"]); a.Amenity17 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity17"]); a.Amenity18 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity18"]); a.dLatitude = ds.Tables[1].Rows[i]["dLatitude"] != DBNull.Value ? Convert.ToDecimal(ds.Tables[1].Rows[i]["dLatitude"]) : 0; a.dLongitude = ds.Tables[1].Rows[i]["dLongitude"] != DBNull.Value ? Convert.ToDecimal(ds.Tables[1].Rows[i]["dLongitude"]) : 0; a.rating_image_url = Convert.ToString(ds.Tables[1].Rows[i]["rating_image_url"]); a.rating = ds.Tables[1].Rows[i]["rating"] != DBNull.Value ? Convert.ToDecimal(ds.Tables[1].Rows[i]["rating"]) : 0; a.ranking_string = Convert.ToString(ds.Tables[1].Rows[i]["ranking_string"]); a.bIsTopHotel = ds.Tables[1].Rows[i]["bIsTopHotel"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsTopHotel"]) : false; a.bIsPopularHotel = ds.Tables[1].Rows[i]["bIsPopularHotel"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsPopularHotel"]) : false; a.bIsNew = ds.Tables[1].Rows[i]["bIsNew"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsNew"]) : false; a.bIsHighDemand = ds.Tables[1].Rows[i]["bIsHighDemand"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsHighDemand"]) : false; a.sCurrencySymbol = Convert.ToString(ds.Tables[1].Rows[i]["Symbol"]); a.lstBidAmenAppl = lstAppl; a.ExtraTaxPer = Convert.ToString(ds.Tables[1].Rows[i]["ExtraTaxPer"]); lstRooms.Add(a); } obj.lstBidRoomsData = lstRooms; obj.sCheckIn = Convert.ToString(ds.Tables[2].Rows[0]["dtCheckIn"]); obj.sCheckOut = Convert.ToString(ds.Tables[2].Rows[0]["dtChekOut"]); obj.sCheckInDateDisplay = Convert.ToString(ds.Tables[2].Rows[0]["sCheckInDate"]); obj.sCheckOutDateDisplay = Convert.ToString(ds.Tables[2].Rows[0]["sCheckOutDate"]); } } objConn.Close(); return(obj); }
public static eBidding GetSearchedBidHotelsList(DateTime checkin, DateTime checkout, string currency, int StarRating, DataTable dtTblRoomOccupancySearch, DataTable dtTblChildrenAgeSearch, string Type, DataTable dtIds, decimal BidAmount) { SqlConnection objConn = default(SqlConnection); DataSet ds = new DataSet(); objConn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()); objConn.Open(); eBidding obj = new eBidding(); SqlParameter[] MyParam = new SqlParameter[9]; MyParam[0] = new SqlParameter("@dtCheckIn", checkin); MyParam[1] = new SqlParameter("@dtCheckOut", checkout); MyParam[2] = new SqlParameter("@Currency", currency); MyParam[3] = new SqlParameter("@iStarCategory", StarRating); MyParam[4] = new SqlParameter("@RoomOccupancySearch", dtTblRoomOccupancySearch); MyParam[4].TypeName = "[dbo].[RoomOccupancySearch]"; MyParam[5] = new SqlParameter("@ChildrenAgeSearch", dtTblChildrenAgeSearch); MyParam[5].TypeName = "[dbo].[ChildrenAgeSearch]"; MyParam[6] = new SqlParameter("@sType", Type); MyParam[7] = new SqlParameter("@Ids", dtIds); MyParam[7].TypeName = "[dbo].[Ids]"; MyParam[8] = new SqlParameter("@dBidAmount", BidAmount); ds = SqlHelper.ExecuteDataset(objConn, CommandType.StoredProcedure, "uspGetBidHotelsFinalList", MyParam); if (ds.Tables.Count > 0) { if (ds.Tables[1].Rows.Count > 0) { List <BidRoomsData> lstRooms = new List <BidRoomsData>(); for (int i = 0; i < ds.Tables[1].Rows.Count; i++) { List <BidAmenAppl> lstAppl = new List <BidAmenAppl>(); for (int j = 0; j < ds.Tables[0].Rows.Count; j++) { if (Convert.ToInt32(ds.Tables[0].Rows[j]["iHotelId"]) == Convert.ToInt32(ds.Tables[1].Rows[i]["iPropId"].ToString())) { lstAppl.Add(new BidAmenAppl() { iHotelId = Convert.ToInt32(ds.Tables[0].Rows[j]["iHotelId"]), Amen = Convert.ToString(ds.Tables[0].Rows[j]["Amen"]), Appl = Convert.ToString(ds.Tables[0].Rows[j]["Appl"]) }); } } var roomData = new BidRoomsData() { LastBook = ds.Tables[1].Rows[i]["LastBook"].ToString(), Looking = Convert.ToInt32(ds.Tables[1].Rows[i]["Looking"]), iRank = Convert.ToInt32(ds.Tables[1].Rows[i]["iRank"]), sHotelName = Convert.ToString(ds.Tables[1].Rows[i]["sHotelName"]), sLocality = Convert.ToString(ds.Tables[1].Rows[i]["sLocality"]), //sDescription = Convert.ToString(ds.Tables[1].Rows[i]["sDescription"]), iStarCategoryId = Convert.ToInt16(ds.Tables[1].Rows[i]["iStarCategoryId"]), iPropId = Convert.ToInt32(ds.Tables[1].Rows[i]["iPropId"]), dPrice = Convert.ToDecimal(ds.Tables[1].Rows[i]["dPrice"]), dDiscPrice = Convert.ToDecimal(ds.Tables[1].Rows[i]["dDiscPrice"]), iRoomId = Convert.ToInt32(ds.Tables[1].Rows[i]["iRoomId"]), iRPId = Convert.ToInt32(ds.Tables[1].Rows[i]["iRPId"]), sImgUrl = Convert.ToString(ds.Tables[1].Rows[i]["sImgUrl"]), Discount = Convert.ToDecimal(ds.Tables[1].Rows[i]["Discount"]), bUpgrade = Convert.ToBoolean(ds.Tables[1].Rows[i]["bUpgrade"]), Amenity1 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity1"]), Amenity2 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity2"]), Amenity3 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity3"]), Amenity4 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity4"]), Amenity5 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity5"]), Amenity6 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity6"]), Amenity7 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity7"]), Amenity8 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity8"]), Amenity9 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity9"]), Amenity10 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity10"]), Amenity11 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity11"]), Amenity12 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity12"]), Amenity13 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity13"]), Amenity14 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity14"]), Amenity15 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity15"]), Amenity16 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity16"]), Amenity17 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity17"]), Amenity18 = Convert.ToString(ds.Tables[1].Rows[i]["Amenity18"]), dLatitude = Convert.ToInt32(ds.Tables[1].Rows[i]["dLatitude"]), dLongitude = Convert.ToInt32(ds.Tables[1].Rows[i]["dLongitude"]), rating_image_url = Convert.ToString(ds.Tables[1].Rows[i]["rating_image_url"]), rating = Convert.ToDecimal(ds.Tables[1].Rows[i]["rating"]), ranking_string = Convert.ToString(ds.Tables[1].Rows[i]["ranking_string"]), bIsTopHotel = Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsTopHotel"]), bIsPopularHotel = Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsPopularHotel"]), bIsNew = Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsNew"]), bIsHighDemand = Convert.ToBoolean(ds.Tables[1].Rows[i]["bIsHighDemand"]), sCurrencySymbol = Convert.ToString(ds.Tables[1].Rows[i]["Symbol"]), lstBidAmenAppl = lstAppl }; lstRooms.Add(roomData); } obj.lstBidRoomsData = lstRooms; } } objConn.Close(); return(obj); }