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()); }