Fermé

Customer Card Details

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.

Compétences : Programmation C#, .NET, Programmation C++, Programmation C, Architecture Logicielle

En voir plus : store credit card details virtuemart, oscommerce credit card details, cart customer shipping details registration, oscommerce customer details custom fields, create sql database customer order details code, view credit card details volusion, change key encryption credit card details, customer card design psd, oscommerce view credit card details authorizenet, verotel safe credit card details, magento credit card details, customer services crm data fields, validating credit card details joomla, free adult webcam chats without credit card details, extract credit card details website, joomla credit card details, ecommerce credit card details

Concernant l'employeur :
( 0 commentaires ) Jaipur, India

Nº du projet : #30612305

3 freelances font une offre moyenne de 617 ₹/heure pour ce travail

F2210655640

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、 Jav Plus

₹1000 INR / heure
(7 Commentaires)
2.6
GlobalSSPL

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 prope Plus

₹250 INR / heure
(0 Commentaires)
0.0
NamPT10

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 Plus

₹600 INR / heure
(0 Commentaires)
0.0