public void UpdateUserInfo(Usersinfo userupdatedinfo)
{
Usersinfo userinfo = Database.GetUserInfo(userupdatedinfo.Username, _dbContext);
if (userinfo.Favoriteteam != userupdatedinfo.Favoriteteam)
{
userinfo.Favoriteteam = userupdatedinfo.Favoriteteam;
}
if (userupdatedinfo.UserImg != null)
{
userinfo.UserImg = userupdatedinfo.UserImg;
}
_dbContext.Update(userinfo);
_dbContext.SaveChanges();
}
internal static Usersinfo GetUserInfo(string username, ApplicationDbContext dbContext)
{
Usersinfo qry = new Usersinfo();
List <String> userLeagues = new List <string>();
qry = (from u in dbContext.Usersinfo
where u.Username == username
select new Usersinfo
{
Id = u.Id,
Name = u.Name,
Username = u.Username,
Favoriteteam = u.Favoriteteam,
Notifications = u.Notifications,
Leagues = u.Leagues,
UserImg = u.UserImg
}).FirstOrDefault();
return(qry);
}
public async Task <IActionResult> OnGetAsync()
{
var user = await _userManager.GetUserAsync(User);
if (user == null)
{
return(NotFound($"Unable to load user with ID '{_userManager.GetUserId(User)}'."));
}
ViewData["Ligas"] = Database.LoadUserLeagues(User.Identity.Name, _dbContext);
List <Teams> teams = Database.GetTeams(_dbContext);
FavoriteTeam = new SelectList(teams, "Name", "Name");
var userName = await _userManager.GetUserNameAsync(user);
var email = await _userManager.GetEmailAsync(user);
var phoneNumber = await _userManager.GetPhoneNumberAsync(user);
Usersinfo usersinfo = Database.GetUserInfo(user.UserName, _dbContext);
//UserImg = File(usersinfo.UserImg, "image/png");
UserImg = usersinfo.UserImg;
Username = userName;
Input = new InputModel
{
Email = email,
PhoneNumber = phoneNumber,
FavoriteTeam = usersinfo.Favoriteteam,
};
IsEmailConfirmed = await _userManager.IsEmailConfirmedAsync(user);
return(Page());
}
internal static List <string> GetLeagues(string username, ApplicationDbContext dbContext)
{
//Melhorar isto para ir antes à tabela dos users
Usersinfo qry = new Usersinfo();
List <String> userLeagues = new List <string>();
qry = (from u in dbContext.Usersinfo
where u.Username == username
select new Usersinfo
{
Leagues = u.Leagues
}).FirstOrDefault();
if (qry.Leagues != null)
{
userLeagues = qry.Leagues.Split(';').ToList();
}
else
{
userLeagues.Add("---");
}
return(userLeagues);
}
public void InsertUserInfo(Usersinfo userinfo)
{
_dbContext.Add(userinfo);
_dbContext.SaveChanges();
}
