예제 #1
0
        public static void TestDeletev3order(SqlMapper_v3.IDataMapper orderMapper)
        {
            Console.WriteLine("------------------> Inseri um registo");
            Customer newcust  = new Customer("C0001", "Company1", "Contact1", "Mr", "Rua xxx", "Porto", " North", "4950 ", " Portugal", " 91123456", "2151421 ");
            Employee newempl  = new Employee(1, "Rodrigues", "Tatiana", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            Order    neworder = new Order(newcust, newempl, DateTime.Now, DateTime.Now, DateTime.Now, 4, 4, "Barco do amor", "miami", "miami", "miami", "333222", "miami");

            orderMapper.Insert(neworder);
            SqlMapper_v3.DataMapper <Order> orderMapper2 = (SqlMapper_v3.DataMapper <Order>)orderMapper;
            int lastRecord = orderMapper2.GetLastInsertedRecord();

            Console.WriteLine("------------------> Inseri um registo");
            newcust  = new Customer("C0002", "Company2", "Contact2", "Mrs", "Rua yy", "Porto", " North", "4950 ", " Portugal", " 91123456", "2151421 ");
            newempl  = new Employee(5, "Domingos", "Diana", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua eee", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            neworder = new Order(newcust, newempl, DateTime.Now, DateTime.Now, DateTime.Now, 4, 4, "Barco do amor", "miami", "miami", "miami", "333222", "miami");
            orderMapper.Insert(neworder);
            Console.ReadKey();//vejo estado actual
            Order newremorder = new Order(lastRecord, newcust, newempl, DateTime.Now, DateTime.Now, DateTime.Now, 0, 0, "", "", "", "", "", "");

            orderMapper.Delete(newremorder);
            Console.WriteLine("------------------> Removi um registo");
            newremorder = new Order(lastRecord + 1, newcust, newempl, DateTime.Now, DateTime.Now, DateTime.Now, 0, 0, "", "", "", "", "", "");
            orderMapper.Delete(newremorder);
            Console.WriteLine("------------------> Removi um registo");
            Console.ReadKey();//vejo estado actual
        }
예제 #2
0
 public static void TestGetAllv3(SqlMapper_v3.IDataMapper mapper)
 {
     SqlMapper_v3.ISqlEnumerable result = mapper.GetAll();
     //Console.WriteLine("Get all elements in Orders:");
     foreach (var r in result)
     {
         Console.WriteLine(r.ToString());
     }
     Console.ReadKey();
 }
예제 #3
0
        public static void TestUpdatev3employee(SqlMapper_v3.IDataMapper mapper)
        {
            Console.WriteLine("------------------> Alterei um registo num Employee");
            Employee newempl = new Employee(3, "Rodrigues", "Tatiana", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");

            mapper.Update(newempl);
            UnitTest.TestGetAllv3(mapper);//vejo estado actual
            Console.WriteLine("------------------> Repus o estado do registo de um Employee");
            newempl = new Employee(3, "Geraldes", "Guida", "Ms", "Ms", Convert.ToDateTime("1900/01/01 12:10:05.123"), Convert.ToDateTime("1900/01/01 12:10:05.123"), "Rua qqq", "Lisbon", "Center", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            mapper.Update(newempl);
            UnitTest.TestGetAllv3(mapper);//vejo estado actual
        }
예제 #4
0
        public static void TestInsertv3employee(SqlMapper_v3.IDataMapper mapper)
        {
            Console.WriteLine("------------------> Inseri um registo");
            Employee newempl = new Employee("Ermenegilda", "Escarlate", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");

            mapper.Insert(newempl);
            UnitTest.TestGetAllv3(mapper);//vejo estado actual
            Console.WriteLine("------------------> Inseri um registo");
            newempl = new Employee("Ermenegilda", "Escarlate", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            mapper.Insert(newempl);
            UnitTest.TestGetAllv3(mapper);//vejo estado actual
        }
예제 #5
0
        public static void TestUpdatev3order(SqlMapper_v3.IDataMapper orderMapper)
        {
            Console.WriteLine("------------------> Alterei um registo numa Order");
            Customer newcust  = new Customer("C0002", "Company2", "Contact2", "Mrs", "Rua yy", "Porto", " North", "4950 ", " Portugal", " 91123456", "2151421 ");
            Employee newempl  = new Employee(5, "Domingos", "Diana", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua eee", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            Order    neworder = new Order(6, newcust, newempl, DateTime.Now, DateTime.Now, DateTime.Now, 4, 4, "Barco do amor", "miami", "miami", "miami", "333222", "miami");

            orderMapper.Update(neworder);
            Console.ReadKey();//vejo estado actual
            Console.WriteLine("------------------> Repus o estado do registo de uma Order");
            newcust  = new Customer("C0001", "Company1", "Contact1", "Mr", "Rua xxx", "Porto", " North", "4950 ", " Portugal", " 91123456", "2151421 ");
            newempl  = new Employee(1, "Rodrigues", "Tatiana", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            neworder = new Order(6, newcust, newempl, DateTime.Now, DateTime.Now, DateTime.Now, 4, 4, "Barco do amor", "miami", "miami", "miami", "333222", "miami");
            orderMapper.Update(neworder);
            Console.ReadKey();//vejo estado actual
        }
예제 #6
0
        public static void TestDeletev3employee(SqlMapper_v3.IDataMapper mapper)
        {
            Console.WriteLine("------------------> Inseri um registo");
            Employee newempl = new Employee("Ermenegilda", "Escarlate", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");

            mapper.Insert(newempl);
            SqlMapper_v3.DataMapper <Employee> newempl2 = (SqlMapper_v3.DataMapper <Employee>)mapper;
            int lastRecord = newempl2.GetLastInsertedRecord();

            UnitTest.TestGetAllv3(mapper);//vejo estado actual
            Console.WriteLine("------------------> Inseri um registo");
            newempl = new Employee("Ermenegilda", "Escarlate", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            mapper.Insert(newempl);
            UnitTest.TestGetAllv3(mapper);//vejo estado actual
            newempl = new Employee(lastRecord, "Ermenegilda", "Escarlate", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            mapper.Delete(newempl);
            Console.WriteLine("------------------> Removi um registo");
            newempl = new Employee(lastRecord + 1, "Ermenegilda", "Escarlate", "Ms", "Ms", DateTime.Now, DateTime.Now, "Rua xxx", "Porto", "North", "3521", "Portugal", "12387643", "521", null, " ", 1, " ");
            mapper.Delete(newempl);
            Console.WriteLine("------------------> Removi um registo");
            UnitTest.TestGetAllv3(mapper);//vejo estado actual
        }