public void RejectFriendship(Guid userId, Guid friendId) { using (var db = new PeopleDBEntities()) { //TODO Вывод в лог var accenpt = db.FriendRelationship.Where(f => f.UserId == userId && f.FriendId == friendId && f.status == false).Delete(); var accenpti = db.FriendRelationship.Where(f => f.UserId == friendId && f.FriendId == userId && f.status == false).Delete(); db.SaveChanges(); } }
public void AcceptFriendship(Guid userId, Guid friendId) { using (var db = new PeopleDBEntities()) { //TODO Вывод в лог var accenpt = db.FriendRelationship.Where(f => f.UserId == userId && f.FriendId == friendId && f.status == false).Update(f => new FriendRelationship{ status = true}); var accenptі = db.FriendRelationship.Where(f => f.UserId == friendId && f.FriendId == userId && f.status == false).Update(f => new FriendRelationship { status = true }); db.SaveChanges(); } }
public void AddUserToDb(CustomUser model) { using (var db = new PeopleDBEntities()) { var entity = new User() { Id = Guid.NewGuid(), FirstName = model.FirstName, LastName = model.LastName, Age = model.Age, City = model.City, AboutUser = model.Description, Email = model.Email, Password = Crypto.SHA256(model.Password), Gender = CheckGender(model.Sex), ImageBase64 = model.ImageBase64, ImageContentType = model.ImageContentType, RoleId = GetRole("user") }; try { db.User.Add(entity); db.SaveChanges(); } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } }
public bool AddUserToFriend(Guid userId, Guid friendId) { bool result = false; using (var db = new PeopleDBEntities()) { var check = (from friend in db.FriendRelationship .Where(f => (f.FriendId == friendId && f.UserId == userId) || (f.FriendId == userId && f.UserId == friendId)) select friend).ToList(); if (check.Count == 0) { var entity1 = new FriendRelationship { Id = Guid.NewGuid(), FriendId = friendId, UserId = userId, status = false }; var entity2 = new FriendRelationship { Id = Guid.NewGuid(), FriendId = userId, UserId = friendId, status = false }; try { db.FriendRelationship.Add(entity1); db.FriendRelationship.Add(entity2); db.SaveChanges(); result = true; } catch (DbEntityValidationException e) { foreach (var eve in e.EntityValidationErrors) { Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:", eve.Entry.Entity.GetType().Name, eve.Entry.State); foreach (var ve in eve.ValidationErrors) { Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage); } } throw; } } } return result; }
public void RemoveUserFromFriend(Guid userId, Guid friendId) { using (var db = new PeopleDBEntities()) { var accenpt = db.FriendRelationship.Where(f => f.UserId == userId && f.FriendId == friendId && f.status == true).Delete(); var accenptі = db.FriendRelationship.Where(f => f.UserId == friendId && f.FriendId == userId && f.status == true).Delete(); db.SaveChanges(); } }