public ActionResult SearchList(SearchListModel model)
{
//取得查詢資料
model.GetSearchList();
ViewBag.ResultMessage = TempData["ResultMessage"];
return(View(model));
}
public void OnPostSaveChecklistAsync_IfValidModel_ReturnPage()
{
var pageModel = new SearchListModel();
var result = pageModel.OnPostSaveChecklistAsync();
Assert.IsType <PageResult>(result);
}
public void OnGet_IfValidModel_ReturnPage()
{
var pageModel = new SearchListModel();
var result = pageModel.OnGet();
Assert.IsType <PageResult>(result);
}
public async Task <IActionResult> ChangePage(string title = null, int?categoryId = 0, int page = 1)
{
int pageSize = 10;
IEnumerable <AdvertisingModel> ads = await db.Advertisings.GetAllAsync();
if (categoryId != null && categoryId != 0)
{
ads = ads.Where(p => p.AdvertisingCategoryId == categoryId);
}
if (!String.IsNullOrEmpty(title))
{
ads = ads.Where(p => p.AdvertisingName.Contains(title));
}
var count = ads.Count();
var items = ads.Skip((page - 1) * pageSize).Take(pageSize).ToList();
SearchListModel viewModel = new SearchListModel
{
PageModel = new PageModel(count, page, pageSize),
FilterModel = new FilterModel(await db.AdvertisingCategories.GetAllAsync(), categoryId, title),
Ads = items
};
return(Ok(viewModel));
}
public void OnPostTrafficDensity_IfValidModel_ReturnPage()
{
var pageModel = new SearchListModel();
string testString = "test";
var result = pageModel.OnPostTrafficDensity(testString);
Assert.IsType <PageResult>(result);
}
public void OnGet_IfInvalidModel_ReturnBadRequest()
{
var pageModel = new SearchListModel();
pageModel.ModelState.AddModelError("Error", "Bad request: GET method failed in SearchList.cshtml.cs.");
var result = pageModel.OnGet();
Assert.IsType <BadRequestResult>(result);
}
public void OnPostTrafficDensity_IfInvalidModel_ReturnBadRequest()
{
var pageModel = new SearchListModel();
pageModel.ModelState.AddModelError("Error", "Bad request: OnPostSearchList method failed in SearchList.cshtml.cs.");
string testString = "test";
var result = pageModel.OnPostTrafficDensity(testString);
Assert.IsType <BadRequestResult>(result);
}
//accessing the DB to search for the available room for the selected dates by joining tables and sub query
internal SearchListModel SearchRooms(SearchRoomsModel searchInput)
{
SearchListModel searchListModel = new SearchListModel();
// #1.. Read the value from the appsettings.json and connect to DB
string connstr = configuration.GetConnectionString("HotelLandlystDB");
SqlConnection conn = new SqlConnection(connstr);
conn.Open();
// #2.. Create command and get the hands on the customerID
string query = "SELECT [ro].[roomType], [ro].[price], [ro].[miniBar], [ro].[aircondition], [ro].[petsPosible], [ro].[golfPosible], " +
"[ro].[roomId], [ro].[imageName], [rd].[roomDescription]" +
"FROM [dbo].[Rooms] [ro] " +
"join [dbo].[RoomDescriptions] as [rd] " +
"on [ro].[descriptionId] = [rd].[descriptionId] " +
"where [ro].[roomId] not in(select [roomId] from [Reservations] " +
"where @searchInputArriving between [arriving] and [departing] " +
"and @searchInputDeparting between [arriving] and [departing]) ";
//Applying the searchinputs to parameters
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("@searchInputArriving", searchInput.Arriving.ToString("yyyy/MM/dd"));
cmd.Parameters.AddWithValue("@searchInputDeparting", searchInput.Departing.ToString("yyyy/MM/dd"));
// #3.. Query the DB
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
while (reader.Read())
{
RoomModel room = new RoomModel
{
RoomType = (reader["roomType"].ToString()),
ImageName = (reader["imageName"].ToString()),
Price = (reader["price"].ToString()),
MiniBar = (reader["miniBar"].ToString()),
Aircondition = (reader["aircondition"].ToString()),
PetsPossible = (reader["petsPosible"].ToString()),
GolfPossible = (reader["golfPosible"].ToString()),
RoomDescription = (reader["roomDescription"].ToString())
};
searchListModel.AccessList().Add(room);
}
// #4.. Close the connection
conn.Close();
return(searchListModel);
}
private async void LoadSelectDiseaseActivity()
{
var progressBarDialog = new ProgressBarDialog("Va rugam asteptati", "Se aduc date...", this, false);
progressBarDialog.Show();
var list = new List <SearchListModel>();
if (listToBeSaved != null)
{
Log.Error("UpdateProfileActivity", "diseases count: " + listToBeSaved.Count);
foreach (PersonalDisease element in listToBeSaved)
{
var slm = new SearchListModel();
slm.Id = element.Cod;
slm.Title = element.Name;
slm.IsSelected = true;
list.Add(slm);
}
}
else
{
if (personalData.listOfPersonalDiseases.Count != 0)
{
Log.Error("UpdateProfileActivity", "diseases count: " + personalData.listOfPersonalDiseases.Count);
foreach (PersonalDisease element in personalData.listOfPersonalDiseases)
{
var slm = new SearchListModel();
slm.Id = element.Cod;
slm.Title = element.Name;
slm.IsSelected = true;
list.Add(slm);
}
}
}
var intent = new Intent(this, typeof(SearchListActivity));
intent.PutExtra("Items", JsonConvert.SerializeObject(await GetDiseaseList()));
intent.PutExtra("SelectedItems", JsonConvert.SerializeObject(list));
StartActivityForResult(intent, 3);
RunOnUiThread(() => progressBarDialog.Dismiss());
}
public async Task <IActionResult> SearchMovies(string searchQuery, int pageNumber)
{
if (pageNumber == 0)
{
pageNumber = 1;
}
var response = await _client.GetAsync($"?s={searchQuery}&page={pageNumber}&apikey=ab73b87f");
var movies = await response.Content.ReadAsAsync <SearchResultsRoot>();
List <string> tempList = new List <string>();
foreach (var item in _context.FavList)
{
tempList.Add(item.Title);
}
SearchListModel newListModel = new SearchListModel(movies, tempList);
return(View("Index", newListModel));
}
public ActionResult SearchList()
{
SearchListModel model = new SearchListModel();
return(SearchList(model));
}
public IActionResult queryresult(SearchListModel model)
{
return(Redirect(Config.GetUrl("videos/search/" + WebUtility.UrlEncode(UtilityBLL.ReplaceSpaceWithHyphin(model.Query)))));
}
public IActionResult queryresult(SearchListModel model)
{
return(Redirect(Config.GetUrl("blogs/search/" + WebUtility.UrlEncode(UtilityBLL.CleanSearchTerm(model.Query)))));
}
