LOVE ME OR HATE ME

Friday, March 10, 2006

guess wad?!?!?! today the last day of iap!!! haha.. the day i have been waiting for is here.. hmm.. lets see.. wad haf i been doing for the past few months.. ive done quite a number of things but they assume i didnt.. so who cares.. heres a list of what i have done.. aha..

.aspx file:

Maintain_Equipment.aspx ~ to insert new equipment
Maintain_Equipment_Select.aspx ~ to search for a certain equipment and it will display the equipments too
*Maintain_Module.aspx ~ to insert new module
*Maintain_Module_Select.aspx ~ to search for modules
*Maintain_Operation.aspx ~ to insert new operation
*Maintain_Operation_Select.aspx ~ to search for operation
*Maintain_Process.aspx ~ to insert new process
*Maintain_Process_Select.aspx ~ to search for process
Trans_Hist.aspx ~ to display all transactions history (eg: item being checkout)
Display_Item.aspx ~ to display the details of an item
Usage_rpt.aspx ~ a report to show the amount of usage of a certain item
Item_Checkout.aspx ~ to record down the item that is being checkout

Database:

*tblOperation
*tblProcess
*tblModule
EQUIP ~ database with updated data
ISSREC ~ added four new fields namely operation, process, module and equiptype

Store procedures (a list of sql statements in one program):

usp_item_checkout ~ added some codes to insert new data into the database and its link to the aspx file in order for the data to be insert
usp_rpt_usage ~ added new fields and take out some of the existing fields, filter of data was done further
*usp_find_operation ~ to retrieve operation id and operation name by some condition
*usp_find_module – to retrieve module id and module name by some condition
*usp_find_process ~ (to retrieve process id and process name by some condition

ps: * denotes page/database I created

so u guys judge, have i done enough?? blueks.. haha.. anyway im so freaking happy im gonna get out from here soon!!! hurray!! *BIG WIDE SMILE* :D