internal void BookCar(CreateBookingVM createBooking)
{
Customer customer = new Customer();
if (carRentalContext.Customer.Any(c => c.CustomerSsn == createBooking.SSN))
{
Customer existingCustomer = carRentalContext.Customer.Single(c => c.CustomerSsn == createBooking.SSN);
customer = existingCustomer;
}
else
{
Customer newCustomer = new Customer
{
CustomerSsn = createBooking.SSN
};
carRentalContext.Customer.Add(newCustomer);
carRentalContext.SaveChanges();
customer = newCustomer;
}
Booking booking = new Booking
{
RentedCar = carRentalContext.Car.Single(c => c.CarRegistrationNumber == createBooking.RegistrationNumber).Id,
CustomerId = customer.Id,
};
carRentalContext.Car.SingleOrDefault(c => c.Id == booking.RentedCar).RentalStart = createBooking.StartOfRental;
carRentalContext.Booking.Add(booking);
carRentalContext.SaveChanges();
}
public IActionResult Post([FromBody] Order order)
{
if (ModelState.IsValid)
{
db.Orders.Add(order);
db.SaveChanges();
return(Ok(order));
}
return(BadRequest(ModelState));
}
protected CarRental ReturnRental(string bookingNumber, decimal milageAtReturn)
{
using (var db = new CarRentalContext())
{
CarRental rental = FirstOrDefaultCarRental(bookingNumber, db);
if (rental == null)
{
throw new Exception("no such rental: " + bookingNumber);
}
if (rental.CarMilageAtRentInKm > milageAtReturn)
{
throw new Exception("Milage is lower at return than at rent time. Customer may be cheating");
}
rental.CarMilageAtReturnInKm = milageAtReturn;
rental.Returned = _dateTimeProvider.GetUtcNow();
if (rental.Returned < rental.Rented)
{
throw new Exception("Returned before it was rented");
}
db.SaveChanges();
return(rental);
}
}
static void Update()
{
using (var db = new CarRentalContext())
{
Console.WriteLine("Wyszukaj Rejstrację do Zmiany Położenia Samochodu");
string place = Console.ReadLine();
Car car = db.Cars.Where(x => x.RegistrationNumber == place).FirstOrDefault();
if (car != null)
{
Console.WriteLine("Wprowadz Xpostion");
double x = Convert.ToDouble(Console.ReadLine());
car.XPosition = x;
Console.WriteLine("Wprowadz Ypostion");
double y = Convert.ToDouble(Console.ReadLine());
car.YPosition = x;
db.SaveChanges();
}
else
{
Console.WriteLine("Nie odnaleziono samochodu o tym numerze rejstracyjnym");
}
}
return;
}
public async override Task FillTestDataAsync()
{
List <Company> Companies = new List <Company>();
Companies.Add(new Company()
{
Name = "Vueling Airlines", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
Companies.Add(new Company()
{
Name = "Blizzard", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
Companies.Add(new Company()
{
Name = "Riot Games", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
Companies.Add(new Company()
{
Name = "King", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
Companies.Add(new Company()
{
Name = "ToySRUs", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
Companies.Add(new Company()
{
Name = "Decathlon", CreatedDate = DateTime.Now, UpdatedDate = DateTime.Now
});
DeleteAll();
Companies.ForEach(async x => await InsertAsync(x));
_context.SaveChanges();
}
public void Delete(Car car)
{
using (CarRentalContext context = new CarRentalContext())
{
var deletedEntity = context.Entry(car);
deletedEntity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Update(User user)
{
using (var context = new CarRentalContext())
{
var updateUser = context.User.Single(u => u.Id == user.Id);
updateUser = Convert.ToDataModel(user);
context.SaveChanges();
}
}
public void Add(User user)
{
using (var context = new CarRentalContext())
{
var newUser = Convert.ToDataModel(user);
context.User.Add(newUser);
context.SaveChanges();
}
}
public void Add(Maintenance maint)
{
using (var context = new CarRentalContext())
{
var newMaint = Convert.ToDataModel(maint);
context.Maintenance.Add(newMaint);
context.SaveChanges();
}
}
public void Update(Car car)
{
using (CarRentalContext context = new CarRentalContext())
{
var updatedEntity = context.Entry(car);
updatedEntity.State = EntityState.Modified;
context.SaveChanges();
}
}
public void Update(Maintenance maint)
{
using (var context = new CarRentalContext())
{
var updateMaint = context.Maintenance.Single(m => m.Id == maint.Id);
updateMaint = Convert.ToDataModel(maint);
context.SaveChanges();
}
}
public void Add(Vehicle vehicle)
{
using (var context = new CarRentalContext())
{
var newVehicle = Convert.ToDataModel(vehicle);
context.Vehicle.Add(newVehicle);
context.SaveChanges();
}
}
public void Add(Car car)
{
using (CarRentalContext context = new CarRentalContext())
{
var addedEntity = context.Entry(car);
addedEntity.State = EntityState.Added;
context.SaveChanges();
}
}
public void Update(Vehicle vehicle)
{
using (var context = new CarRentalContext())
{
var updateVehicle = context.Vehicle.Single(v => v.Id == vehicle.Id);
updateVehicle = Convert.ToDataModel(vehicle);
context.SaveChanges();
}
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new CarRentalContext(
serviceProvider.GetRequiredService <
DbContextOptions <CarRentalContext> >()))
{
// Look for any cars.
if (context.Car.Any())
{
return; // DB has been seeded
}
context.Car.AddRange(
new Car
{
Model = "Sedan",
ImageSrc = "https://c4.wallpaperflare.com/wallpaper/413/595/829/2014-audi-a8-l-w12-exclusive-concept-blue-audi-sedan-wallpaper-preview.jpg",
Doors = 4,
seats = 5,
automatic = false,
Price = 99.99m
},
new Car
{
Model = "HatchBack",
ImageSrc = "https://c4.wallpaperflare.com/wallpaper/832/475/785/audi-rs4-side-view-black-wallpaper-preview.jpg",
Doors = 3,
seats = 4,
automatic = true,
Price = 64.95m
},
new Car
{
Model = "SUV",
ImageSrc = "https://pxhere.com/en/photo/1447497",
Doors = 5,
seats = 7,
automatic = false,
Price = 120m
},
new Car
{
Model = "Van",
ImageSrc = "https://cdn.pixabay.com/photo/2017/01/23/10/54/van-2002079_960_720.png",
Doors = 4,
seats = 2,
automatic = false,
Price = 120m
}
);
context.SaveChanges();
}
}
public void AddCustomer(CustomerDetailsDto customerDetailsDto)
{
var customer = Mapper.Map <CustomerDetails>(customerDetailsDto);
using (var context = new CarRentalContext())
{
context.Customers.Add(customer);
context.SaveChanges();
}
}
public void AddRental(RentalDto rentalDto)
{
var rental = Mapper.Map <Rental>(rentalDto);
using (var context = new CarRentalContext())
{
context.Rentals.Add(rental);
context.SaveChanges();
}
}
public void UpdateCustomer(CustomerDetailsDto customerDetailsDto)
{
var customer = Mapper.Map <CustomerDetails>(customerDetailsDto);
using (var context = new CarRentalContext())
{
context.Customers.Attach(customer);
context.Entry(customer).State = EntityState.Modified;
context.SaveChanges();
}
}
public User Remove(int id)
{
using (var context = new CarRentalContext())
{
var user = context.User.Single(u => u.Id == id);
user.UserType = (int)Enums.UserTypes.Noone;
context.SaveChanges();
return(Convert.FromDataModel(user));
}
}
protected string CreateAndSaveACarRental(string carCategory, string customerSocialSecurityNumber, decimal currentMilage)
{
using (var db = new CarRentalContext())
{
var rental = new CarRental()
{
CarCategory = carCategory,
CustomerSocialSecurityNumber = customerSocialSecurityNumber,
CarMilageAtRentInKm = currentMilage,
Rented = _dateTimeProvider.GetUtcNow()
};
db.Add(rental);
db.SaveChanges();
rental.BookingNumber = "BN" + rental.Id; //No real req. here, just it made up for now
db.SaveChanges();
return(rental.BookingNumber);
}
}
public Vehicle Remove(int id)
{
using (var context = new CarRentalContext())
{
var vehicle = context.Vehicle.Single(v => v.Id == id);
vehicle.Removed = true;
context.SaveChanges();
return(Convert.FromDataModel(vehicle));
}
}
public Maintenance Remove(int id)
{
using (var context = new CarRentalContext())
{
var maint = context.Maintenance.Single(m => m.Id == id);
maint.Completed = true;
context.SaveChanges();
return(Convert.FromDataModel(maint));
}
}
public ActionResult Rent()
{
string status = String.Empty;
try {
Rental r = new Rental();
r.PickupDate = DateTime.ParseExact(Request.Form["pickupDate"], "dd/MM/yyyy", CultureInfo.InvariantCulture);
r.ReturnDate = DateTime.ParseExact(Request.Form["returnDate"], "dd/MM/yyyy", CultureInfo.InvariantCulture);
r.CarID = int.Parse(Request.Form["CarID"]);
r.DriverAge = 21;
r.UserID = int.Parse(Request.Form["UserID"]);
dbContext.Rental.Add(r);
dbContext.SaveChanges();
status = "success";
}
catch (Exception ex)
{
status = "failure";
}
return(Content(status, "application/json"));
}
public ActionResult AddManufacture(Manufacture m)
{
try
{
Manufacture temp = dbContext.Manufacture.Where(x => x.Name.Contains(m.Name)).FirstOrDefault();
if (temp == null)
{
dbContext.Manufacture.Add(m);
dbContext.SaveChanges();
}
}
catch (Exception ex)
{
RedirectToAction("Index", "Home");
}
return(View());
}
static void Delete()
{
using (var db = new CarRentalContext())
{
Console.WriteLine("Wyszukaj Rejstrację do Zmiany Położenia Samochodu");
string place = Console.ReadLine();
Car car = db.Cars.Where(x => x.RegistrationNumber == place).FirstOrDefault();
if (car != null)
{
db.Cars.Remove(car);
db.SaveChanges();
}
else
{
Console.WriteLine("Nie odnaleziono samochodu o tym numerze rejstracyjnym");
}
}
return;
}
public async override Task FillTestDataAsync()
{
_fleet.Add(new Car()
{
Registration = "ESP-1234", Brand = Brand.Tesla, Model = "model 3", Type = CarType.Convertible
});
_fleet.Add(new Car()
{
Registration = "ASD-1234", Brand = Brand.Renault, Model = "Megane Sport", Type = CarType.Convertible
});
_fleet.Add(new Car()
{
Registration = "EFA-1234", Brand = Brand.Ford, Model = "Kuga", Type = CarType.MiniVan
});
_fleet.Add(new Car()
{
Registration = "GFE-1234", Brand = Brand.Renault, Model = "Scenic", Type = CarType.MiniVan
});
_fleet.Add(new Car()
{
Registration = "SDE-1234", Brand = Brand.Renault, Model = "Megane F", Type = CarType.Convertible
});
_fleet.Add(new Car()
{
Registration = "ASD-1234", Brand = Brand.Tesla, Model = "model S", Type = CarType.SUV
});
_fleet.Add(new Car()
{
Registration = "FAS-1234", Brand = Brand.Ferrari, Model = "Imprezza", Type = CarType.SUV
});
_fleet.Add(new Car()
{
Registration = "FEW-1234", Brand = Brand.Audi, Model = "A4 Sport", Type = CarType.Convertible
});
_fleet.Add(new Car()
{
Registration = "FES-1234", Brand = Brand.Audi, Model = "A4", Type = CarType.SUV
});
DeleteAll();
_fleet.ForEach(async x => await InsertAsync(x));
_context.SaveChanges();
}
public void AddCustomer(Customer customer)
{
inputUserData.Customers.Add(customer);
inputUserData.SaveChanges();
}
public bool Save()
{
return(_context.SaveChanges() >= 0);
}
//using (var context = new CarRentalContext())
//{
// ManyToManyRelationship(context);
//}
private static void ManyToManyRelationship(CarRentalContext context)
{
var car1 = new Car
{
BrandId = 1,
ColorId = 1,
CarTypeId = 1,
Model = "Focus",
Capacity = 4,
ModelYear = "2018",
DailyPrice = 150,
};
var car2 = new Car
{
Model = "Fiesta",
ModelYear = "2012",
ColorId = 1,
BrandId = 1,
CarTypeId = 1,
Capacity = 4,
DailyPrice = 100,
};
context.AddRange(
//new Brand
//{
// Name = "Ford"
//},
//new Color
//{
// Name = "Siyah"
//},
//new CarType
//{
// Name = "Hatchback"
//},
//new Department
//{
// Name = "Satış"
//},
//new Employee
//{
// IdentityNo = "23456789101",
// FirstName = "Ahmet",
// LastName = "Çalışkan",
// Gender = 'M',
// DOB = Convert.ToDateTime("12/24/1987"),
// Address = "İzmir",
// PhoneNumber = "05554443322",
// Email = "*****@*****.**",
// PasswordHash = "23456",
// DepartmentId = 1,
// Position = "Satis Temsilcisi",
// JoinDate = DateTime.Now
//},
//new IndividualCustomer
//{
// IdentityNo = "12345678910",
// FirstName = "Ali",
// LastName = "Yaman",
// DOB = Convert.ToDateTime("10/10/1990"),
// PhoneNumber = "05556667788",
// Address = "İzmir",
// Email = "*****@*****.**",
// PasswordHash = "12345",
// JoinDate = DateTime.Now
//},
new Rental
{
CustomerId = 2,
EmployeeId = 1,
RentDate = DateTime.Now,
TotalPrice = 100,
Discount = 0
},
new Rental
{
CustomerId = 2,
EmployeeId = 1,
RentDate = DateTime.Now,
});
context.SaveChanges();
}
public void AddCar(Car car)
{
inputUserData.Cars.Add(car);
inputUserData.SaveChanges();
}