public EditarTipoCombustible(int TipoCombustibleID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarTipo(TipoCombustibleID);
}
public List <CategoriaVehiculos> ObtenerTodos()
{
using (var db = new RentCarContext())
{
return(db.CatVehiculos.ToList());
}
}
public NuevoCliente()
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarTiposPersona();
}
public List <Clientes> ObtenerTodos()
{
using (var db = new RentCarContext())
{
return(db.Clientes.ToList());
}
}
public List <Empresa> ObtenerTodos()
{
using (var db = new RentCarContext())
{
return(db.Empresa.ToList());
}
}
public List <Marcas> ObtenerTodos()
{
using (var db = new RentCarContext())
{
return(db.MarcasVehiculos.ToList());
}
}
public EditarTipoVehiculo(int TipoVehiculoID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarTipo(TipoVehiculoID);
}
public EditarMarca(int MarcaID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarMarca(MarcaID);
}
public EditarEmpleado(int EmpleadoID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarTandas();
CargarEmpleado(EmpleadoID);
}
public List <Sucursales> ObtenerTodos()
{
using (var db = new RentCarContext())
{
return(db.Sucursales.ToList());
}
}
internal void Crear(Clientes model)
{
using (var db = new RentCarContext())
{
db.Clientes.Add(model);
db.SaveChanges();
}
}
internal void Crear(Empresa model)
{
using (var db = new RentCarContext())
{
db.Empresa.Add(model);
db.SaveChanges();
}
}
public ClientesMain()
{
RentaDto ds = new RentaDto();
dbContext = RentCarContext.Create();
InitializeComponent();
Display();
}
internal void Crear(Marcas model)
{
using (var db = new RentCarContext())
{
db.MarcasVehiculos.Add(model);
db.SaveChanges();
}
}
internal void Crear(CategoriaVehiculos model)
{
using (var db = new RentCarContext())
{
db.CatVehiculos.Add(model);
db.SaveChanges();
}
}
public EditarCliente(int ClienteID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarTiposPersona();
CargarCliente(ClienteID);
}
public ReportesMain()
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarTiposVehiculo();
CargarClientes();
CargarEmpleados();
LoadReport();
}
public IResult Delete(Brand brand)
{
using (RentCarContext context = new RentCarContext())
{
_brandDal.Delete(brand);
return(new SuccessResult(Messages.BrandDeleted));
//Console.WriteLine("marka silindi");
}
}
public IResult Update(Brand brand)
{
using (RentCarContext context = new RentCarContext())
{
_brandDal.Update(brand);
return(new SuccessResult(Messages.BrandUpdted));
//Console.WriteLine("marka güncellendi");
}
}
public IResult Add(Brand brand)
{
using (RentCarContext context = new RentCarContext())
{
context.Brands.Add(brand);
return(new SuccessResult(Messages.BrandAdded));
//Console.WriteLine( "marka eklendi");
}
}
public UnitOfWork(RentCarContext context)
{
this.context = context;
Users = new UserRepository(this.context);
CarCategories = new CarCategoryRepository(this.context);
CarModels = new CarModelRepository(this.context);
Cars = new CarRepository(this.context);
Parts = new PartRepository(this.context);
Orders = new OrderRepository(this.context);
}
public NuevoVehiculo()
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarMarcas();
CargarModelos();
CargarTiposVehiculo();
CargarTiposCombustible();
}
public EditarVehiculo(int VehiculoID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarEstados();
CargarMarcas();
CargarModelos();
CargarTiposVehiculo();
CargarTiposCombustible();
CargarVehiculo(VehiculoID);
}
public NuevaDevolucion(int RentaID)
{
dbContext = RentCarContext.Create();
InitializeComponent();
Devolucion = dbContext.Rentas_Devoluciones
.Include(r => r.Estado)
.Include(r => r.Cliente)
.Include(r => r.Vehiculo)
/*.Include(r => r.Inspeccion)*/
.Include(r => r.Empleado)
.AsNoTracking()
.FirstOrDefault(r => r.ID == RentaID);
ValidarRentado();
Display();
}
static void Main(string[] args)
{
// CarManager carManager = new CarManager(new InMemoryCarDal());
// foreach (var car in carManager.GetAll())
// {
// System.Console.WriteLine(car.Description);
// }
using (var rentCarContext = new RentCarContext())
{
foreach (var rent in rentCarContext.Cars)
{
System.Console.WriteLine(rent.CarId);
}
}
}
static void Main(string[] args)
{
RentCarContext dbContext = new RentCarContext(
new DbContextOptionsBuilder <RentCarContext>()
.UseSqlServer(new SqlConnection("server=localhost; database=RentCar;Trusted_Connection=True;")).Options
);
CarManager carManager = new(
new EfCarDal(dbContext), new BrandManager(new EfBrandDal(dbContext)), new ColorManager(new EfColorDal(dbContext))
);
IResult carResult = carManager.Add(new Car {
BrandId = 1, ColorId = 1, DailyPrice = 5, Name = "asdas"
}).Result;
Console.ReadLine();
}
// GET: Vehiculos/Create
public ActionResult Create()
{
List <Marcas> lMarcas = new List <Marcas>();
using (var db = new RentCarContext())
{
lMarcas = db.MarcasVehiculos.ToList();
ViewBag.listaMarcas = lMarcas;
}
List <CategoriaVehiculos> lCatVehiculos = new List <CategoriaVehiculos>();
using (var db = new RentCarContext())
{
lCatVehiculos = db.CatVehiculos.ToList();
ViewBag.listaCatVehiculos = lCatVehiculos;
}
return(View());
}
public NuevaInspeccion(int?clienteID = null, int?vehiculoID = null, int?empleadoID = null)
{
dbContext = RentCarContext.Create();
InitializeComponent();
CargarCombustibles();
if (clienteID != null)
{
this.Cliente = dbContext.Clientes.FirstOrDefault(c => c.ID == clienteID.Value);
txtCliente.Text = $"{Cliente.ID} - {Cliente.Nombre}";
}
if (vehiculoID != null)
{
this.Vehiculo = dbContext.Vehiculos.FirstOrDefault(v => v.ID == vehiculoID.Value);
txtVehiculo.Text = $"{Vehiculo.Marca} {Vehiculo.Modelo} ({Vehiculo.NumPlaca})";
}
if (empleadoID != null)
{
this.Empleado = dbContext.Empleados.FirstOrDefault(e => e.ID == empleadoID.Value);
txtEmpleado.Text = $"{Empleado.ID} - {Empleado.Nombre} {Empleado.Apellido}";
}
}
public TiposCombustibleMain()
{
dbContext = RentCarContext.Create();
InitializeComponent();
Display();
}
public TiposDeVehiculo()
{
dbContext = RentCarContext.Create();
InitializeComponent();
Display();
}
