public Task <List <FuelingModel> > GetFuelings()
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
List <FuelingModel> fuelings = dbContext.Fuelings.ToList();
return(Task.FromResult(fuelings));
}
public Task <VehicleModel> GetVehicleByID(int id)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
VehicleModel existingModel = dbContext.Vehicles.FirstOrDefault(u => u.Id == id);
return(Task.FromResult(existingModel));
}
public Task <List <FuelingModel> > GetFuelings(List <Guid> list)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
List <FuelingModel> fuelings = dbContext.Fuelings.Where(f => list.Contains(f.VehicleGID)).ToList();
return(Task.FromResult(fuelings));
}
public Task <FuelingModel> GetFuelingByID(int Id)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
FuelingModel existingModel = dbContext.Fuelings.FirstOrDefault(u => u.Id == Id);
return(Task.FromResult(existingModel));
}
public Task <bool> IsEmailRegistered(UserModel userModel)
{
//UserDbContext _userDbContext = new UserDbContext(_dbContextOptions);
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
UserModel existingUser = dbContext.Users.FirstOrDefault(u => u.Email == userModel.Email);
return(Task.FromResult(existingUser != null ? true : false));
}
public Task <bool> UpdateVehicle(VehicleModel vehicleModel)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
dbContext.Vehicles.Update(vehicleModel);
dbContext.SaveChanges();
return(Task.FromResult(true));
}
public UserService(DbContextOptions <FuelAppDbContext> dbAppContextOptions)
{
//Since userservice is the first service accessed it´s the place to ensure DB creation
_dbAppContextOptions = dbAppContextOptions;
FuelAppDbContext fuelAppDbContext = new FuelAppDbContext(_dbAppContextOptions);
fuelAppDbContext.Database.EnsureCreated();
}
public Task <bool> EditFueling(FuelingModel fuelingModel)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
dbContext.Fuelings.Update(fuelingModel);
dbContext.SaveChanges();
return(Task.FromResult(true));
}
public Task <UserModel> Login(UserModel userModel)
{
//TODO - check email,password and confirmation with DB
//UserDbContext _userDbContext = new UserDbContext(_dbContextOptions);
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
UserModel existingUser = dbContext.Users.FirstOrDefault(u => u.Email == userModel.Email && u.Password == userModel.Password && u.IsEmailConfirmed);
return(Task.FromResult(existingUser));
}
public Task <FuelingModel> GetFuelingByGID(string gid)
{
Guid curGID = Guid.Empty;
Guid.TryParse(gid, out curGID);
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
FuelingModel existingModel = dbContext.Fuelings.FirstOrDefault(u => u.GID == curGID);
return(Task.FromResult(existingModel));
}
public Task <bool> DeleteVehicle(int id) //VehicleModel vehicleModel)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
VehicleModel existingModel = dbContext.Vehicles.FirstOrDefault(u => u.Id == id);
if (existingModel != null)
{
dbContext.Remove(existingModel);
dbContext.SaveChanges();
}
return(Task.FromResult(true));
}
public Task <List <VehicleModel> > GetVehicles(string userId)
{
Guid curGID = Guid.Empty;
Guid.TryParse(userId, out curGID);
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
List <VehicleModel> list = dbContext.Vehicles.Where(v => v.UserGID == curGID).ToList();
return(Task.FromResult(list));
}
public Task <bool> AddFueling(FuelingModel fuelingModel)
{
if (fuelingModel.GID == Guid.Empty)
{
fuelingModel.GID = Guid.NewGuid();
}
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
dbContext.Add(fuelingModel);
dbContext.SaveChanges();
return(Task.FromResult(true));
}
public Task <bool> RegisterUser(UserModel userModel)
{
//check for empty GUID and create one if empty
if (userModel.GID == Guid.Empty)
{
userModel.GID = Guid.NewGuid();
}
FuelAppDbContext appDbContext = new FuelAppDbContext(_dbAppContextOptions);
appDbContext.Users.Add(userModel);
appDbContext.SaveChanges();
return(Task.FromResult(true));
}
public Task <bool> RegisterVehicle(VehicleModel vehicleModel)
{
if (vehicleModel.GID == Guid.Empty)
{
vehicleModel.GID = Guid.NewGuid();
}
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
dbContext.Vehicles.Add(vehicleModel);
dbContext.SaveChanges();
return(Task.FromResult(true));
}
public Task <bool> DeleteFueling(int id)
{
FuelAppDbContext dbContext = new FuelAppDbContext(_dbContextOptions);
FuelingModel existingModel = dbContext.Fuelings.FirstOrDefault(u => u.Id == id);
if (existingModel != null)
{
dbContext.Fuelings.Remove(existingModel);
dbContext.SaveChanges();
return(Task.FromResult(true));
}
else
{
return(Task.FromResult(false));
}
}
public Task <bool> ConfirmEmail(string id)
{
Guid guid = Guid.Parse(id);
//UserDbContext userDbContext = new UserDbContext(_dbContextOptions);
FuelAppDbContext dbContext = new FuelAppDbContext(_dbAppContextOptions);
UserModel existingUser = dbContext.Users.FirstOrDefault(u => u.GID == guid);
if (existingUser != null)
{
existingUser.IsEmailConfirmed = true;
existingUser.EmailConfirmationDate = DateTime.Now;
dbContext.SaveChanges();
return(Task.FromResult(true));
}
else
{
return(Task.FromResult(false));
}
}
