public void CreateTable_Employee_Test() { var entity = new Employee(); var table = Engine.GetTable<Employee>(); Assert.IsNotNull(table.KeyFields); Assert.IsNotNull(table.Fields); List<Field> fields = table.Fields.ToList(); Assert.AreEqual("Employees", table.TableName); AssertFields(fields); Assert.IsFalse(fields[0].IsRequired); Assert.IsTrue(fields[1].IsRequired); Assert.IsTrue(fields[2].IsRequired); Assert.IsTrue(fields[0].IsKey); foreach (var field in fields.Skip(1)) { Assert.IsFalse(field.IsKey); } Assert.IsNotNull(table.CommandsHolder.Select); }
public void FullEntityLoader_Employees() { using (var con = new NameConventionDbConnectionCreator("System.Data.SqlClient").Create()) { con.Open(); var employee = new Employee(); var cmd = con.CreateCommand(); cmd.CommandText = Utils.EmployeeTable.CommandsHolder.Select; var reader = cmd.ExecuteReader(); Assert.IsNotNull(reader); Assert.IsTrue(reader.Read()); new FullEntityLoader(new CachedEntities()).Load(employee, null, reader); reader.Close(); EntitiesAsserts.Assert_Employee_1(employee); } }
public static void Assert_Employee_3(Employee employee) { Assert.AreEqual(3, employee.EmployeeId); Assert.AreEqual("Janet", employee.FirstName); Assert.AreEqual("Leverling", employee.LastName); Assert.AreEqual("Sales Representative", employee.Title); Assert.AreEqual("Ms.", employee.TitleOfCourtesy); Assert.AreEqual(new DateTime(1963,08,30), employee.BirthDate); Assert.AreEqual(new DateTime(1992, 4, 1), employee.HireDate); Assert.AreEqual("722 Moss Bay Blvd.", employee.Address); Assert.AreEqual("Kirkland", employee.City); Assert.AreEqual("WA", employee.Region); Assert.AreEqual("98033", employee.PostalCode); Assert.AreEqual("USA", employee.Country); Assert.AreEqual("(206) 555-3412", employee.HomePhone); Assert.AreEqual("3355", employee.Extension); Assert.AreEqual(21722, employee.Photo.Count()); Assert.AreEqual( "Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.", employee.Notes); Assert.AreEqual("http://accweb/emmployees/leverling.bmp", employee.PhotoPath); Assert.IsNotNull(employee.ReportsTo); }
public static void Assert_Employee_2(Employee employee) { Assert.AreEqual(2, employee.EmployeeId); Assert.AreEqual("Andrew", employee.FirstName); Assert.AreEqual("Fuller", employee.LastName); Assert.AreEqual("Vice President, Sales", employee.Title); Assert.AreEqual("Dr.", employee.TitleOfCourtesy); Assert.AreEqual(new DateTime(1952, 2, 19), employee.BirthDate); Assert.AreEqual(new DateTime(1992, 8, 14), employee.HireDate); Assert.AreEqual("908 W. Capital Way", employee.Address); Assert.AreEqual("Tacoma", employee.City); Assert.AreEqual("WA", employee.Region); Assert.AreEqual("98401", employee.PostalCode); Assert.AreEqual("USA", employee.Country); Assert.AreEqual("(206) 555-9482", employee.HomePhone); Assert.AreEqual("3457", employee.Extension); Assert.AreEqual(21626, employee.Photo.Count()); Assert.AreEqual( "Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.", employee.Notes); Assert.AreEqual("http://accweb/emmployees/fuller.bmp", employee.PhotoPath); Assert.IsNotNull(employee.ReportsTo); Assert_Employee_1(employee.ReportsTo); }
public static void Assert_Employee_1(Employee employee) { Assert.AreEqual(1, employee.EmployeeId); Assert.AreEqual("Nancy", employee.FirstName); Assert.AreEqual("Davolio", employee.LastName); Assert.AreEqual("Sales Representative", employee.Title); Assert.AreEqual("Ms.", employee.TitleOfCourtesy); Assert.AreEqual(new DateTime(1948, 12, 8), employee.BirthDate); Assert.AreEqual(new DateTime(1992, 5, 1), employee.HireDate); Assert.AreEqual("507 - 20th Ave. E.\r\nApt. 2A", employee.Address); Assert.AreEqual("Seattle", employee.City); Assert.AreEqual("WA", employee.Region); Assert.AreEqual("98122", employee.PostalCode); Assert.AreEqual("USA", employee.Country); Assert.AreEqual("(206) 555-9857", employee.HomePhone); Assert.AreEqual("5467", employee.Extension); Assert.AreEqual(21626, employee.Photo.Count()); Assert.AreEqual( "Education includes a BA in psychology from Colorado State University in 1970. She also completed \"The Art of the Cold Call.\" Nancy is a member of Toastmasters International.", employee.Notes); Assert.AreEqual("http://accweb/emmployees/davolio.bmp", employee.PhotoPath); Assert.IsNotNull(employee.ReportsTo); Assert.AreEqual(2, employee.ReportsTo.EmployeeId); }
private static Object FillEmployee(Employee employee) { employee.EmployeeId = 1; employee.FirstName = "test name"; employee.LastName = "test last name"; employee.BirthDate = new DateTime(1983, 4, 16); employee.HireDate = new DateTime(1999, 4, 16); employee.Photo = new Byte[10]; return employee; }