public IHttpActionResult PutCar([FromUri] int id, [FromBody] Car car) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != car.CarId) { return(BadRequest()); } _db.Entry(car).State = EntityState.Modified; try { _db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CarExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public bool CreateCar(Car car) { if (!string.IsNullOrWhiteSpace(car.ModelName) || !string.IsNullOrWhiteSpace(car.Marke) || !string.IsNullOrWhiteSpace(car.Color) || car.ProductionYear > 2000 || car.ProductionYear <= Year) { var newCar = new Car() { ModelName = car.ModelName, Marke = car.Marke, Color = car.Color, ProductionYear = car.ProductionYear }; if (newCar != null) { _database.Cars.Add(newCar); _database.SaveChanges(); return(true); } } return(false); }
public IActionResult Post([FromBody] Car carObject) { _dbContext.Cars.Add(carObject); _dbContext.SaveChanges(); return(StatusCode(StatusCodes.Status201Created)); }
public ActionResult Create([Bind(Include = "CarId,Name,RegNo,Price")] Car car) { if (ModelState.IsValid) { db.Cars.Add(car); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(car)); }
public ActionResult Create([Bind(Include = "ID,Name,Mileage,Color")] Car car) { if (ModelState.IsValid) { db.Cars.Add(car); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(car)); }
public Car CreateCar(string name, BrandOfCars brand, int year) { Car car = new Car() { Name = name, Brand = brand, Year = year }; _carDbcontext.Cars.Add(car); _carDbcontext.SaveChanges(); return(car); }
public IActionResult deleteCar(int id) { var car = context.Cars.Find(id); if (car == null) { return(NotFound()); } context.Cars.Remove(car); context.SaveChanges(); return(NoContent()); }
public IActionResult deleteManufacturer(int id) { var manufacturer = context.Manufacturers.Find(id); if (manufacturer == null) { return(NotFound()); } context.Manufacturers.Remove(manufacturer); context.SaveChanges(); return(NoContent()); }
internal int SaveChanges() { try { return(_db.SaveChanges()); } catch (DbUpdateConcurrencyException ex) { // Генерируется, когда возникла ошибка, связанная с параллелизмом. // Пока что просто сгенерировать исключение повторно, throw; } catch (RetryLimitExceededException ex) { // Генерируется, когда достигнуто максимальное количество попыток. // Дополнительные детали можно найти во внутреннем исключении (исключениях) . // Пока что просто сгенерировать исключение повторно. throw; } catch (DbUpdateException ex) { // Генерируется, когда обновление базы данных потерпело неудачу. // Дополнительные детали и затронутые объекты можно // найти во внутреннем исключении (исключениях). // Пока что просто сгенерировать исключение повторно, throw; } catch (Exception ex) { // Возникло какое-то другое исключение, которое должно быть обработано, throw; } }
internal static void Initialize(CarDbContext context) { context.Database.EnsureCreated(); if (!context.Cars.Any()) { var cars = new List <Car>(); { cars.Add(new Car() { Name = "AMG C63", Brand = BrandOfCars.Mercedes, Year = 2019 }); cars.Add(new Car() { Name = "M5 F90", Brand = BrandOfCars.Bmw, Year = 2018 }); cars.Add(new Car() { Name = "RS7", Brand = BrandOfCars.Audi, Year = 2017 }); } context.Cars.AddRange(cars); context.SaveChanges(); } }
public static void Main() { using (var db = new CarDbContext()) { db.Database.Migrate(); var purchases = db.Purchases. Select(p => new PurchaseResultModel { Price = p.Price, Date = p.PurchaseDate, Car = new CarResultModel { VIN = p.Car.VIN, Make = p.Car.Model.Make.Name, Model = p.Car.Model.Name }, Customer = new CustomerResultModel { Name = p.Customer.FirstName + " " + p.Customer.LastName, Age = p.Customer.Age } }) .ToList(); foreach (var pur in purchases) { Console.WriteLine(pur.Customer.Name); Console.WriteLine(pur.Car.Make + " " + pur.Car.Model); Console.WriteLine(pur.Price); } db.SaveChanges(); } }
public IActionResult CreateOrder(CreateOrderVM order) { Order orderDb = new Order() { OrderId = 0, Date = DateTime.Now, ClientName = order.ClientName, CarName = order.CarName, Telephone = order.Telephone }; db.Orders.Add(orderDb); db.SaveChanges(); CarListVM model = new CarListVM() { cars = db.Cars.ToList() }; return(View("/Views/Car/Index.cshtml", model)); }
public ActionResult Delete(int id) { CarDbContext db = new CarDbContext(); var c = db.CarMarks.FirstOrDefault(x => x.Id == id); db.CarMarks.Remove(c); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task SeedAsync() { db.Database.EnsureCreated(); //StoreUser user = await userManager.FindByEmailAsync("*****@*****.**"); //if (user == null) //{ // user = new StoreUser() // { // FirstName = "test", // LastName = "testov", // Email = "*****@*****.**", // UserName = "******" // }; // var result = await userManager.CreateAsync(user, "P@ssw0rd!"); // if (result != IdentityResult.Success) // { // new InvalidOperationException("Could not create new user in seeder."); // } //} if (!db.Cars.Any()) { db.Cars.Add(new Car() { Id = "7", Type = "Golf", Model = "Mk5", Year = "2003", Engine = "1.9" }); db.Cars.Add(new Car() { Id = "8", Type = "bmw", Model = "5", Year = "2013", Engine = "3.3" }); db.Cars.Add(new Car() { Id = "9", Type = "audi", Model = "a4", Year = "2003", Engine = "1.9" }); db.SaveChanges(); } }
public CarController(CarDbContext context) { _context = context; if (_context.Car.Count() == 0) { _context.Car.Add(new Car { Make = "Mazda", Model = "CX-5", Year = 2016, Color = "Red" }); _context.SaveChanges(); } }
public IActionResult RemoveCar(int id) { List <Car> cars = db.Cars.ToList(); foreach (Car c in cars) { if (c.CarId == id) { db.Cars.Remove(c); } } db.SaveChanges(); List <Car> cars2 = db.Cars.ToList(); CarListVM model = new CarListVM() { cars = cars2 }; return(View("Index", model)); }
public void Delete(int?id) { if (id != null || id != 0) { var car = _database.Cars.SingleOrDefault(x => x.Id == id); _database.Cars.Remove(car); _database.SaveChanges(); _car.DeleteCar(id); } }
public CarSparePart SaveCarSparePart(CarSparePart cs) { CarDbContext db = new CarDbContext(); var list = db.CarSpareParts.ToList(); if (list.Contains(list.Find(x => (x.CarMarkId == cs.CarMarkId) && (x.SparePartId == cs.SparePartId)))) { return(cs); } db.CarSpareParts.Add(cs); db.SaveChanges(); return(cs); }
public CarMark SaveCarMark(CarMark c) { CarDbContext db = new CarDbContext(); var list = db.CarMarks.ToList(); if (list.Contains(list.Find(x => x.Name == c.Name))) { return(c); } db.CarMarks.Add(c); db.SaveChanges(); return(c); }
public SparePart SaveSparePart(SparePart s) { CarDbContext db = new CarDbContext(); var list = db.SpareParts.ToList(); if (list.Contains(list.Find(x => (x.Name == s.Name) && (x.Code == s.Code)))) { return(s); } db.SpareParts.Add(s); db.SaveChanges(); return(s); }
// Guardar los autos public Boolean agregarAutos(Autos _autos) { try { _context.Autos.Add(_autos); _context.SaveChanges(); return(true); } catch (Exception err) { return(false); } }
public void Add(Car car) { if (car.CarDailyPrice > 0 && car.CarDescription.Length >= 2) { using (CarDbContext context = new CarDbContext()) { var addedCar = context.Entry(car); addedCar.State = EntityState.Added; context.SaveChanges(); } } else { Console.WriteLine("Kriterlere uygun şekilde araba girişi yapmadınız!"); } }
static void Main(string[] args) { using (var db = new CarDbContext()) { db.Database.Migrate(); var customer = db.Customers.FirstOrDefault(); customer.Address = new Address { Text = "Tintiava 15", Town = "Sofia" }; db.SaveChanges(); } }
public void Demo() { //Car mashin = new Car(); //mashin.Name = "Volkswagen Passat"; //mashin.Price = 50.99F; //mashin.State = false; //db.Cars.Add(mashin); //db.SaveChanges(); Order sifarish = new Order(); sifarish.StartDate = new DateTime(2019, 03, 02); sifarish.EndDate = new DateTime(2019, 04, 10); sifarish.CarId = 1; db.Orders.Add(sifarish); db.SaveChanges(); }
public static void Main(string[] args) { var db = new CarDbContext(); using (db) { db.Database.Migrate(); // AddMakesToDb(db); // AddModelsToOpel(db); // AddCarsToInsignia(db); // AddCarToCustomer(db); // AddAddressToCustomer(db); // GetPurchase(db); var result1 = db .Cars .FromSqlInterpolated($"SELECT * FROM Cars WHERE Price > 5000") .ToList(); db.Cars .Where(c => c.Price > 5000) .Select(c => new ResultModel { FullName = c.Model.Make.Name }) .ToList(); var query = EF.CompileQuery <CarDbContext, IEnumerable <ResultModel> > (db => db .Cars .Where(c => c.Price > 5000) .Select(c => new ResultModel { FullName = c.Model.Make.Name })); var result2 = query(db); db.SaveChanges(); } }
/// <summary> /// Build several items in database, initialize the database. /// </summary> public void InitDb() { Description d1 = new Description(); d1.Content = "This is just a content"; Description d2 = new Description(); d2.Content = "This is just another content"; var n_car = new Car(); n_car.Model = "BMW"; n_car.Descriptions.Add(d1); n_car.Descriptions.Add(d2); _dbContext.Cars.Add(n_car); _dbContext.SaveChanges(); }
public static void Initial(CarDbContext context) { if (!context.Categories.Any()) { context.Categories.AddRange(Categories.Select(c => c.Value)); } if (!context.Cars.Any()) { context.AddRange( new Car { CarName = "BMW", CarModel = "M5", YearOfIssue = 2000, CarCost = 800, Category = Categories["Седан"] }, new Car { CarName = "BMW", CarModel = "M4", YearOfIssue = 2001, CarCost = 700, Category = Categories["Купе"] }, new Car { CarName = "BMW", CarModel = "M3", YearOfIssue = 2002, CarCost = 400, Category = Categories["Купе"] } );;;; } context.SaveChanges(); }
public static void Initialize(CarDbContext context) { context.Database.EnsureCreated(); if (context.Cars.Any()) { return; } var sections = new List <Car>() { new Car() { Id = 1, CarMark = "Audi", CarModel = "Q8", CarEngine = 3 }, new Car() { Id = 2, CarMark = "Audi", CarModel = "Q7", CarEngine = 3 }, new Car() { Id = 3, CarMark = "Audi", CarModel = "A4", CarEngine = 2 } }; using (var trans = context.Database.BeginTransaction()) { foreach (var section in sections) { context.Cars.Add(section); } context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Cars] ON"); context.SaveChanges(); context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Cars] OFF"); trans.Commit(); } }
public static void Main(string[] args) { var db = new CarDbContext(); using (db) { db.Database.Migrate(); // AddMakesToDb(db); // AddModelsToOpel(db); // AddCarsToInsignia(db); // AddCarToCustomer(db); // AddAddressToCustomer(db); // GetPurchase(db); db.SaveChanges(); } }
public static void Initialize(CarDbContext context) { context.Database.EnsureCreated(); // Look for any students. if (context.Cars.Any()) { return; // DB has been seeded } var cars = new[] { new Car { Make = "BMW", Model = "740", Year = 1999, HorsePowerCount = 400 }, new Car { Make = "Mercedes-benz", Model = "S500", Year = 1994, HorsePowerCount = 355 }, new Car { Make = "Bugatti", Model = "Veyron", Year = 2018, HorsePowerCount = 700 }, new Car { Make = "Toyota", Model = "Corolla", Year = 2021, HorsePowerCount = 155 } }; foreach (var car in cars) { context.Cars.Add(car); } context.SaveChanges(); }