public List <SearchAdvanceRoomTypeResultVM> SearchAdvanceRoomType(SearchAdvanceRoomTypeParametersVM model)
{
SqlParameter[] parameters =
{
new SqlParameter {
ParameterName = "@RateTypeId", Value = model.RateTypeId
},
new SqlParameter {
ParameterName = "@ArrivalDate", Value = model.ArrivalDate
},
new SqlParameter {
ParameterName = "@NoOfNight", Value = model.NoOfNight
},
new SqlParameter {
ParameterName = "@DepartureDate", Value = model.DepartureDate
},
new SqlParameter {
ParameterName = "@RoomTypeCode", Value = model.RoomTypeCode
},
new SqlParameter {
ParameterName = "@Description", Value = model.Description
},
new SqlParameter {
ParameterName = "@AvailableRooms", Value = model.AvailableRooms
},
new SqlParameter {
ParameterName = "@RoomCapacity", Value = model.RoomCapacity
},
new SqlParameter {
ParameterName = "@IsWeekEndPrice", Value = model.IsWeekEndPrice
},
new SqlParameter {
ParameterName = "@UserId", Value = model.UserId
}
};
var dt = DALHelper.GetDataTableWithExtendedTimeOut("SearchAdvanceRoomType", parameters);
var results = new List <SearchAdvanceRoomTypeResultVM>();
results = DALHelper.CreateListFromTable <SearchAdvanceRoomTypeResultVM>(dt);
return(results);
}
public ActionResult SearchAdvanceRoomType(SearchAdvanceRoomTypeParametersVM model)
{
try
{
model.UserId = LogInManager.LoggedInUserId;
var roomTypes = roomTypeRepository.SearchAdvanceRoomType(model);
return(Json(new
{
IsSuccess = true,
data = roomTypes
}, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Utility.Utility.LogError(e, "SearchAdvanceRoomType");
return(Json(new { IsSuccess = false, errorMessage = e.Message }));
}
}
