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