public ActionResult Delete(int teamId)
{
SoccerEntities teamcontext = new SoccerEntities();
return(View());
}
public ActionResult All()
{
SoccerEntities footballcontext = new SoccerEntities();
List <Player> players = footballcontext.Players.ToList();
return(View(players));
}
//EDIT
public ActionResult Edit(int teamId)
{
SoccerEntities teamcontext = new SoccerEntities();
Team1 team = teamcontext.Team1.Single(m => m.ID == teamId);
return(View(team));
}
public ActionResult Create()
{
SoccerEntities db = new SoccerEntities();
ViewBag.Teams = new SelectList(db.Team1, "ID", "Name");
return(View());
}
public static ObservableCollection <Player> GetPlayersFromNation(int nation)
{
using (SoccerEntities context = new SoccerEntities())
{
List <Player> players = (from p in context.Players where p.TeamID == nation select p).ToList <Player>();
var ocPlayers = new ObservableCollection <Player>();
foreach (Player player in DBAdapter.GetPlayersFromNation(nation))
{
ocPlayers.Add(new Player()
{
Lastname = player.Lastname,
Firstname = player.Firstname,
Height = player.Height,
Jerseynumber = player.Jerseynumber,
Birthdate = player.Birthdate,
PositionID = player.PositionID,
Playedgames = player.Playedgames,
Goals = player.Goals,
TeamID = player.TeamID
});
}
return(ocPlayers);
}
}
public ActionResult Register(RegisterModel model)
{
if (ModelState.IsValid)
{
User user = null;
using (SoccerEntities db = new SoccerEntities())
{
user = db.Users.FirstOrDefault(u => u.Email == model.Name);
}
if (user == null)
{
using (SoccerEntities db = new SoccerEntities())
{
db.Users.Add(new User {
Email = model.Name, Password = model.Password, Age = model.Age, RoleId = 2
});
db.SaveChanges();
user = db.Users.Where(u => u.Email == model.Name && u.Password == model.Password).FirstOrDefault();
}
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Name, true);
return(RedirectToAction("Index", "Team1"));
}
}
else
{
ModelState.AddModelError("", "Uzytkownik z takim loginem juz istnieje");
}
}
return(View(model));
}
//DETAILS
public ActionResult Details(int teamId)
{
SoccerEntities footballcontext = new SoccerEntities();
Team1 team = footballcontext.Team1.Single(py => py.ID == teamId);
IEnumerable <Player> players = footballcontext.Players.Where(model => model.TeamID == teamId).ToList();
return(View(team));
}
public ActionResult playerOfTeam(int teamId)
{
SoccerEntities footballcontext = new SoccerEntities();
List <Player> players = footballcontext.Players.Where(m => m.TeamID == teamId).ToList();
ViewBag.teamId = teamId;
return(View(players));
}
public ActionResult Details(int playerId)
{
SoccerEntities footballcontext = new SoccerEntities();
Player player = footballcontext.Players.Single(py => py.ID == playerId);
return(View(player));
}
public ActionResult Delete_p(int playerId, int teamId)
{
SoccerEntities footballcontext = new SoccerEntities();
Player player = footballcontext.Players.Single(pl => pl.ID == playerId);
footballcontext.Players.Remove(player);
footballcontext.SaveChanges();
return(RedirectToAction("Index", new { teamId = player.TeamID }));
}
public ActionResult Edit(Player player)
{
SoccerEntities db = new SoccerEntities();
{
db.Entry(player).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index", new { teamId = player.TeamID }));
}
// return View(player);
}
public ActionResult Edit(int playerId)
{
SoccerEntities db = new SoccerEntities();
Player player = db.Players.Single(m => m.ID == playerId);
if (player == null)
{
return(HttpNotFound());
}
return(View(player));
}
public ActionResult Edit(Team1 team)
{
SoccerEntities db = new SoccerEntities();
if (ModelState.IsValid)
{
db.Entry(team).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(team));
}
public ActionResult Index()
{
SoccerEntities teamcontext = new SoccerEntities();
List <Team1> teams = teamcontext.Team1.ToList();
if (User.Identity.IsAuthenticated)
{
string username = User.Identity.Name;
ViewBag.User = username;
}
//zwrocic team
return(View(teams));
}
public ActionResult Delete_p(int teamId)
{
SoccerEntities footballcontext = new SoccerEntities();
Team1 team = footballcontext.Team1.Single(py => py.ID == teamId);
IEnumerable <Player> players = footballcontext.Players.Where(pl => pl.TeamID == teamId);
foreach (var Item in players)
{
footballcontext.Players.Remove(Item);
}
footballcontext.Team1.Remove(team);
footballcontext.SaveChanges();
return(RedirectToAction("Index"));
}
public override bool IsUserInRole(string username, string roleName)
{
bool outputResult = false;
using (SoccerEntities db = new SoccerEntities())
{
User user = db.Users.FirstOrDefault(u => u.Email == username);
if (user != null)
{
Role userRole = db.Roles.Find(user.RoleId);
if (userRole != null && userRole.Name == roleName)
{
outputResult = true;
}
}
}
return(outputResult);
}
public override string[] GetRolesForUser(string username)
{
string[] roles = new string[] { };
using (SoccerEntities db = new SoccerEntities())
{
User user = db.Users.FirstOrDefault(u => u.Email == username);
if (user != null)
{
Role userRole = db.Roles.Find(user.RoleId);
if (userRole != null)
{
roles = new string[] { userRole.Name };
}
}
}
return(roles);
}
public static ObservableCollection <Team> GetAllTeams()
{
using (SoccerEntities context = new SoccerEntities())
{
List <Team> teams = context.Teams.ToList();
var ocTeam = new ObservableCollection <Team>();
foreach (Team team in DBAdapter.GetAllTeams())
{
ocTeam.Add(new Team()
{
ID = (team.ID),
Title = team.Title
});
}
return(ocTeam);
}
}
public ActionResult Create(Team1 team)
{
SoccerEntities footballcontext = new SoccerEntities();
if (ModelState.IsValid)
{
try
{
footballcontext.Team1.Add(team);
footballcontext.SaveChanges();
return(RedirectToAction("Index"));
}
catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ex)
{
Console.WriteLine(ex.InnerException);
}
}
return(View(team));
}
public ActionResult CreateForTeam(Player player)
{
SoccerEntities footballcontext = new SoccerEntities();
if (ModelState.IsValid)
{
try
{
player.Photo = "~/Photo.anonim.png";
footballcontext.Players.Add(player);
footballcontext.SaveChanges();
return(RedirectToAction("Index", new { teamId = player.TeamID }));
}
catch (System.Data.Entity.Infrastructure.DbUpdateConcurrencyException ex)
{
Console.WriteLine(ex.InnerException);
}
}
return(View(player));
}
public static ObservableCollection <Position> GetAllPositions()
{
using (SoccerEntities context = new SoccerEntities())
{
List <Position> positions = context.Positions.ToList();
var ocPosition = new ObservableCollection <Position>();
foreach (Position position in DBAdapter.GetAllPositions())
{
ocPosition.Add(new Position()
{
ID = (position.ID),
Title = position.Title
});
}
return(ocPosition);
}
}
public ActionResult Index(string searchBy, string search, int?page, string sortBy)
{
ViewBag.SortNameParameter = string.IsNullOrEmpty(sortBy)?"Name desc":"";
ViewBag.SortAgeParameter = sortBy == "Age" ? "Age desc" : "Age";
SoccerEntities footballcontext = new SoccerEntities();
var players = footballcontext.Players.AsQueryable();
if (searchBy == "Team")
{
players = players.Where(x => x.Name.StartsWith(search) || search == null);
}
else
{
players = players.Where(x => x.Name.StartsWith(search) || search == null);
}
switch (sortBy)
{
case "Age":
players = players.OrderBy(x => x.Age);
break;
case "Name desc":
players = players.OrderByDescending(x => x.Name);
break;
case "Age desc":
players = players.OrderByDescending(x => x.Age);
break;
default:
players = players.OrderBy(x => x.Name);
break;
}
return(View(players.ToPagedList(page ?? 1, 5)));
}
public ActionResult Login(RegisterModel model)
{
if (ModelState.IsValid)
{
User user = null;
using (SoccerEntities db = new SoccerEntities())
{
user = db.Users.FirstOrDefault(u => u.Email == model.Name);
}
if (user != null)
{
FormsAuthentication.SetAuthCookie(model.Name, true);
return(RedirectToAction("Index", "Team1"));
}
else
{
ModelState.AddModelError("", "Brak uzytkownika z takimi danymi");
}
}
return(View(model));
}
