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