public void SaveSentMessage(SentTransferConnectionInvitationEvent message)
{
var transferRelationship = new TransferRelationship()
{
SenderAccountId = message.SenderAccountId,
ReceiverAccountId = message.ReceiverAccountId,
RelationshipStatus = TransferRelationshipStatus.Pending,
SenderUserId = message.SentByUserId
};
_transferRelationshipRepository.SaveTransferRelationship(transferRelationship);
}
public void SaveRejectedMessage(RejectedTransferConnectionInvitationEvent message)
{
var senderUserId = GetSenderUserId(message.SenderAccountId, message.ReceiverAccountId);
var transferRelationship = new TransferRelationship()
{
SenderAccountId = message.SenderAccountId,
ReceiverAccountId = message.ReceiverAccountId,
SenderUserId = senderUserId,
RelationshipStatus = TransferRelationshipStatus.Rejected,
RejectorUserId = message.RejectorUserId
};
_transferRelationshipRepository.SaveTransferRelationship(transferRelationship);
}
public void InsertIntoEmployerTransferRelationships(dynamic value, ICollection <string> columns)
{
var trnasferRelationship = new TransferRelationship();
trnasferRelationship.SenderAccountId = columns.Contains("SenderAccountId") ? value.SenderAccountId : null;
trnasferRelationship.ReceiverAccountId = columns.Contains("ReceiverAccountId") ? value.ReceiverAccountId : null;
trnasferRelationship.RelationshipStatus = columns.Contains("RelationshipStatus") ? Enum.Parse(typeof(TransferRelationshipStatus), value.RelationshipStatus) : null;
trnasferRelationship.SenderUserId = columns.Contains("SenderUserId") ? value.SenderUserId : null;
trnasferRelationship.ApproverUserId = columns.Contains("ApproverUserId") ? value.ApproverUserId : null;
trnasferRelationship.RejectorUserId = columns.Contains("RejectorUserId") ? value.RejectorUserId : DateTime.Now.AddDays(-100);
var employeraccoutsrepo = new TransferRelationshipRepository(_connectionString);
employeraccoutsrepo.SaveTransferRelationship(trnasferRelationship).Wait();
}
public async Task SaveTransferRelationship(TransferRelationship transferRelationship)
{
await WithConnection(async c =>
{
var parameters = new DynamicParameters();
parameters.Add("@SenderAccountId", transferRelationship.SenderAccountId, DbType.Int64);
parameters.Add("@ReceiverAccountId", transferRelationship.ReceiverAccountId, DbType.Int64);
parameters.Add("@RelationshipStatus", transferRelationship.RelationshipStatus.ToString(), DbType.String);
parameters.Add("@SenderUserId", transferRelationship.SenderUserId, DbType.Int64);
parameters.Add("@ApproverUserId", transferRelationship.ApproverUserId, DbType.Int64);
parameters.Add("@RejectorUserId", transferRelationship.RejectorUserId, DbType.Int64);
return(await c.ExecuteAsync(
sql: "[Data_Load].[CreateTransferRelationship]",
param: parameters,
commandType: CommandType.StoredProcedure));
});
}
