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