public void takeData(User user)
{
using (var context = new VignetteContext())
{
context.Users.Add(user);
context.SaveChanges();
}
}
public void takeData(Car cars)
{
using (var context = new VignetteContext())
{
context.Cars.Add(cars);
context.SaveChanges();
}
}
public User GetByCar(Car car)
{
User user = null;
using (var context = new VignetteContext())
{
user = context.Users.FirstOrDefault(u => u.Id == car.Id_User);
}
return(user);
}
public List <User> GetAll()
{
List <User> user = null;
using (var context = new VignetteContext())
{
user = context.Users.ToList();
}
return(user);
}
//Get bought vignette by car from db
public BoughtVignette GetByCar(Car car)
{
BoughtVignette boughtVignettes = null;
using (var context = new VignetteContext())
{
boughtVignettes = context.BoughtVignettes.FirstOrDefault(b => b.Id_Car == car.Id);
}
return(boughtVignettes);
}
public List <BoughtVignette> GetAll()
{
List <BoughtVignette> boughtVignettes = null;
using (var context = new VignetteContext())
{
boughtVignettes = context.BoughtVignettes.ToList();
}
return(boughtVignettes);
}
public Car GetByCarRegistration(string carRegistration)
{
Car car = new Car();
using (var context = new VignetteContext())
{
car = context.Cars.FirstOrDefault(c => c.CarRegistration == carRegistration);
}
return(car);
}
public List <Car> GetAll()
{
List <Car> cars = null;
using (var context = new VignetteContext())
{
cars = context.Cars.ToList();
}
return(cars);
}
//Take date
public void takeData(BoughtVignette boughtVignettes, User user, Car car)
{
using (var context = new VignetteContext())
{
context.Users.Add(user);
car.user = user;
car.Id_User = user.Id;
context.Cars.Add(car);
boughtVignettes.Id_Car = car.Id;
boughtVignettes.cars = car;
context.BoughtVignettes.Add(boughtVignettes);
context.SaveChanges();
}
}
//Deleated information from base
public void DeleteData(BoughtVignette boughtVignettes, User user, Car car)
{
using (var context = new VignetteContext())
{
User removeUser = context.Users.FirstOrDefault(u => u.FirstName == user.FirstName &&
u.LastName == user.LastName && u.PersonalCode == user.PersonalCode);
Car removeCar = context.Cars.FirstOrDefault(c => c.Id_User == removeUser.Id &&
c.CarRegistration == car.CarRegistration);
BoughtVignette removeBoughtVignette = context.BoughtVignettes.FirstOrDefault(b => b.Id_Car == removeCar.Id &&
b.VignettesId == boughtVignettes.VignettesId);
//car.user = user;
//car.Id_User = user.Id;
//boughtVignettes.Id_Car = car.Id;
//boughtVignettes.cars = car;
context.Users.Remove(removeUser);
context.Cars.Remove(removeCar);
context.BoughtVignettes.Remove(removeBoughtVignette);
context.SaveChanges();
}
}
