/// <summary>
/// 新增
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override int Insert(CarBrandEntity car)
{
int id = 0;
var list = this.QueryList(car);
if (list.Any())
{
car.BrandLogo = list[0].BrandLogo;
this.Update(car);
id = list[0].Id;
}
else
{
id = CarDataAccess.Insert(
"INSERT INTO hengtu_carbrand(rid,url,brand,logo,tagname,add_time)VALUES(@Rid,@Url,@BrandName,@BrandLogo,@TagName,@AddTime)",
new
{
car.Rid,
car.Url,
car.BrandName,
car.BrandLogo,
car.AddTime
});
}
ShowInfoEventHandler?.Invoke(this, new ViewModelArg <CarBrandEntity> {
Car = car, Type = list.Any() ? 0 : 1
});
return(car.Id = id);
}
/// <summary>
/// 新增
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override int Insert(CarSeriesEntity car)
{
int id = 0;
var list = this.QueryList(car);
if (list.Any())
{
this.Update(car);
id = list[0].Id;
}
else
{
id = CarDataAccess.Insert(
"INSERT INTO hengtu_carmodeldetail(modelid,model,linkurl,reference_price,full_payment_reference,msrp,add_time)" +
"VALUES(@ModelId,@SeriesName,@LinkUrl,@ReferencePrice,@FullPaymentReference,@Msrp,@AddTime)",
new
{
car.ModelId,
car.SeriesName,
car.LinkUrl,
car.ReferencePrice,
car.FullPaymentReference,
car.Msrp,
DateTime.Now,
});
}
ShowInfoEventHandler?.Invoke(this, new ViewModelArg <CarSeriesEntity> {
Car = car, Type = list.Any() ? 0 : 1
});
return(car.Id = id);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override bool Update(CarSeriesEntity car)
{
return(CarDataAccess.Update(
"UPDATE hengtu_carmodeldetail SET model=@SeriesName WHERE modelid=@ModelId AND linkurl=@LinkUrl", new
{
car.SeriesName,
car.ModelId,
car.LinkUrl
}));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override bool Update(CarModelEntity car)
{
return(CarDataAccess.Update(
"UPDATE hengtu_carmodel SET model=@ModelName,factory=@Factory,add_time=@AddTime,image=@ImagePath,national_reference_price=@NationalReferencePrice,msrp=@Msrp,second_hand=@SecondHand,fuel_consumption=@FuelConsumption WHERE brandid=@BrandId AND linkurl=@LinkUrl",
new
{
car.ModelName,
car.Factory,
car.AddTime,
car.ImagePath,
car.NationalReferencePrice,
car.Msrp,
car.SecondHand,
car.FuelConsumption,
car.BrandId,
car.LinkUrl
}));
}
/// <summary>
/// 新增
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override int Insert(CarModelEntity car)
{
int id = 0;
var list = this.QueryList(car);
if (list.Any())
{
car.ModelName = list[0].ModelName;
this.Update(car);
id = list[0].Id;
}
else
{
id = CarDataAccess.Insert(
"INSERT INTO hengtu_carmodel(brandid,model,linkurl,factory,image,add_time,national_reference_price,msrp,second_hand,displacement,fuel_consumption,gearbox,warranty)" +
"VALUES(@BrandId,@ModelName,@LinkUrl,@Factory,@ImagePath,@AddTime,@NationalReferencePrice,@Msrp,@SecondHand,@Displacement,@FuelConsumption,@Gearbox,@Warranty)",
new
{
car.BrandId,
car.ModelName,
car.LinkUrl,
car.Factory,
car.ImagePath,
car.AddTime,
car.NationalReferencePrice,
car.Msrp,
car.SecondHand,
car.Displacement,
car.FuelConsumption,
car.Gearbox,
car.Warranty
});
}
ShowInfoEventHandler?.Invoke(this, new ViewModelArg <CarModelEntity> {
Car = car, Type = list.Any() ? 0 : 1
});
return(car.Id = id);
}
public SetCarOnlineOfflineRequestHandler()
{
_carDataAccess = new CarDataAccess();
}
static void Main(String[] args)
{
//In this Problem, we have a Cars class which gets a list of Cars from different JSON files.
// Write the "GetCars" method to return a dictionary with the key being the First Letter of the model of the car and the value being the list of cars in the JSON file with that result.
// See Example Answer
// A
//Altima
// Audi
//E
// Escape
//F
//F-250 Super Duty
//P
// Pilot
//T
// Tracker
var carDataAccess = new CarDataAccess("SmallListofCars");
var cars = new Cars(carDataAccess);
var response = cars.GetCars();
foreach (var VARIABLE in response)
{
Console.WriteLine(VARIABLE.Key);
foreach (var car in VARIABLE.Value)
{
Console.WriteLine(" " + car);
}
}
//var allCars = new List<Car>()
//{
// new Car() {Name = "A", Color = "red"},
// new Car() {Name = "B", Color = "blue"},
// new Car() {Name = "C", Color = "red"},
// new Car() {Name = "D", Color = "yellow"},
// new Car() {Name = "E", Color = "green"},
// new Car() {Name = "F", Color = "black"}
//};
//var redcars = allCars.Where(x => x.Color.Equals("red")).ToList();
//foreach (var carsRedcar in redcars)
//{
// Console.WriteLine(carsRedcar.Name);
//}
//Console.WriteLine(allCars.Count());
Console.WriteLine("Press Enter to Close Program");
string s = Console.ReadLine();
//string fileName = System.Environment.GetEnvironmentVariable("OUTPUT_PATH");
//TextWriter fileOut = new StreamWriter(@fileName, true);
//string[] res = getMovieTitles(s);
//for (int res_i = 0; res_i < res.Length; res_i++)
//{
// fileOut.WriteLine(res[res_i]);
//}
//fileOut.Flush();
//fileOut.Close();
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="car">实体对象</param>
/// <returns>返回列表</returns>
public override IList <CarModelEntity> QueryList(CarModelEntity car)
{
return(CarDataAccess.QueryList(
"SELECT id,brandid AS BrandId,model AS ModelName, linkurl AS LinkUrl,factory,image AS ImagePath,add_time AS AddTime,national_reference_price AS NationalReferencePrice,msrp,second_hand AS SecondHand,displacement AS Displacement,fuel_consumption AS FuelConsumption,gearbox AS Gearbox,warranty AS Warranty,color_link AS ColorLink FROM hengtu_carmodel WHERE brandid=@BrandId AND linkurl=@LinkUrl",
new { car.BrandId, car.LinkUrl }, null));
}
/// <summary>
/// 查询
/// </summary>
/// <param name="id">ID</param>
/// <returns>返回对象</returns>
public override CarBrandEntity FindBy(object id)
{
return(CarDataAccess.FindBy(
"SELECT id,rid,url,brand,logo,tagname,add_time WHERE id=@id", id, null));
}
/// <summary>
/// 更新
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override bool Update(CarBrandEntity car)
{
return(CarDataAccess.Update(
"UPDATE hengtu_carbrand SET brand=@BrandName,logo=@BrandLogo,add_time=@AddTime WHERE rid=@Rid AND url=@Url AND tagname=@TagName",
new { car.BrandName, car.BrandLogo, car.AddTime, car.Rid, car.Url, car.TagName }));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="car">实体对象</param>
/// <returns></returns>
public override bool Delete(CarBrandEntity car)
{
return(CarDataAccess.Delete(id: car.Id));
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="car">实体对象</param>
/// <returns>返回列表</returns>
public override IList <CarBrandEntity> QueryList(CarBrandEntity car)
{
return(CarDataAccess.QueryList(
"SELECT id,rid,url,brand AS BrandName,logo AS BrandLogo,tagname,add_time AS AddTime FROM hengtu_carbrand WHERE rid=@Rid AND url=@Url AND tagname=@TagName",
new { car.Rid, car.Url, car.TagName }, null));
}
public CarListViewModel()
{
var carDataAccess = new CarDataAccess("US");
Cars = new CarRepository(carDataAccess).GetCars();
}
/// <summary>
/// 查询列表
/// </summary>
/// <param name="car">实体对象</param>
/// <returns>返回列表</returns>
public override IList <CarSeriesEntity> QueryList(CarSeriesEntity car)
{
return(CarDataAccess.QueryList(
"SELECT id,modelid AS ModelId,model AS SeriesName,linkurl AS LinkUrl,reference_price AS ReferencePrice,full_payment_reference AS FullPaymentReference,msrp AS Msrp,fuel_consumption AS FullPaymentReference,displacement AS Displacement,engine AS Engine,gearbox AS Gearbox,add_time AS AddTime FROM hengtu_carmodeldetail WHERE modelid=@ModelId AND linkurl=@LinkUrl",
new { car.ModelId, car.LinkUrl }, null));
}
