//[HttpPost] public int Login(string email, string password) { var dbFactory = new HealthDataContextFactory( dataProvider: LinqToDB.DataProvider.MySql.MySqlTools.GetDataProvider(), connectionString: _configuration.GetConnectionString("Health") ); using (var context = dbFactory.Create()) { var userquery = (from u in context.Users where u.Admin == true && u.Email == email && u.Password == password select u).Take(1); foreach (var u in userquery) { SetCookie("User", u.Id.ToString(), 20); //HttpContext.Session.Set("User", Encoding.Unicode.GetBytes(usr.Id.ToString())); return(u.Id); } } return(0); //return View("Login"); /*int userId = user.Id; * string name = user.Name; * string surname = user.Surname; * string email = user.Email; * * return View();*/ }
public User GetUserInformation(int id, IConfiguration _configuration) { var dbFactory = new HealthDataContextFactory( dataProvider: LinqToDB.DataProvider.MySql.MySqlTools.GetDataProvider(), connectionString: _configuration.GetConnectionString("Health") ); using (var context = dbFactory.Create()) { IQueryable <User> userQuery = from users in context.Users where users.Id == id select users; foreach (var user in userQuery) { return(user); } } return(null); }