public void Update(InputOutputCar inputOutputCar)
{
using (var context = new ParqueoContext())
{
var inputOutputCarUpdate = context.InputOutputCars.SingleOrDefault(x => x.Id == inputOutputCar.Id);
if (inputOutputCarUpdate != null)
{
inputOutputCarUpdate.LastUpdatedOn = inputOutputCar.LastUpdatedOn;
inputOutputCarUpdate.Status = inputOutputCar.Status;
inputOutputCarUpdate.Observation = inputOutputCar.Observation;
inputOutputCarUpdate.Name = inputOutputCar.Name;
inputOutputCarUpdate.FatherName = inputOutputCar.FatherName;
inputOutputCarUpdate.MotherName = inputOutputCar.MotherName;
inputOutputCarUpdate.Ci = inputOutputCar.Ci;
inputOutputCarUpdate.PhoneNumber = inputOutputCar.PhoneNumber;
inputOutputCarUpdate.CarPlate = inputOutputCar.CarPlate;
inputOutputCarUpdate.Model = inputOutputCar.Model;
inputOutputCarUpdate.Color = inputOutputCar.Color;
inputOutputCarUpdate.Brand = inputOutputCar.Brand;
inputOutputCarUpdate.TypeCar = inputOutputCar.TypeCar;
inputOutputCarUpdate.FirstHour = inputOutputCar.FirstHour;
inputOutputCarUpdate.AdditionalHour = inputOutputCar.AdditionalHour;
inputOutputCarUpdate.InHour = inputOutputCar.InHour;
inputOutputCarUpdate.OutHour = inputOutputCar.OutHour;
inputOutputCarUpdate.BigTotal = inputOutputCar.BigTotal;
}
context.SaveChanges();
}
}
public void Create(InputOutputCar inputOutputCar)
{
using (var context = new ParqueoContext())
{
context.InputOutputCars.Add(inputOutputCar);
context.SaveChanges();
}
}
public void Create(Client client)
{
using (var context = new ParqueoContext())
{
context.Clients.Add(client);
context.SaveChanges();
}
}
public void Create(SetMoney setMoney)
{
using (var context = new ParqueoContext())
{
context.SetMoneys.Add(setMoney);
context.SaveChanges();
}
}
public void Create(CarPark carPark)
{
using (var context = new ParqueoContext())
{
context.CarParks.Add(carPark);
context.SaveChanges();
}
}
public void Create(Parking parking)
{
using (var context = new ParqueoContext())
{
context.Parkings.Add(parking);
context.SaveChanges();
}
}
public void Delete(SetMoney setMoney)
{
using (var context = new ParqueoContext())
{
var setMoneyDelete = context.SetMoneys.SingleOrDefault(x => x.Id == setMoney.Id);
context.SetMoneys.Remove(setMoneyDelete);
context.SaveChanges();
}
}
public void Delete(Client client)
{
using (var context = new ParqueoContext())
{
var clientDelete = context.Clients.SingleOrDefault(x => x.Id == client.Id);
context.Clients.Remove(clientDelete);
context.SaveChanges();
}
}
public void Delete(InputOutputCar inputOutputCar)
{
using (var context = new ParqueoContext())
{
var inputOutputCarDelete = context.InputOutputCars.SingleOrDefault(x => x.Id == inputOutputCar.Id);
context.InputOutputCars.Remove(inputOutputCarDelete);
context.SaveChanges();
}
}
public void Delete(Parking parking)
{
using (var context = new ParqueoContext())
{
var parkingDelete = context.Parkings.SingleOrDefault(x => x.Id == parking.Id);
context.Parkings.Remove(parkingDelete);
context.SaveChanges();
}
}
public void Delete(CarPark carPark)
{
using (var context = new ParqueoContext())
{
var carParkDelete = context.CarParks.SingleOrDefault(x => x.Id == carPark.Id);
context.CarParks.Remove(carParkDelete);
context.SaveChanges();
}
}
public IEnumerable <SetMoney> GetAll()
{
List <SetMoney> setMoneys;
using (var context = new ParqueoContext())
{
setMoneys = context.SetMoneys.Where(x => x.CreatedOn != null).ToList();
}
return(setMoneys);
}
public IEnumerable <Client> GetAll()
{
List <Client> clients;
using (var context = new ParqueoContext())
{
clients = context.Clients.Where(x => x.CreatedOn != null).ToList();
}
return(clients);
}
public IEnumerable <Parking> GetAll()
{
List <Parking> parkings;
using (var context = new ParqueoContext())
{
parkings = context.Parkings.Where(x => x.CreatedOn != null).ToList();
}
return(parkings);
}
public Parking GetForId(int id)
{
Parking parking;
using (var context = new ParqueoContext())
{
parking = context.Parkings.SingleOrDefault(x => x.Id == id);
}
return(parking);
}
public Car GetForId(int id)
{
Car car;
using (var context = new ParqueoContext())
{
car = context.Cars.SingleOrDefault(x => x.Id == id);
}
return(car);
}
public Client GetForId(int id)
{
Client client;
using (var context = new ParqueoContext())
{
client = context.Clients.SingleOrDefault(x => x.Id == id);
}
return(client);
}
public IEnumerable <InputOutputCar> GetAll()
{
List <InputOutputCar> inputOutputCars;
using (var context = new ParqueoContext())
{
inputOutputCars = context.InputOutputCars.Where(x => x.CreatedOn != null).ToList();
}
return(inputOutputCars);
}
public InputOutputCar GetForId(int id)
{
InputOutputCar inputOutputCar;
using (var context = new ParqueoContext())
{
inputOutputCar = context.InputOutputCars.SingleOrDefault(x => x.Id == id);
}
return(inputOutputCar);
}
public SetMoney GetForId(int id)
{
SetMoney setMoney;
using (var context = new ParqueoContext())
{
setMoney = context.SetMoneys.SingleOrDefault(x => x.Id == id);
}
return(setMoney);
}
public IEnumerable <CarPark> GetAll()
{
List <CarPark> carParks;
using (var context = new ParqueoContext())
{
carParks = context.CarParks.Where(x => x.CreatedOn != null).ToList();
}
return(carParks);
}
public CarPark GetForId(int id)
{
CarPark carPark;
using (var context = new ParqueoContext())
{
carPark = context.CarParks.SingleOrDefault(x => x.Id == id);
}
return(carPark);
}
public void Update(Parking parking)
{
using (var context = new ParqueoContext())
{
var parkingUpdate = context.Parkings.SingleOrDefault(x => x.Id == parking.Id);
if (parkingUpdate != null)
{
parkingUpdate.LastUpdatedOn = parking.LastUpdatedOn;
parkingUpdate.Status = parking.Status;
parkingUpdate.Observation = parking.Observation;
parkingUpdate.CodeName = parking.CodeName;
parkingUpdate.Free = parking.Free;
}
context.SaveChanges();
}
}
public void Update(SetMoney setMoney)
{
using (var context = new ParqueoContext())
{
var setMoneyUpdate = context.SetMoneys.SingleOrDefault(x => x.Id == setMoney.Id);
if (setMoneyUpdate != null)
{
setMoneyUpdate.LastUpdatedOn = setMoneyUpdate.LastUpdatedOn;
setMoneyUpdate.Status = setMoneyUpdate.Status;
setMoneyUpdate.Observation = setMoneyUpdate.Observation;
setMoneyUpdate.FirstHour = setMoneyUpdate.FirstHour;
setMoneyUpdate.AdditionalHour = setMoneyUpdate.AdditionalHour;
setMoneyUpdate.parking = setMoneyUpdate.parking;
}
context.SaveChanges();
}
}
public void Update(CarPark carPark)
{
using (var context = new ParqueoContext())
{
var carParkUpdate = context.CarParks.SingleOrDefault(x => x.Id == carPark.Id);
if (carParkUpdate != null)
{
carParkUpdate.LastUpdatedOn = carPark.LastUpdatedOn;
carParkUpdate.Status = carPark.Status;
carParkUpdate.Observation = carPark.Observation;
carParkUpdate.Name = carPark.Name;
carParkUpdate.Address = carPark.Address;
carParkUpdate.CapacityCars = carPark.CapacityCars;
}
context.SaveChanges();
}
}
public void Update(Client client)
{
using (var context = new ParqueoContext())
{
var clientUpdate = context.Clients.SingleOrDefault(x => x.Id == client.Id);
if (clientUpdate != null)
{
clientUpdate.LastUpdatedOn = client.LastUpdatedOn;
clientUpdate.Status = client.Status;
clientUpdate.Observation = client.Observation;
clientUpdate.Name = client.Name;
clientUpdate.FatherName = client.FatherName;
clientUpdate.MotherName = client.MotherName;
clientUpdate.Ci = client.Ci;
clientUpdate.PhoneNumber = client.PhoneNumber;
}
context.SaveChanges();
}
}
public void Update(Car car)
{
using (var context = new ParqueoContext())
{
var carUpdate = context.Cars.SingleOrDefault(x => x.Id == car.Id);
if (carUpdate != null)
{
carUpdate.LastUpdatedOn = car.LastUpdatedOn;
carUpdate.Status = car.Status;
carUpdate.Observation = car.Observation;
carUpdate.CarPlate = car.CarPlate;
carUpdate.Model = car.Model;
carUpdate.Color = car.Color;
carUpdate.Brand = car.Brand;
carUpdate.TypeCar = car.TypeCar;
}
context.SaveChanges();
}
}
