public User Authenticate(string userName, string password)
{
User user;
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
user = context.Users.FirstOrDefault(u => u.Username == userName && u.Password == password);
}
if (user == null)
{
return(null);
}
// authentication successful, generate jwt token
var tokenHandler = new JwtSecurityTokenHandler();
//var jwtSettings = new JwtSettings();
var key = Encoding.ASCII.GetBytes("secretsecretsecretsecretsecret");
var tokenDescriptor = new SecurityTokenDescriptor
{
Subject = new ClaimsIdentity(new Claim[]
{
new Claim(ClaimTypes.Name, user.UserId.ToString()),
new Claim("username", user.Username)
}),
Expires = DateTime.UtcNow.AddDays(7),
SigningCredentials = new SigningCredentials(new SymmetricSecurityKey(key), SecurityAlgorithms.HmacSha256Signature),
};
var token = tokenHandler.CreateToken(tokenDescriptor);
user.Token = tokenHandler.WriteToken(token);
user.Password = null;
return(user);
}
public Reservation Get(int id)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var reservation = context.Reservations.FirstOrDefault(c => c.ReservationId == id);
return(reservation);
}
}
catch { return(null); }
}
public ICollection <Sport> GetAll()
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var sports = context.Sports.ToList();
return(sports);
}
}
catch { return(null); }
}
public ICollection <Company> GetAll()
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var companies = context.Companies.ToList();
return(companies);
}
}
catch { return(null); }
}
public ICollection <Court> GetAllOfCompanyForSport(int companyId, int sportId)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var courts = context.Courts.Where(court => court.CompanyId == companyId && court.SportId == sportId).ToList();
return(courts);
}
}
catch { return(null); }
}
public Company Get(int id)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var company = context.Companies.FirstOrDefault(c => c.CompanyId == id);
return(company);
}
}
catch { return(null); }
}
public User GetByUserName(string username)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var user = context.Users.FirstOrDefault(c => c.Username == username);
return(user);
}
}
catch { return(null); }
}
public User GetById(int id)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var user = context.Users.FirstOrDefault(c => c.UserId == id);
return(user);
}
}
catch { return(null); }
}
public ICollection <User> GetAll(int id)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var users = context.Users.ToList();
return(users);
}
}
catch { return(null); }
}
public bool Add(Court court)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
context.Courts.Add(court);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public bool Delete(User user)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
context.Users.Remove(user);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public ICollection <Reservation> GetAllForCompanyOnDate(int companyId, DateTime date)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var reservations = context.Reservations.Where(r => r.Court.CompanyId == companyId && r.StartTime.Date == date.Date)
.Include(r => r.Court).ToList();
return(reservations);
}
}
catch { return(null); }
}
public bool Add(Reservation reservation)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
context.Reservations.Add(reservation);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public bool Delete(Company company)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
context.Companies.Remove(company);
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public int Add(Company company)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
context.Companies.Add(company);
context.SaveChanges();
return(company.CompanyId);
}
}
catch { return(-1); }
}
public ICollection <Reservation> GetAllForDateTime(DateTime date)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var reservations = context.Reservations.Where(r => r.StartTime.CompareTo(date) == 0)
.Include(r => r.Court.Company).ToList();
return(reservations);
}
}
catch { return(null); }
}
public bool Update(Court court, Court updated)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
court.CourtName = updated.CourtName;
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public ICollection <Reservation> GetAllForUser(int id)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var reservations = context.Reservations.Where(r => r.UserId == id)
.Include(r => r.Court.Company)
.ToList();
return(reservations);
}
}
catch { return(null); }
}
public bool Update(Reservation reservation, Reservation updated)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
reservation.StartTime = updated.StartTime;
reservation.EndTime = updated.EndTime;
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public ICollection <Company> GetAllForSport(int sportId)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
//var courts = context.Courts.Where(c => c.Sport.Name == sportName).ToList();
var companies = context.Companies.Where(c => c.Courts.Any(court => court.Sport.SportId == sportId))
.Include(c => c.Courts)
.ToList();
//var companies = context.Companies.Where(c => c.Courts.Contains(courts));
return(companies.ToList());
}
}
catch { return(null); }
}
public bool Update(User user, User updated)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
user.FirstName = updated.FirstName;
user.LastName = updated.LastName;
user.PhoneNumber = updated.PhoneNumber;
user.Password = updated.Password;
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public bool Update(Company company, Company updated)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
company.CompanyName = updated.CompanyName;
company.Description = updated.Description;
company.Latitude = updated.Latitude;
company.Longitude = updated.Longitude;
company.PhoneNumber = updated.PhoneNumber;
context.SaveChanges();
return(true);
}
}
catch { return(false); }
}
public bool Delete(int reservationId, int userId)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var reservation = context.Reservations.FirstOrDefault(r => r.ReservationId == reservationId);
var user = context.Users.FirstOrDefault(u => u.UserId == userId);
if (reservation.UserId == userId || reservation.Court.CompanyId == user.CompanyId)
{
context.Reservations.Remove(reservation);
context.SaveChanges();
return(true);
}
return(false);
}
}
catch { return(false); }
}
public ICollection <Sport> GetAllForCompany(int companyId)
{
try
{
using (var context = new SportivoContext(new DbContextOptions <SportivoContext>()))
{
var courts = context.Courts.Where(c => c.CompanyId == companyId);
List <int> sportIds = new List <int>();
foreach (var court in courts)
{
if (!sportIds.Contains(court.SportId))
{
sportIds.Add(court.SportId);
}
}
var sports = context.Sports.Where(s => sportIds.Contains(s.SportId)).ToList();
return(sports);
}
}
catch { return(null); }
}
