public void InsertBalanceSnapshot(string currency, string baseExchange, string counterExchange, decimal total, decimal price, int processId = 0)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.InsertBalanceSnapshot", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@currency", Value = currency
},
new SqlParameter {
ParameterName = "@baseExchange", Value = baseExchange
},
new SqlParameter {
ParameterName = "@counterExchange", Value = counterExchange
},
new SqlParameter {
ParameterName = "@total", Value = total
},
new SqlParameter {
ParameterName = "@price", Value = price
},
new SqlParameter {
ParameterName = "@processId", Value = processId
}
});
}
public void LogError(string baseX, string arbX, string symbol, string method, string message, string content, int processId = -1)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.InsertError", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@baseExchange", Value = baseX
},
new SqlParameter {
ParameterName = "@arbExchange", Value = arbX
},
new SqlParameter {
ParameterName = "@symbol", Value = symbol
},
new SqlParameter {
ParameterName = "@method", Value = method
},
new SqlParameter {
ParameterName = "@message", Value = message
},
new SqlParameter {
ParameterName = "@exception", Value = content
},
new SqlParameter {
ParameterName = "@processId", Value = processId
}
});
}
public void SaveArbitragePair(IArbitragePairDTO dto)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.SaveArbitragePair", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = dto.Id
},
new SqlParameter {
ParameterName = "@status", Value = dto.Status
},
new SqlParameter {
ParameterName = "@type", Value = dto.Type
},
new SqlParameter {
ParameterName = "@tradeThreshold", Value = dto.TradeThreshold
},
new SqlParameter {
ParameterName = "@increment", Value = dto.Increment
},
new SqlParameter {
ParameterName = "@tickSize", Value = dto.TickSize
},
new SqlParameter {
ParameterName = "@askSpread", Value = dto.AskSpread
},
new SqlParameter {
ParameterName = "@bidSpread", Value = dto.BidSpread
}
});
}
public IEnumerable <DbBalance> GetBalanceSnapshots(string currency = "", string baseExchange = "", string counterExchange = "", DateTime?fromDate = null, int processId = 0)
{
using (var reader = DbServiceHelper.ExecuteQuery(sqlConnectionString, "dbo.GetBalances", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@currency", Value = currency
},
new SqlParameter {
ParameterName = "@baseExchange", Value = baseExchange
},
new SqlParameter {
ParameterName = "@counterExchange", Value = counterExchange
},
new SqlParameter {
ParameterName = "@fromDate", Value = fromDate
},
new SqlParameter {
ParameterName = "@processId", Value = processId
}
}))
{
return(reader.ToList <DbBalance>());
}
}
public void InsertArbitragePair(string baseExchange, string arbExchange, string symbol, string baseSymbol, string counterSymbol, string baseCurrency, string marketCurrency)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.InsertArbitragePair", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@baseExchange", Value = baseExchange
},
new SqlParameter {
ParameterName = "@arbExchange", Value = arbExchange
},
new SqlParameter {
ParameterName = "@symbol", Value = symbol
},
new SqlParameter {
ParameterName = "@baseSymbol", Value = baseSymbol
},
new SqlParameter {
ParameterName = "@counterSymbol", Value = counterSymbol
},
new SqlParameter {
ParameterName = "@baseCurrency", Value = baseCurrency
},
new SqlParameter {
ParameterName = "@marketCurrency", Value = marketCurrency
}
});
}
public IEnumerable <DbOpportunity> GetRecentOpportunities(int hours = 1)
{
using (var reader = DbServiceHelper.ExecuteQuery(sqlConnectionString, "dbo.GetRecentOpportunities", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@hours", Value = hours
}
}))
{
return(reader.ToList <DbOpportunity>());
}
}
public IEnumerable <DbHeroStat> GetHeroStats(int hours)
{
using (var reader = DbServiceHelper.ExecuteQuery(sqlConnectionString, "dbo.GetHeroStats", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@hours", Value = hours
}
}))
{
return(reader.ToList <DbHeroStat>());
}
}
public int InsertTransaction(int pairId, string type)
{
return((int)DbServiceHelper.ExecuteScalar(sqlConnectionString, "dbo.InsertTransaction", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@pairId", Value = pairId
},
new SqlParameter {
ParameterName = "@type", Value = type
}
}));
}
public void CloseTransaction(int id, string baseTxId, string counterTxId)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.CloseTransaction", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@baseTxId", Value = baseTxId
},
new SqlParameter {
ParameterName = "@counterTxId", Value = counterTxId
}
});
}
public void UpdateTransactionStatus(int id, string status, object payload = null)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.UpdateTransactionStatus", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@status", Value = status
},
new SqlParameter {
ParameterName = "@meta", Value = (payload == null) ? "" : JsonConvert.SerializeObject(payload)
}
});
}
public void EndEngineProcess(int id, string resultStatus, object payload = null)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.EndEngineProcess", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@result", Value = resultStatus
},
new SqlParameter {
ParameterName = "@meta", Value = (payload == null) ? "" : JsonConvert.SerializeObject(payload)
}
});
}
public IEnumerable <DbMakerOrder> GetMakerOrdersByStatus(string status, int pairId = 0)
{
using (var reader = DbServiceHelper.ExecuteQuery(sqlConnectionString, "dbo.GetMakerOrdersByStatus", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@status", Value = status
},
new SqlParameter {
ParameterName = "@pairId", Value = pairId
}
}))
{
return(reader.ToList <DbMakerOrder>());
}
}
public void UpdateOrder(int id, string baseUuid = "", string counterUuid = "", decimal baseRate = 0, decimal counterRate = 0, string status = "", decimal baseQuantityFilled = 0, decimal counterQuantityFilled = 0, decimal baseCost = 0m, decimal counterCost = 0m, decimal commission = 0m, object payload = null)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.UpdateOrder", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@baseUuid", Value = baseUuid
},
new SqlParameter {
ParameterName = "@counterUuid", Value = counterUuid
},
new SqlParameter {
ParameterName = "@baseRate", Value = baseRate
},
new SqlParameter {
ParameterName = "@counterRate", Value = counterRate
},
new SqlParameter {
ParameterName = "@status", Value = status
},
new SqlParameter {
ParameterName = "@baseQuantityFilled", Value = baseQuantityFilled
},
new SqlParameter {
ParameterName = "@counterQuantityFilled", Value = counterQuantityFilled
},
new SqlParameter {
ParameterName = "@baseCost", Value = baseCost
},
new SqlParameter {
ParameterName = "@counterCost", Value = counterCost
},
new SqlParameter {
ParameterName = "@commission", Value = commission
},
new SqlParameter {
ParameterName = "@meta", Value = (payload == null) ? "" : JsonConvert.SerializeObject(payload)
}
});
}
public IEnumerable <DbArbitragePair> GetArbitragePairs(string type, string baseExchange = "", string arbExchange = "")
{
using (var reader = DbServiceHelper.ExecuteQuery(sqlConnectionString, "dbo.GetArbitragePairs", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@type", Value = type
},
new SqlParameter {
ParameterName = "@baseExchange", Value = baseExchange
},
new SqlParameter {
ParameterName = "@arbExchange", Value = arbExchange
}
}))
{
return(reader.ToList <DbArbitragePair>());
}
}
public void UpdateTransactionOrderUuid(int id, string baseUuid, string counterUuid, object payload = null)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.UpdateTransactionOrderUuid", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@baseUuid", Value = baseUuid
},
new SqlParameter {
ParameterName = "@counterUuid", Value = counterUuid
},
new SqlParameter {
ParameterName = "@meta", Value = (payload == null) ? "" : JsonConvert.SerializeObject(payload)
}
});
}
public void UpdateOrderStatus(int id, string status, decimal baseQuantityFilled = 0, decimal counterQuantityFilled = 0)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.UpdateOrderStatus", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@status", Value = status
},
new SqlParameter {
ParameterName = "@baseQuantityFilled", Value = baseQuantityFilled
},
new SqlParameter {
ParameterName = "@counterQuantityFilled", Value = counterQuantityFilled
}
});
}
public void UpdateTransactionWithdrawalUuid(int id, string baseUuid, string counterUuid, decimal commission)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.UpdateTransactionWithdrawalUuid", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@baseUuid", Value = baseUuid
},
new SqlParameter {
ParameterName = "@counterUuid", Value = counterUuid
},
new SqlParameter {
ParameterName = "@commission", Value = commission
}
});
}
public int StartEngineProcess(string baseExchange, string arbExchange, string runType, CurrencyConfig baseCurrency)
{
return((int)DbServiceHelper.ExecuteScalar(sqlConnectionString, "dbo.StartEngineProcess", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@baseExchange", Value = baseExchange
},
new SqlParameter {
ParameterName = "@arbExchange", Value = arbExchange
},
new SqlParameter {
ParameterName = "@runType", Value = runType
},
new SqlParameter {
ParameterName = "@baseCurrency", Value = JsonConvert.SerializeObject(baseCurrency)
}
}));
}
public void InsertMakerOrder(int pairId, string type, string baseUuid, string counterUuid)
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.InsertMakerOrder", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@pairId", Value = pairId
},
new SqlParameter {
ParameterName = "@type", Value = type
},
new SqlParameter {
ParameterName = "@baseUuid", Value = baseUuid
},
new SqlParameter {
ParameterName = "@counterUuid", Value = counterUuid
}
});
}
public void UpdateOrderUuid(int id, string baseUuid, string counterUuid = "", decimal counterRate = 0, string status = "")
{
DbServiceHelper.ExecuteNonQuery(sqlConnectionString, "dbo.UpdateOrderUuid", 15,
new SqlParameter[]
{
new SqlParameter {
ParameterName = "@id", Value = id
},
new SqlParameter {
ParameterName = "@baseUuid", Value = baseUuid
},
new SqlParameter {
ParameterName = "@counterUuid", Value = counterUuid
},
new SqlParameter {
ParameterName = "@counterRate", Value = counterRate
},
new SqlParameter {
ParameterName = "@status", Value = status
}
});
}
