public void LoadDivisionTest() { context = new CSBCDbContext(); var repDivision = new DivisionRepository(context); var divisions = repDivision.LoadDivisions(2); Assert.IsTrue(divisions.Count<vw_Divisions>() != 0); }
private void LoadDivisions(int division, int companyId, int seasonId) { var divisions = new DivisionRepository(new CSBCDbContext()); try { var rsData = divisions.LoadDivisions(seasonId); var count = rsData.Count<vw_Divisions>(); cmbDivisions.DataSource = rsData; cmbDivisions.DataValueField = "DivisionID"; cmbDivisions.DataTextField = "Div_Desc"; cmbDivisions.DataBind(); } catch (Exception ex) { lblError.Text = "LoadDivisions::" + ex.Message; } finally { //if (Session["DivisionID"] != null) // cmbDivisions.SelectedValue = Session["DivisionID"].ToString(); } }
public ActionResult Index() { _divisionRepository.LoadDivisions(); _countryRepository.LoadCountries(); _userRepository.LoadAdmins(); var LeaderBoard = _userRepository.GetLeaderBoard().ToList(); string SearchString = null; int? SearchCountry = null; if (Request["SearchByNameTextBox"] != null) { SearchString = Request["SearchByNameTextBox"].ToString(); } if (Request["CountryID"] != null) { bool result = Int32.TryParse(Request["CountryID"], out int number); if (result) { SearchCountry = Convert.ToInt32(Request["CountryID"]); } } //Search by Name & Username & Country if (Request["SearchByNameTextBox"] != null && Request["SearchByNameCheckBox"] == "check" && Request["SearchByCountryCheckBox"] == "check") { var searchResult = _userRepository.GetLeaderBoardByNameAndCountry(LeaderBoard, SearchString, SearchCountry); ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "Name").OrderBy(c => c.Text); if (searchResult.Count() == 0) { TempData["UserListResult"] = "No results that match your search criteria where found"; } return(View(searchResult)); } //Search by Name & Username if (Request["SearchByNameTextBox"] != null && Request["SearchByNameCheckBox"] == "check") { var searchResult = _userRepository.GetLeaderBoardByName(LeaderBoard, SearchString); ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "Name").OrderBy(c => c.Text); if (searchResult.Count() == 0) { TempData["UserListResult"] = "No results that match your search criteria where found"; } return(View(searchResult)); } //Search by Country if (Request["SearchByCountryCheckBox"] == "check") { var searchResult = _userRepository.GetLeaderBoardByCountry(LeaderBoard, SearchCountry); ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "Name").OrderBy(c => c.Text); if (searchResult.Count() == 0) { TempData["UserListResult"] = "No results that match your search criteria where found"; } return(View(searchResult)); } //Get all users for Leaderboard LeaderBoard = _userRepository.GetLeaderBoard().ToList(); ViewBag.CountryID = new SelectList(db.Countries, "CountryID", "Name").OrderBy(c => c.Text); return(View(LeaderBoard)); }