public List <MessageTransactionInfoContract> GetMessageTransactionsMatchingUsernameAndReceiverEmail(string username, string recieverEmail) { try { RetrieveUserClass retrieveUser = new RetrieveUserClass(DbContextConstant.MsSqlDbContext); long senderId = retrieveUser.GetEntityMatchingFunc(u => u.UserName == username).Id; RetrieveMessageTransactionClass retrieveMessageTransaction = new RetrieveMessageTransactionClass(DbContextConstant.MsSqlDbContext); return(retrieveMessageTransaction.GetAllEntitiesMatchingCondtionsEagerLoadAssociatedEntitiesFunc(t => t.Message, t => t.Message.SenderId == senderId) .Select(m => CreateRetrieveMessageContract(username, m.EmailAddress, m.Message.MessageCreated.Value)) .ToList()); } catch (Exception exception) { var error = new EntityErrorContract { Message = exception.Message }; throw new FaultException <EntityErrorContract>(error); } }
public void TestRetrieveMessageTransactionUsingSenderIdMssql() { RetrieveMessageTransactionClass retrieveMessageTransaction = new RetrieveMessageTransactionClass(DbContextConstant.MsSqlDbContext); var list = retrieveMessageTransaction.GetAllEntitiesMatchingCondtionsEagerLoadAssociatedEntitiesFunc(t => t.Message, t => t.Message.SenderId == 1); int value = 1; }