public virtual T GetById(int id)
{
using (var db = new AlgotrageContext())
{
return(db.Set <T>().FirstOrDefault(x => x.Id == id));
}
}
public override Team GetById(int id)
{
using (var db = new AlgotrageContext())
{
return(db.Teams.Include(t => t.PossibleNames).FirstOrDefault(x => x.Id == id));
}
}
public Team GetByPossibleName(string name)
{
using (var db = new AlgotrageContext())
{
var teams = db.Teams.Include(x => x.PossibleNames).ToList();
return(teams.FirstOrDefault(t => t.DisplayName == name || t.PossibleNames.ConvertAll(x => x.PossibleName).Contains(name)));
}
}
public virtual void AddRange(List <T> ts)
{
using (var db = new AlgotrageContext())
{
db.Set <T>().AddRange(ts);
db.SaveChanges();
}
}
public void AddPossibleName(TeamPossibleName teamPossibleName)
{
using (var db = new AlgotrageContext())
{
var entry = db.Entry(teamPossibleName);
entry.State = EntityState.Added;
db.SaveChanges();
}
}
public virtual void Remove(T t)
{
using (var db = new AlgotrageContext())
{
var entry = db.Entry(t);
entry.State = EntityState.Deleted;
db.SaveChanges();
}
}
public virtual void Update(T t)
{
using (var db = new AlgotrageContext())
{
var entry = db.Entry(t);
entry.State = EntityState.Modified;
db.SaveChanges();
}
}
public override List <Game> GetAll()
{
List <Game> ts = null;
using (var db = new AlgotrageContext())
{
ts = db.Games.Include(x => x.GameSiteRatios).OrderBy(x => x.Date).ToList();
}
return(ts);
}
public virtual List <T> GetAll()
{
List <T> ts = null;
using (var db = new AlgotrageContext())
{
ts = db.Set <T>().ToList();
}
return(ts);
}
public ArbitragesDbManager()
{
context = new AlgotrageContext();
}
static void Main(string[] args)
{
using (var db = new AlgotrageContext())
{
var team1 = new Team
{
DisplayName = "First"
};
var team2 = new Team
{
DisplayName = "Second"
};
db.Teams.Add(team1);
db.Teams.Add(team2);
var game = new Game
{
AwayTeam = team2,
HomeTeam = team1,
Date = DateTime.Now,
};
db.Games.Add(game);
Site s1 = new Site()
{
Image = "bla.jpg",
Url = "http://bla.com",
Name = "bla"
};
Site s2 = new Site()
{
Image = "bla2.jpg",
Url = "http://bla2.com",
Name = "bla2"
};
Site s3 = new Site()
{
Image = "bla3.jpg",
Url = "http://bla3.com",
Name = "bla3"
};
db.Sites.Add(s1);
db.Sites.Add(s2);
db.Sites.Add(s3);
Arbitrage arb = new Arbitrage()
{
Game = game,
AwayRatio = 3.1,
HomeRatio = 3.1,
DrawRatio = 3.1,
AwayRatioSite = s1,
HomeRatioSite = s2,
DrawRatioSite = s3,
FindTime = DateTime.Now,
IsActive = true,
ProfitPercent = 0.3,
HomeBetPercent = 0.33,
AwayBetPercent = 0.33,
DrawBetPercent = 0.34,
};
db.Arbitrages.Add(arb);
db.SaveChanges();
//var games = new GamesManager().GetAll();
}
}
