private void Register(string functionName, string login, string password)
{
SportBetDbContext context = GetContext();
string query = String.Format("DO $$ BEGIN PERFORM {0}('{1}', '{2}'); END $$;", functionName, login, password);
context.Database.ExecuteSqlCommand(query);
}
private void Delete(string functionName, string login)
{
SportBetDbContext context = GetContext();
string query = String.Format("DO $$ BEGIN PERFORM {0}('{1}'); END $$;", functionName, login);
context.Database.ExecuteSqlCommand(query);
}
public int GetIdByLogin(string login)
{
SportBetDbContext context = GetContext();
UserEntity userEntity = context.Users.Single(user => user.Login == login);
return(userEntity.Id);
}
public CountryEntity Get(string countryName)
{
SportBetDbContext context = GetContext();
CountryEntity countryEntity = context.Countries.SingleOrDefault(country => country.Name == countryName);
return(countryEntity);
}
public SportEntity Get(string sportName)
{
SportBetDbContext context = GetContext();
SportEntity sportEntity = context.Sports.SingleOrDefault(sport => sport.Type == sportName);
return(sportEntity);
}
public IEnumerable <TEntity> GetAll(Expression <Func <TEntity, bool> > predicate)
{
SportBetDbContext context = GetContext();
DbSet <TEntity> dbSet = context.Set <TEntity>();
return(dbSet.Where(predicate).ToList());
}
public void Add(TEntity entity)
{
SportBetDbContext context = GetContext();
DbSet <TEntity> dbSet = context.Set <TEntity>();
dbSet.Add(entity);
}
public IEnumerable <TEntity> GetAll()
{
SportBetDbContext context = GetContext();
DbSet <TEntity> dbSet = context.Set <TEntity>();
return(dbSet.ToList());
}
public virtual TEntity Get(int id)
{
SportBetDbContext context = GetContext();
DbSet <TEntity> dbSet = context.Set <TEntity>();
return(dbSet.Find(id));
}
public void Remove(TEntity entity)
{
SportBetDbContext context = GetContext();
DbSet <TEntity> dbSet = context.Set <TEntity>();
dbSet.Remove(entity);
}
public void ChangePassword(string login, string newPassword)
{
SportBetDbContext context = GetContext();
string query = String.Format("DO $$ BEGIN PERFORM change_password('{0}', '{1}'); END $$;", login, newPassword);
context.Database.ExecuteSqlCommand(query);
}
public BetEntity Get(int coefficientId, string clientPhoneNumber)
{
SportBetDbContext context = GetContext();
ClientEntity clientEntity = context.Clients.Single(c => c.PhoneNumber == clientPhoneNumber);
BetEntity betEntity = context.Bets.SingleOrDefault(b => b.ClientId == clientEntity.Id && b.CoefficientId == coefficientId);
return(betEntity);
}
public CoefficientEntity Get(int eventId, string description)
{
SportBetDbContext context = GetContext();
CoefficientEntity coefficientEntity = context
.Coefficients.SingleOrDefault(c =>
c.EventId == eventId &&
c.Description == description);
return(coefficientEntity);
}
public TournamentEntity Get(string name, string sportName, DateTime dateOfStart)
{
SportBetDbContext context = GetContext();
TournamentEntity tournament = context
.Tournaments
.SingleOrDefault(t =>
t.Name == name &&
t.Sport.Type == sportName &&
t.DateOfStart == dateOfStart);
return(tournament);
}
public bool Exists(string name, int sportId, DateTime dateOfStart)
{
SportBetDbContext context = GetContext();
TournamentEntity tournament = context
.Tournaments
.SingleOrDefault(t =>
t.Name == name &&
t.SportId == sportId &&
t.DateOfStart == dateOfStart);
return(tournament != null);
}
public BookmakerEntity Get(string bookmakerPhoneNumber)
{
SportBetDbContext context = GetContext();
return(context.Bookmakers.SingleOrDefault(b => b.PhoneNumber == bookmakerPhoneNumber));
}
public ClientEntity Get(string clientPhoneNumber)
{
SportBetDbContext context = GetContext();
return(context.Clients.SingleOrDefault(c => c.PhoneNumber == clientPhoneNumber));
}
