public IEnumerable <Users> GetFriendlist(int id)
{
UserController uC = new UserController();
List <Users> UserList = new List <Users>();
using (var entities = new yndlingsfilmDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
var FriendshipsList = from s in entities.Relationship where s.userone_id == id || s.usertwo_id == id select s;
foreach (var relationship in FriendshipsList.ToList())
{
if (relationship.userone_id != id)
{
int idd = relationship.userone_id;
Users user = uC.GetUserById(relationship.userone_id);
Console.WriteLine(user.user_id);
UserList.Add(user);
}
if (relationship.usertwo_id != id)
{
Users user = uC.GetUserById(relationship.usertwo_id);
Console.WriteLine(user.user_id);
UserList.Add(user);
}
}
return(UserList);
}
}
public IHttpActionResult PutUser([FromBody] Users user)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var entities = new yndlingsfilmDBEntities())
{
//DATABASE QUERY. CHECKS THE DATABASE FOR THE USER WITH THE GIVEN USERID. THEN IT CREATES A NEW USER VARIABLE THAT WE DECLARE ALL OF THE GIVEN VARIBLES FROM THE HTTP PUT REQUEST
var existingUser = entities.Users
.FirstOrDefault(s => s.user_id == user.user_id);
if (existingUser != null)
{
existingUser.Username = user.Username;
existingUser.Email = user.Email;
existingUser.Password = user.Password;
entities.SaveChanges();
}
else
{
return(NotFound());
}
}
return(Ok());
}
public Users GetUserById(int id)
{
using (yndlingsfilmDBEntities entities = new yndlingsfilmDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.Users.FirstOrDefault(e => e.user_id == id));
}
}
public IEnumerable <Users> GetAllUsers()
{
using (yndlingsfilmDBEntities entities = new yndlingsfilmDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.Users.ToList());
}
}
public Users GetUserById(String username)
{
using (yndlingsfilmDBEntities entities = new yndlingsfilmDBEntities())
{
entities.Configuration.LazyLoadingEnabled = false;
return(entities.Users.FirstOrDefault(e => e.Username == username));
}
}
public IEnumerable <Relationship> GetFriendlist(int id)
{
using (var entities = new yndlingsfilmDBEntities())
{
var FriendshipsList = entities.Relationship.Where(s => s.userone_id == id).ToList().AsEnumerable();
return(FriendshipsList);
}
}
internal bool ValidateUser(string userName, string password)
{
yndlingsfilmDBEntities db = new yndlingsfilmDBEntities();
var tempUser = db.Users.FirstOrDefault(u => u.Username == userName && u.Password == password);
if (tempUser == null)
{
return(false);
}
return(true);
}
public Boolean GetLoginUser(String Username, String Password)
{
using (yndlingsfilmDBEntities entities = new yndlingsfilmDBEntities())
{
var tempUser = entities.Users.FirstOrDefault(u => u.Username == Username);
if (BCrypt.Net.BCrypt.Verify(Password, tempUser.Password))
{
return(true);
}
return(false);
}
}
public IHttpActionResult PostRelationship(Relationship relationship)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (yndlingsfilmDBEntities entities = new yndlingsfilmDBEntities())
{
entities.Relationship.Add(new Relationship()
{
userone_id = relationship.userone_id,
usertwo_id = relationship.usertwo_id
});;
entities.SaveChanges();
}
return(Ok());
}
public IHttpActionResult DeleteUser(int id)
{
if (id <= 0)
{
return(BadRequest("Not a valid student id"));
}
using (var entities = new yndlingsfilmDBEntities())
{
//DATABASE QUERY. CHECKS THE DATABASE FOR THE USER WITH THE GIVEN USERID. THEN IT CREATES A NEW USER VARIABLE THAT WE DECLARE ALL OF THE GIVEN VARIBLES FROM THE HTTP PUT REQUEST
var existingUser = entities.Users
.FirstOrDefault(s => s.user_id == id);
if (existingUser != null)
{
entities.Entry(existingUser).State = System.Data.Entity.EntityState.Deleted;
entities.SaveChanges();
}
return(Ok());
}
}
public IHttpActionResult PostUser([FromBody] Users user)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (yndlingsfilmDBEntities entities = new yndlingsfilmDBEntities())
{
entities.Users.Add(new Users()
{
Username = user.Username,
Password = BCrypt.Net.BCrypt.HashPassword(user.Password),
Email = user.Email,
});;
entities.SaveChanges();
Console.WriteLine("User was created with following information:" + user.Username + user.Password + user.Email);
}
return(Ok());
}
