Beispiel #1
0
        void RunVendorTest()
        {
            var conn = new Connection(@"localhost\sqlexpress", "PRSdb");

            conn.Open();
            Vendors.Connection = conn;

            var vendidtest = Vendors.GetByPK(2);

            var success = Vendors.Delete(4);
            var vendors = Vendors.GetAll();

            foreach (var v in vendors)
            {
                Console.WriteLine(v.Name);
            }

            //var newvendora = new Vendors();
            //newvendora.Address = "bridge4";
            //newvendora.City = "City";
            //newvendora.Code = "BGHTS";
            //newvendora.Email = "emaiiil.email";
            //newvendora.Name = "Big Hats";
            //newvendora.Phone = "484-562-4636";
            //newvendora.State = "NM";
            //newvendora.Zip = "43532";
            //success = Vendors.Insert(newvendora);

            foreach (var v in vendors)
            {
                Console.WriteLine(v.Name);
            }


            conn.Close();
        }