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