public void DeleteExistingCustomer()
{
try
{
var customer = new GetAllCustomers();
customer.GetAllCustomersInfo();
Console.WriteLine("Choose Customer to delete by entering Customer Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getCustomer = new ReturnCustomer();
var customerToDelete = getCustomer.Return_Customer(userinput);
if (customerToDelete == null)
{
Console.WriteLine("No customer was found..");
Visuals.ReturnToMainMenu();
}
_bicycleRentalDbContext
.Customers
.Remove(customerToDelete);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine($"Existing customer with customer id: {customerToDelete.Customer_id} deleted successfully!");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
public void DeleteExistingBicycleBrand()
{
try
{
var bicycleBrand = new GetAllBicycleBrands();
bicycleBrand.GetAllBicycleBrandsInfo();
Console.WriteLine("Choose Bicycle Brand to delete by entering Brand Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getBicycleBrand = new ReturnBicycleBrand();
var bicycleBrandToDelete = getBicycleBrand.Return_BicycleBrand(userinput);
if (bicycleBrandToDelete == null)
{
Console.WriteLine("No Bicycle Brand was found..");
Visuals.ReturnToMainMenu();
}
_bicycleRentalDbContext
.Bicycle_brands
.Remove(bicycleBrandToDelete);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine($"Existing Bicycle brand with Brand id: {bicycleBrandToDelete.Brand_id} deleted successfully!");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
public void DeleteExistingCustomer()
{
try
{
var bookingDetails = new GetAllBookingDetails();
bookingDetails.GetAllBookingDetailsInfo();
Console.WriteLine("Choose booking detail to delete by entering Booking Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getBookingDetail = new ReturnBookingDetails();
var bookingDetailToDelete = getBookingDetail.Return_BookingDetail(userinput);
if (bookingDetailToDelete == null)
{
Console.WriteLine("No Booking Detail was found..");
Visuals.ReturnToMainMenu();
}
_bicycleRentalDbContext
.Booking_details
.Remove(bookingDetailToDelete);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine($"Existing booking details with booking id: {bookingDetailToDelete.Booking_id} deleted successfully!");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
/// <summary>
/// Add new bicycle
/// </summary>
public void AddNewBicycle()
{
try
{
Console.WriteLine("Frame_number");
var frameNumber = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Brand_id");
var brandId = Convert.ToInt32(Console.ReadLine());
var newBicycle = new Bicycle()
{
Frame_number = frameNumber,
Brand_id = brandId
};
_bicycleRentalDbContext.Bicycles
.Add(newBicycle);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("New Bicycle added successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Bicycle Frame Number: {newBicycle.Frame_number}");
Console.WriteLine($"Bicycle Brand Id: {newBicycle.Brand_id}");
Console.WriteLine("---------------------------------------");
Console.WriteLine("");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
public void UpdateExistingCustomer()
{
try
{
var customer = new GetAllCustomers();
customer.GetAllCustomersInfo();
Console.WriteLine("Choose Customer to update by entering Customer Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getCustomer = new ReturnCustomer();
var customerToUpdate = getCustomer.Return_Customer(userinput);
if (customerToUpdate == null)
{
Console.WriteLine("No customer was found..");
Visuals.ReturnToMainMenu();
}
Console.WriteLine("Change Customer information");
Console.WriteLine("");
Console.WriteLine("Update Customer_First_Name");
customerToUpdate.Customer_First_Name = Console.ReadLine();
Console.WriteLine("Update Customer_Last_Name");
customerToUpdate.Customer_Last_Name = Console.ReadLine();
Console.WriteLine("Update Gender");
customerToUpdate.Gender = Console.ReadLine();
Console.WriteLine("Phone_number");
customerToUpdate.Phone_number = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Update E_mail");
customerToUpdate.E_mail = Console.ReadLine();
_bicycleRentalDbContext
.Customers
.Update(customerToUpdate);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("Existing Customer updated successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Customer Customer_First_Name: {customerToUpdate.Customer_First_Name}");
Console.WriteLine($"Customer Customer_Last_Name: {customerToUpdate.Customer_Last_Name}");
Console.WriteLine($"Customer Gender: {customerToUpdate.Gender}");
Console.WriteLine($"Customer Phone_number: {customerToUpdate.Phone_number}");
Console.WriteLine($"Customer E_mail: {customerToUpdate.E_mail}");
Console.WriteLine("---------------------------------------");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
public void UpdateExistingBookingDetails()
{
try
{
var bookingDetail = new GetAllBookingDetails();
bookingDetail.GetAllBookingDetailsInfo();
Console.WriteLine("Choose Booking detail to update by entering Booking Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getBookingDetail = new ReturnBookingDetails();
var bookingDetailToUpdate = getBookingDetail.Return_BookingDetail(userinput);
if (bookingDetailToUpdate == null)
{
Console.WriteLine("No Booking Detail was found..");
Visuals.ReturnToMainMenu();
}
Console.WriteLine("Change Booking detail information");
Console.WriteLine("");
Console.WriteLine("Update Booking_date");
bookingDetailToUpdate.Booking_date = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("Update Return_due_date");
bookingDetailToUpdate.Return_due_date = Convert.ToDateTime(Console.ReadLine());
Console.WriteLine("Update Rental_price");
bookingDetailToUpdate.Rental_price = float.Parse(Console.ReadLine());
Console.WriteLine("Customer_id");
bookingDetailToUpdate.Customer_id = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Bicycle_id");
bookingDetailToUpdate.Bicycle_id = Convert.ToInt32(Console.ReadLine());
_bicycleRentalDbContext
.Booking_details
.Update(bookingDetailToUpdate);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("Existing Booking detail updated successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Customer Booking_date: {bookingDetailToUpdate.Booking_date}");
Console.WriteLine($"Customer Return_due_date: {bookingDetailToUpdate.Return_due_date}");
Console.WriteLine($"Customer Rental_price: {bookingDetailToUpdate.Rental_price}");
Console.WriteLine($"Customer Customer_id: {bookingDetailToUpdate.Customer_id}");
Console.WriteLine($"Customer Bicycle_id: {bookingDetailToUpdate.Bicycle_id}");
Console.WriteLine("---------------------------------------");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
public void UpdateExistingBicycleBrand()
{
try
{
var bicycleBrand = new GetAllBicycleBrands();
bicycleBrand.GetAllBicycleBrandsInfo();
Console.WriteLine("Choose bicycle brand to update by entering Bicycle Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getBicycleBrand = new ReturnBicycleBrand();
var bicycleBrandToUpdate = getBicycleBrand.Return_BicycleBrand(userinput);
if (bicycleBrandToUpdate == null)
{
Console.WriteLine("No Bicycle Brand was found..");
Visuals.ReturnToMainMenu();
}
Console.WriteLine("Change bicycle brand information");
Console.WriteLine("");
Console.WriteLine("Update Bicycle type");
bicycleBrandToUpdate.Bicycle_type = Console.ReadLine();
Console.WriteLine("Update Bicycle name");
bicycleBrandToUpdate.Bicycle_name = Console.ReadLine();
Console.WriteLine("Update Avilability");
bicycleBrandToUpdate.Avilability = Convert.ToBoolean(Console.ReadLine());
_bicycleRentalDbContext
.Bicycle_brands
.Update(bicycleBrandToUpdate);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("Existing bicicle brand: updated successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Bicycle brand Bicycle_type: {bicycleBrandToUpdate.Bicycle_type}");
Console.WriteLine($"Bicycle brand Bicycle_name: {bicycleBrandToUpdate.Bicycle_name}");
Console.WriteLine($"Bicycle brand Avilability: {bicycleBrandToUpdate.Avilability}");
Console.WriteLine("---------------------------------------");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
public void UpdateExistingBicycle()
{
try
{
var bicycle = new GetAllBicycles();
bicycle.GetAllBicyclesInfo();
Console.WriteLine("Choose bicycle to update by entering Bicycle Id: ");
var userinput = Convert.ToInt32(Console.ReadLine());
var getBicycle = new ReturnBicycle();
var bicycleToUpdate = getBicycle.Return_Bicycle(userinput);
if (bicycleToUpdate == null)
{
Console.WriteLine("No bicycle was found..");
Visuals.ReturnToMainMenu();
}
Console.WriteLine("Change bicycle information");
Console.WriteLine("");
Console.WriteLine("Update Frame number");
bicycleToUpdate.Frame_number = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Update Brand id");
bicycleToUpdate.Brand_id = Convert.ToInt32(Console.ReadLine());
_bicycleRentalDbContext
.Bicycles
.Update(bicycleToUpdate);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("Existing bicicle updated successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Bicycle Bicycle_id: {bicycleToUpdate.Bicycle_id}");
Console.WriteLine($"Bicycle Frame_number: {bicycleToUpdate.Frame_number}");
Console.WriteLine($"Bicycle Brand_id: {bicycleToUpdate.Brand_id}");
Console.WriteLine("---------------------------------------");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
/// <summary>
/// Add new Customer
/// </summary>
public void AddNewCustomer()
{
try
{
Console.WriteLine("Customer_First_Name");
var customerFirstName = Console.ReadLine();
Console.WriteLine("Customer_Last_Name");
var customerLastName = Console.ReadLine();
Console.WriteLine("Gender");
var gender = Console.ReadLine();
Console.WriteLine("Phone_number");
var phoneNumber = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("E_mail");
var eMail = Console.ReadLine();
var newCustomer = new Customer()
{
Customer_First_Name = customerFirstName,
Customer_Last_Name = customerLastName,
Gender = gender,
Phone_number = phoneNumber,
E_mail = eMail
};
_bicycleRentalDbContext.Customers
.Add(newCustomer);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("New customer added successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Customer_id: {newCustomer.Customer_id}");
Console.WriteLine($"Customer_First_Name: {newCustomer.Customer_First_Name}");
Console.WriteLine($"Customer_Last_Name: {newCustomer.Customer_Last_Name}");
Console.WriteLine($"Gender: {newCustomer.Gender}");
Console.WriteLine($"Phone_number: {newCustomer.Phone_number}");
Console.WriteLine($"E_mail: {newCustomer.E_mail}");
Console.WriteLine("---------------------------------------");
Console.WriteLine("");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
/// <summary>
/// Add new Booking Details
/// </summary>
public void AddNewBooking_detail()
{
try
{
Console.WriteLine("Return_due_date");
var returnDueDate = DateTime.Parse(Console.ReadLine());
Console.WriteLine("Rental_price");
var rentalPrice = float.Parse(Console.ReadLine());
Console.WriteLine("Customer_id");
var customerId = Convert.ToInt32(Console.ReadLine());
Console.WriteLine("Bicycle_id");
var bicycleId = Convert.ToInt32(Console.ReadLine());
var newBookingDetail = new Booking_detail()
{
Booking_date = DateTime.Now,
Return_due_date = returnDueDate,
Rental_price = rentalPrice,
Customer_id = customerId,
Bicycle_id = bicycleId
};
_bicycleRentalDbContext.Booking_details
.Add(newBookingDetail);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("New booking detail added successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Return_due_date: {newBookingDetail.Return_due_date.ToShortDateString()}");
Console.WriteLine($"Rental_price: {newBookingDetail.Rental_price}");
Console.WriteLine($"Customer_id: {newBookingDetail.Customer_id}");
Console.WriteLine($"Bicycle_id: {newBookingDetail.Bicycle_id}");
Console.WriteLine("---------------------------------------");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
/// <summary>
/// Add new bicycle Brand
/// </summary>
public void AddNewBicycleBrand()
{
try
{
Console.WriteLine("Bicycle_type");
var bicycleType = Console.ReadLine();
Console.WriteLine("Bicycle_name");
var bicycleName = Console.ReadLine();
Console.WriteLine("Avilability");
var avilability = Convert.ToBoolean(Console.ReadLine());
var newBicycleBrand = new Bicycle_brand()
{
Bicycle_type = bicycleType,
Bicycle_name = bicycleName,
Avilability = avilability
};
_bicycleRentalDbContext.Bicycle_brands
.Add(newBicycleBrand);
_bicycleRentalDbContext
.SaveChanges();
Console.WriteLine("New Bicycle Brand added successfully!");
Console.WriteLine("");
Console.WriteLine("---------------------------------------");
Console.WriteLine($"Bicycle_type: {newBicycleBrand.Bicycle_type}");
Console.WriteLine($"Bicycle_name: {newBicycleBrand.Bicycle_name}");
Console.WriteLine($"Avilability: {newBicycleBrand.Avilability}");
Console.WriteLine("---------------------------------------");
}
catch (Exception ex)
{
Console.WriteLine($"You messed up! {ex}");
}
}
/// <summary>
/// Seeds data when used
/// </summary>
public void StartUpData()
{
var customer = new Customer {
Customer_First_Name = "Alexander", Customer_Last_Name = "Haglund", Gender = "Male", Phone_number = 9009111, E_mail = "*****@*****.**"
};
var customer1 = new Customer {
Customer_First_Name = "Mel", Customer_Last_Name = "Gibson", Gender = "Male", Phone_number = 7010202, E_mail = "*****@*****.**"
};
var customer2 = new Customer {
Customer_First_Name = "Miriam", Customer_Last_Name = "Bryant", Gender = "Female", Phone_number = 1032111, E_mail = "*****@*****.**"
};
var customer3 = new Customer {
Customer_First_Name = "Tobias", Customer_Last_Name = "Nilsson", Gender = "Male", Phone_number = 1212120, E_mail = "*****@*****.**"
};
var customer4 = new Customer {
Customer_First_Name = "Elin", Customer_Last_Name = "Rosblad", Gender = "Female", Phone_number = 2024111, E_mail = "*****@*****.**"
};
var customer5 = new Customer {
Customer_First_Name = "Maria", Customer_Last_Name = "Bergsten", Gender = "Female", Phone_number = 1122334, E_mail = "*****@*****.**"
};
var bicycleBrand = new Bicycle_brand {
Bicycle_type = "BMX", Bicycle_name = "Tricky Ramp Bike", Avilability = true
};
var bicycleBrand1 = new Bicycle_brand {
Bicycle_type = "Mountain Bike", Bicycle_name = "Down Hill 2000", Avilability = true
};
var bicycleBrand2 = new Bicycle_brand {
Bicycle_type = "Road bike", Bicycle_name = "Smooth Rider", Avilability = true
};
var bicycleBrand3 = new Bicycle_brand {
Bicycle_type = "Folding bikes", Bicycle_name = "Smart Bike", Avilability = true
};
var bicycle = new Bicycle {
Frame_number = 1313, Brand_id = 1
};
var bicycle1 = new Bicycle {
Frame_number = 2121, Brand_id = 1
};
var bicycle2 = new Bicycle {
Frame_number = 1111, Brand_id = 1
};
var bicycle3 = new Bicycle {
Frame_number = 3131, Brand_id = 2
};
var bicycle4 = new Bicycle {
Frame_number = 6262, Brand_id = 2
};
var bicycle5 = new Bicycle {
Frame_number = 5757, Brand_id = 3
};
var bicycle6 = new Bicycle {
Frame_number = 7811, Brand_id = 3
};
var bicycle7 = new Bicycle {
Frame_number = 1100, Brand_id = 4
};
var bicycle8 = new Bicycle {
Frame_number = 8811, Brand_id = 4
};
var bookingDetail = new Booking_detail {
Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(12), Rental_price = 1200, Customer_id = 1, Bicycle_id = 2
};
var bookingDetail1 = new Booking_detail {
Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(10), Rental_price = 999, Customer_id = 2, Bicycle_id = 1
};
var bookingDetail2 = new Booking_detail {
Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(20), Rental_price = 2000, Customer_id = 3, Bicycle_id = 3
};
var bookingDetail3 = new Booking_detail {
Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(5), Rental_price = 79, Customer_id = 4, Bicycle_id = 2
};
var bookingDetail4 = new Booking_detail {
Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(8), Rental_price = 88, Customer_id = 5, Bicycle_id = 4
};
var bookingDetail5 = new Booking_detail {
Booking_date = DateTime.Now, Return_due_date = DateTime.Now.AddDays(4), Rental_price = 49, Customer_id = 6, Bicycle_id = 4
};
var databaseOwner = new DatabaseOwner {
OwnersFirstName = "Pontus", OwnersLastName = "Haglund"
};
_bicycleRentalDbContext.Customers.Add(customer);
_bicycleRentalDbContext.Customers.Add(customer1);
_bicycleRentalDbContext.Customers.Add(customer2);
_bicycleRentalDbContext.Customers.Add(customer3);
_bicycleRentalDbContext.Customers.Add(customer4);
_bicycleRentalDbContext.Customers.Add(customer5);
_bicycleRentalDbContext.SaveChanges();
_bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand);
_bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand1);
_bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand2);
_bicycleRentalDbContext.Bicycle_brands.Add(bicycleBrand3);
_bicycleRentalDbContext.SaveChanges();
_bicycleRentalDbContext.Bicycles.Add(bicycle);
_bicycleRentalDbContext.Bicycles.Add(bicycle1);
_bicycleRentalDbContext.Bicycles.Add(bicycle2);
_bicycleRentalDbContext.Bicycles.Add(bicycle3);
_bicycleRentalDbContext.Bicycles.Add(bicycle4);
_bicycleRentalDbContext.Bicycles.Add(bicycle5);
_bicycleRentalDbContext.Bicycles.Add(bicycle6);
_bicycleRentalDbContext.Bicycles.Add(bicycle7);
_bicycleRentalDbContext.Bicycles.Add(bicycle8);
_bicycleRentalDbContext.SaveChanges();
_bicycleRentalDbContext.Booking_details.Add(bookingDetail);
_bicycleRentalDbContext.Booking_details.Add(bookingDetail1);
_bicycleRentalDbContext.Booking_details.Add(bookingDetail2);
_bicycleRentalDbContext.Booking_details.Add(bookingDetail3);
_bicycleRentalDbContext.Booking_details.Add(bookingDetail4);
_bicycleRentalDbContext.Booking_details.Add(bookingDetail5);
_bicycleRentalDbContext.SaveChanges();
_bicycleRentalDbContext.DatabaseOwners.Add(databaseOwner);
_bicycleRentalDbContext.SaveChanges();
Console.WriteLine("Database filled with information successfully");
}