public IActionResult GetSpareParts(string vehicle_id, string group_id, string lang)
{
// List<SpareParts> list = ClassCrud.GetSpareParts(nplblk, hmodtyp); // "B__0100", 1667
DetailsInNode detailsInNode = ClassCrud.GetDetailsInNode(vehicle_id, group_id, lang);
return(Json(detailsInNode));
}
public IActionResult GetFilters(string modelId)
{
// List<Filters> list = ClassCrud.GetFilters("CIVIC", "4", "1982", "JH");
List <Filters> list = ClassCrud.GetFilters(modelId); // "CIVIC", "4", "1982", "JH"
return(Json(list));
}
public IActionResult GetListCarTypeInfoFilterCars(int modelId, string [] param, int page = 1, int page_size = 10, string lang = "EN")
{
if (param.Length == 5)
{
List <header> headerList = ClassCrud.GetHeaders();
string body = param[0];
string modification = param[1];
string door = param[2];
string transmission = param[3];
string engine = param[4];
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfoFilterCars(modelId, body, modification, door, transmission, engine, lang); //
list = list.Skip((page - 1) * page_size).Take(page_size).ToList();
var result = new
{
headers = headerList,
items = list,
cntitems = list.Count,
page = page
};
return(Json(result));
}
return(NotFound("Проверьте параметры запроса!"));
}
public IActionResult GetListCarTypeInfoFilterCars(string modelId, string [] param, int page = 1, int page_size = 10)
{
if (param.Length == 3)
{
List <header> headerList = ClassCrud.GetHeaders();
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
};
return(Json(result));
}
return(NotFound("Проверьте параметры запроса!"));
}
[Route("/filters")] // [FromQuery] and [FromRoute]
public IActionResult GetFilters(string model_id, [FromQuery(Name = "params[0]")] string xcardrsP, [FromQuery(Name = "params[1]")] string dmodyrP,
[FromQuery(Name = "params[2]")] string xgradefulnamP, [FromQuery(Name = "params[3]")] string ctrsmtypP, [FromQuery(Name = "params[4]")] string cmftrepcP,
[FromQuery(Name = "params[5]")] string careaP, [FromQuery(Name = "params[6]")] string nengnpfP)
{
List <Filters> list = ClassCrud.GetFilters(model_id, xcardrsP, dmodyrP, xgradefulnamP, ctrsmtypP, cmftrepcP, careaP, nengnpfP);
return(Json(list));
}
public IActionResult GetListNotes(int partslist_number)
{
List <notes> list = ClassCrud.GetListNotes(partslist_number);
if (list == null)
{
return(Ok("Ошибка в запросе!"));
}
return(Json(list));
}
public IActionResult GetVehiclePropArr(string vehicle_id)
{
try
{
VehiclePropArr result = ClassCrud.GetVehiclePropArr(vehicle_id);
return(Json(result));
}
catch (Exception ex)
{
return(NotFound(ex.Message));
}
}
[Route("/vehicle/{vehicle_id:required}/sgroups/{node_id:required}")] //
public IActionResult GetSpareParts(string vehicle_id, string node_id)
{
string lang = "EN";
if (!String.IsNullOrEmpty(Request.Headers["lang"].ToString()))
{
lang = Request.Headers["lang"].ToString();
}
DetailsInNode detailsInNode = ClassCrud.GetDetailsInNode(vehicle_id, node_id, lang);
return(Json(detailsInNode));
}
public IActionResult GetPartsGroups(string vehicle_id)
{
string lang = "EN";
if (!String.IsNullOrEmpty(Request.Headers["lang"].ToString()))
{
lang = Request.Headers["lang"].ToString();
}
List <PartsGroup> list = ClassCrud.GetPartsGroup(vehicle_id, lang);
return(Json(list));
}
public IActionResult CodesForTree(string vehicle_id)
{
string lang = "EN";
if (!String.IsNullOrEmpty(Request.Headers["lang"].ToString()))
{
lang = Request.Headers["lang"].ToString();
}
List <string> list = ClassCrud.CodesForTree(vehicle_id, lang);
return(Json(list));
}
public IActionResult GetListCarTypeInfo(string body_code, string body_num, string lang)
{
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfo(body_code, body_num, lang);
List <header> headerList = ClassCrud.GetHeaders();
var result = new
{
headers = headerList,
items = list,
cntitems = list.Count,
page = 1
};
return(Json(result));
}
public IActionResult GetListCarTypeInfo(string vin)
{
List <VehiclePropArr> list = ClassCrud.GetListCarTypeInfo(vin); // JHMED73600S205949
List <header> headerList = ClassCrud.GetHeaders();
var result = new
{
headers = headerList,
items = list,
cntitems = list.Count,
page = 1
};
return(Json(result));
}
public IActionResult GetSgroups(string vehicle_id, string group_id, string[] codes, string[] node_id, [FromBody] codePost n1)
{
VehicleStruct_ID vs = new VehicleStruct_ID(vehicle_id);
//string catalog =
//string catalog_code,
//string part_group,
//string compl_code,
#region lang
string lang = "EN";
if (!String.IsNullOrEmpty(Request.Headers["lang"].ToString()))
{
lang = Request.Headers["lang"].ToString();
}
#endregion
if (!String.IsNullOrEmpty(group_id))
{
string part_group = group_id.Substring(group_id.LastIndexOf("_") + 1, group_id.Length - (group_id.LastIndexOf("_") + 1));
List <Sgroups> list = ClassCrud.GetSgroups(vs.catalog, vs.catalog_code, part_group, vs.compl_code, lang);
return(Json(list));
}
// else if ((codes != null && codes.Length > 0) || (node_id != null && node_id.Length > 0))
else if (n1 != null)
{
string part_group = string.Empty;
for (int i = 0; i < n1.codes.Length; i++)
{
if (i == 0)
{
part_group += "'" + n1.codes[i] + "'";
}
else
{
part_group += ", '" + n1.codes[i] + "'";
}
}
List <Sgroups> list = ClassCrud.GetSgroups(vs.catalog, vs.catalog_code, part_group, vs.compl_code, lang);
return(Json(list));
}
return(NotFound("Проверте параметры!"));
}
public IActionResult GetListCarTypeInfo(string vin, int page = 1, [FromQuery(Name = "per-page")] int qty = 10)
{
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfo(vin);
List <header> headerList = ClassCrud.GetHeaders(8);
List <CarTypeInfo> items = list.Skip((page - 1) * qty).Take(qty).ToList();
var result = new
{
header = headerList,
items,
cnt_items = list.Count,
page
};
return(Json(result));
}
public IActionResult GetListCarTypeInfoFilterCars(string model_id, [FromQuery(Name = "params[]")] string[] param, string brand_id = "TOYOTA", int page = 1, int page_size = 10)
{
List <header> headerList = ClassCrud.GetHeaders(8);
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfoFilterCars(model_id, param, brand_id); //
int count = list.Count;
list = list.Skip((page - 1) * page_size).Take(page_size).ToList();
var result = new
{
header = headerList,
items = list,
cnt_items = count,
page = page
};
return(Json(result));
}
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 IActionResult GetSgroups(string vehicle_id, string group_id, string[] codes, string[] node_id)
{
#region lang
string lang = "EN";
if (!String.IsNullOrEmpty(Request.Headers["lang"].ToString()))
{
lang = Request.Headers["lang"].ToString();
}
#endregion
if (!String.IsNullOrEmpty(group_id)) // 7.1
{
List <Sgroups> list = ClassCrud.GetSgroups(vehicle_id, group_id, lang);
return(Json(list));
}
else if ((codes != null && codes.Length > 0) || (node_id != null && node_id.Length > 0)) // 7.2
{
List <node> list = ClassCrud.GetNodes(codes, node_id);
return(Json(list));
}
return(NotFound("Проверте параметры!"));
}
public IActionResult GetListCarTypeInfoFilterCars(string model_id, [FromQuery(Name = "params[0]")] string xcardrsP,
[FromQuery(Name = "params[1]")] string dmodyrP,
[FromQuery(Name = "params[2]")] string xgradefulnamP,
[FromQuery(Name = "params[3]")] string ctrsmtypP,
[FromQuery(Name = "params[4]")] string cmftrepcP,
[FromQuery(Name = "params[5]")] string careaP,
[FromQuery(Name = "params[6]")] string nengnpfP,
int page = 1, int page_size = 10)
{
List <header> headerList = ClassCrud.GetHeaders();
List <CarTypeInfo> list = ClassCrud.GetListCarTypeInfoFilterCars(model_id, xcardrsP, dmodyrP, xgradefulnamP, ctrsmtypP, cmftrepcP, careaP, nengnpfP);
list = list.Skip((page - 1) * page_size).Take(page_size).ToList();
var result = new
{
header = headerList,
items = list,
cnt_items = list.Count,
page = page
};
return(Json(result));
}
public IActionResult GetWmi()
{
List <string> list = ClassCrud.GetWmi();
return(Json(list));
}
public IActionResult GetFilters(int modelId, string lang)
{
List <Filters> list = ClassCrud.GetFilters(modelId, lang);
return(Json(list));
}
public IActionResult GetSgroups(string catalog, int pos, int size, string lang = "EN")
{
List <Sgroups> list = ClassCrud.GetSgroups(catalog, pos, size, lang);
return(Json(list));
}
public IActionResult GetSpareParts(int group_id, int vehicle_id, string lang)
{
List <SpareParts> list = ClassCrud.GetSpareParts(group_id, vehicle_id, lang);
return(Json(list));
}
public IActionResult GetPartsGroups(int pos, string lang)
{
List <PartsGroup> list = ClassCrud.GetPartsGroup(pos, lang);
return(Json(list));
}
public IActionResult GetModels(string lang)
{
List <ModelCar> list = ClassCrud.GetModelCars(lang);
return(Json(list));
}
public IActionResult GetNodes(string[] codes, string[] node_ids)
{
List <node> list = ClassCrud.GetNodes(codes, node_ids);
return(Json(list));
}
public IActionResult GetYearIssue(int xcardrs, string cmodnamepc)
{
List <string> list = ClassCrud.GetYearIssue(xcardrs, cmodnamepc);
return(Json(list));
}
public IActionResult GetLang()
{
List <lang> list = ClassCrud.GetLang();
return(Json(list));
}
public IActionResult GetSgroups(string vehicle_id, string group_id, string code_lang = "EN")
{
List <Sgroups> list = ClassCrud.GetSgroups(vehicle_id, group_id, code_lang);
return(Json(list));
}
public IActionResult GetPartsGroups(string vehicle_id)
{
List <PartsGroup> list = ClassCrud.GetPartsGroup(vehicle_id);
return(Json(list));
}
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));
});
}
