public IEnumerable <Fund> GetFunds()
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return(GetEntities(entityContext));
}
}
public IEnumerable <AlgorithmParameter> GetAlgorithmParameters()
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return(GetEntities(entityContext).ToArray().ToList());
}
}
public IEnumerable <AlgorithmMessage> GetAlgorithmMessages()
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return(GetEntities(entityContext));
}
}
public IEnumerable <Reservation> GetOpenReservationsByAccount(int accountId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return(GetEntities(entityContext).Where(r => r.Account.AccountID == accountId && r.Open == true));
}
}
public IEnumerable <Participation> GetParticipations()
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return(GetEntities(entityContext));
}
}
public IEnumerable <Strategy> GetStrategies()
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return(GetEntities(entityContext));
}
}
public IEnumerable <MetaFieldDefinition> GetFieldDefinitions(string tableName, bool enabled = true)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var fieldDefinitions = GetEntities(entityContext).Where(x => x.TableName == tableName && x.Enabled == enabled);
return(fieldDefinitions);
}
}
public IEnumerable <MetaLookup> GetLookups(string type, bool enabledOnly = true)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var lookups = GetEntities(entityContext).Where(x => x.Type == type);
return(lookups);
}
}
public Account GetByLogin(string login)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return((from a in entityContext.AccountSet
where a.LoginEmail == login
select a).FirstOrDefault());
}
}
public Account GetById(int accountId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
return((from a in entityContext.AccountSet
where a.AccountID == accountId
select a).FirstOrDefault());
}
}
public Broker GetBrokerByName(string name)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var broker = GetEntities(entityContext).Where(x => x.Name == name).FirstOrDefault();
return(broker);
}
}
protected override Participation GetEntity(MarketMinerContext entityContext, int id)
{
var query = (from e in entityContext.ParticipationSet
where e.ParticipationID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override Fund GetEntity(MarketMinerContext entityContext, int id)
{
var query = (from e in entityContext.FundSet
where e.FundID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override MetaResource GetEntity(MarketMinerContext entityContext, int id)
{
var query = (from e in entityContext.MetaResourceSet
where e.MetaResourceID == id
select e);
var result = query.FirstOrDefault();
return(result);
}
protected override AlgorithmMessage GetEntity(MarketMinerContext entityContext, int id)
{
var query = (from e in entityContext.AlgorithmMessageSet
where e.AlgorithmMessageID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override CommunicationTemplate GetEntity(MarketMinerContext entityContext, int id)
{
var query = (from e in entityContext.CommunicationTemplateSet
where e.CommunicationTemplateID == id
select e);
var results = query.FirstOrDefault();
return(results);
}
public MetaResource GetResource(string set, string type, string key, string cultureCode = "en-US", bool enabled = true)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var resource = GetEntities(entityContext)
.Where(x => x.Set == set && x.Type == type && x.Key == key && x.CultureCode == cultureCode && x.Enabled == enabled)
.FirstOrDefault();
return(resource);
}
}
public IEnumerable <Participation> GetParticipationsByStrategy(short strategyId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from p in entityContext.ParticipationSet
where p.Fund.Strategies.FirstOrDefault(s => s.StrategyID == strategyId) != null
select p;
return(query.ToFullyLoaded());
}
}
public IEnumerable <Participation> GetParticipationsByDateCreatedRange(DateTime dateBottom, DateTime dateTop)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from p in entityContext.ParticipationSet
where p.DateCreated >= dateBottom && p.DateCreated <= dateTop
select p;
return(query.ToFullyLoaded());
}
}
public IEnumerable <Participation> GetParticipationsByDate(DateTime dateCreated)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from r in entityContext.ParticipationSet
where r.DateCreated == dateCreated
select r;
return(query.ToFullyLoaded());
}
}
public IEnumerable <Fund> GetFundsByStrategy(int strategyId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from f in entityContext.FundSet
join s in entityContext.StrategySet on f.FundID equals s.FundID
select f;
return(query);
}
}
public IEnumerable <Communication> GetCommunicationsByDateRange(DateTime dateBottom, DateTime dateTop)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from r in entityContext.CommunicationSet
where r.DateCreated >= dateBottom && r.DateCreated <= dateTop
select r;
return(query.ToFullyLoaded());
}
}
public IEnumerable <CommunicationTemplate> GetCommunicationTemplateByName(string name)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from t in entityContext.CommunicationTemplateSet
where t.Name == name
select t;
return(query.ToFullyLoaded());
}
}
public IEnumerable <AlgorithmMessage> GetAlgorithmMessagesByStrategy(int strategyId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from m in entityContext.AlgorithmMessageSet
join i in entityContext.AlgorithmInstanceSet on m.AlgorithmInstanceID equals i.AlgorithmInstanceID
where i.StrategyID == strategyId
select m;
return(query);
}
}
public IEnumerable <Strategy> GetStrategiesByAlgorithmStatus(short algorithmStatus)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from s in entityContext.StrategySet
join a in entityContext.AlgorithmInstanceSet on s.StrategyID equals a.StrategyID
where a.Status > 0
select s;
return(query);
}
}
public IEnumerable <Fund> GetFundsByAccount(int accountId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from a in entityContext.AccountSet
join p in entityContext.ParticipationSet on a.AccountID equals p.AccountID
join f in entityContext.FundSet on p.FundID equals f.FundID
where a.AccountID == accountId
select f;
return(query);
}
}
public IEnumerable <Signal> GetSignals(bool activesOnly = false)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
if (activesOnly)
{
return(GetEntities(entityContext).Where(e => e.Active == true).ToArray().ToList());
}
else
{
return(GetEntities(entityContext).ToArray().ToList());
}
}
}
public IEnumerable <MetaResource> GetResourcesByCulture(string set, string cultureCode = "en-US", bool enabledOnly = true)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var resources = GetEntities(entityContext).Where(x => x.Set == set && x.CultureCode == cultureCode);
if (enabledOnly)
{
resources.Where(r => r.Enabled);
}
return(resources);
}
}
public IEnumerable <AccountSubscriptionInfo> GetAccountSubscriptionsByProduct(int productId)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var query = from s in entityContext.SubscriptionSet
join a in entityContext.AccountSet
on s.AccountID equals a.AccountID
where s.ProductID == productId &&
s.Active == true
select new AccountSubscriptionInfo()
{
Account = a,
Subscription = s
};
return(query.ToFullyLoaded());
}
}
public IEnumerable <MetaSetting> GetSettings(string type, bool enabled = true)
{
using (MarketMinerContext entityContext = new MarketMinerContext())
{
var defaults = from s in entityContext.MetaSettingSet
where s.Environment == Constants.MetaSettings.Environments.Default &&
s.Type == type &&
s.Enabled == enabled
select s;
var environments = from s in entityContext.MetaSettingSet
where s.Environment == _environment &&
s.Type == type &&
s.Enabled == enabled
select s;
// remove defaults with environment-specific equivalents
defaults.ToList().RemoveAll(d => environments.FirstOrDefault(e => e.Type == d.Type && e.Code == d.Code) != null);
environments = environments.Concat(defaults);
return(environments.ToFullyLoaded());
}
}
