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