Exemple #1
0
        private void CheckAccpet_Click(object sender, EventArgs e)
        {
            int err = 0;

            if (Int32.TryParse(ItemRecievedCode.Text, out err)) //checks for integer input
            {
                PartsDBConnector connection = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
                Part             signlePart = connection.GetPartByID(Int32.Parse(ItemRecievedCode.Text));
                PartName.Text    = signlePart.Name;
                PartName.Visible = true;
            }
            else
            {
                PartName.Text = "Error, not valid part";
            }                                                //else show error
        }
Exemple #2
0
        static void Main(string[] args)
        {
            PartsDBConnector connector = new PartsDBConnector("blitz.cs.niu.edu", 3306, "student", "student");
            var parts = connector.GetAllParts();

            foreach (var part in parts)
            {
                Console.WriteLine(part.ID);
                Console.WriteLine(part.Name);
                Console.WriteLine(part.Price);
                Console.WriteLine("---------------");
            }
            Console.ReadLine();

            var part1 = connector.GetPartByID(3);

            Console.WriteLine(part1.ID);
            Console.WriteLine(part1.Name);
            Console.WriteLine(part1.Price);
            Console.WriteLine("---------------");

            Console.ReadLine();
        }