public ActionResult SearchPage() { SearchViewModel vm = new SearchViewModel(); SearchCategoryDal C_dal = new SearchCategoryDal(); List <SearchCategory> CategoryList = C_dal.Category.ToList <SearchCategory>(); SearchSubCategoryDal S_dal = new SearchSubCategoryDal(); List <SearchSubCategory> SubCategoryList = S_dal.SubCategory.ToList <SearchSubCategory>(); var JoinTables = from subcategoy in SubCategoryList join category in CategoryList on subcategoy.CategoryID equals category.CategoryID select new { Category = category.CategoryName, Subcategory = subcategoy.SubCategory }; List <Search1> searchList = new List <Search1>(); foreach (var item in JoinTables) { Search1 temp = new Search1(); temp.Category = item.Category; temp.SubCategory = item.Subcategory; searchList.Add(temp); } vm.Categories = searchList; return(View("SearchPage", vm)); }
public ActionResult ChangeCategory() { string Selected = Request.Form["Category"]; SearchViewModel vm = new SearchViewModel(); ViewData["selectedCategory"] = Selected; // send the data to View SearchCategoryDal C_dal = new SearchCategoryDal(); List <SearchCategory> CategoryList = C_dal.Category.ToList <SearchCategory>(); SearchSubCategoryDal S_dal = new SearchSubCategoryDal(); List <SearchSubCategory> SubCategoryList = S_dal.SubCategory.ToList <SearchSubCategory>(); var JoinTables = from subcategoy in SubCategoryList join category in CategoryList on subcategoy.CategoryID equals category.CategoryID select new { Category = category.CategoryName, Subcategory = subcategoy.SubCategory }; List <Search1> searchList = new List <Search1>(); foreach (var item in JoinTables) { Search1 temp = new Search1(); temp.Category = item.Category; temp.SubCategory = item.Subcategory; searchList.Add(temp); } //SearchDal dal = new SearchDal(); // no join table //List<Search> searchList = dal.Categories.ToList<Search>(); // no join table if (Selected != "All Categories") { for (int i = 0; i < searchList.Count(); i++) { if (searchList[i].Category != Selected) { searchList[i].SubCategory = null; } } } // searchList get data from DB vm.Categories = searchList; // vm get data from searchList return(View("SearchPage", vm)); }
protected void BtnOkClick(object sender, EventArgs e) { try { bindingControl.Data = new SupplierSearch(); bindingControl.CollectData(); Search1.RegisterReturnValue(bindingControl.Data); } catch (Exception ex) { WebUtility.RegisterClientErrorMessage(ex); } }
public ActionResult SearchPage() { // save the url string url = Request.Url.PathAndQuery; SearchViewModel vm = new SearchViewModel(); SearchCategoryDal C_dal = new SearchCategoryDal(); List <SearchCategory> CategoryList = C_dal.Category.ToList <SearchCategory>(); SearchSubCategoryDal S_dal = new SearchSubCategoryDal(); List <SearchSubCategory> SubCategoryList = S_dal.SubCategory.ToList <SearchSubCategory>(); var JoinTables = from subcategoy in SubCategoryList join category in CategoryList on subcategoy.CategoryID equals category.CategoryID select new { Category = category.CategoryName, Subcategory = subcategoy.SubCategory }; List <Search1> searchList = new List <Search1>(); foreach (var item in JoinTables) { Search1 temp = new Search1(); temp.Category = item.Category; temp.SubCategory = item.Subcategory; searchList.Add(temp); } vm.Categories = searchList; //return PartialView("~/Views/Mechanical/Fans.cshtml", vm); return(View("SharedSearchBar", vm)); }
// HAV Fans public ActionResult SelectSubCategory() { string selectedSbuCategory = Request.Form["SubCategory"]; //var JoinedTable = TempData["JoinedTable"] as IEnumerable<Search> // useless; string selectedCategory = ""; SearchCategoryDal C_dal = new SearchCategoryDal(); List <SearchCategory> CategoryList = C_dal.Category.ToList <SearchCategory>(); SearchSubCategoryDal S_dal = new SearchSubCategoryDal(); List <SearchSubCategory> SubCategoryList = S_dal.SubCategory.ToList <SearchSubCategory>(); var JoinTables = from subcategoy in SubCategoryList join category in CategoryList on subcategoy.CategoryID equals category.CategoryID select new { Category = category.CategoryName, Subcategory = subcategoy.SubCategory }; List <Search1> searchList = new List <Search1>(); foreach (var item in JoinTables) { if (selectedSbuCategory == item.Subcategory) { selectedCategory = item.Category; } Search1 temp = new Search1(); temp.Category = item.Category; temp.SubCategory = item.Subcategory; searchList.Add(temp); } string URL = "~/Views/" + selectedCategory + "/" + selectedSbuCategory + ".cshtml"; Session["url"] = URL; // Short code if (selectedCategory != "") { ViewBag.Category = selectedCategory; ViewBag.SubCategory = selectedSbuCategory; TempData["Category"] = selectedCategory; TempData["SubCategory"] = selectedSbuCategory; // return RedirectToAction(selectedSbuCategory, selectedCategory) return(RedirectToAction("List", "Product")); } else { return(RedirectToAction("SearchPage", "Search")); } ///// Long code //if (selectedSbuCategory == "Fans") //{ // return RedirectToAction("Fans", "Mechanical"); //} //else if (selectedSbuCategory == "Microwave") //{ // return RedirectToAction("Microwave", "Electrical"); //} //else if (selectedSbuCategory == "Refrigerator") //{ // return RedirectToAction("Refrigerator", "Electrical"); //} //else //{ // return RedirectToAction("SearchPage", "Search"); //} //return RedirectToAction("SearchPage", "Search"); }
public async Task <IActionResult> OnPostPretrazi() { Console.WriteLine(Search1 + " --- " + Search3 + " --- " + Cena + " --- " + CenaDO + " --- " + CenaDO); HttpContext.Session.SetString("Search1", string.IsNullOrEmpty(Search1) ? "0" : Search1.ToString()); HttpContext.Session.SetString("Search3", string.IsNullOrEmpty(Search3) ? "0" : Search3.ToString()); HttpContext.Session.SetString("DO", CenaDO.ToString()); HttpContext.Session.SetString("OD", CenaOD.ToString()); HttpContext.Session.SetString("Cena", Cena.ToString()); return(RedirectToPage()); }
public async Task <ActionResult> OnPostBrojElemenataNaStrani(int brEl) { bool log = !string.IsNullOrEmpty(HttpContext.Session.GetString("idKupac")); if (log) { HttpContext.Session.SetString("pageSize", brEl.ToString()); HttpContext.Session.SetString("Search1", string.IsNullOrEmpty(Search1) ? "0" : Search1.ToString()); HttpContext.Session.SetString("Search3", string.IsNullOrEmpty(Search3) ? "0" : Search3.ToString()); HttpContext.Session.SetString("DO", CenaDO.ToString()); HttpContext.Session.SetString("OD", CenaOD.ToString()); HttpContext.Session.SetString("Cena", Cena.ToString()); return(RedirectToPage("./Kupovina", new { pageIndex = 1 })); } else { return(RedirectToPage("../Index")); } }
public async Task <ActionResult> OnPostIdiNaStranu() { bool log = !string.IsNullOrEmpty(HttpContext.Session.GetString("idKupac")); if (log) { Console.WriteLine(pageInput + "++++++++++"); HttpContext.Session.SetString("Search1", string.IsNullOrEmpty(Search1) ? "0" : Search1.ToString()); HttpContext.Session.SetString("Search3", string.IsNullOrEmpty(Search3) ? "0" : Search3.ToString()); HttpContext.Session.SetString("DO", CenaDO.ToString()); HttpContext.Session.SetString("OD", CenaOD.ToString()); HttpContext.Session.SetString("Cena", Cena.ToString()); return(RedirectToPage("./Kupovina", new { pageIndex = pageInput })); } else { return(RedirectToPage("../Index")); } }
public ActionResult ChangeCategory() { //string url = Request.Url.PathAndQuery; // useless string Selected = Request.Form["Category"]; SearchViewModel vm = new SearchViewModel(); ViewData["selectedCategory"] = Selected; // send the data to View SearchCategoryDal C_dal = new SearchCategoryDal(); List <SearchCategory> CategoryList = C_dal.Category.ToList <SearchCategory>(); SearchSubCategoryDal S_dal = new SearchSubCategoryDal(); List <SearchSubCategory> SubCategoryList = S_dal.SubCategory.ToList <SearchSubCategory>(); var JoinTables = from subcategoy in SubCategoryList join category in CategoryList on subcategoy.CategoryID equals category.CategoryID select new { Category = category.CategoryName, Subcategory = subcategoy.SubCategory }; List <Search1> searchList = new List <Search1>(); foreach (var item in JoinTables) { Search1 temp = new Search1(); temp.Category = item.Category; temp.SubCategory = item.Subcategory; searchList.Add(temp); } //SearchDal dal = new SearchDal(); // no join table //List<Search> searchList = dal.Categories.ToList<Search>(); // no join table if (Selected != "All Categories") { for (int i = 0; i < searchList.Count(); i++) { if (searchList[i].Category != Selected) { searchList[i].SubCategory = null; } } } // searchList get data from DB vm.Categories = searchList; // vm get data from searchList Session["SearchBar"] = vm; string url = Session["url"].ToString(); string cshtml_path = "~/Views" + url + ".cshtml"; return(View(cshtml_path, vm)); // Stay at the same page, but search bar does not change //return View("SharedSearchBar", vm); // got SharedSearchBar but didn't stay the same page. //return View("SharedSearchBar", vm); //return PartialView("SharedSearchBar", vm); }