Budget:	$ 100-300
Status:	Closed for Bidding (selected user maxdev)
Project Creator:	mhortman
	4 reviews
Required Skills:	Programming, Visual Basic .Net
Attached Files:	(None)

NEW	SEND	DISCUSS	CONTACT	OPTIONS

Description
Need VB.Net program written with the following inputs
D is Number 0-9


Stock Number(SN): format D[A-Z]DDDD Example 7J01234
Yard Location (YL): (Format) YDDDADDD Example Y101A034
Dismantlers Initials(DI) : [A-Z]\d Example MDH
Inventory Initials (II): [A-Z]\d Example MDH


And an accept button:
1.) After the Accept button is pushed and all Stored procedures and updates are run and no errors occur. Program will clear out the StockNumber, YardLocation, and Dismanters initials and leave Inventory Initials the same.

The Accept button will
Find all inventory with the StockNumber = SN that has QuantityAvailable > 0

Then peform the following checks on each part:
If CategoryCode = Y and locationCode = DI, Change LocationCode = YL
If CategoryCode = U and locationcode = DI, Change Location = “INV”
Change DateAquired to todays Date
Change DismantledBy = EmployeeID (of Dismantler)
Change Inventoriedby = EmployeeID (of Inventory)

If CategoryCode = Y, change retail and wholesale prices to $0.

There are two tables to deal with in this program.
Inventory And Employee
The Employee table is only used to map the Initials that are typed in to the EmployeeID


The Inventory Retail and wholesale prices are changed via a stored procedure:
create procedure dbo.setpartwholesaleprice
(
@InventoryID int,
@WholesalePrice money,
@ModifiedByEmployee int,
@ReasonForChange varchar(99)
)

create procedure dbo.setpartretailprice
(
@InventoryID int,
@RetailPrice money,
@ModifiedByEmployee int,
@ReasonForChange varchar(99)
)
The ModifiedByEmployee will be the EmployeeID of Inventory
The reason for change will be Inventory Script




CREATE TABLE [dbo].[INVENTORY] (
[InventoryID] [int] NOT NULL ,
[InventoryNumber] [inventorynumber] NOT NULL ,
[ModelYear] [smallint] NULL ,
[ModelName] [char] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CategoryCode] [categorycode] NOT NULL ,
[StockTicketNumber] [stockticketnumber] NULL ,
[CategorizingStoreNumber] [int] NOT NULL ,
[PurchaseOrderLineItemID] [int] NULL ,
[CategorizingYardNumber] [int] NOT NULL ,
[PurchaseOrderID] [int] NULL ,
[SourceVehicleStoreNumber] [int] NULL ,
[SourceVehicleYardNumber] [int] NULL ,
[PartType] [int] NOT NULL ,
[PrivacyIndicator] [boolean] NOT NULL ,
[LocationCode] [locationcode] NULL ,
[PrimaryARADamageCode] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SecondaryARADamageCode] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ConditionsAndOptions] [conditionsandoptions] NULL ,
[WarrantyInfo] [varchar] (36) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PartNotes] [notes] NULL ,
[ImageFile] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PrintTags] [boolean] NOT NULL ,
[InterchangeNumber] [char] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AlphaExt] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LeftRightCode] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AlternateNumberIndicator] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DirectionOfRetailPriceChange] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DirectionOfWholesalePriceChange] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[AssociatedTagNumber] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[PartRating] [type] NULL ,
[InterchangeApplication] [varchar] (99) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[InventoriedDate] [datetime] NOT NULL ,
[DateRetailLastChanged] [datetime] NULL ,
[DateWholesaleLastChanged] [datetime] NULL ,
[ValuePricedDate] [datetime] NULL ,
[DateAcquired] [datetime] NULL ,
[ConditionCode] [conditioncode] NULL ,
[QuantityAvailable] [quantity] NOT NULL ,
[QuantityQuoted] [quantity] NOT NULL ,
[QuantityOnHold] [quantity] NOT NULL ,
[InventorierID] [int] NULL ,
[DismantlerID] [int] NULL ,
[Mileage] [int] NULL ,
[RetailPrice] [money] NOT NULL ,
[WholesalePrice] [money] NOT NULL ,
[CostPrice] [money] NOT NULL ,
[ValuePrice] [money] NOT NULL ,
[IsRowReusable] [boolean] NOT NULL ,
[LogAsLocalInventory] [boolean] NOT NULL ,
[APGGraded] [boolean] NOT NULL ,
[DamageReported] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UnitsOfDamage] [decimal](3, 1) NOT NULL ,
[HasImages] [boolean] NOT NULL ,
[DateBPGGraded] [datetime] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[EMPLOYEE] (
[EmployeeID] [int] NOT NULL ,
[EmployeeName] [contact] NOT NULL ,
[Password] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[EmployeeInitials] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LoginName] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[Address1] [address] NULL ,
[Address2] [address] NULL ,
[City] [city] NULL ,
[StateOrProvince] [stateorprovince] NULL ,
[PostalCode] [postalcode] NULL ,
[Phone] [phonenumber] NULL ,
[OtherPhone] [phonenumber] NULL ,
[EmergencyContact] [contact] NULL ,
[SSN] [ssn] NULL ,
[JobType] [type] NULL ,
[TerminationType] [type] NULL ,
[PayType] [type] NULL ,
[PayFrequency] [type] NULL ,
[HireDate] [datetime] NULL ,
[DOB] [datetime] NULL ,
[ReviewDate] [datetime] NULL ,
[TerminationDate] [datetime] NULL ,
[PasswordChanged] [datetime] NULL ,
[DisplayNonExactInterchange] [boolean] NOT NULL ,
[LogActivity] [boolean] NOT NULL ,
[DisplayQuotes] [boolean] NOT NULL ,
[DisplayActivityDetail] [boolean] NOT NULL ,
[CustomerNumber] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CustomerYardNumber] [int] NULL ,
[DisplayNonExactMessage] [boolean] NOT NULL ,
[DisplayStoplights] [boolean] NOT NULL ,
[DisplayOrderIcons] [boolean] NOT NULL ,
[GUILanguage] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO


