public void AddContactToUser(string userId, Contact newContact) { User user = GetUserById(userId); if (user != null) { List <Contact> tmpList = new List <Contact>(); tmpList.AddRange(user.ContactList); tmpList.Add(newContact); Cql cqlQuery = new Cql("UPDATE users set contacts = ? where id = ?"); var preperadStatement = this.cassandraConnector.GetSession().Prepare(cqlQuery.Statement); var preparedQuery = preperadStatement.Bind(ContactAssembler.ConvertListOfContactToListContactEntity(tmpList), userId); this.cassandraConnector.GetSession().Execute(preparedQuery); } }
public void DeleteUserContact(string userId, string contactId) { User user = GetUserById(userId); if (user != null) { var contactToRemove = user.ContactList.FirstOrDefault(c => c.Id.ToString() == contactId); if (contactToRemove != null) { List <Contact> tmpList = new List <Contact>(); user.ContactList.Remove(contactToRemove); tmpList.AddRange(user.ContactList); Cql cqlQuery = new Cql("UPDATE users set contacts = ? where id = ?"); var preperadStatement = this.cassandraConnector.GetSession().Prepare(cqlQuery.Statement); var preparedQuery = preperadStatement.Bind(ContactAssembler.ConvertListOfContactToListContactEntity(tmpList), userId); this.cassandraConnector.GetSession().Execute(preparedQuery); } } }