public Cliente Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Cliente.Find(id));
}
}
public Servico Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Servico.Find(id));
}
}
public Comanda ShortShow(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Comanda.Where(model => model.ComandaID == id).FirstOrDefault());
}
}
public List <Cliente> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.Cliente.ToList());
}
}
public List <VagaTipo> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.VagaTipo.ToList());
}
}
public ComandaStatus Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.ComandaStatus.Find(id));
}
}
public List <Funcionario> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.Funcionario.ToList());
}
}
public VagaTipo Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.VagaTipo.Find(id));
}
}
public Funcionario Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Funcionario.Find(id));
}
}
public List <Veiculo> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.Veiculo.ToList());
}
}
public List <ComandaStatus> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.ComandaStatus.ToList());
}
}
public List <Servico> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.Servico.ToList());
}
}
public List <Vaga> List()
{
using (var db = new ParkingSystemDBContext())
{
var vaga = db.Vaga.Include(v => v._VagaTipo);
return(vaga.ToList());
}
}
public void Create(Funcionario model)
{
using (var db = new ParkingSystemDBContext())
{
db.Funcionario.Add(model);
db.SaveChanges();
}
}
public void Destroy(Funcionario model)
{
using (var db = new ParkingSystemDBContext())
{
db.Entry(model).State = EntityState.Deleted;
db.SaveChanges();
}
}
public void Create(Cliente model)
{
using (var db = new ParkingSystemDBContext())
{
db.Cliente.Add(model);
db.SaveChanges();
}
}
public void Update(Funcionario model)
{
using (var db = new ParkingSystemDBContext())
{
db.Entry(model).State = EntityState.Modified;
db.SaveChanges();
}
}
public void Create(VagaTipo model)
{
using (var db = new ParkingSystemDBContext())
{
db.VagaTipo.Add(model);
db.SaveChanges();
}
}
public void Create(ComandaStatus model)
{
using (var db = new ParkingSystemDBContext())
{
db.ComandaStatus.Add(model);
db.SaveChanges();
}
}
public Funcionario GetByEmail(string email)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Funcionario
.Where(model => model.Email == email)
.FirstOrDefault());
}
}
public Vaga Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Vaga.Where(model => model.VagaID == id)
.Include(model => model._VagaTipo)
.FirstOrDefault());
}
}
public List <Veiculo> List()
{
using (var db = new ParkingSystemDBContext())
{
return(db.Veiculo
.Include(veiculo => veiculo._VeiculoTipo)
.Include(veiculo => veiculo._Cliente)
.ToList());
}
}
public Veiculo Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Veiculo.Where(model => model.VeiculoID == id)
.Include(model => model._VeiculoTipo)
.Include(model => model._Cliente)
.FirstOrDefault());
}
}
public List <Comanda> List()
{
using (var db = new ParkingSystemDBContext())
{
var comanda = db.Comanda
.Include(c => c._Cliente)
.Include(c => c._ComandaStatus)
.Include(c => c._Funcionario)
.Include(c => c._Servico)
.Include(c => c._Vaga)
.Include(c => c._Veiculo);
return(comanda.ToList());
}
}
public Comanda Show(int id)
{
using (var db = new ParkingSystemDBContext())
{
return(db.Comanda.Where(model => model.ComandaID == id)
.Include(model => model._Cliente)
.Include(model => model._ComandaStatus)
.Include(model => model._Funcionario)
.Include(model => model._Servico)
.Include(model => model._Vaga)
.Include(model => model._Veiculo)
.FirstOrDefault());
}
}
