public void TestProductInsertAndDelete()
{
//
// Create and insert a new product
//
Category c = (Category)categories.GetById(4);
Supplier s = (Supplier)suppliers.GetById(17);
Product p = new Product()
{
Category = c,
Supplier = s,
ProductName = "Bacalhau",
ReorderLevel = 23,
UnitsInStock = 100,
UnitsOnOrder = 40
};
object id = prods.Insert(p);
//
// Get the new product object from database
//
Product actual = (Product)prods.GetById(id);
Assert.AreEqual(p.ProductName, actual.ProductName);
Assert.AreEqual(p.UnitsInStock, actual.UnitsInStock);
//
// Delete the created product from database
//
prods.Delete(actual);
actual = (Product)prods.GetById(id);
Assert.IsNull(actual);
}
public void TestRegionGetById()
{
Region r = (Region)regions.GetById(1);
Assert.AreEqual("Eastern ", r.RegionDescription);
//Assert.AreEqual("Western ", r.RegionDescription); //id=2
}
public void TestGenericProductGetById()
{
Product p = prods.GetById(10);
Assert.AreEqual("Ikura", p.ProductName);
Assert.AreEqual("Seafood", p.Category.CategoryName);
Assert.AreEqual("Tokyo Traders", p.Supplier.CompanyName);
}
public static void EmployeeEmit()
{
IDataMapper test = EmitDataMapper.Build(typeof(Employee), connStr, true);
object id = test.Insert(tester);
IEnumerable res = test.GetAll();
Employee actual = (Employee)test.GetById(id);
test.Delete(actual);
Employee original = (Employee)test.GetById(1);
test.Update(tester);
test.Update(original);
}
public static void CustomerEmit()
{
IDataMapper test = EmitDataMapper.Build(typeof(Customer), connStr, true);
object id = test.Insert(insertTestC);
IEnumerable res = test.GetAll();
Customer actual = (Customer)test.GetById(id);
test.Delete(actual);
Customer original = (Customer)test.GetById("ALFKI");
test.Update(updateTestC);
test.Update(original);
}
protected override object Load(IDataReader dr)
{
return(new Product {
ProductID = (int)Caster(dr["ProductID"]),
ProductName = (string)Caster(dr["ProductName"]),
Supplier = (Supplier)suppliers.GetById(dr["SupplierID"]),
Category = (Category)categories.GetById(dr["CategoryID"]),
UnitsInStock = (short)Caster(dr["UnitsInStock"]),
UnitsOnOrder = (short)Caster(dr["UnitsOnOrder"]),
ReorderLevel = (short)Caster(dr["ReorderLevel"])
});
}
internal void TestRegionInsertAndDelete()
{
//
// Create and Insert new Region
Region r = new Region()
{
RegionID = 12,
RegionDescription = "Western ",
};
object id = regions.Insert(r);
//
// Get the new region object from database
//
Region actual = (Region)regions.GetById(12);
Assert.AreEqual(r.RegionID, actual.RegionID);
Assert.AreEqual(r.RegionDescription, actual.RegionDescription);
// Delete the created region from database
//
regions.Delete(actual);
object res = regions.GetById(12);
actual = res != null ? (Region)res : default(Region);
Assert.IsNull(actual);
}
public void TestRegionGetById()
{
Region c = (Region)regions.GetById(3);
string trimmedResult = c.RegionDescription.Trim(); ///TODO porque é que tem espaços vazios, a info vinda da query?
Assert.AreEqual("Northern", trimmedResult);
}
public void TestShipperGetById()
{
Shipper c = (Shipper)shippers.GetById(3);
Assert.AreEqual("Federal Shipping", c.CompanyName);
Assert.AreEqual("(503) 555-9931", c.Phone);
}
public void TestCategoryGetById()
{
Category c = (Category)categories.GetById(3);
Assert.AreEqual("Confections", c.CategoryName);
Assert.AreEqual("Desserts, candies, and sweet breads", c.Description);
}
protected override object Load(SqlDataReader dr)
{
Product p = new Product();
p.ProductID = (int)dr["ProductID"];
p.ProductName = (string)dr["ProductName"];
p.Supplier = (Supplier)suppliers.GetById(dr["SupplierID"]);
p.Category = (Category)categories.GetById(dr["CategoryID"]);
p.UnitsInStock = (short)dr["UnitsInStock"];
p.UnitsOnOrder = (short)dr["UnitsOnOrder"];
p.ReorderLevel = (short)dr["ReorderLevel"];
return(p);
}
public void TestEmployeeGetById()
{
Employee e = (Employee)employee.GetById(1);
Assert.AreEqual("Davolio", e.LastName);
Assert.AreEqual("Nancy", e.FirstName);
Assert.AreEqual("Sales Representative", e.Title);
}
public Product GetById(int id, SqlTransaction trx)
{
using (SqlCommand cmdGet = sqlGetById(c))
{
if (trx != null)
{
cmdGet.Transaction = trx;
}
cmdGet.Parameters["@ProductId"].Value = id;
using (SqlDataReader dr = cmdGet.ExecuteReader())
{
dr.Read();
Product newProd = new Product(
(int)dr[0],
(string)dr[1],
(decimal)dr[2],
(short)dr[3],
suppMapper.GetById((int)dr[4]));
return(newProd);
}
}
}
public static void ProductEmit()
{
IDataMapper test = EmitDataMapper.Build(typeof(Product), connStr, true);
IDataMapper categories = EmitDataMapper.Build(typeof(Category), connStr, true);
IDataMapper suppliers = EmitDataMapper.Build(typeof(Supplier), connStr, true);
Category c = (Category)categories.GetById(4);
Supplier s = (Supplier)suppliers.GetById(17);
object id = test.Insert(ProductBuilder(c, s));
IEnumerable res = test.GetAll();
Product actual = (Product)test.GetById(id);
test.Delete(actual);
Product original = (Product)test.GetById(10);
c = (Category)categories.GetById(4);
s = (Supplier)suppliers.GetById(17);
test.Update(ProductBuilder(c, s));
test.Update(original);
}
public void TestCustomerGetById()
{
Customer c = (Customer)customers.GetById("ALFKI");
Assert.AreEqual("ALFKI", c.CustomerID);
Assert.AreEqual("Alfreds Futterkiste", c.CompanyName);
Assert.AreEqual("Maria Anders", c.ContactName);
Assert.AreEqual("Obere Str. 57", c.Address);
Assert.AreEqual("Berlin", c.City);
Assert.AreEqual("12209", c.PostalCode);
Assert.IsNull(c.Region);
Assert.AreEqual("Germany", c.Country);
Assert.AreEqual("030-0074321", c.Phone);
Assert.AreEqual("030-0076545", c.Fax);
}
public IEnumerator <object> GetEnumerator()
{
if (results == null)
{
results = new List <object>();
Dictionary <string, Type> allEDMembers = columnMapper.MapEDMembersTypes();
connectionPolicy.DoBeforeCommandExecution();
using (SqlCommand cmd = connectionPolicy.GetConnection().CreateCommand())
{
cmd.Transaction = connectionPolicy.GetTransaction();
cmd.CommandText = "SELECT * FROM " + tableName;
if (!string.IsNullOrEmpty(whereClause))
{
cmd.CommandText = string.Format("{0} WHERE {1}", cmd.CommandText, whereClause);
}
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
Dictionary <string, object> members = columnMapper.MapAllMembers(dr);
foreach (string name in allEDMembers.Keys)
{
IDataMapper dataMapper = foreignMappers[allEDMembers[name]];
object foreignObject = dataMapper.GetById(members[name]);
members[name] = foreignObject;
}
object newObject = columnMapper.MapMembersIntoObject(members);
results.Add(newObject);
}
}
}
connectionPolicy.DoAfterCommandExecution();
}
foreach (object obj in results)
{
yield return(obj);
}
}
public static void m1()
{
Builder builder = new Builder(
SqlDataMapperType,
DataMapperParams,
//FieldsColumnMapperType,
PropertyColumnMapperType,
MultipleConnectionPolicyType);
IDataMapper productMapper = builder.Build <Product>();
SqlEnumerable prods = productMapper.GetAll();
Product p2 = (Product)productMapper.GetById(1);
p2.SupplierID.ContactName = "Charlotte";
productMapper.Update(p2);
p2.SupplierID.ContactName = "Charlotte Cooper";
productMapper.Update(p2);
foreach (Product p in prods)
{
Console.WriteLine(p);
}
}
public void TestEmployeeGetById()
{
EmployeeP3 e = (EmployeeP3)employee.GetById(1);
Assert.AreEqual("Davolio", e.LastName);
Assert.AreEqual("Nancy", e.FirstName);
Assert.AreEqual("Sales Representative", e.Title);
IEnumerable <Order> a = e.Orders;
IEnumerable <Order> b = ((AbstractDataMapper <int, Order>)orders).Get("SELECT * FROM Orders WHERE EmployeeID = 1");
int countA = 0;
int countB = 0;
foreach (Order o in a)
{
countA++;
}
foreach (Order o in b)
{
countB++;
}
Assert.AreEqual(countA, countB);
}
