public static bool DeleteFriendUser(int userId, int friendId) { using (var db = new TwitterOnVaadinEntities()) { var friendUser = db.FriendLists.FirstOrDefault(e => e.User == userId && e.Friend == friendId); db.FriendLists.DeleteObject(friendUser); db.SaveChanges(); } return true; }
public static bool AddPost(Post newPost) { using (var db = new TwitterOnVaadinEntities()) { newPost.id = 1; db.Posts.AddObject(newPost); db.SaveChanges(); } return true; }
public static bool DeleteBlockedUser(int userId, int blockedId) { using (var db = new TwitterOnVaadinEntities()) { var blockedUsers = db.BlockedLists.FirstOrDefault(e => e.User == userId && e.BlockedUser == blockedId); db.BlockedLists.DeleteObject(blockedUsers); db.SaveChanges(); } return true; }
public static bool AddUser(User newUser) { using (var db = new TwitterOnVaadinEntities()) { if (db.Users.FirstOrDefault(e => e.Username == newUser.Username) != null) { db.Users.AddObject(newUser); db.SaveChanges(); return true; } return false; } }
public static bool AddFriendUser(int userId, int friendId) { using (var db = new TwitterOnVaadinEntities()) { var friendUser = new FriendList { Friend = friendId, User = userId, }; db.FriendLists.AddObject(friendUser); db.SaveChanges(); } return true; }
public static bool AddBlockedUser(int userId, int blockedId) { using (var db = new TwitterOnVaadinEntities()) { var blockedUsers = new BlockedList { BlockedUser = blockedId, User = userId, }; db.BlockedLists.AddObject(blockedUsers); db.SaveChanges(); } return true; }
public static bool DeletePost(int postId) { using (var db = new TwitterOnVaadinEntities()) { var post = db.Posts.FirstOrDefault(e => e.id == postId); db.Posts.DeleteObject(post); db.SaveChanges(); } return true; }
public static bool UpdateUser(User newUser) { using (var db = new TwitterOnVaadinEntities()) { var user = db.Users.FirstOrDefault(e => e.id == newUser.id); if (user != null) { user = newUser; } db.SaveChanges(); } return true; }
public static bool UpdatePost(Post newPost) { using (var db = new TwitterOnVaadinEntities()) { var post = db.Posts.FirstOrDefault(e => e.id == newPost.id); if (post != null) { post = newPost; } db.SaveChanges(); } return true; }
public static User GetUser(string username, string password) { var user = new User(); using (var db = new TwitterOnVaadinEntities()) { user = db.Users.ToList().FirstOrDefault(e => e.Username == username && e.Password == password); //if (userDb != null) //{ // user.Username = userDb.Username; // user.Forename = userDb.Forename; // user.Surname = userDb.Surname; // user.Age = userDb.Age; // user.Password = userDb.Password; // user.Photo = userDb.Photo; // user.id = userDb.id; // user.Admin = userDb.Admin; // user.Ban = userDb.Ban; //} } return user; }
public static List<Post> GetPosts(int userId) { var posts = new List<Post>(); using (var db = new TwitterOnVaadinEntities()) { posts = db.Posts.Where(e => e.User == userId).ToList(); } return posts; }
public static List<User> GetFriendUsers(int userId) { var users = new List<User>(); using (var db = new TwitterOnVaadinEntities()) { var friendUsers = db.FriendLists.Where(e => e.User == userId).ToList(); foreach (var temp in friendUsers) { users.Add(GetAllUsers().FirstOrDefault(e => e.id == temp.Friend)); } } return users; }
public static List<User> GetAllUsers() { var users = new List<User>(); using (var db = new TwitterOnVaadinEntities()) { users = db.Users.ToList(); //if (usersDb != null) //{ // foreach (var userDb in usersDb) // { // users.Add(new User{ // Username = userDb.Username, // Forename = userDb.Forename, // Surname = userDb.Surname, // Age = userDb.Age, // Password = userDb.Password, // Photo = userDb.Photo, // id = userDb.id, // Admin = userDb.Admin, // Ban = userDb.Ban, // }); // } //} } return users; }