private static void ApplicationAuditTrailData <TEntity>() where TEntity : ZDataBase { ZOperationResult operationResult = new ZOperationResult(); IAuditTrailGenericApplication <TEntity> application = DIHelper.GetService <IAuditTrailGenericApplication <TEntity> >(); IEnumerable <TEntity> enumerable = application.SearchAll(operationResult); if (operationResult.Ok) { Console.WriteLine(typeof(TEntity).Name + ": {0}", enumerable.Count()); } else { Console.WriteLine(operationResult.Text); } }
public AuditTrailLogController(IAuditTrailGenericApplication <AuditTrailLog> application) : base(application.AuthorizationManager) { Application = application; }
private static void CRUDApplication() { bool exit = false; while (!exit) { Console.Clear(); Console.WriteLine("CRUD Application Demo\n"); Console.WriteLine("<0> RETURN"); Console.WriteLine("<1> CREATE AuditTrailLog"); Console.WriteLine("<2> UPDATE AuditTrailLog"); Console.WriteLine("<3> DELETE AuditTrailLog"); Console.WriteLine("<4> TRANSACTION COMMIT AuditTrailLog"); Console.WriteLine("<5> TRANSACTION ROLLBAK AuditTrailLog"); Console.WriteLine("<T> TRUNCATE TABLE AuditTrailLog"); Console.Write("\nChoose an option... "); ConsoleKeyInfo key = Console.ReadKey(); Console.WriteLine(); ZOperationResult operationResult = new ZOperationResult(); IAuditTrailGenericApplication <AuditTrailLog> application = DIHelper.DIManager.GetService <IAuditTrailGenericApplication <AuditTrailLog> >(); AuditTrailLog auditTrailLog; switch (key.KeyChar) // <ENTER> = '\r' { case ('0'): exit = true; break; case ('1'): auditTrailLog = new AuditTrailLog(); auditTrailLog.LogDate = DateTime.Today; auditTrailLog.LogTime = DateTime.Now; application.Create(operationResult, auditTrailLog); break; case ('2'): auditTrailLog = new AuditTrailLog(); auditTrailLog.LogDate = DateTime.Today; auditTrailLog.LogTime = DateTime.Now; if (application.Create(operationResult, auditTrailLog)) { auditTrailLog.LogDate = DateTime.Today.AddMonths(1); auditTrailLog.LogTime = DateTime.Now.AddMonths(1); application.Update(operationResult, auditTrailLog); } break; case ('3'): auditTrailLog = new AuditTrailLog(); auditTrailLog.LogDate = DateTime.Today; auditTrailLog.LogTime = DateTime.Now; if (application.Create(operationResult, auditTrailLog)) { application.Delete(operationResult, auditTrailLog); } break; case ('4'): try { if (application.UnitOfWork.BeginTransaction(operationResult)) { auditTrailLog = new AuditTrailLog(); auditTrailLog.LogDate = DateTime.Today; auditTrailLog.LogTime = DateTime.Now; if (application.Create(operationResult, auditTrailLog)) { auditTrailLog.LogDate = DateTime.Today.AddMonths(1); auditTrailLog.LogTime = DateTime.Now.AddMonths(1); if (application.Update(operationResult, auditTrailLog)) { application.UnitOfWork.CommitTransaction(operationResult); } } } } catch (Exception exception) { operationResult.ParseException(exception); } if (!operationResult.Ok) { application.UnitOfWork.RollbackTransaction(operationResult); } break; case ('5'): try { if (application.UnitOfWork.BeginTransaction(operationResult)) { auditTrailLog = new AuditTrailLog(); auditTrailLog.LogDate = DateTime.Today; auditTrailLog.LogTime = DateTime.Now; if (application.Create(operationResult, auditTrailLog)) { auditTrailLog.LogDate = DateTime.Today.AddMonths(1); auditTrailLog.LogTime = DateTime.Now.AddMonths(1); if (application.Update(operationResult, auditTrailLog)) { application.UnitOfWork.RollbackTransaction(operationResult); } } } } catch (Exception exception) { operationResult.ParseException(exception); } if (!operationResult.Ok) { application.UnitOfWork.RollbackTransaction(operationResult); } break; case ('t'): case ('T'): application.UnitOfWork.SQLCommand("TRUNCATE TABLE EasyLOBAuditTrailLog"); break; } if (!exit) { if (operationResult.Ok) { List <AuditTrailLog> list = (List <AuditTrailLog>)application.SearchAll(operationResult); if (operationResult.Ok) { foreach (AuditTrailLog entity in list) { Console.WriteLine("{0} {1} {2}", entity.Id, entity.LogDate, entity.LogTime); } } } if (!operationResult.Ok) { Console.WriteLine(operationResult.Text); } Console.Write("\nPress <KEY> to continue... "); Console.ReadKey(); } } }
private static void DemoDI() { Console.WriteLine("\nDI Demo"); try { { // Activity Console.WriteLine(); IActivityGenericApplication <EasyLOB.Activity.Data.Activity> application = DIHelper.DIManager.GetService <IActivityGenericApplication <EasyLOB.Activity.Data.Activity> >(); Console.WriteLine(application.ToString()); IActivityGenericApplicationDTO <EasyLOB.Activity.Data.ActivityDTO, EasyLOB.Activity.Data.Activity> applicationDTO = DIHelper.DIManager.GetService <IActivityGenericApplicationDTO <EasyLOB.Activity.Data.ActivityDTO, EasyLOB.Activity.Data.Activity> >(); Console.WriteLine(applicationDTO.ToString()); IUnitOfWork unitOfWork = DIHelper.DIManager.GetService <IActivityUnitOfWork>(); Console.WriteLine(unitOfWork.ToString()); IActivityGenericRepository <EasyLOB.Activity.Data.Activity> repository = DIHelper.DIManager.GetService <IActivityGenericRepository <EasyLOB.Activity.Data.Activity> >(); Console.WriteLine(repository.ToString()); } { // AuditTrail Console.WriteLine(); IAuditTrailGenericApplication <AuditTrailConfiguration> application = DIHelper.DIManager.GetService <IAuditTrailGenericApplication <AuditTrailConfiguration> >(); Console.WriteLine(application.ToString()); IAuditTrailGenericApplicationDTO <AuditTrailConfigurationDTO, AuditTrailConfiguration> applicationDTO = DIHelper.DIManager.GetService <IAuditTrailGenericApplicationDTO <AuditTrailConfigurationDTO, AuditTrailConfiguration> >(); Console.WriteLine(applicationDTO.ToString()); IUnitOfWork unitOfWork = DIHelper.DIManager.GetService <IAuditTrailUnitOfWork>(); Console.WriteLine(unitOfWork.ToString()); IAuditTrailGenericRepository <AuditTrailConfiguration> repository = DIHelper.DIManager.GetService <IAuditTrailGenericRepository <AuditTrailConfiguration> >(); Console.WriteLine(repository.ToString()); } { // Identity Console.WriteLine(); IIdentityGenericApplication <User> application = DIHelper.DIManager.GetService <IIdentityGenericApplication <User> >(); Console.WriteLine(application.ToString()); IIdentityGenericApplicationDTO <UserDTO, User> applicationDTO = DIHelper.DIManager.GetService <IIdentityGenericApplicationDTO <UserDTO, User> >(); Console.WriteLine(applicationDTO.ToString()); IUnitOfWork unitOfWork = DIHelper.DIManager.GetService <IIdentityUnitOfWork>(); Console.WriteLine(unitOfWork.ToString()); IIdentityGenericRepository <User> repository = DIHelper.DIManager.GetService <IIdentityGenericRepository <User> >(); Console.WriteLine(repository.ToString()); Console.WriteLine(); ZOperationResult operationResult = new ZOperationResult(); User user = application.Get(operationResult, x => x.UserName.ToLower() == "administrator"); Console.WriteLine(user.UserName); } } catch (Exception exception) { WriteException(exception); } }
private static void LINQApplication() { bool exit = false; while (!exit) { Console.Clear(); Console.WriteLine("LINQ Application Demo\n"); Console.WriteLine("<0> RETURN"); Console.WriteLine("<1> LINQ AuditTrailLog"); Console.Write("\nChoose an option... "); ConsoleKeyInfo key = Console.ReadKey(); Console.WriteLine(); ZOperationResult operationResult = new ZOperationResult(); IAuditTrailGenericApplication <AuditTrailLog> application = DIHelper.DIManager.GetService <IAuditTrailGenericApplication <AuditTrailLog> >(); IEnumerable <AuditTrailLog> enumerable; Expression <Func <AuditTrailLog, bool> > where; Func <IQueryable <AuditTrailLog>, IOrderedQueryable <AuditTrailLog> > orderBy; switch (key.KeyChar) // <ENTER> = '\r' { case ('0'): exit = true; break; case ('1'): int id = 0; Console.WriteLine("\nLINQ"); enumerable = application .Search(operationResult, x => x.Id > id, o => o.OrderByDescending(x => x.Id)); if (operationResult.Ok) { foreach (AuditTrailLog entity in enumerable) { Console.WriteLine("{0} {1} {2}", entity.Id, entity.LogDate, entity.LogTime); } } Console.WriteLine("\nLINQ with parameters"); where = x => x.Id > id; orderBy = o => o.OrderByDescending(x => x.Id); enumerable = application .Search(operationResult, where, orderBy); if (operationResult.Ok) { foreach (AuditTrailLog entity in enumerable) { Console.WriteLine("{0} {1} {2}", entity.Id, entity.LogDate, entity.LogTime); } } Console.WriteLine("\nDynamic LINQ"); enumerable = application .Search(operationResult, "Id > @0", new object[] { id }, "Id descending"); if (operationResult.Ok) { foreach (AuditTrailLog entity in enumerable) { Console.WriteLine("{0} {1} {2}", entity.Id, entity.LogDate, entity.LogTime); } } break; } if (!exit) { Console.WriteLine("\n{0}\n{1}\n{2}", application.GetType().FullName, application.UnitOfWork.GetType().FullName, application.UnitOfWork.DBMS.ToString()); if (!operationResult.Ok) { Console.WriteLine(operationResult.Text); } Console.Write("\nPress <KEY> to continue... "); Console.ReadKey(); } } }