//[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);
}