public ActionResult GetLeftPayment(BiddingHotelsUpgrade objUpgrade) { try { var obj = new BiddingHotelsUpgrade(); if (TempData["BIdUpgradeHotels"] != null) { TempData.Keep(); obj = TempData["BIdUpgradeHotels"] as BiddingHotelsUpgrade; } var prop = obj.lstRoomsData.Where(u => u.iRoomId == objUpgrade.iRoomId).SingleOrDefault(); var obj1 = new eBiddingHotelsUpgradeRoomsList(); obj1 = prop as eBiddingHotelsUpgradeRoomsList; var result = BL_Bidding.UpdateUpgradeBidBookingUnfinished(Convert.ToInt64(objUpgrade.iBookingId), obj.iPropId, objUpgrade.iRoomId, obj1.TotalDifference, obj1.TaxDifference, objUpgrade.sAuthCode); if (result.Status == "Success") { var bookingModel = BL_Booking.GetBooking(Convert.ToInt64(objUpgrade.iBookingId)); 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 static BiddingHotelsUpgrade GetHotelUpgradeResult(int PropId, int BookingId) { SqlConnection objConn = default(SqlConnection); DataSet ds = new DataSet(); objConn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"].ToString()); objConn.Open(); BiddingHotelsUpgrade obj = new BiddingHotelsUpgrade(); SqlParameter[] MyParam = new SqlParameter[2]; MyParam[0] = new SqlParameter("@iBookingId", BookingId); MyParam[1] = new SqlParameter("@propid", PropId); ds = SqlHelper.ExecuteDataset(objConn, CommandType.StoredProcedure, "uspGetUpgradeList", MyParam); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { List <eBiddingHotelsUpgradeRoomsList> lstRooms = new List <eBiddingHotelsUpgradeRoomsList>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { List <eBiddingHotelsUpgradeImages> lstImages = new List <eBiddingHotelsUpgradeImages>(); for (int j = 0; j < ds.Tables[1].Rows.Count; j++) { if (Convert.ToInt32(ds.Tables[0].Rows[i]["iRoomId"]) == Convert.ToInt32(ds.Tables[1].Rows[j]["RoomId"].ToString())) { lstImages.Add(new eBiddingHotelsUpgradeImages() { iPropId = Convert.ToInt32(ds.Tables[1].Rows[j]["iPropId"]), RoomId = Convert.ToInt32(ds.Tables[1].Rows[j]["RoomId"]), bIsPrimaryR = Convert.ToBoolean(ds.Tables[1].Rows[j]["bIsPrimaryR"]), Image = ds.Tables[1].Rows[j]["Image"].ToString() }); } } List <eBiddingHotelsUpgradeViews> lstViews = new List <eBiddingHotelsUpgradeViews>(); for (int k = 0; k < ds.Tables[2].Rows.Count; k++) { if (Convert.ToInt32(ds.Tables[0].Rows[i]["iRoomId"]) == Convert.ToInt32(ds.Tables[2].Rows[k]["iRoomId"].ToString())) { lstViews.Add(new eBiddingHotelsUpgradeViews() { iPropId = Convert.ToInt32(ds.Tables[2].Rows[k]["iPropId"]), iRoomId = Convert.ToInt32(ds.Tables[2].Rows[k]["iRoomId"]), sView = ds.Tables[2].Rows[k]["sView"].ToString() }); } } List <eBiddingHotelsUpgradeFacilities> lstFacilities = new List <eBiddingHotelsUpgradeFacilities>(); for (int l = 0; l < ds.Tables[3].Rows.Count; l++) { if (Convert.ToInt32(ds.Tables[0].Rows[i]["iRoomId"]) == Convert.ToInt32(ds.Tables[3].Rows[l]["iRoomId"].ToString())) { lstFacilities.Add(new eBiddingHotelsUpgradeFacilities() { iPropId = Convert.ToInt32(ds.Tables[3].Rows[l]["iPropId"]), iRoomId = Convert.ToInt32(ds.Tables[3].Rows[l]["iRoomId"]), sFacility = ds.Tables[3].Rows[l]["sFacility"].ToString() }); } } var roomData = new eBiddingHotelsUpgradeRoomsList() { sRoomName = Convert.ToString(ds.Tables[0].Rows[i]["sRoomName"]), dSizeMtr = Convert.ToDecimal(ds.Tables[0].Rows[i]["dSizeMtr"]), dSizeSqft = Convert.ToDecimal(ds.Tables[0].Rows[i]["dSizeSqft"]), IsUpgradedRoom = Convert.ToBoolean(ds.Tables[0].Rows[i]["IsUpgradedRoom"]), iPropId = Convert.ToInt32(ds.Tables[0].Rows[i]["iPropId"]), dPrice = Convert.ToDecimal(ds.Tables[0].Rows[i]["dPrice"]), dDiscPrice = Convert.ToDecimal(ds.Tables[0].Rows[i]["dDiscPrice"]), iRoomId = Convert.ToInt32(ds.Tables[0].Rows[i]["iRoomId"]), iRPId = Convert.ToInt32(ds.Tables[0].Rows[i]["iRPId"]), dPriceWithTax = Convert.ToDecimal(ds.Tables[0].Rows[i]["dPriceWithTax"]), dTax = Convert.ToDecimal(ds.Tables[0].Rows[i]["dTax"]), sImgUrl = Convert.ToString(ds.Tables[0].Rows[i]["sImgUrl"]), TotalDifference = Convert.ToDecimal(ds.Tables[0].Rows[i]["Total Difference"]), TotalDifferenceConverted = Convert.ToDecimal(ds.Tables[0].Rows[i]["Total Difference Converted"]), TaxDifference = Convert.ToDecimal(ds.Tables[0].Rows[i]["Tax Difference"]), Amenity1 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity1"]), Amenity2 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity2"]), Amenity3 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity3"]), Amenity4 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity4"]), Amenity5 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity5"]), Amenity6 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity6"]), Amenity7 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity7"]), Amenity8 = Convert.ToString(ds.Tables[0].Rows[i]["Amenity8"]), Symbol = Convert.ToString(ds.Tables[0].Rows[i]["Symbol"]), lstImages = lstImages, lstViews = lstViews, lstfacilities = lstFacilities }; lstRooms.Add(roomData); } obj.lstRoomsData = lstRooms; } } objConn.Close(); return(obj); }