public ActionResult SearchAdvanceRoom(SearchAdvanceRoomParametersVM model)
{
try
{
if (model.RoomFeatures != null && model.RoomFeatures.Count > 0)
{
model.RoomFeaturesIds = String.Join(",", model.RoomFeatures.ToArray());
}
model.UserId = LogInManager.LoggedInUserId;
var rooms = roomRepository.SearchAdvanceRoom(model);
return(Json(new
{
IsSuccess = true,
data = rooms
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Utility.Utility.LogError(e, "SearchAdvanceRoom");
return(Json(new { IsSuccess = false, errorMessage = e.Message }));
}
}
public List <SearchAdvanceRoomResultVM> SearchAdvanceRoom(SearchAdvanceRoomParametersVM model)
{
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@RoomTypeId", Value = model.RoomTypeId
},
new SqlParameter {
ParameterName = "@ArrivalDate", Value = model.ArrivalDate
},
new SqlParameter {
ParameterName = "@NoOfNight", Value = model.NoOfNight
},
new SqlParameter {
ParameterName = "@DepartureDate", Value = model.DepartureDate
},
new SqlParameter {
ParameterName = "@RoomNo", Value = model.RoomNo
},
new SqlParameter {
ParameterName = "@Type", Value = model.Type
},
new SqlParameter {
ParameterName = "@RoomFeatures", Value = model.RoomFeaturesIds
},
new SqlParameter {
ParameterName = "@IsClean", Value = model.IsClean
},
new SqlParameter {
ParameterName = "@IsDirty", Value = model.IsDirty
},
new SqlParameter {
ParameterName = "@IsInspected", Value = model.IsInspected
},
new SqlParameter {
ParameterName = "@ReservationId", Value = model.ReservationId
},
new SqlParameter {
ParameterName = "@UserId", Value = model.UserId
}
};
var dt = DALHelper.GetDataTableWithExtendedTimeOut("SearchAdvanceRoom", parameters);
var results = new List <SearchAdvanceRoomResultVM>();
results = DALHelper.CreateListFromTable <SearchAdvanceRoomResultVM>(dt);
return(results);
}
public ActionResult ShowCheckInPaymentMethod(Guid reservationId, string source = "")
{
try
{
var reservation = reservationRepository.GetReservationById(reservationId, LogInManager.LoggedInUserId).FirstOrDefault();
var paymentMethodList = paymentMethodRepository.GetPaymentMethods();
#region Room Mapping
//Get Room Mapping
var selectedRooms = roomRepository.GetReservationRoomMapping(reservationId, null, LogInManager.LoggedInUserId);
var roomIds = string.Empty;
var roomNumbers = string.Empty;
if (selectedRooms != null && selectedRooms.Count > 0)
{
foreach (var room in selectedRooms)
{
roomIds += string.Format("{0},", room.RoomId);
roomNumbers += string.Format("{0}, ", room.RoomNo);
}
if (!string.IsNullOrWhiteSpace(roomIds))
{
//Remove Last Comma.
roomIds = Utility.Utility.RemoveLastCharcter(roomIds, ',');
}
if (!string.IsNullOrWhiteSpace(roomNumbers))
{
//Remove Last Comma.
roomNumbers = Utility.Utility.RemoveLastCharcter(roomNumbers, ',');
}
}
else
{
SearchAdvanceRoomParametersVM searchRoomModel = new SearchAdvanceRoomParametersVM();
searchRoomModel.RoomTypeId = reservation.RoomTypeId;
searchRoomModel.ArrivalDate = reservation.ArrivalDate;
searchRoomModel.NoOfNight = reservation.NoOfNight;
searchRoomModel.DepartureDate = reservation.DepartureDate;
searchRoomModel.RoomNo = string.Empty;
searchRoomModel.Type = string.Empty;
searchRoomModel.IsClean = true; //only take clean room.
searchRoomModel.UserId = LogInManager.LoggedInUserId;
var availableRoomList = roomRepository.SearchAdvanceRoom(searchRoomModel);
if (availableRoomList != null && availableRoomList.Count > 0)
{
//Get default available rooms by top.
availableRoomList = availableRoomList.Take(reservation.NoOfRoom.HasValue ? reservation.NoOfRoom.Value : 1).ToList();
foreach (var room in availableRoomList)
{
roomIds += string.Format("{0},", room.RoomId);
roomNumbers += string.Format("{0}, ", room.RoomNo);
}
if (!string.IsNullOrWhiteSpace(roomIds))
{
//Remove Last Comma.
roomIds = Utility.Utility.RemoveLastCharcter(roomIds, ',');
}
if (!string.IsNullOrWhiteSpace(roomNumbers))
{
//Remove Last Comma.
roomNumbers = Utility.Utility.RemoveLastCharcter(roomNumbers, ',');
}
}
}
#endregion
CheckInPaymentMethodVM model = new CheckInPaymentMethodVM();
model.ReservationId = reservation.Id;
model.ProfileId = reservation.ProfileId;
model.CheckInDate = reservation.ArrivalDate;
model.CheckInTime = reservation.ETA;
if (reservation.ETA.HasValue)
{
model.CheckInTimeText = string.Format("{0:hh\\:mm\\:ss}", reservation.ETA.Value);
}
model.NoOfRoom = reservation.NoOfRoom.HasValue ? reservation.NoOfRoom.Value : 1;
model.Name = Convert.ToString(reservation.LastName + " " + reservation.FirstName).Trim();
model.PaymentMethodId = reservation.PaymentMethodId;
//Decrypt Credit Card#
model.CreditCardNo = Utility.Utility.Decrypt(reservation.CreditCardNo, Utility.Utility.EncryptionKey);
//Original Credit Card#
ViewData["OriginalCreditCardNo"] = model.CreditCardNo;
//Mask Credit Card#
model.CreditCardNo = Utility.Utility.MaskCreditCardNo(model.CreditCardNo);
model.CardExpiryDate = reservation.CardExpiryDate;
model.RoomNumbers = roomNumbers;
model.RoomIds = roomIds;
model.RoomTypeId = reservation.RoomTypeId;
ViewData["Source"] = source;
ViewData["ArrivalDate"] = reservation.ArrivalDate.HasValue ? reservation.ArrivalDate.Value.ToString("dd/MM/yyyy") : "";
ViewData["DepartureDate"] = reservation.DepartureDate.HasValue ? reservation.DepartureDate.Value.ToString("dd/MM/yyyy") : "";
ViewData["PaymentMethodList"] = paymentMethodList;
return(PartialView("_PaymentMethod", model));
}
catch (Exception e)
{
Utility.Utility.LogError(e, "ShowCheckInPaymentMethod");
return(Json(new { IsSuccess = false, errorMessage = e.Message }));
}
}
