private static void ImportSales()
{
var objects = new List <Sale>();
var context = new CarsDBContext();
double[] discounts = { 1, 0.95, 0.9, 0.85, 0.8, 0.7, 0.6, 0.5 };
int carsCount = context.Cars.Count();
int customersCount = context.Customers.Count();
int discountCount = discounts.Length;
int num = 0;
foreach (var car in context.Cars.ToList())
{
int customer = ((num + 7) % customersCount) + 1;
double discount = discounts[num % discountCount];
var sale = new Sale()
{
CarId = car.Id,
CustomerId = customer,
Discount = discount
};
objects.Add(sale);
num++;
}
context.Sales.AddRange(objects);
context.SaveChanges();
}
private static void SalesWithAppliedDiscount()
{
var context = new CarsDBContext();
var query = context.Sales
.Select(s => new
{
car = new
{
s.Car.Make,
s.Car.Model,
s.Car.TravelledDistance
},
customerName = s.Customer.Name,
s.Discount,
price = s.Car.Parts.Sum(p => p.Price)
})
.AsEnumerable()
.Select(s => new
{
s.car,
s.customerName,
s.Discount,
s.price,
pricewithDiscount = s.price * (decimal)s.Discount
});
var json = JsonConvert.SerializeObject(query, Formatting.Indented);
File.WriteAllText("..\\..\\Jsons\\sales-discounts.json", json);
}
private static void ImportCars()
{
var json = File.ReadAllText("..\\..\\jsons\\cars.json");
var objects = JsonConvert.DeserializeObject <List <Car> >(json);
var context = new CarsDBContext();
int count = context.Parts.Count();
int partsCount = 10;
int num = 0;
foreach (var c in objects)
{
for (int i = 0; i < partsCount; i++)
{
c.Parts.Add(context.Parts.Find(num % count + 1));
}
num++;
partsCount++;
if (partsCount == 21)
{
partsCount = 10;
}
}
context.Cars.AddRange(objects);
context.SaveChanges();
}
public IEnumerable <RoadDto> GetAllRoads()
{
using (CarsDBContext dBContext = new CarsDBContext())
{
IEnumerable <RoadDto> result = AutoMapperConfiguration.MapperConfiguration.Map <List <Road>, List <RoadDto> >(dBContext.Roads.ToList());
return(result);
}
}
public IEnumerable <DriverDto> GetDriversByAge(int age, int driverType)
{
using (CarsDBContext dBContext = new CarsDBContext())
{
IEnumerable <DriverDto> result = AutoMapperConfiguration.MapperConfiguration.Map <List <Driver>, List <DriverDto> >(dBContext.Drivers.Where(dri => dri.Age > age && dri.DriversLessonType == driverType).ToList());
return(result);
}
}
public IEnumerable <DriverDto> GetDriversByCityName(String cityName)
{
using (CarsDBContext dBContext = new CarsDBContext())
{
IEnumerable <DriverDto> result = AutoMapperConfiguration.MapperConfiguration.Map <List <Driver>, List <DriverDto> >(dBContext.Drivers.Where(dri => dri.Address.Contains(cityName)).ToList());
return(result);
}
}
public IEnumerable <CarDto> GetCars()
{
using (CarsDBContext dBContext = new CarsDBContext())
{
IEnumerable <CarDto> result = AutoMapperConfiguration.MapperConfiguration.Map <List <Car>, List <CarDto> > (dBContext.Car.ToList());
return(result);
}
}
static Reports AddReport(CarsDBContext context, string xmlText)
{
Reports report = new Reports {
ReportData = xmlText, RequestedDateTime = DateTime.Now, AddedToDatabase = false
};
context.Add(report);
return(report);
}
private static void OrderedCustomers()
{
var context = new CarsDBContext();
var query = context.Customers.OrderBy(c => c.BirthDate).ThenBy(c => c.IsYoungDriver);
var json = JsonConvert.SerializeObject(query, Formatting.Indented);
File.WriteAllText("..\\..\\Jsons\\ordered-customers.json", json);
}
public IEnumerable <DriverDto> GetAllDrivers()
{
using (CarsDBContext dBContext = new CarsDBContext())
{
List <Driver> sourceDrivers = dBContext.Drivers.ToList();
IEnumerable <DriverDto> result = AutoMapperConfiguration.MapperConfiguration.Map <List <Driver>, List <DriverDto> >(sourceDrivers);
return(result);
}
}
private static void CarsFromMakeToyota()
{
var context = new CarsDBContext();
var query = context.Cars.Where(c => c.Make == "Toyota")
.OrderBy(c => c.Model)
.ThenByDescending(c => c.TravelledDistance);
var json = JsonConvert.SerializeObject(query, Formatting.Indented);
File.WriteAllText("..\\..\\Jsons\\toyota-cars.json", json);
}
public IndexModel(CarsDBContext context, IHubContext <CarHub> hubContext, ISqlDependencyManager sqlDependencyManager, CarHub carHubDI)
{
_context = context;
_carHubContext = hubContext;
//all dependency based stuff is in dependency manager
_sqlDependencyManager = sqlDependencyManager;
_carHub = carHubDI;
//only callback is added to the manager
_sqlDependencyManager.SetAction(OnDependencyChangeInManager);
}
private static void ImportCustomers()
{
var json = File.ReadAllText("..\\..\\jsons\\customers.json");
var objects = JsonConvert.DeserializeObject <List <Customer> >(json);
var context = new CarsDBContext();
context.Customers.AddRange(objects);
context.SaveChanges();
}
public void Configure(IApplicationBuilder app,
IHostingEnvironment env,
CarsDBContext carsDBContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
app.UseStaticFiles();
carsDBContext.CreateSeedData();
app.UseMvc();
app.Run(async(context) =>
{
await context.Response.WriteAsync("C# can't find anything");
});
}
static void AddCarProductCarFeature(CarsDBContext context, DefaultDeserializer deserializer)
{
var carProductsQuery = context.CarProducts;
var carFeaturesQuery = context.CarFeatures;
foreach (var car in deserializer.Find("Car"))
{
int carID = carProductsQuery.Where(s => s.Vin == car.Attributes["VIN"]).First().Id;
foreach (var feature in car.FindChildren("Feature"))
{
int featureID = carFeaturesQuery.Where(s => s.Code == feature.Attributes["Code"]).First().Id;
context.Add(new CarProductCarFeature {
CarProductId = carID, InstalledFeatureId = featureID
});
}
}
}
private static void LocalSuppliers()
{
var context = new CarsDBContext();
var query = context.Suppliers
.Where(s => s.IsImporter == false)
.Select(s => new
{
s.Id,
s.Name,
PartsCount = s.Parts.Count
});
var json = JsonConvert.SerializeObject(query, Formatting.Indented);
File.WriteAllText("..\\..\\Jsons\\local-suppliers.json", json);
}
public IEnumerable <DriverDto> GetDriversByDriverType(string driverType)
{
using (CarsDBContext dBContext = new CarsDBContext())
{
var driversByType = (from driver in dBContext.Drivers
join driverLessonType in dBContext.DriverLessonType on driver.DriversLessonType equals driverLessonType.LessonType
where driverLessonType.LessonTypeDriver == driverType
select new DriverDto
{
ID = driver.ID,
DriverName = driver.DriverName,
DriversLessonType = driver.DriversLessonType,
Address = driver.Address,
DriversLessonTypeValue = driverLessonType.LessonTypeDriver
});
return(driversByType.ToList());
}
}
public void AddCar(CarDto mycar)
{
Car car = new Car();
if (mycar != null)
{
car = AutoMapperConfiguration.MapperConfiguration.Map <CarDto, Car>(mycar);
//car.CarColor = mycar.CarColor;
//car.CarCompany = mycar.CarCompany;
//car.CarSize = mycar.CarSize;
//car.Comments = mycar.Comments;
using (CarsDBContext dBContext = new CarsDBContext())
{
dBContext.Car.Add(car);
dBContext.SaveChanges();
}
}
}
public IEnumerable <CarDto> GetCarsByNumOfPassengers(int numOfPassengers)
{
using (CarsDBContext dBContext = new CarsDBContext())
{
var carsAndPass = from car in dBContext.Car
join carSize in dBContext.CarSize on car.CarSize equals carSize.ID
where carSize.NumOfPassengers > numOfPassengers
select new CarDto
{
CarColor = car.CarColor,
CarCompany = car.CarCompany,
ID = car.ID,
Comments = car.Comments,
NumOfPassengers = carSize.NumOfPassengers,
CarSize1 = carSize.CarSize1
};
return(carsAndPass.ToList());
}
}
static void AddCarProducts(CarsDBContext context, DefaultDeserializer deserializer)
{
var carModelsQuery = context.CarModels;
var carFactoriesQuery = context.CarFactories;
foreach (var factory in deserializer.Find("Factory"))
{
//finds factory id by correlating same factory name attribute and Name column in CarFactories
int factoryID = carFactoriesQuery.Where(s => s.Name == factory.Attributes["Name"]).First().Id;
foreach (var car in factory.FindChildren("Car"))
{
int carID = carModelsQuery.Where(s => s.Name == car.FindChildren("Model").First().Value).First().Id;
short carYear = short.Parse(car.FindChildren("ProductionYear").First().Value);
string carVIN = car.Attributes["VIN"];
context.Add(new CarProducts {
CarModelId = carID, Year = carYear, Vin = carVIN, FactoryId = factoryID
});
}
}
}
private static void ImportParts()
{
var json = File.ReadAllText("..\\..\\jsons\\parts.json");
var objects = JsonConvert.DeserializeObject <List <Part> >(json);
var context = new CarsDBContext();
int count = context.Suppliers.Count();
int num = 0;
foreach (var p in objects)
{
p.SupplierId = num % count + 1;
num++;
}
context.Parts.AddRange(objects);
context.SaveChanges();
}
public IHttpActionResult UpdateCar(CarDto myCar)
{
using (CarsDBContext dBContext = new CarsDBContext())
{
Car car = dBContext.Car.Where(c => c.ID == myCar.ID).FirstOrDefault();
if (car != null)
{
//IEnumerableCarDto> result = AutoMapperConfiguration.MapperConfiguration.Map<List<Car>, List<CarDto>>(dBContext.carss.Where(dri => dri.Age > age && dri.DriversLessonType == driverType).ToList());
car = AutoMapperConfiguration.MapperConfiguration.Map <CarDto, Car>(myCar);
// car.CarColor = myCar.CarColor;
// car.CarCompany = myCar.CarCompany;
// car.CarSize = myCar.CarSize;
// car.Comments = myCar.Comments;
}
dBContext.SaveChanges();
return(Ok(myCar));
}
}
public IHttpActionResult AddDriver(DriverDto myDriver)
{
Driver driver = new Driver();
if (driver != null)
{
driver = AutoMapperConfiguration.MapperConfiguration.Map <DriverDto, Driver>(myDriver);
//driver.DriverName = myDriver.DriverName;
//driver.DriversLessonType = myDriver.DriversLessonType;
//driver.Age = myDriver.Age;
//driver.Address = myDriver.Address;
using (CarsDBContext dBContext = new CarsDBContext())
{
dBContext.Drivers.Add(driver);
dBContext.SaveChanges();
return(Ok(myDriver));
}
}
return(Ok(myDriver));
}
static void AddToDatabase(Stream stream)
{
DefaultDeserializer deserializer = new DefaultDeserializer(stream);
deserializer.Deserialize();
CarsDBContext db = new CarsDBContext();
//gets reference to added report for later
Reports addedReport;
try
{
addedReport = AddReport(db, deserializer.Document.ToString());
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
try
{
AddCarProducts(db, deserializer);
db.SaveChanges();
AddCarProductCarFeature(db, deserializer);
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
ConfirmReport(context: db, reportToConfirm: addedReport);
db.SaveChanges();
}
static void Main(string[] args)
{
using (var ctx = new CarsDBContext())
{
var car = new Car()
{
Brand = "Audi"
};
var driver1 = new Driver()
{
DriverID = 1, Name = "Bill"
};
car.CurrentDriver = driver1;
var driver2 = new Driver()
{
DriverID = 1, Name = "Bill"
};
car.PreviousDriver = driver2;
Debug.WriteLine("Check equality before saving to db");
Debug.WriteLineIf(driver1.Equals(driver2), "driver1 and 2 are equal");
Debug.WriteLineIf(driver1.GetHashCode() == driver2.GetHashCode(), "hashcodes are equal");
Debug.WriteLine("Driver1 hash: {0}", driver1.GetHashCode());
Debug.WriteLine("Driver2 hash: {0}", driver2.GetHashCode());
ctx.Cars.Add(car);
ctx.Drivers.Remove(driver2);
ctx.SaveChanges();
Debug.WriteLine("Check equality after saving to db");
Debug.WriteLineIf(driver1.Equals(driver2), "driver1 and 2 are equal");
Debug.WriteLineIf(driver1.GetHashCode() == driver2.GetHashCode(), "hashcodes are equal");
Debug.WriteLine("Driver1 hash: {0}", driver1.GetHashCode());
Debug.WriteLine("Driver2 hash: {0}", driver2.GetHashCode());
}
}
private static void CarsWithTheirListOfParts()
{
var context = new CarsDBContext();
var query = context.Cars
.Select(c => new
{
car = new
{
c.Make,
c.Model,
c.TravelledDistance,
},
parts = c.Parts.Select(p => new
{
p.Name,
p.Price
})
});
var json = JsonConvert.SerializeObject(query, Formatting.Indented);
File.WriteAllText("..\\..\\Jsons\\cars-and-parts.json", json);
}
private static void TotalSalesByCustomer()
{
var context = new CarsDBContext();
decimal youngDriverDiscount = 0.95m;
var query = context.Customers.Where(c => c.Sales.Any())
.Select(c => new
{
fullName = c.Name,
boughtCars = c.Sales.Count(),
spentMoney = c.Sales.Select(s => new { price = s.Car.Parts.Sum(p => p.Price), s.Discount }),
c.IsYoungDriver
})
.AsEnumerable()
.Select(c => new
{
c.fullName,
c.boughtCars,
spentMoney = (c.spentMoney.Sum(s => s.price * (decimal)s.Discount)) * (c.IsYoungDriver? youngDriverDiscount : 1)
});
var json = JsonConvert.SerializeObject(query, Formatting.Indented);
File.WriteAllText("..\\..\\Jsons\\customers-total-sales.json", json);
}
public CarsController(CarsDBContext context)
{
_context = context;
}
static void Main()
{
var context = new CarsDBContext();
context.Database.Initialize(true);
}
public DetailsModel(CarsDBContext context)
{
_context = context;
}
