public LookUpItem getPositions() { LookUpItem lookUpItem = new LookUpItem(); using (var connection = new SqlConnection(this.connectionString)) { var commandText = "SELECT PositionEID, PositionName FROM DRD_TE_Position"; var command = new SqlCommand(commandText, connection); connection.Open(); using (var reader = command.ExecuteReader()) { lookUpItem.DropDownList = new List <SelectListItem>(); while (reader.Read()) { lookUpItem.DropDownList.Add(new SelectListItem { Text = (string)reader["PositionName"], Value = reader.GetInt32(0).ToString() }); } } } return(lookUpItem); }
public ActionResult GetTeamIndex() { // VM LookUpItem lookUpItem = lookUpRepo.getTeams(); var teamVM = new TeamViewModel() { Teams = lookUpItem.DropDownList }; return(PartialView(@"~/Views/Shared/_TeamIndex.cshtml", teamVM)); }
public ActionResult Edit(int id) { Player player = drdRepo.GetPlayer(id); LookUpItem lookUpItem = lookUpRepo.getPositions(); LookUpItem mlbTeamLookUpItem = lookUpRepo.getMLBTeams(); var modelVM = new EditPlayerViewModel(player) { Positions = lookUpItem.DropDownList, MLBTeams = mlbTeamLookUpItem.DropDownList }; return(View(modelVM)); }
public ActionResult SidebarMenu() { // VM LookUpItem lookUpItem = lookUpRepo.getTeams(); List <Team> myTeams = drdRepo.ListTeams(); var teamVM = new TeamViewModel() { Teams = lookUpItem.DropDownList, ListOfTeamObject = myTeams }; return(PartialView(@"~/Views/Shared/_SidebarMenu.cshtml", teamVM)); }
public LookUpItem getMLBTeams() { LookUpItem lookUpItem = new LookUpItem(); lookUpItem.DropDownList = new List <SelectListItem>(); Array MLBTeams = Enum.GetValues(typeof(MLBTeam)); foreach (int MLBTeamID in MLBTeams) { lookUpItem.DropDownList.Add(new SelectListItem { Text = Enum.GetName(typeof(MLBTeam), MLBTeamID), Value = MLBTeamID.ToString() }); } return(lookUpItem); }
public ActionResult Edit(int id, FormCollection formValues) { Player player = drdRepo.GetPlayer(id); LookUpItem positionLookUpItem = lookUpRepo.getPositions(); LookUpItem mlbTeamLookUpItem = lookUpRepo.getMLBTeams(); var modelVM = new EditPlayerViewModel(player) { Positions = positionLookUpItem.DropDownList, MLBTeams = mlbTeamLookUpItem.DropDownList }; if (TryUpdateModel(modelVM)) { drdRepo.EditPlayer(modelVM.Player); return(RedirectToAction("Index", new { id = player.TeamPID })); } return(View(modelVM)); }
/// <summary> /// Creates a new KeyValueCache. Default expiration is 1 day. /// </summary> /// <param name="cacheDelegate">The delegate that returns the initial list of items.</param> /// <param name="expiration">The amount of time the cache is allowed to persist.</param> /// <param name="lookupDelegate">The delegate used to lookup an item if it does not exist in the cache.</param> public KeyValueCache(InitializeCache cacheDelegate, LookUpItem lookupDelegate, TimeSpan expiration) : base(cacheDelegate, expiration, lookupDelegate) { }
/// <summary> /// Creates a new KeyValueCache. Default expiration is 1 day. /// </summary> /// <param name="cacheDelegate">The delegate that returns the initial list of items.</param> /// <param name="lookupDelegate">The delegate used to lookup an item if it does not exist in the cache.</param> public KeyValueCache(InitializeCache cacheDelegate, LookUpItem lookupDelegate) : base(cacheDelegate, lookupDelegate) { }
/// <summary> /// Creates a new KeyValueCache. Default expiration is 1 day. /// </summary> /// <param name="lookupDelegate">The delegate used to lookup an item if it does not exist in the cache.</param> /// /// <param name="expiration">The amount of time the cache is allowed to persist.</param> public KeyValueCache(LookUpItem lookupDelegate, TimeSpan expiration) : base(lookupDelegate, expiration) { }
/// <summary> /// Creates a new KeyValueCache. Default expiration is 1 day. /// </summary> /// <param name="lookupDelegate">The delegate used to lookup an item if it does not exist in the cache.</param> public KeyValueCache(LookUpItem lookupDelegate) : base(lookupDelegate) { }
public void AddLookUpItem(LookUpItem lookUpItem) { this.LookUpItems.Add(lookUpItem); }