public void Createuser(User user) //indsætter brugernavn, password og email i databasen under "user"
{
var ctx = new Databasecontext();
ctx.Database.ExecuteSqlInterpolated($"select createUser({user.username},{user.password},{user.email})");
}
public IList <SearchHistory> GetSearchHistory(int userid)
{
var ctx = new Databasecontext();
return(ctx.SearchHistory.Where(x => x.Userid == userid).OrderByDescending(x => x.SearchDate).ToList());
}
public User GetUser(string username, string password)
{
var ctx = new Databasecontext();
return(ctx.User.FirstOrDefault(x => x.username == username && x.password == password));
}
public IList <SearchHistory> GetSearchHistory(int?userid)
{
var ctx = new Databasecontext();
return(ctx.SearchHistory.ToList());
}
private List <User> _users = testdata.Users; //Henter dummy data til authorization
/*
* public User GetUser(string username) // Current user, hentet fra dummy data
* {
*
* return _users.FirstOrDefault(x => x.username == username);
*
* }
*
* /*public User GetUser(int id)
* {
* return _users.FirstOrDefault(x => x.userid == id);
* } */
public IList <User> GetUsers()
{
var ctx = new Databasecontext();
return(ctx.User.ToList());
}