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 static DetailsInNode GetDetailsInNode(string node_id, string lang = "EN")
{
string npl = node_id.Substring(0, node_id.IndexOf("_"));
string nplblk = node_id.Substring(node_id.IndexOf("_") + 1);
DetailsInNode detailsInNode = new DetailsInNode {
node_id = node_id
};
string strCommand = " SELECT " +
" pp.xplblk " +
" FROM " +
" pl_pbldst pp " +
" WHERE " +
" pp.npl = @npl " +
" AND pp.nplblk = @nplblk " +
" AND pp.clangjap = @lang; ";
string strCommDeatil = " SELECT " +
" pp.hpartplblk number, " +
" p.xpartext name " +
" FROM " +
" pl_pblpat pp " +
" LEFT JOIN pl_ppartt p ON pp.npartgenu = p.npartgenu " +
" AND pp.disc_no = p.disc_no " +
" WHERE " +
" pp.npl = @npl " +
" AND " +
" pp.nplblk = @nplblk ; ";
try
{
using (IDbConnection db = new MySqlConnection(strConn))
{
detailsInNode.name = db.Query <string>(strCommand, new { npl, nplblk, lang }).FirstOrDefault();
detailsInNode.parts = db.Query <Detail>(strCommDeatil, new { npl, nplblk }).ToList();
}
images images = new images {
id = nplblk, ext = ".png"
};
List <images> listImages = new List <images>();
listImages.Add(images);
detailsInNode.images = listImages;
for (int i = 0; i < detailsInNode.parts.Count; i++)
{
detailsInNode.parts[i].hotspots = GetHotspots(node_id);
}
}
catch (Exception ex)
{
string Error = ex.Message;
int y = 0;
}
return(detailsInNode);
}
[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 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 DetailsInNode GetDetailsInNode(string vehicle_id, string node_id, string lang = "EN")
{
DetailsInNode detailsInNode = new DetailsInNode {
node_id = node_id
};
string imgPath = Ut.GetImagePath();
string strCommand = " SELECT DISTINCT pbldst.xplblk " +
" FROM " +
" pbldst " +
" WHERE pbldst.id = @node_id ";
string strCommDeatil = " SELECT DISTINCT " +
" ppartt.npartgenu number, " +
" ppartt.xpartext name, " +
" pblpat.npl, " +
" pblpat.nplblk, " +
" pblpat.nplpartref " +
" FROM pblpat " +
" join ppartt on(ppartt.clangjap IN (SELECT DISTINCT lang.clangjap FROM lang WHERE lang.code = @code ) " +
" and ppartt.npartgenu = pblpat.npartgenu) " +
" join ppasat on(ppartt.npartgenu = ppasat.npartgenu) " +
" left outer join pbprmt on(pbprmt.hpartplblk = pblpat.hpartplblk " +
" and pbprmt.clangjap IN(SELECT DISTINCT lang.clangjap FROM lang WHERE lang.code = @code )) " +
" WHERE pblpat.npl IN(SELECT DISTINCT npl FROM pbldst WHERE pbldst.id = @node_id) AND " +
" pblpat.nplblk IN(SELECT DISTINCT nplblk FROM pbldst WHERE pbldst.id = @node_id) AND " +
" ((EXISTS(SELECT pb.hmodtyp " +
" FROM pbpmtt AS pb " +
" WHERE pb.hpartplblk = pblpat.hpartplblk AND " +
" pb.hmodtyp IN(@vehicle_id))) OR " +
" ((NOT EXISTS(SELECT pb.hmodtyp " +
" FROM pbpmtt AS pb " +
" WHERE pb.hpartplblk = pblpat.hpartplblk)) " +
" AND " +
" (EXISTS(SELECT pb.hmodtyp " +
" FROM pblmtt AS pb " +
" WHERE pb.npl = pblpat.npl AND " +
" pb.nplblk = pblpat.nplblk AND " +
" pb.hmodtyp IN( @vehicle_id ))))); ";
string strCommImages = " SELECT DISTINCT CONCAT(pbldst.npl, '_', pbldst.nplblk, '-png') image_id, '.png' ext, " +
$" CONCAT( '{imgPath}', pbldst.npl, '/' , 'IMGE/', pbldst.nplblk, '.png') path " + // // pbldst.npl, 'IMGE+',
" FROM pbldst WHERE " +
" pbldst.nplblk IN ( SELECT DISTINCT nplblk FROM pbldst WHERE pbldst.id = @node_id ) " +
" AND pbldst.npl IN ( SELECT DISTINCT npl FROM pbldst WHERE pbldst.id = @node_id ) " +
$" AND pbldst.clangjap IN ({getLang}) ; ";
try
{
using (IDbConnection db = new MySqlConnection(strConn))
{
detailsInNode.name = db.Query <string>(strCommand, new { node_id, code = lang }).FirstOrDefault();
detailsInNode.parts = db.Query <Detail>(strCommDeatil, new { vehicle_id, node_id, code = lang }).ToList();
detailsInNode.images = db.Query <images>(strCommImages, new { node_id, code = lang }).ToList();
}
for (int i = 0; i < detailsInNode.parts.Count; i++)
{
detailsInNode.parts[i].hotspots = GetHotspots(detailsInNode.parts[i].nplblk, detailsInNode.parts[i].npl, detailsInNode.parts[i].nplpartref);
}
}
catch (Exception ex)
{
string Error = ex.Message;
int y = 0;
}
return(detailsInNode);
}
public static DetailsInNode GetDetailsInNode(string vehicle_id, string node_id, string lang = "EN")
{
string npl = node_id.Substring(0, node_id.IndexOf("_"));
string nplblk = node_id.Substring(node_id.IndexOf("_") + 1, node_id.Length - (node_id.IndexOf("_") + 1));
DetailsInNode detailsInNode = new DetailsInNode {
node_id = node_id
};
string strCommand = " SELECT DISTINCT pbldst.xplblk " +
" FROM " +
" pbldst " +
" WHERE " +
" pbldst.npl = @npl " +
" AND pbldst.nplblk = @nplblk " +
$" AND pbldst.clangjap IN ({getLang}) " +
" LIMIT 1; ";
string strCommDeatil = " SELECT p.hpartplblk number, " +
" p2.xpartext name " +
" FROM pblpat p " +
" LEFT JOIN ppartt p2 " +
" ON p.npartgenu = p2.npartgenu " +
" LEFT JOIN pbprmt deskr ON " +
" p.hpartplblk = deskr.hpartplblk " +
$" WHERE p2.clangjap IN ({getLang}) AND " +
" p.nplblk = @nplblk AND " +
" p.hpartplblk IN " +
" (SELECT pbpmtt.hpartplblk FROM pbpmtt " +
" WHERE pbpmtt.hmodtyp = @vehicle_id ); ";
string strCommImages = " SELECT DISTINCT pbldst.nplblk id, '.png' ext " +
" FROM pbldst WHERE " +
" pbldst.npl = @npl " +
" AND pbldst.nplblk = @nplblk " +
$" AND pbldst.clangjap IN ({getLang}) ; ";
try
{
using (IDbConnection db = new MySqlConnection(strConn))
{
detailsInNode.name = db.Query <string>(strCommand, new { npl, nplblk, code = lang }).FirstOrDefault();
detailsInNode.parts = db.Query <Detail>(strCommDeatil, new { nplblk, vehicle_id, code = lang }).ToList();
detailsInNode.images = db.Query <images>(strCommImages, new { npl, nplblk, code = lang }).ToList();
}
List <hotspots> hotspots = GetHotspots(nplblk, npl);
for (int i = 0; i < detailsInNode.parts.Count; i++)
{
detailsInNode.parts[i].hotspots = hotspots;
}
}
catch (Exception ex)
{
string Error = ex.Message;
int y = 0;
}
return(detailsInNode);
}
