Posts

Showing posts from October, 2019

Change Autorization of PDM Client

Image
Go to Administrator Program of PDM Client Go to Menu :: Help > About  Solidwork PDM Administrator Change Client Type and Press OK Log off and Login again.

WebApi Concept

Image
API Description Request body Response body GET /api/TodoItems Get all to-do items None Array of to-do items GET /api/TodoItems/{id} Get an item by ID None To-do item POST /api/TodoItems Add a new item To-do item To-do item PUT /api/TodoItems/{id} Update an existing item   To-do item None DELETE /api/TodoItems/{id}     Delete an item     None None Credit by  https://docs.microsoft.com/th-th/aspnet/core/tutorials/first-web-api?view=aspnetcore-3.0&tabs=visual-studio

Weekday Algorithm

select getdate() as 'Current Date' ,datepart(dw,getdate()) as 'Day of Week (Sun=1)' ,dateadd(day,-(datepart(dw,getdate()) - 1),getdate()) as 'FirstDay'  ,dateadd(day,(7 - datepart(dw,getdate())),getdate()) as 'EndDay'