public bool AddFriend(int userId, int friendId) { try { CinguettioDBEntities context = new CinguettioDBEntities(); User user = context.Users.FirstOrDefault(u => u.Id == userId); if (user == null) { return false; } User friend = context.Users.FirstOrDefault(u => u.Id == friendId); if (friend == null) { return false; } user.Friends.Add(friend); context.SaveChanges(); return true; } catch (Exception) { return false; } }
public bool CreateUser(string userName, string password, string firstName, string lastName, string email, string latitude, string longitude) { try { decimal? latitudeDecimal = null; if (!string.IsNullOrEmpty(latitude)) { latitudeDecimal = decimal.Parse(latitude, System.Globalization.CultureInfo.InvariantCulture); } decimal? longitudeDecimal = null; if (!string.IsNullOrEmpty(longitude)) { longitudeDecimal = decimal.Parse(longitude, System.Globalization.CultureInfo.InvariantCulture); } CinguettioDBEntities context = new CinguettioDBEntities(); context.AddToUsers(new User() { UserName = userName, Password = password, FirstName = firstName, LastName = lastName, Email = email, Latitude = latitudeDecimal, Longitude = longitudeDecimal }); context.SaveChanges(); return true; } catch (Exception) { return false; } }
public void CreatePost(int userId, string title, string content) { CinguettioDBEntities context = new CinguettioDBEntities(); context.AddToPosts(new Post() { UserId = userId, Title = title, Content = content, DateCreated = DateTime.UtcNow }); context.SaveChanges(); }
public void UpdateUserProfile(int userId, string firstName, string lastName, string email, string imageUrl) { CinguettioDBEntities context = new CinguettioDBEntities(); User user = context.Users.FirstOrDefault(u => u.Id == userId); if (user == null) { return; } if (!string.IsNullOrEmpty(firstName) && firstName != user.FirstName) { user.FirstName = firstName; } if (!string.IsNullOrEmpty(lastName) && lastName != user.LastName) { user.LastName = lastName; } if (!string.IsNullOrEmpty(email) && email != user.Email) { user.Email = email; } if (!string.IsNullOrEmpty(imageUrl) && imageUrl != user.ImageUrl) { user.ImageUrl = imageUrl; } context.SaveChanges(); }
public void UpdateUserPosition(int userId, decimal latitude, decimal longitude) { CinguettioDBEntities context = new CinguettioDBEntities(); User user = context.Users.FirstOrDefault(u => u.Id == userId); if (user == null) { return; } user.Latitude = latitude; user.Longitude = longitude; context.SaveChanges(); }
public void UpdatePost(int postId, string title, string content) { CinguettioDBEntities context = new CinguettioDBEntities(); Post post = context.Posts.FirstOrDefault(p => p.Id == postId); if (post == null) { return; } if (!string.IsNullOrEmpty(title) && post.Title != title) { post.Title = title; } if (!string.IsNullOrEmpty(content) && post.Content != content) { post.Content = content; } context.SaveChanges(); }