public List <Teams> ListTeams() { using (var db = new SupenEntities()) { var listTeams = db.Teams.ToList(); return(listTeams); } }
public Teams GetTeam(Guid id, string teamName) { using (var db = new SupenEntities()) { var getTeam = db.Teams.Where(t => t.TeamId == id && t.TeamName == teamName).FirstOrDefault(); return(getTeam); } }
public List <AppUser> SearchUser(string search) { using (var db = new SupenEntities()) { var searchuser = db.AppUser.Where(a => a.Email.Contains(search)).ToList(); return(searchuser); } }
public AppUser GetMyProfile(Guid id) { using (var db = new SupenEntities()) { var getId = db.AppUser.Where(a => a.AppUserId == id).FirstOrDefault(); return(getId); } }
public AppUser(Guid id) { using (var db = new SupenEntities()) { var repos = new AppUserRepos(); var getUser = repos.GetAppUser(id); AppUserId = id; } }
public Teams(Guid id, string teamName) { using (var db = new SupenEntities()) { var repos = new TeamRepos(); var team = repos.GetTeam(id, teamName); TeamId = id; TeamName = teamName; } }
public AppUser UpdateValues(string firstName, string lastName, int age, Guid id) { using (var db = new SupenEntities()) { var user = db.AppUser.FirstOrDefault(a => a.AppUserId == id); user.FirstName = firstName; user.LastName = lastName; user.Age = age; db.SaveChanges(); return(user); } }
public Teams CreateTeam(string teamName) { using (var db = new SupenEntities()) { var team = new Teams { TeamId = Guid.NewGuid(), TeamName = teamName }; db.Teams.Add(team); db.SaveChanges(); return(team); } }
public bool CreateBlogPost(string text, string category, Guid id) { using (var db = new SupenEntities()) { var repos = new AppUserRepos(); var bp = new Blogg(); bp.BloggId = Guid.NewGuid(); bp.Category = category; bp.Text = text; bp.AppUserId = id; db.Blogg.Add(bp); db.SaveChanges(); } return(true); }
public Games addGames(string hometeam, string awayteam, int?homescore, int?awayscore) { using (var db = new SupenEntities()) { var addGame = new Games { GameId = Guid.NewGuid(), HomeTeam = hometeam, AwayTeam = awayteam, HomeScore = homescore, AwayScore = awayscore, }; db.Games.Add(addGame); db.SaveChanges(); return(addGame); } }
public bool AddUser(string FirstName, string LastName, int Age, string Email, string Password) { using (var db = new SupenEntities()) { var appUser = new AppUser { AppUserId = Guid.NewGuid(), FirstName = FirstName, LastName = LastName, Age = Age, Email = Email, Password = Password, }; db.AppUser.Add(appUser); db.SaveChanges(); return(true); } }