public static async Task EndTradeOpportunity(TradeOpportunity opportunity, TradeOpportunityState finalState, TradeOpportunityValue finalOpportunityValue = null, TradeActionResponse tradeActionResponse = null)
{
// Note: This was initially written in a way that I first remove the trade opp from the concurrent dictionary and then write to the DB.
// It was wrong as by the time we got back a response from the db, other same opportunities were being written! This caused a lot of same opportunities to be written!
// Therefore what we do here is first we singal the removal from the database and only once this is done we try to remove it from the concurrent dictionary.
// For this reason the trade opportunity is immediately locked.
// This is the part we persist to the db. We first wait for
// any possible semaphore on the opportunity and release it as soon as we're done.
await opportunity.LockingSemaphore.WaitAsync();
// It might have happened that this opportunity was already written to the db. Ignore this call.
if (opportunity.IsDbExecutedWritten)
{
return;
}
try
{
// Persist to db
using (var ctx = new RBBotContext())
{
opportunity.TradeOpportunityStateId = finalState.Id;
opportunity.EndTime = DateTime.UtcNow;
// If a final value is specified, add it now.
if (finalOpportunityValue != null)
{
finalOpportunityValue.TradeOpportunityId = opportunity.Id;
ctx.TradeOpportunityValues.Add(finalOpportunityValue);
}
// With transactions we also look into the accounts and update them.
if (tradeActionResponse != null)
{
tradeActionResponse.Transactions.ToList().ForEach(x => x.TradeOpportunity = opportunity);
ctx.TradeOpportunityTransactions.AddRange(tradeActionResponse.Transactions);
foreach (var acc in opportunity.LatestOpportunity.GetAffectedAccounts())
{
ctx.TradeAccounts.Attach(acc);
ctx.Entry(acc).State = System.Data.Entity.EntityState.Modified;
}
}
ctx.TradeOpportunities.Attach(opportunity);
ctx.Entry(opportunity).State = System.Data.Entity.EntityState.Modified;
await ctx.SaveChangesAsync();
opportunity.IsDbExecutedWritten = true; // This is an unmapped property that is used to make sure that if by any chance this trade opportunity is tried to be ended again, it won't succeed!
// Now that we've written to the db, try removing it from the concurrent dictionary.
TradeOpportunity time = null;
bool removedSuccess = tradeOpportunities.TryRemove(opportunity.LatestOpportunity.UniqueIdentifier, out time);
if ((removedSuccess) && (OnOpportunityExpired != null)) // If the opportunity could be removed, then raise event!.
{
OnOpportunityExpired(opportunity);
}
}
}
finally
{
opportunity.LockingSemaphore.Release();
}
}
private static async Task <TradeOpportunity> GetOrUpdateTradeOpportunity(Opportunity opportunity, bool IsSimulation)
{
// Update requirements and maximum possible trade.
var requirements = opportunity.UpdateRequirementsAndAmount().ToList();
//
string stateCode = opportunity.RequirementsMet ? "RQ-MET" : "RQ-MISSING";
decimal oppValue = opportunity.GetMarginValuePercent();
// Create the trade value;
var newTradeValue = new TradeOpportunityValue()
{
PotentialMargin = oppValue,
Timestamp = DateTime.UtcNow,
TradeOpportunityStateId = TradeOpportunityState.States.Single(x => x.Code == stateCode).Id
};
// If the oppvalue is below treshold and doesn't exist yet, then ignore it. Else stop it.
if (oppValue < SystemSetting.MinimumTradeOpportunityPercent)
{
TradeOpportunity tradOpp = null;
tradeOpportunities.TryGetValue(opportunity.UniqueIdentifier, out tradOpp);
if (tradOpp == null)
{
return(null);
}
else
{
var belowThresholdState = TradeOpportunityState.States.Single(x => x.Code == "EXP-BELOW");
newTradeValue.TradeOpportunityStateId = belowThresholdState.Id;
await EndTradeOpportunity(tradOpp, belowThresholdState, newTradeValue);
return(null);
}
}
// Try getting the TradeOpp from the dictionary. If it doesn't exist, then construct it now
var isNewOpportunity = false;
var tradeOpp = tradeOpportunities.GetOrAdd(opportunity.UniqueIdentifier, (key) =>
{
isNewOpportunity = true;
return(new TradeOpportunity()
{
CurrencyId = opportunity.OpportunityBaseCurrency.Id,
IsExecuted = false,
IsSimulation = IsSimulation,
StartTime = DateTime.UtcNow,
TradeOpportunityTypeId = TradeOpportunityType.Types.Single(x => x.Code == opportunity.TypeCode).Id,
TradeOpportunityStateId = TradeOpportunityState.States.Single(x => x.Code == stateCode).Id,
Description = opportunity.UniqueIdentifier,
LatestOpportunity = opportunity,
LastestUpdate = DateTime.UtcNow
});
}
);
tradeOpp.LatestOpportunity = opportunity;
tradeOpp.LastestUpdate = DateTime.UtcNow;
// Before writing, we lock the semaphore.
await tradeOpp.LockingSemaphore.WaitAsync(); // Lock
try
{
// Otherwise the opportunity is still valid.
// If this is a new opportunity, then we definitely need to save to DB.
if (isNewOpportunity)
{
using (var ctx = new RBBotContext())
{
requirements.ForEach(x => { x.TradeOpportunity = tradeOpp; tradeOpp.TradeOpportunityRequirements.Add(x); });
tradeOpp.TradeOpportunityValues.Add(newTradeValue);
newTradeValue.TradeOpportunity = tradeOpp;
ctx.TradeOpportunities.Add(tradeOpp);
ctx.TradeOpportunityRequirements.AddRange(requirements);
ctx.TradeOpportunityValues.Add(newTradeValue);
await ctx.SaveChangesAsync();
}
}
else
{
// Else we take the requirements and see if anything changed.
var requirementsToAdd = new List <TradeOpportunityRequirement>();
foreach (var req in requirements)
{
var toReq = tradeOpp.TradeOpportunityRequirements.Where(x => x.ItemIdentifier == req.ItemIdentifier && x.TradeOpportunityRequirementType == req.TradeOpportunityRequirementType).OrderBy(x => x.Timestamp).LastOrDefault();
if (toReq == null || toReq.RequirementMet != req.RequirementMet)
{
requirementsToAdd.Add(req);
req.TradeOpportunityId = tradeOpp.Id;
}
}
newTradeValue.TradeOpportunityId = tradeOpp.Id;
using (var ctx = new RBBotContext())
{
ctx.TradeOpportunityRequirements.AddRange(requirementsToAdd);
ctx.TradeOpportunityValues.Add(newTradeValue);
await ctx.SaveChangesAsync();
}
}
}
finally
{
tradeOpp.LockingSemaphore.Release();
}
// Return the trade opportunity object.
return(tradeOpp);
}
internal async Task UpdateOpportunity(decimal newMarginValue)
{
this.CurrentValue = newMarginValue;
// the opportunity is only considered started on first non-zero value!
if (newMarginValue == 0m)
{
return;
}
using (var ctx = new RBBotContext())
{
if (this.OpportunityModel == null)
{
this.OpportunityModel = new TradeOpportunity()
{
CurrencyId = this.OpportunityBaseCurrency.Id,
StartTime = DateTime.UtcNow,
IsExecuted = false,
TradeOpportunityTypeId = ctx.TradeOpportunityTypes.Single(x => x.Code == this.TypeCode).Id
};
lock (this.OpportunityModel)
{
// Add it to the context.
ctx.TradeOpportunities.Add(this.OpportunityModel);
ctx.SaveChanges(); // Don't execute this async so we avoid having the children created before the parent!
}
}
var newTradeValue = new TradeOpportunityValue()
{
PotentialMargin = newMarginValue,
Timestamp = DateTime.UtcNow,
TradeOpportunityId = this.OpportunityModel.Id
};
ctx.TradeOpportunityValues.Add(newTradeValue);
//this.OpportunityModel.TradeOpportunityValues.Add(newTradeValue);
//ctx.Entry(this.OpportunityModel).State = System.Data.Entity.EntityState.Modified;
//ctx.TradeOpportunityValues.Add(newTradeValue);
try
{
await ctx.SaveChangesAsync();
}
catch (Exception ex)
{
Console.WriteLine("Error saving opportunity to database: ", ex.ToString());
}
// async save to db and return
//await ctx.SaveChangesAsync();
//
await OpportunityScoreEngine.UpdateOpportunityValue(this);
}
}
