public static IEnumerable <IBSecurity> GetIbSecurities()
{
using (wvDB entity = new wvDB())
{
return(entity.IBSecurities.ToList());
}
}
public static bool Login(string username, string password)
{
using (wvDB entities = new wvDB())
{
return(entities.Users.Any(user => user.Username.Equals(username, StringComparison.OrdinalIgnoreCase) && user.Password == password));
}
}
public static decimal GetCashActivity(string accountname)
{
using (wvDB entity = new wvDB())
{
return(entity.IBCashActivities.Where(x => x.AccountName == accountname).Sum(x => x.Amount));
}
}
public static IEnumerable <IBStaticData> GetIbStaticData()
{
using (wvDB entity = new wvDB())
{
return(entity.IBStaticDatas.ToList());
}
}
public static IEnumerable <IBStrategy> GetIbStrategy()
{
using (wvDB entity = new wvDB())
{
return(entity.IBStrategies.ToList());
}
}
public static IEnumerable <IBStrategyMapping> GetIbStrategyMapping(string account)
{
using (wvDB entity = new wvDB())
{
return(entity.IBStrategyMappings.Where(x => x.AccountName == account).ToList());
}
}
public static bool UpdateIbStrategyMapping(IBStrategyMapping ibmap)
{
using (wvDB entity = new wvDB())
{
try
{
entity.Configuration.AutoDetectChangesEnabled = false;
ibmap.LastUpdated = DateTime.Now;
entity.IBStrategyMappings.AddOrUpdate(ibmap);
entity.SaveChanges();
}
finally
{
entity.Configuration.AutoDetectChangesEnabled = true;
}
return(true);
}
}
internal static void InsertIbStrategyMapping(List <IBStrategyMapping> newmapping)
{
using (wvDB entity = new wvDB())
{
try
{
entity.Configuration.AutoDetectChangesEnabled = false;
foreach (IBStrategyMapping ibmap in newmapping)
{
entity.IBStrategyMappings.Add(ibmap);
}
entity.SaveChanges();
}
finally
{
entity.Configuration.AutoDetectChangesEnabled = true;
}
}
}
public static bool UpdateIbStaticData(IEnumerable <IBStaticData> ibmaps)
{
using (wvDB entity = new wvDB())
{
try
{
foreach (var ibmap in ibmaps)
{
entity.Configuration.AutoDetectChangesEnabled = false;
ibmap.LastUpdated = DateTime.Now;
entity.IBStaticDatas.AddOrUpdate(ibmap);
}
entity.SaveChanges();
}
finally
{
entity.Configuration.AutoDetectChangesEnabled = true;
}
return(true);
}
}