public async Task <IActionResult> Create([Bind("FuelID,Kilometres,Burned_fuel,Price,Date,GasStation,CarID")] Fuel fuel)
{
if (ModelState.IsValid)
{
_context.Add(fuel);
await _context.SaveChangesAsync();
}
return(RedirectToAction("Details", "Cars", new { id = fuel.CarID }));
}
// POST /api/cars
public HttpResponseMessage PostCar(Car car) {
var createdCar = _carsCtx.Add(car);
var response = Request.CreateResponse(HttpStatusCode.Created, createdCar);
response.Headers.Location = new Uri(
Url.Link("DefaultHttpRoute", new { id = createdCar.Id }));
return response;
}
public Car Post([FromBody] Car value)
{
if (ModelState.IsValid)
{
_context.Add(value);
_context.SaveChanges();
return(_context.Cars.Find(value.Id));
}
return(null);
}
public async Task <IActionResult> Create([Bind("CarsId,CarModel,CarName,CarType,CarYear")] Cars cars)
{
if (ModelState.IsValid)
{
_context.Add(cars);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(cars));
}
public async Task <IActionResult> Create([Bind("CarroId,Marca,DataCompra,Descricao,Cor")] Carro carro)
{
if (ModelState.IsValid)
{
_context.Add(carro);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(carro));
}
public async Task <IActionResult> Create([Bind("AcessorioId,Nome")] Acessorio acessorio)
{
if (ModelState.IsValid)
{
_context.Add(acessorio);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(acessorio));
}
public async Task <IActionResult> Create([Bind("CarID,Brand,Model,Year,Vin")] Car car)
{
if (ModelState.IsValid)
{
_context.Add(car);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(car));
}
public async Task <IActionResult> Create([Bind("Id,Title,ReleaseDate,Price,Weight")] Car car)
{
if (ModelState.IsValid)
{
_context.Add(car);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(car));
}
public async Task <IActionResult> Create([Bind("PartID,Name,Producer,ChangeID")] Part part)
{
if (ModelState.IsValid)
{
_context.Add(part);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["ChangeID"] = new SelectList(_context.Changes, "ChangeID", "ChangeID", part.ChangeID);
return(View(part));
}
public async Task <IActionResult> Create([Bind("TireID,Type,SpeedIndx,WeightIndx,Production_date_dot,Brand,Description,CarID")] Tire tire)
{
if (ModelState.IsValid)
{
_context.Add(tire);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
ViewData["CarID"] = new SelectList(_context.Cars, "CarID", "Brand", tire.CarID);
return(View(tire));
}
public async Task <IActionResult> Create([Bind("ChangeID,Milage,Date,Parts_prize,Work_prize,Description,CarID")] Change change)
{
if (ModelState.IsValid)
{
_context.Add(change);
await _context.SaveChangesAsync();
return(RedirectToAction("Details", "Cars", new { id = change.CarID }));
}
ViewData["CarID"] = new SelectList(_context.Cars, "CarID", "Brand", change.CarID);
return(View(change));
}
public async Task <IActionResult> AddOrEdit([Bind("Id,Model,Power,Description,Prize,Version,Name")] Car car)
{
if (ModelState.IsValid)
{
if (car.Id == 0)
{
_context.Add(car);
}
else
{
_context.Update(car);
}
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(car));
}
public async Task <IActionResult> Create(
[Bind("Manufacture,Model,Engine,ProductionDate")] Car car)
{
try
{
if (ModelState.IsValid)
{
_context.Add(car);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
}
catch (DbUpdateException /* ex */)
{
//Log the error (uncomment ex variable name and write a log.
ModelState.AddModelError("", "Unable to save changes. " +
"Try again, and if the problem persists " +
"see your system administrator.");
}
return(View(car));
}
public HttpResponseMessage PostCar(Car car)
{
_carsContext.Add(car);
return(new HttpResponseMessage(HttpStatusCode.Created));
}
public void Add(Car car)
{
_context.Add(car);
}
public void AppointmentAdded(CarScheduling appointment)
{
db.Add(appointment);
db.SaveChanges();
Refresh();
}
static void Main(string[] args)
{
// Step 1: Install dotnet-ef if it isn't:
// dotnet tool install --global dotnet-ef
// Step 2: Install the packages in the project:
// dotnet add package Microsoft.EntityFrameworkCore.Design
// dotnet add package Pomelo.EntityFrameworkCore.MySql
// Step 3: Create the models and context:
// dotnet ef dbcontext scaffold "server=localhost;port=3306;user=root;password=;database=DB_NAME" Pomelo.EntityFrameworkCore.MySql -c CONTEXT_NAME -o Models -f -d
// Step 4: Pluralize the property names in the context file.
// Step 5: Pluralize the virtual ICollections in the table classes (and their InverseProperty's).
// Step 6 (optional): Rename any instances of "Id" to "ID".
// Initialize our database interaction (the context):
using (CarsContext context = new CarsContext())
{
Console.WriteLine(context.Cars.Count(x => x.Manufacturer.Name == "BMW"));
Console.WriteLine(context.Cars.Count(x => x.Manufacturer.Name == "Mitsubishi"));
// Adding data to database...
string make, model, colour;
Console.WriteLine(context.Cars.Count(x => x.Manufacturer.Name == "Mitsubishi"));
Console.Write("Please enter a Make for your new car: ");
make = Console.ReadLine();
Console.Write("Please enter a Model for your new car: ");
model = Console.ReadLine();
Console.Write("Please enter a Colour for your new car: ");
colour = Console.ReadLine();
context.Add(new Car()
{
Manufacturer = context.Manufacturers.Where(x => x.Name == make).SingleOrDefault(),
Model = model,
Colour = colour
});
// Update Data to database..
string model1, colour1;
Console.Write("Please enter a model to change the colour: ");
model1 = Console.ReadLine();
Console.Write("Please enter the new colour: ");
colour1 = Console.ReadLine();
context.Cars.Where(x => x.Model == model1).SingleOrDefault().Colour = colour1;
// Removing Data from Database..
string model2;
Console.Write("Please enter a model to remove: ");
model2 = Console.ReadLine();
context.Cars.Remove(context.Cars.Where(x => x.Model == model2).SingleOrDefault());
context.SaveChanges();
}
}
