public void Insert() { //var handler = new CreateStaffHandler(new CreateStaffQuery(new ConnectionFactory(_configConnection))); var command = new CreateStaffCommand("first", "last", "123456789", "*****@*****.**", DateTime.Now, null, "note"); if (_commandHandler.Execute(command).Success) { Console.WriteLine("new record inserted."); } var staffQuery = new StaffQuery(new ConnectionFactory(_configConnection)); var staffs = staffQuery.GetStaffs(); foreach (var staff in staffs) { Console.WriteLine($"Name: {staff.FirstName} {staff.LastName} Email: {staff.Email} Create: {staff.StartDate}"); } }
/// <summary> /// Test Find using the Query class /// </summary> private void Step_30_TestFindByQuery_Generated() { using (TransactionManager tm = CreateTransaction()) { //Insert Mock Instance Staff mock = CreateMockInstance(tm); bool result = DataRepository.StaffProvider.Insert(tm, mock); Assert.IsTrue(result, "Could Not Test FindByQuery, Insert Failed"); StaffQuery query = new StaffQuery(); query.AppendEquals(StaffColumn.Id, mock.Id.ToString()); if (mock.Name != null) { query.AppendEquals(StaffColumn.Name, mock.Name.ToString()); } if (mock.Depart != null) { query.AppendEquals(StaffColumn.Depart, mock.Depart.ToString()); } if (mock.OpenDate != null) { query.AppendEquals(StaffColumn.OpenDate, mock.OpenDate.ToString()); } if (mock.SalaryLevel != null) { query.AppendEquals(StaffColumn.SalaryLevel, mock.SalaryLevel.ToString()); } if (mock.Address != null) { query.AppendEquals(StaffColumn.Address, mock.Address.ToString()); } if (mock.Phone != null) { query.AppendEquals(StaffColumn.Phone, mock.Phone.ToString()); } if (mock.PersonId != null) { query.AppendEquals(StaffColumn.PersonId, mock.PersonId.ToString()); } if (mock.PersonIddate != null) { query.AppendEquals(StaffColumn.PersonIddate, mock.PersonIddate.ToString()); } if (mock.Location != null) { query.AppendEquals(StaffColumn.Location, mock.Location.ToString()); } if (mock.ContactPerson != null) { query.AppendEquals(StaffColumn.ContactPerson, mock.ContactPerson.ToString()); } if (mock.Remark != null) { query.AppendEquals(StaffColumn.Remark, mock.Remark.ToString()); } if (mock.Labelsprn != null) { query.AppendEquals(StaffColumn.Labelsprn, mock.Labelsprn.ToString()); } if (mock.Status != null) { query.AppendEquals(StaffColumn.Status, mock.Status.ToString()); } TList <Staff> results = DataRepository.StaffProvider.Find(tm, query); Assert.IsTrue(results.Count == 1, "Find is not working correctly. Failed to find the mock instance"); } }