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
}
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();
}
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
}
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
}
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
}
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
}
