/// <summary> /// Create Friend Request /// </summary> /// <param name="user">The user ID we adding for friend request</param> /// <returns>new relationship</returns> public tblRelationship CreateFriendRequest(tblUser user) { try { using (BetweenUsDBEntities context = new BetweenUsDBEntities()) { tblRelationship newRelationShip = new tblRelationship { RelationshipStatus = "Pending", User1ID = LoggedInUser.CurrentUser.UserID, User2ID = user.UserID, }; context.tblRelationships.Add(newRelationShip); context.SaveChanges(); return(newRelationShip); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public int DeleteRelationship(string relationshipId) { tblRelationship relationship = dbEntities.tblRelationships.Find(int.Parse(relationshipId)); dbEntities.tblRelationships.Remove(relationship); return(dbEntities.SaveChanges()); }
public int UpdateRelationship(string relationshipId, string relationshipName, string isActive) { tblRelationship relationship = dbEntities.tblRelationships.Find(int.Parse(relationshipId)); relationship.RelationshipName = relationshipName; relationship.IsActive = Convert.ToBoolean(isActive); return(dbEntities.SaveChanges()); }
public static int Delete(Guid id) { using (BoBEntities bob = new BoBEntities()) { tblRelationship row = bob.tblRelationships.FirstOrDefault(r => id == r.Id); bob.tblRelationships.Remove(row); return(bob.SaveChanges()); } }
public static int Update(Relationship relationship) { using (BoBEntities bob = new BoBEntities()) { tblRelationship row = bob.tblRelationships.FirstOrDefault(r => relationship.Id == r.Id); row.isFriend = relationship.isFriend; return(bob.SaveChanges()); } }
public int InsertRelationship(string relationshipName, string isActive) { tblRelationship relationship = new tblRelationship() { RelationshipName = relationshipName, IsActive = Convert.ToBoolean(isActive) }; dbEntities.tblRelationships.Add(relationship); return(dbEntities.SaveChanges()); }
/// <summary> /// Deny Friend Request /// </summary> /// <param name="user">The friend request we are deleting</param> public void DenyFriendRequest(tblRelationship user) { try { using (BetweenUsDBEntities context = new BetweenUsDBEntities()) { tblRelationship requestToDelete = (from ss in context.tblRelationships where ss.RelationshipID == user.RelationshipID select ss).First(); context.tblRelationships.Remove(requestToDelete); context.SaveChanges(); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public static Relationship LoadById(Guid id) { using (BoBEntities bob = new BoBEntities()) { tblRelationship row = bob.tblRelationships.FirstOrDefault(r => r.Id == id); Relationship relationship = new Relationship { Id = row.Id, Friend1 = UserManager.LoadById(row.SenderId), Friend2 = UserManager.LoadById(row.FriendId), isFriend = row.isFriend, StartDate = row.FriendDate }; return(relationship); } }
public static int Insert(Relationship relationship) { using (BoBEntities bob = new BoBEntities()) { tblRelationship row = new tblRelationship { Id = Guid.NewGuid(), SenderId = relationship.Friend1.Id, FriendId = relationship.Friend2.Id, isFriend = relationship.isFriend, FriendDate = DateTime.Now }; relationship.Id = row.Id; bob.tblRelationships.Add(row); return(bob.SaveChanges()); } }
/// <summary> /// Accept Friend Request /// </summary> /// <param name="user">The user we accepting for friend request</param> /// <returns>edited relationship</returns> public tblRelationship AcceptFriendRequest(tblRelationship user) { try { using (BetweenUsDBEntities context = new BetweenUsDBEntities()) { tblRelationship requestToEdit = (from ss in context.tblRelationships where ss.RelationshipID == user.RelationshipID select ss).First(); requestToEdit.RelationshipStatus = "Accepted"; user.RelationshipStatus = "Accepted"; context.SaveChanges(); return(user); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }