private UserTable RetrieveUser(string userName)
{
RetrieveUserClass retrieveUser = new RetrieveUserClass(DatabaseOptionConfigRetriever.DatabaseOptionAppSetting);
var user = retrieveUser.GetEntityMatchingFunc(u => u.UserName == userName);
if (user == null)
{
throw new Exception();
}
return(user);
}
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);
}
}