Part will be updated via

create procedure dbo.updatepart
(
@InventoryID int,
@InventoryNumber inventorynumber,
@CategoryCode categorycode,
@StockTicketNumber stockticketnumber,
@PrivacyIndicator boolean,
@LocationCode locationcode,
@PrimaryARADamageCode char(3),
@SecondaryARADamageCode char(3),
@ConditionsAndOptions conditionsandoptions,
@WarrantyInfo varchar(36),
@PartNotes notes,
@ModelName modelname,
@ImageFile varchar(255),
@PrintTags boolean,
@InterchangeNumber char(5),
@AlphaExt char(2),
@LeftRightCode char(1),
@AlternateNumberIndicator char(1),
@AssociatedTagNumber varchar(20),
@PartRating type,
@InterchangeApplication varchar(99),
@InventoriedDate datetime,
@DateAcquired datetime,
@ConditionCode conditioncode,
@CategorizingStoreNumber int,
@CategorizingYardNumber int,
@SourceVehicleStoreNumber int,
@SourceVehicleYardNumber int,
@PartType int,
@InventorierID int,
@DismantlerID int,
@ModelYear modelyear,
@Mileage int,
@IsRowReusable boolean,
@LogAsLocalInventory boolean,
@PurchaseOrderID int,
@PurchaseOrderLineItemID int,
@ModifiedByEmployee int,
@ReasonForChange varchar(99),
@APGGraded boolean,
@DamageReported varchar(255),
@UnitsOfDamage decimal(3,1),
@GradingMethod VARCHAR(10)
)

Reminder
You may not start working in this and any project before your bid is accepted. Any user who violates this policy may have their account permanently suspended.

Bids Received (7)   Shortlist (7)   Declined Bids (0)    Average bid amount:   $238.57   Average delivery time:   8 Day(s)

Place Bid | Post Similar Project | Send Project | Message Board(0) | Contact mhortman Order by: Rating Bid sum Bid date

Remember that contacting the other party outside the site (by email, phone, etc.) on all business projects (before the project is awarded) is a violation of our terms of use. We supervise all site activity for such infringements and can immediately expel transgressors on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thank you for your help.

nbsp;

maxdev   Hannover, DE location US$200 bid amount (193 reviews) feedback 8 day(s) delivery time     this can be done. (maxdev) Bid Time: 12-05-2007 15:05

De-Shortlist Decline Bid    TechnoVilla   Dhaka, BD location US$175 bid amount (183 reviews) feedback 7 day(s) delivery time     plz check pmb Bid Time: 12-05-2007 16:25

De-Shortlist Decline Bid    ravian   Lahore, PK location US$500 bid amount (59 reviews) feedback 10 day(s) delivery time     Lets Start Bid Time: 12-05-2007 14:44

De-Shortlist Decline Bid hummadhassan   Lahore, PK location US$150 bid amount (22 reviews) feedback 6 day(s) delivery time     Good Day Sir Please See The Private Message For Details Thanks. Bid Time: 12-05-2007 16:20

De-Shortlist Decline Bid hatim   Udaipur, IN location US$120 bid amount (3 reviews) feedback 2 day(s) delivery time     Please see PM. Thanks. Bid Time: 12-05-2007 16:17

De-Shortlist Decline Bid JasonGames   Savanna, US location US$250 bid amount (1 reviews) feedback 10 day(s) delivery time     Hi, I can do this for you without a problem. Please review your PM Bid Time: 12-05-2007 14:50

De-Shortlist Decline Bid sharpwebsol   Jaipur, IN location US$275 bid amount (No Feedback Yet) feedback 10 day(s) delivery time     We are web design ,graphic design and website development company comprises a pool of professionals who deliver quality work on a wide range of communication web site design and web application projects. The web design ,graphic design and web site development services span all aspects of project work including research, planning, concept, design, execution and training. Our services include end to end web solutions , search engine marketing and corporate identity development. We also provide web consulting and full implementation services for industries like Travel & Hospitality, Casino and Entertainment, Real Estate, IT and BPO. We are a premier provider of websites design, content management systems, e-commerce solutions, flash and multimedia presentations, search engine optimization and pay per click consulting services.Our business model focuses on having long-term strategic relationships with clients and a significant portion of our revenue comes from repeat business from our client and partner base extending across the world. Our Global Services Delivery Model leverages cost-competitive development at our offshore development center in India leveraging the superior workforce. With our strategically located marketing business centers and a virtual team model, we can provide high quality,mission critical, rapid time-to-market solutions on time and within budget. Bid Time: 12-05-2007 16:52