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;