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);
}
