Senior Project Material Management By: Carman Babin

1. 09 Senior Project Material Management By: Carman Babin

2. Telephone: 24 hours (713) 225-4300toll free (800) 550-4374 Fax: (713) 225-5707 Postal Address:P.O. Box 1549Houston, TX 77251-1549 At AmeriMex Inc. we put our customers first. They are the reason for our existence. We form partnerships with our customers to ensure that projects are handled in a timely, professional, and responsible manner. Our customers’ needs are always our primary concern. At AmeriMex Inc. we provide our customers with the highest quality machinery in the frame needed for a reasonable cost

3. Telephone: 24 hours (713) 225-4300toll free (800) 550-4374 Fax: (713) 225-5707 Postal Address:P.O. Box 1549Houston, TX 77251-1549 The Project consists of developing an application which will allow users to input, edit, and delete information from database to maintain better inventory of Machines and All of their components. Users will be required to enter information such as… • Part ID • Manufacturer # • Part Description • Cost • Unit of Measure “UOM” • Make/Buy:

4. Telephone: 24 hours (713) 225-4300toll free (800) 550-4374 Fax: (713) 225-5707 Postal Address:P.O. Box 1549Houston, TX 77251-1549 Technologies Used To Create the Program • C# • MySQL

5. Telephone: 24 hours (713) 225-4300toll free (800) 550-4374 Fax: (713) 225-5707 Postal Address:P.O. Box 1549Houston, TX 77251-1549 Inventory Screen Bill of Material “BOM” Screen Parts Screen

6. VIDEO

7. Code Used public DataTableGetBom(string BomName) { DataTabledt = new DataTable(); dt = new DataTable(); string sql = string.Format("SELECT BomPart.PK, BomPart.PartNum AS 'Part #', BomPart.Qty as 'Part Quantity', BomPart.TagNum as 'Tag #', Parts.Manufacturer, Parts.MfrPartNum as 'Manufacturer #', Parts.UnitOfMeasure AS 'Unit Of Measure', BomPart.PassOrMfg 'Pass Through Or Manufactured', Parts.Description From BomPart LEFT JOIN Parts ON BomPart.PartNum = Parts.ApsPartNum WHERE BomPart.PartNum = Parts.ApsPartNum AND BomPart.Name = '{0}'", BomName); MySqlCommandcmd = new MySqlCommand(sql, conn); MySqlDataAdapterda = new MySqlDataAdapter(cmd); da.Fill(dt); return dt; }

8. Code Used public boolSeeIfBomExist(string BomName) { string sql = string.Format("Select COUNT(BOM_Name) from BOM WHERE BOM_Name = '{0}'", BomName); MySqlCommandcmd = new MySqlCommand(sql, conn); MySqlDataAdapterda = new MySqlDataAdapter(cmd); conn.Open(); MySqlDataReader reader = cmd.ExecuteReader(); int usernames = 0; while (reader.Read()) { if (reader.HasRows == true) { usernames = reader.GetInt32(0); } } conn.Close(); if (usernames < 1) { return false; } else { return true; } da.Dispose(); reader.Close();

9. Database

10. Telephone: 24 hours (713) 225-4300toll free (800) 550-4374 Fax: (713) 225-5707 Postal Address:P.O. Box 1549Houston, TX 77251-1549 Enhancement Opportunity • The program needs a button for users to add inventory stock when a part arrives. • Need user management for security • Need to be able to issue B.O.M. to a work order • The program needs to automatically take out parts in inventory when a work order is issued. • The program needs to have a nested grid for the B.O.M’s and work orders.