public async Task AddCar(CarData car)
{
await using var db = new CarsContext();
await db.Cars.AddAsync(car);
await db.SaveChangesAsync();
}
public Car Get(Expression <Func <Car, bool> > filter)
{
using (CarsContext context = new CarsContext())
{
return(context.Set <Car>().SingleOrDefault(filter));
}
}
public BuildVehicleVM(Frame main, MainWindow window, BuildVehiclePage buildVehiclePage)
{
this.buildVehiclePage = buildVehiclePage;
this.window = window;
this.main = main;
db = new CarsContext();
Engines = new ObservableCollection <Engine>(db.Engine.ToList());
Colors = new ObservableCollection <Models.Color>(db.Color.ToList());
Headlights = new ObservableCollection <Option>(db.Option.ToList());
Wheels = new ObservableCollection <Option>();
Mirrors = new ObservableCollection <Option>();
Wings = new ObservableCollection <Option>();
Seats = new ObservableCollection <Option>();
Upholsteries = new ObservableCollection <Option>();
Steerings = new ObservableCollection <Option>();
Heatings = new ObservableCollection <Option>();
Sills = new ObservableCollection <Option>();
Lightings = new ObservableCollection <Option>();
Others = new ObservableCollection <OptionModel>();
Models = new ObservableCollection <Model>(db.Model.ToList());
Brands = new ObservableCollection <Brand>(db.Brand.ToList());
SelectedBrand = Brands.First();
SelectedModel = Models.First();
}
static void Main(string[] args)
{
//Initialize our database interaction
/*
* using (CarsContext context = new CarsContext())
* {
* string make, model, colour;
* Console.WriteLine(context.Cars.Count(x => x.Manufacturer.Name == "BMW"));
* Console.WriteLine(context.Cars.Count(x => x.Manufacturer.Name == "Mercedes-Benz"));
* 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
* });
* context.SaveChanges();
* }*/
using (CarsContext context = new CarsContext())
{
string model;
Console.Write("Please enter a model to remove: ");
model = Console.ReadLine();
context.Cars.Remove(context.Cars.Where(x => x.Model == model).SingleOrDefault());
context.SaveChanges();
}
}
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())
{
string model;
Console.Write("Please enter a model to remove: ");
model = Console.ReadLine();
context.Cars.Remove(context.Cars.Where(x => x.Model == model).SingleOrDefault());
context.SaveChanges();
}
}
public CarImpactClassesController(
CarsContext context,
IMapper mapper)
{
_context = context;
_mapper = mapper;
}
public CarsAPIController(CarsContext context)
{
db = context;
if (!db.Cars.Any())
{
db.Cars.Add(new Car {
CarBrand = "DeLorean", CarModel = "DMC-12", CarNum = "OUTATIME", CarColor = "Silver", CarPruductionYear = "1981", CarOwnerFirstName = "Марти", CarOwnerLastName = "Макфлай",
});
db.Cars.Add(new Car {
CarBrand = "Aston Martin", CarModel = "DB5", CarNum = "BMT 216A", CarColor = "Silver", CarPruductionYear = "1970", CarOwnerFirstName = "Джеймс", CarOwnerLastName = "Бонд",
});
db.Cars.Add(new Car {
CarBrand = "Chevrolet", CarModel = "Sport 108", CarNum = "Отсутствуют", CarColor = "Sea", CarPruductionYear = "1968", CarOwnerFirstName = "Фред", CarOwnerLastName = "Джонс",
});
db.Cars.Add(new Car {
CarBrand = "British Leyland", CarModel = "Mini 1000", CarNum = "SLW 287R", CarColor = "Yellow", CarPruductionYear = "1976", CarOwnerFirstName = "Mr.", CarOwnerLastName = "Bean",
});
db.Cars.Add(new Car {
CarBrand = "Peugeot", CarModel = "406", CarNum = "724NLB13", CarColor = "White", CarPruductionYear = "1995", CarOwnerFirstName = "Даниэль", CarOwnerLastName = "Моралес",
});
db.Cars.Add(new Car {
CarBrand = "Audi", CarModel = "A8", CarNum = "247 BRD 06", CarColor = "Black", CarPruductionYear = "2006", CarOwnerFirstName = "Tom", CarOwnerLastName = "Tom",
});
db.SaveChanges();
}
}
public CarProbabilityClassesController(
CarsContext context,
IMapper mapper)
{
_context = context;
_mapper = mapper;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, CarsContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
app.UseBrowserLink();
}
else
{
app.UseExceptionHandler("/Home/Error");
}
app.UseStaticFiles();
// добавляем поддержку сессий
app.UseSession();
// добавляем компонента miidleware по инициализации базы данных
app.UseDbInitializer();
app.UseMvc(routes =>
{
routes.MapRoute(
name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
}
public StaticticVM()
{
db = new CarsContext();
baseDate1 = new DateTime(2019, 12, 20);
baseDate2 = DateTime.Now;
selectedDate1 = baseDate1;
selectedDate2 = baseDate2;
allContracts = new ObservableCollection <ContractModel>(db.Contract.ToList()
.Where(i => i.Type == "Покупка")
.Select(i => new ContractModel()
{
contract = i,
model = i.Vehicle.Kit.Model.Name,
modelId = i.Vehicle.Kit.Model.Id,
kit = i.Vehicle.Kit.Name,
client = i.Client.Name,
employee = i.Employee.Name,
employeeId = i.Employee.Id,
date = i.Date.ToString("dd.MM.yyyy")
}));
selectedContracts = new ObservableCollection <ContractModel>();
allContracts.ToList().ForEach(i => selectedContracts.Add(i));
int s = 0;
foreach (var item in selectedContracts)
{
s += (int)(item.contract.Total_Price);
}
Sum = s.ToString();
Models = new ObservableCollection <Model>(db.Model.ToList());
Employees = new ObservableCollection <Employee>(db.Employee.ToList());
}
//[ExpectedException(typeof(InvalidOperationException))]
public void TestNavigationAndForeignKeyConflictingChanges()
{
using (TransactionScope ts = new TransactionScope())
using (CarsContext context = new CarsContext())
{
var brands = context.Brands.Include(b => b.Cars).OrderBy(b => b.BrandId);
var car = brands.First().Cars.First();
Debug.WriteLine("The car has BrandId {0} pointing to Brand \"{1}\"",
car.BrandId, car.Brand.Name);
Brand newBrand = brands.Skip(1).First();
int newBrandId = brands.Skip(2).First().BrandId;
Debug.WriteLine(string.Format("Setting Brand to {0}", newBrand.Name));
car.Brand = newBrand;
Debug.WriteLine(string.Format("The car has BrandId {0} pointing to Brand \"{1}\"",
car.BrandId, car.Brand.Name));
Debug.WriteLine(string.Format("Setting BrandId to {0}", newBrandId));
car.BrandId = newBrandId;
Debug.WriteLine(string.Format("The car has BrandId {0} pointing to Brand \"{1}\"",
car.BrandId, car.Brand.Name));
Debug.WriteLine("Saving Changes...");
context.SaveChanges();
Debug.WriteLine(string.Format("The car has BrandId {0} pointing to Brand \"{1}\"",
car.BrandId, car.Brand.Name));
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env)
{
app.UseDeveloperExceptionPage();
app.UseStatusCodePages();
app.UseStaticFiles();
app.UseSession();
app.UseAuthentication();
app.UseAuthorization();
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapRazorPages();
endpoints.MapHub <ChatHub>("/chatHub");
});
app.UseMvc(routes =>
{
routes.MapRoute(name: "default",
template: "{controller=Home}/{action=Index}/{id?}");
});
using (var scope = app.ApplicationServices.CreateScope())
{
CarsContext context = scope.ServiceProvider.GetRequiredService <CarsContext>();
DBObjects.First(context);
}
}
public void RunSeedMethod_WithoutDescription()
{
using (var ctx = new CarsContext())
{
ctx.Seed <CarBodyStyle>(descriptionField: null);
}
}
/// <summary>
/// Загрузка
/// </summary>
public static ObservableCollection <Auto> Load()
{
using (CarsContext db = new CarsContext())
{
var cars = db.Cars;
var services = db.Services;
var refuelings = db.Refuelings;
var spareParts = db.SpareParts;
foreach (var item in cars)
{
foreach (var service in services)
{
}
foreach (var refueling in refuelings)
{
}
foreach (var sparePart in spareParts)
{
}
Cars.Add(item);
}
return(Cars);
}
}
public HttpResponseMessage Put([FromBody] CarPutDTO car)
{
try
{
CarsContext db = new CarsContext();
int idtochange = int.Parse(car.Id);
var actualcar = from c in db.Cars
where c.Id == idtochange
select c;
if (actualcar.First() != null)
{
actualcar.First().LicenseNumber = car.Licence;
actualcar.First().Mileage = int.Parse(car.Mileage);
var newcarmodel = from m in db.Models
where m.Model.ToLower() == car.Model.ToLower()
select m;
actualcar.First().Model = newcarmodel.First();
db.SaveChanges();
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.OK);
return(response);
}
else
{
throw new Exception();
}
}
catch (Exception)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.InternalServerError);
return(response);
}
}
public void UpdateFirstCar()
{
int carId = 4;
using (var ts = new TransactionScope())
{
using (var uow = new UnitOfWorkScope <CarsContext>(UnitOfWorkScopePurpose.Writing))
{
Car c = SharedQueries.GetCar(carId);
c.Color = "White";
uow.SaveChanges();
}
using (var ctx = new CarsContext())
{
Assert.AreEqual("White",
ctx.Cars.Single(c => c.CarId == carId).Color);
}
}
using (var ctx = new CarsContext())
{
Assert.AreEqual("Red",
ctx.Cars.Single(c => c.CarId == carId).Color);
}
}
public void CreateWorks()
{
using (var context = new CarsContext())
{
var make = context.Makes.FirstOrDefault();
Assert.IsNull(make);
}
}
public DisplayCarModel GetCar(long carId)
{
using (var dbContext = new CarsContext())
{
var carInstance = dbContext.GetCar.SqlQuery("EXECUTE GetCar {0}", carId).ToListAsync().Result.FirstOrDefault();
return(carInstance);
}
}
public List <DisplayCarModelModel> GetCarBrandModels(long carBrandId)
{
using (var dbContext = new CarsContext())
{
var carBrandModelsList = dbContext.GetCarBrandModels.SqlQuery("EXECUTE GetCarBrandModels {0}", carBrandId).ToListAsync().Result;
return(carBrandModelsList);
}
}
public List <DisplayCarBrandModel> GetCarBrands()
{
using (var dbContext = new CarsContext())
{
var carBrandsList = dbContext.GetCarBrand.SqlQuery("EXECUTE GetCarBrands").ToListAsync().Result;
return(carBrandsList);
}
}
/// <summary>
/// Сохранение
/// </summary>
public static void Save <T>(T item) where T : class
{
using (CarsContext db = new CarsContext())
{
db.Set <T>().Add(item);
db.SaveChanges();
}
}
public static void Seed()
{
using (var context = new CarsContext())
{
new Configuration().Seed(context);
context.SaveChanges();
}
}
public ContractVM(AppViewModel vm, VehicleModel v)
{
db = new CarsContext();
contractType = "покупку";
appViewModel = vm;
vehicle = v;
employee = vm.Window.Employee;
date = DateTime.Now;
}
public HttpResponseMessage Delete(int id)
{
CarsContext db = new CarsContext();
Cars CarToDelete = db.Cars.Find(id);
db.Cars.Remove(CarToDelete);
db.SaveChanges();
return(new HttpResponseMessage(HttpStatusCode.OK));
}
public ContractVM(BuildVehicleVM vm, VehicleModel v)
{
db = new CarsContext();
contractType = "заказ";
buildVehicleVM = vm;
vehicle = v;
employee = vm.Window.Employee;
date = DateTime.Now;
}
public ReportService(
CarsContext context,
IMapper mapper,
IAppLogger <ReportService> logger)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
_mapper = mapper ?? throw new ArgumentNullException(nameof(mapper));
_logger = logger ?? throw new ArgumentNullException(nameof(logger));
}
static void Main(string[] args)
{
Console.WriteLine("Hello World!");
using (CarsContext context = new CarsContext())
{
Console.WriteLine(context.Cars.Count(x => x.Manufacturer.Name == "BMW"));
}
}
public static void Insert <TEntity>(List <TEntity> entity) where TEntity : class
{
using (CarsContext context = new CarsContext())
{
DbSet <TEntity> dbset = context.Set <TEntity>();
dbset.AddRange(entity);
context.SaveChanges();
}
}
public List <Car> GetAll(Expression <Func <Car, bool> > filter = null)
{
using (CarsContext context = new CarsContext())
{
return(filter == null
? context.Set <Car>().ToList()
: context.Set <Car>().Where(filter).ToList());
}
}
public void Delete(Car car)
{
//_car.Remove(_car.FirstOrDefault(x => x.Id == car.Id));
using (CarsContext context = new CarsContext())
{
var deletedEntity = context.Entry(car);
deletedEntity.State = EntityState.Deleted;
context.SaveChanges();
}
}
public void Add(Car car)
{
//_car.Add(car);
using (CarsContext context = new CarsContext())
{
var addedEntity = context.Entry(car);
addedEntity.State = EntityState.Added;
context.SaveChanges();
}
}
public static CarReadModel GetById3(int id)
{
using (CarsContext ctx = new CarsContext())
{
return (
from c in ctx.Cars.SelectCarReadModel()
where c.Car.CarId == id
select c
).Single();
}
}
public static CarReadModel SearchByBrand(string brandFilter)
{
using (CarsContext ctx = new CarsContext())
{
return (
from c in ctx.Cars.SelectCarReadModel()
where c.BrandName.StartsWith(brandFilter)
select c
).Single();
}
}
public static CarReadModel GetById(int id)
{
using (CarsContext ctx = new CarsContext())
{
return (
from c in ctx.Cars
where c.CarId == id
select new CarReadModel
{
Car = c,
BrandName = c.Brand.Name
}
).Single();
}
}
public PluginConfig(CarsContext carsContext,
IWorkContext workContext)
{
_carsContext = carsContext;
_workContext = workContext;
}
