public ActionResult UserInfo(string login)
{
using (SudokuDBEntities1 db = new SudokuDBEntities1())
{
User k = db.User.Where(x => x.Email == login).FirstOrDefault();
State m = db.User.Where(x => x.Email == login).FirstOrDefault().State;
UserState us = new UserState(k.Email, m.GameCount.ToString(), m.Point.ToString());
return(View(us));
}
}
public string AddStatLose(string login)
{
using (SudokuDBEntities1 db = new SudokuDBEntities1())
{
User k = db.User.Where(x => x.Email == login).FirstOrDefault();
State state = k.State;
state.GameCount++;
db.SaveChanges();
}
return("ok");
}
public override string[] GetRolesForUser(string username)
{
string[] roles = new string[] { };
using (SudokuDBEntities1 db = new SudokuDBEntities1())
{
// Получаем пользователя
User user = db.User.Where(x => x.Email == username).FirstOrDefault();
if (user != null && user.Role != null)
{
// получаем роль
roles = new string[] { user.Role.Name };
}
return(roles);
}
}
public override bool IsUserInRole(string username, string roleName)
{
using (SudokuDBEntities1 db = new SudokuDBEntities1())
{
// Получаем пользователя
User user = db.User.Where(x => x.Email == username).FirstOrDefault();
if (user != null && user.Role != null && user.Role.Name == roleName)
{
return(true);
}
else
{
return(false);
}
}
}
public ActionResult Top()
{
List <UserState> states = new List <UserState>();
using (SudokuDBEntities1 bd = new SudokuDBEntities1())
{
List <User> users = bd.User.ToList();
for (int i = 0; i < users.Count; i++)
{
State st = users[i].State;
UserState us = new UserState(users[i].Email, st.GameCount.ToString(), st.Point.ToString());
states.Add(us);
}
states.Sort();
}
return(View(states));
}
