public void TestAuditProperties() { AuditPerson p = new AuditPerson(); p.Name = "Frederik"; p.DateOfBirth = new DateTime(1978, 12, 14); SessionManager.Instance.DefaultInterceptor = new AuditInterceptor(); SessionManager.Instance.StartUnitOfWork(); SessionManager.Instance.UnitOfWork.Save(p); Console.WriteLine(p.Name + " " + p.DateOfBirth + " " + p.Created + " " + p.Updated); SessionManager.Instance.UnitOfWork.Flush(); SessionManager.Instance.CloseUnitOfWork(); }
public async Task <IEnumerable <AuditPerson> > GetPersonsAsync() { string sqlProcedure = "PR_Audit_Persons_Read"; List <AuditPerson> table = new List <AuditPerson>(); using (SqlConnection con = new SqlConnection(connectionString)) { await con.OpenAsync(); SqlCommand cmd = new SqlCommand(sqlProcedure, con) { CommandType = CommandType.StoredProcedure }; SqlDataReader reader = await cmd.ExecuteReaderAsync(); if (reader.HasRows) { while (await reader.ReadAsync()) { Person person = new Person { Id = reader.GetInt32("id"), FirstName = reader.GetString("name"), LastName = reader.GetString("surname"), Email = reader.GetString("email"), Phone = reader.GetString("phone"), IsActive = !reader.GetBoolean("inactive") }; AuditPerson audit = new AuditPerson { Person = person, Type = reader.GetString("crud_type"), Time = reader.GetDateTime("crud_time") }; table.Add(audit); } } await reader.CloseAsync(); } return(table); }