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();
}
}
}
