Simple Java WebService Server and Java Client Consumer.
Java WebService Server Functions:
A Loyalty Program has a MSSQL 2008 DATABASE with a TABLE NAMED [login to view URL] (CUSTOMER in english), this table has a record for every customer registered in the loyalty program. Customer earns points on every sales transaction, customers redeem their points every so often using they ID CARD.
We need a simple java web client program to connect to the remote server (where java webservice and db reside) to validate available points and/or consume (redeem) n points for a affiliate customer.
TABLE: [login to view URL]
ID or KEY = Field (NO_CLIENTE)
AVAILABLE POINTS = (PTOS_DISPONIBLES)
Each redemption transaction (redeemed points) shall be recorded in the "dbo.PUNTOS_REDIMIDOS" table.
TABLE: [login to view URL] (CUSTOMER)
===============================================================================
[dbo].[CLIENTES](
[ID_CLIENTE] [int] NOT NULL,
[NO_CLIENTE] [nchar](12) NOT NULL,
[NO_TARJETA] [nchar](12) NOT NULL,
[NOMBRE] [nchar](20) NOT NULL,
[APELLIDOS] [nchar](20) NOT NULL,
[DIRECCION] [nchar](60) NOT NULL,
[ID_SECTOR] [int] NOT NULL,
[TELEFONO] [nchar](15) NULL,
[CELULAR] [nchar](15) NULL,
[ID_GENERO] [int] NOT NULL,
[ID_ESTADO_CIVIL] [int] NOT NULL,
[CORREO_E] [nchar](40) NULL,
[ID_TIENDA] [int] NOT NULL,
[ID_OCUPACION] [int] NOT NULL,
[ID_NIVEL_EDUCACION] [int] NOT NULL,
[FECHA_NACIMIENTO] [date] NOT NULL,
[FECHA_AFILIACION] [date] NOT NULL,
[TOTAL_PTOS_GANADOS] [int] NOT NULL,
[TOTAL_PTOS_REDIMIDOS] [int] NOT NULL,
[TOTAL_PTOS_VENCIDOS] [int] NOT NULL,
[TOTAL_COMPRAS] [decimal](12, 2) NOT NULL,
[CANTIDAD_VISITAS] [int] NOT NULL,
[FECHA_ULT_COMPRA] [date] NULL,
[PTOS_GANADOS] [int] NOT NULL,
[PTOS_REDIMIDOS] [int] NOT NULL,
[PTOS_VENCIDOS] [int] NOT NULL,
[PTOS_DISPONIBLES] [int] NOT NULL,
[COMPRAS] [decimal](12, 2) NOT NULL,
[FECHA_ULT_REDENCION] [date] NULL,
[USUARIO] [nchar](10) NOT NULL,
[FECHAHORA] [datetime] NOT NULL,
[INACTIVO] [char](1) NULL,
[EMPLEADO] [char](1) NULL)
===============================================================================
[dbo].[PUNTOS_REDIMIDOS](
[NO_CLIENTE] [nchar](12) NOT NULL,
[ID_TIENDA] [int] NOT NULL,
[ID_TERMINAL] [int] NOT NULL,
[TRANSACCION] [int] NOT NULL,
[FECHA] [date] NOT NULL,
[PUNTOS] [int] NOT NULL,
[PERIODO] [char](4) NOT NULL,
[USUARIO] [nchar](10) NOT NULL,
[FECHAHORA] [datetime] NOT NULL,
CONSTRAINT [PK_REDENCION_1] PRIMARY KEY CLUSTERED
(
[NO_CLIENTE] ASC,
[ID_TIENDA] ASC,
[ID_TERMINAL] ASC,
[TRANSACCION] ASC,
[FECHA] ASC
)
===============================================================================
REDEEM PROCEDURE
==================
JAVA WEB CLIENT WILL SEND (Customer Number (NO_CLIENTE), Store ID (TIENDA_ID), Pos Number
(ID_TERMINAL), Transaction Number (TRANSACTION), Amount of Points to REDEEM and the JAVA WEBSERVICE will validate information and available points agains table [login to view URL] (field PTOS_DISPONIBLES). If OK, the WEBSERVE will update the available points (field PTOS_DISPONIBLES) and registered the amount of redeem points in (dbo.PUNTOS_REDIMIDOS) table, it also will return OK to the JAVA WEBSERVICE CLIENT.
CONSULTING PROCEDURE
======================
JAVA WEB CLIENT WILL SEND (Customer Number(NO_CLIENTE)) and the JAVA WEBSERVICE will return back the available points to the JAVA WEBSERVICE CLIENT.
JAVA WEBSERVICE PROGRAM must run as a WINDOWS SERVICE in the remote server where the database reside.
JAVA CLIENT COULD USE AXIS or other implementations.
Thanks
Hello,
My name is David, I'm from Argentina and Spanish is my native language.
I can help you with your Java client. I have a los of experience with Java Apps. I can make the app in one day I think,.
I am Computer System Engineer wiht +12 years of experience.
I will be waiting your response.
Regads,
Dave
$84 USD en 7 días
5,0 (1 comentario)
0,0
0,0
11 freelancers están ofertando un promedio de $196 USD por este trabajo
Hello Sir,
I am very good developer of JAVA and MS SQL,
I have more then 1 year experience of JAVA and MS SQL,
I will done your project in very short time and in very less cost to the other,
I hope you can trust me and award me this project,
If you have any Querry about my skill then ask me in Massage,
i have already demo of your project,come in the inbox then i will send you the images and runing file,
Thanks Sir
Hello,
Before you select a part time developer from here, take a look at our portfolio: fugacode.com. If you like what you see, contact us. That's all.
"Why hire part time college students? when you can hire professional developers for the same cost"
Regards,
FUGACODE Team
PS: Freelancer milestone system is used.
Hi, I am an experienced java proffessional expert in core java j2ee spring mvc hibernate orm webservices. I can do this. Pls contact for further progress.
I do not have that much experience with SQL; just a bit with PHP. I have, however, done many things with Java's networking API so I might be able to help you there (have done several multiplayer-oriented games in the past). Might take a while but shouldn't be too difficult. Would have no problem working on this with someone else.
hey I have good knowledge of SQL as well as JAVA. I created the same project for one of my client. I already have same prepared project. All I need only 2-3 days time to change and shape it according to your requirement. I can show you its demos now.
Hello Sir,
I read your job description very carefully and I believe I am very qualified for your project.
I can start your project immediately and finish your project successfully within given time with high quality.
I have experience for 5 years. I can do your project smart and easy.
I look forward to working with you.
Thanks !
Dear Sir, Good Day! I am TOP RANKED Programmer on this site with 10+ years of experience! I have done 700+ projects! Please award me your project! Best Regards!
Hi, I have total 5.8 yrs exp in Java/J2EE , Webservices and Database. I can also provide use case diagrams like Sequence diagrams, class diagrams and can also provide JUnits too.
I have read your requirements. I think of developing a Rest service in server side and make it a windows service. Then the java web client will consume this service easily. I have experience in Java for more than 5 years and can start working now. Thanks.
Dear Sir
This is more than 11 years experienced team and very interested to work in your project
Could you please share more details to be able put the accurate bidding and estimation
Thank you and willing to hear from you soon