Find Jobs
Hire Freelancers

C# Class to add and remove items from a MSSQL database

$30-50 USD

Terminado
Publicado hace más de 16 años

$30-50 USD

Pagado a la entrega
Attached is the class I want implemented. AddItem and RemoveItem need to validate the input the receive. string item should always start with 4-5 digits followed by a possible dot(.). If the dot is found then there will be 1-2 digits after it. Finally there will be 1-2 capitol letters. string shelf should always start with a Letter followed by 1-3 digits int quan should be a positive number. If any of these values don't validate correctly a form should be displayed with the files filled in and the errors marked. The user should then be able to correct the errors in this form and click submit. This form will then be validated and if it passes the program will move on. If it doesn't pass then the errors will be marked and the user will have to correct before moving on. For AddItem: Once the item, shelf, and quan pass validation a query needs to be issued to select Part, Shelf, Quan from Overstock where Part = 'item' and Shelf like 'shelf%' If the item doesn't exist add it (insert into Overstock (Part, Shelf, Quan) values ('item', 'shelf-1', quan)) If the item does exist add it with the number after the dash being one higher then the highest returned number. (if the shelf is A32-2 add it with A32-3). Return true if you succeeded. Try up to 5 times if there is an error and after the fifth failure display the error. Return false if it never succeeded. Please see the attached Word doc for the rest as RAC says it's too long to post here... ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform VS 2005, C#
ID del proyecto: 3466068

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 16 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
See private message.
$38,25 USD en 5 días
5,0 (63 comentarios)
5,0
5,0
3 freelancers are bidding on average $37 USD for this job
Avatar del usuario
See private message.
$38,25 USD en 5 días
5,0 (4 comentarios)
0,2
0,2
Avatar del usuario
See private message.
$34 USD en 5 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
United States
5,0
414
Forma de pago verificada
Miembro desde dic 14, 2004

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.