// GET: Players
public ActionResult Index()
{
if (Convert.ToString(Session["Role"]) == "Admin")
{
PlayersDBContext playersDBContext = new PlayersDBContext();
DataSet dsPlayers = new DataSet();
dsPlayers = playersDBContext.GetPlayersDetails();
Players players = new Players();
List <Players> playersList = new List <Players>();
for (int i = 0; i < dsPlayers.Tables[0].Rows.Count; i++)
{
players = new Players();
players.PlayerID = Convert.ToInt32(dsPlayers.Tables[0].Rows[i]["PlayerID"]);
players.FirstName = Convert.ToString(dsPlayers.Tables[0].Rows[i]["FirstName"]);
players.LastName = Convert.ToString(dsPlayers.Tables[0].Rows[i]["LastName"]);
players.BDate = Convert.ToDateTime(Convert.ToString(dsPlayers.Tables[0].Rows[i]["BirthDate"]));
playersList.Add(players);
}
players.playersList = playersList;
return(View(players));
}
else
{
return(View("~/Views/PageNotFound.cshtml"));
}
}
public ActionResult Create(Players players)
{
try
{
if (Convert.ToString(Session["Role"]) == "Admin")
{
if (ModelState.IsValid)
{
PlayersDBContext playersDBContext = new PlayersDBContext();
int exists = playersDBContext.CheckPlayerExists(players);
if (exists == 1) // Check if player already exists
{
ViewBag.Text = "Player exists Already!!!!";
return(RedirectToAction("RecordExists"));
}
else if (exists == 0)
{
int result = playersDBContext.InsertPlayerDetails(players);
return(RedirectToAction("Save"));
}
}
return(View(players));
}
else
{
return(View("~/Views/PageNotFound.cshtml"));
}
}
catch (Exception ex)
{
return(View("Error", new HandleErrorInfo(ex, "Players", "Create")));
}
}
public List <Players> getPlayersList()
{
try
{
List <Players> playersList = new List <Players>();
PlayersDBContext playersDBContext = new PlayersDBContext();
DataSet ds = playersDBContext.GetPlayers();
foreach (System.Data.DataRow dr in ds.Tables[0].Rows)
{
playersList.Add(new Players {
PlayerID = Convert.ToInt32(@dr["PlayerID"]), FirstName = @dr["FirstName"].ToString(), LastName = @dr["LastName"].ToString()
});
}
return(playersList);
}
catch (Exception ex)
{
new HandleErrorInfo(ex, "Matches", "Create");
return(null);
}
}