Master: Customer card detail
Fields:
Id :- 20 char size
Card Details: 16 char size
Card Validation from date
Card Validate to date
Status- active and expired
CustAccountNum from custtable
Standard Tables: salesTable custinvoicejour CustPackingSlipJour
Task:
1) 5 record insert using code
2) Valid from date should be less than current date.
3) To date logic: Should be more than current date. If a card todate is less than current date then update status to expired.
4) Create job for updating status
5) Update data
a) Update card num in SalesTable for customer which is having currently active card and cust id should match. Select only top 5 records
b) Update card num in CustInvoiceJour table. Which is available in SalesTable.
c) Update card num and customerref in CustPackingSlipJour table Which is available in salesTable.
6) Delete Data
a) Delete any 2 expired record which are having status expired for card.
Hello. I reviewed your request carefully. I can complete your task.
I have 10 years of c# development experience. I am familiar with php、wordpress.
SQL、asp.net、mvc、.net core、 html、 css、React、vue、angular、 jquery、 JavaScript and can develop web pages and desktop programs.
I can complete your tasks quickly and with high quality.
There are some examples in my introduction.
if you think it is appropriate Please contact me.
Hello,
Ready To Work on Your Project.
I Won’t Waste Your Time with Generic Proposals I would suggest arranging our first voice or video call. This call will help you ask me questions to make sure that I have the proper technical knowledge to complete this project. Our Skills and Expertise consists of the following: - .NET - C# Programming - Software Architecture
Regards,
SSPL
P.S: We will keep working until you are satisfied!
Hello, I have more than 4 years to working with .NET/.NET Core framework, SQL Server, ... So if you have interested, please contact me via my email or skype: live:fsthanhnamsf to discuss more about your project. Thanks.