public IActionResult GetVehiclePropArr(string vehicle_id)
{
try
{
VehiclePropArr result = ClassCrud.GetVehiclePropArr(vehicle_id);
return(Json(result));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public static VehiclePropArr GetVehiclePropArr(string vehicle_id)
{
VehiclePropArr model = null;
try
{
#region strCommand
string strCommand = " SELECT DISTINCT " +
" p.hmodtyp vehicle_id, " +
" p.cmodnamepc model_name, " +
" p.xcardrs, " +
" p.dmodyr, " +
" p.xgradefulnam, " +
" p.ctrsmtyp, " +
" p.cmftrepc, " +
" p.carea, " +
" p.nengnpf " +
" FROM pmotyt p " +
" WHERE p.hmodtyp = @vehicle_id LIMIT 1; ";
#endregion
using (IDbConnection db = new MySqlConnection(strConn))
{
CarTypeInfo carType = db.Query <CarTypeInfo>(strCommand, new { vehicle_id }).FirstOrDefault();
List <attributes> list = GetAttributes();
list[0].value = carType.model_name;
list[1].value = carType.xcardrs;
list[2].value = carType.dmodyr;
list[3].value = carType.xgradefulnam;
list[4].value = carType.ctrsmtyp;
list[5].value = carType.cmftrepc;
list[6].value = carType.carea;
list[7].value = carType.nengnpf;
model = new VehiclePropArr {
model_name = carType.model_name
};
model.attributes = list;
}
}
catch (Exception ex)
{
string Errror = ex.Message;
int y = 0;
}
return(model);
}
public IActionResult GetVehiclePropArr(string vehicle_id, int t = 0)
{
try
{
VehiclePropArr result = ClassCrud.GetVehiclePropArr(vehicle_id);
if (t == 0)
{
return(Json(result));
}
else
{
return(View("~/Views/Home/VehicleAttr.cshtml", result));
}
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
public HomeModule()
{
Get("/", args => {
return(View["home.html"]);
});
Get("/models", args => {
List <ModelCar> list = ClassCrud.GetModelCars();
string json = JsonConvert.SerializeObject(list);
return(json);
});
Get("/image", args => {
string image_id = this.Request.Query["image_id"];
string FilderImagePath = Ut.GetImagePath(); //"wwwroot/image/";
//image_id = "Yamato.jpg";
string fullPath = FilderImagePath + image_id;
if (System.IO.File.Exists(fullPath))
{
byte[] file = System.IO.File.ReadAllBytes(fullPath);
string json = JsonConvert.SerializeObject(file);
return(json);
}
var response = new Response {
StatusCode = HttpStatusCode.NotFound, ReasonPhrase = "File not found!",
};
return(response);
});
Get("/vehicle/vin", args => {
// 1HGCE17600A300001
string vin = Request.Query["vin"];
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfo(vin); // JHMED73600S205949
List <header> headerList = ClassCrud.GetHeaders();
var result = new
{
headers = headerList,
items = list,
cnt_items = list.Count,
page = 1
};
return(JsonConvert.SerializeObject(result));
});
Get("/mgroups", args => {
string vehicle_id = Request.Query["vehicle_id"];
string lang = Request.Query["lang"];
List <PartsGroup> list = ClassCrud.GetPartsGroup(vehicle_id, lang);
return(JsonConvert.SerializeObject(list));
});
//=========================================================================================
Get("/vehicle", args => {
string node_id = Request.Query["node_id"];
string lang = Request.Query["lang"];
//List<SpareParts4F> list = ClassCrud.GetSpareParts(nplblk, hmodtyp, npl);
DetailsInNode details = ClassCrud.GetDetailsInNode(node_id, lang);
return(JsonConvert.SerializeObject(details));
});
//=========================================================================================
Get("/filters", args => {
string modelId = Request.Query["modelId"];
List <Filters> list = ClassCrud.GetFilters(modelId);
string json = JsonConvert.SerializeObject(list);
return(json);
});
Get("/filter-cars", args => {
List <header> headerList = ClassCrud.GetHeaders();
int page = Request.Query["page"];
int page_size = Request.Query["page_size"];
string paramStr = Request.Query["param"].Value;
string[] param = paramStr.Split(",");
string modelId = Request.Query["modelId"];
string ctrsmtyp = param[0];
string carea = param[1];
string nengnpf = param[2];
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfoFilterCars(modelId, ctrsmtyp, carea, nengnpf);
list = list.Skip((page - 1) * page_size).Take(page_size).ToList();
var result = new
{
headers = headerList,
items = list,
cntitems = list.Count,
page = page
};
string json = JsonConvert.SerializeObject(result);
return(json);
});
Get("/vehicle/sgroups", args => {
string vehicle_id = Request.Query["vehicle_id"];
string group_id = Request.Query["group_id"];
string lang = Request.Query["lang"];
List <Sgroups> list = ClassCrud.GetSgroups(vehicle_id, group_id, lang);
return(JsonConvert.SerializeObject(list));
});
Get("/locales", args => {
List <lang> list = ClassCrud.GetLang();
return(JsonConvert.SerializeObject(list));
});
Get("/vehicle/wmi", args => {
List <string> list = ClassCrud.GetWmi();
return(JsonConvert.SerializeObject(list));
});
Get("/vehicleAttr", args => {
string vehicle_id = Request.Query["vehicle_id"];
VehiclePropArr result = ClassCrud.GetVehiclePropArr(vehicle_id);
return(JsonConvert.SerializeObject(result));
});
Post("/vehicle/sgroups", args => {
string strCodes = Request.Query["codes"];
string strNodeIds = Request.Query["node_ids"];
string[] codes = strCodes.Split(",");
string[] node_ids = strNodeIds.Split(",");
List <node> list = ClassCrud.GetNodes(codes, node_ids);
return(JsonConvert.SerializeObject(list));
});
}
public static List <VehiclePropArr> GetListCarTypeInfo(string vin)
{
List <VehiclePropArr> VehicleList = new List <VehiclePropArr>();
if (!(String.IsNullOrEmpty(vin)) && (vin.Length == 17))
{
try
{
string nfrmpf = vin.Substring(0, 11);
string nfrmseqepc = vin.Substring(9, 8);
int h = 0;
// public int hmodtyp { get; set; } // hmodtyp 'Код типа автомобиля',
//public string cmodnamepc { get; set; } // cmodnamepc 'Модель автомобиля',
//public string xcardrs { get; set; } // xcardrs 'Кол-во дверей',
//public string dmodyr { get; set; } // dmodyr 'Год выпуска',
//public string xgradefulnam { get; set; } // xgradefulnam Класс
//public string ctrsmtyp { get; set; } // ctrsmtyp VARCHAR(3) NOT NULL COMMENT 'Тип трансмиссии',
//public string cmftrepc { get; set; } // cmftrepc 'Страна производитель',
//public string carea { get; set; } // carea 'Страна рынок',
#region strCommand
string strCommand = " SELECT DISTINCT " +
" pmotyt.hmodtyp, " +
" pmotyt.cmodnamepc, " +
" pmotyt.xcardrs, " +
" pmotyt.dmodyr, " +
" pmotyt.xgradefulnam, " +
" pmotyt.ctrsmtyp, " +
" pmotyt.cmftrepc, " +
" pmotyt.carea " +
" FROM pmodlt " +
" JOIN pmotyt " +
" ON(pmodlt.cmodnamepc = pmotyt.cmodnamepc " +
" AND pmodlt.dmodyr = pmotyt.dmodyr " +
" AND pmodlt.xcardrs = pmotyt.xcardrs), " +
" pmdldt "+
" WHERE(pmotyt.nfrmpf = @nfrmpf ) " +
" AND(pmotyt.nfrmseqepcstrt <= @nfrmseqepc ) " +
" AND(pmotyt.nfrmseqepcend >= @nfrmseqepc ) " +
" AND((NOT EXISTS(SELECT 1 " +
" FROM pmdldt " +
" WHERE pmdldt.cmodnamepc = pmodlt.cmodnamepc " +
" AND pmdldt.dmodyr = pmodlt.dmodyr " +
" AND pmdldt.xcardrs = pmodlt.xcardrs " +
" AND pmdldt.cmftrepc = pmodlt.cmftrepc) " +
" AND pmodlt.dmodlnch < now()) " +
" OR( " +
" EXISTS(SELECT 1 " +
" FROM pmdldt " +
" WHERE pmdldt.cmodnamepc = pmodlt.cmodnamepc " +
" AND pmdldt.dmodyr = pmodlt.dmodyr " +
" AND pmdldt.xcardrs = pmodlt.xcardrs " +
" AND pmdldt.cmftrepc = pmodlt.cmftrepc " +
" AND pmdldt.dmodlnch < now())))";
#endregion
using (IDbConnection db = new MySqlConnection(strConn))
{
List <CarTypeInfo> carTypeList = db.Query <CarTypeInfo>(strCommand, new { nfrmpf, nfrmseqepc }).ToList();
for (int i = 0; i < carTypeList.Count; i++)
{
List <attributes> list = GetAttributes();
list[0].value = carTypeList[i].cmodnamepc;
list[1].value = carTypeList[i].xcardrs;
list[2].value = carTypeList[i].dmodyr;
list[3].value = carTypeList[i].xgradefulnam;
list[4].value = carTypeList[i].ctrsmtyp;
list[5].value = carTypeList[i].cmftrepc;
list[6].value = carTypeList[i].carea;
VehiclePropArr item = new VehiclePropArr {
vehicle_id = carTypeList[i].hmodtyp.ToString(), model_name = carTypeList[i].cmodnamepc
};
item.attributes = list;
VehicleList.Add(item);
}
}
}
catch (Exception ex)
{
string Errror = ex.Message;
int o = 0;
}
}
return(VehicleList);
}
