148 lines
5.5 KiB
C#
148 lines
5.5 KiB
C#
using Ease.Core.DataAccess;
|
|
using Ease.Core.Model;
|
|
using Ease.Core.Utility;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using HRM.BO;
|
|
|
|
namespace HRM.DA
|
|
{
|
|
public class SystemAuditHistoryService : ServiceTemplate, ISystemAuditHistoryService
|
|
{
|
|
public SystemAuditHistoryService()
|
|
{
|
|
}
|
|
|
|
private void MapObject(SystemAuditHistory oItem, DataReader oReader)
|
|
{
|
|
oItem.AuditType = oReader.GetString("AuditType");
|
|
oItem.AuditDate = oReader.GetDateTime("AuditDate");
|
|
oItem.LoginID = oReader.GetString("LoginID");
|
|
oItem.Name = oReader.GetString("Name");
|
|
oItem.Code = oReader.GetString("Code");
|
|
oItem.UserType = UserTypeText(oReader.GetString("UserType"));
|
|
oItem.RoleName = oReader.GetString("RoleName");
|
|
oItem.RoleType = RoleTypeText(oReader.GetInt32("RoleType"));
|
|
oItem.MenuKey = oReader.GetString("MenuKey");
|
|
oItem.MenuName = oReader.GetString("MenuName");
|
|
oItem.AccessType = oReader.GetString("AccessType");
|
|
oItem.Activities = oReader.GetString("Activities");
|
|
oItem.ActionBy = oReader.GetInt32("ActionBy");
|
|
oItem.ActionByLoginID = oReader.GetString("ActionByLoginID");
|
|
oItem.ActionByName = oReader.GetString("ActionByName");
|
|
|
|
// Z_ROLE has no activities column: show the role's status, as the other triggers write it.
|
|
int? status = oReader.GetInt32("Status");
|
|
if (string.IsNullOrWhiteSpace(oItem.Activities) && status.HasValue)
|
|
oItem.Activities = StatusText(status.Value);
|
|
}
|
|
|
|
protected override T CreateObject<T>(DataReader oReader)
|
|
{
|
|
SystemAuditHistory oItem = new SystemAuditHistory();
|
|
MapObject(oItem, oReader);
|
|
return oItem as T;
|
|
}
|
|
|
|
// Same words the Z_ triggers write into "activities".
|
|
private static string StatusText(int status)
|
|
{
|
|
switch (status)
|
|
{
|
|
case 1: return "Active";
|
|
case 2: return "New Not Yet Approve";
|
|
case 3: return "Deleted Not Yet Approve";
|
|
case 4: return "Edited Not Yet Approve";
|
|
case 5: return "Approved";
|
|
case 6: return "Locked";
|
|
case 7: return "Archived";
|
|
case 8: return "Inactive";
|
|
case 9: return "Inactive Not Yet Approve";
|
|
case 10: return "Rejected";
|
|
default: return "None";
|
|
}
|
|
}
|
|
|
|
private static string RoleTypeText(int? roleType)
|
|
{
|
|
if (!roleType.HasValue)
|
|
return null;
|
|
switch ((EnumRoleType)roleType.Value)
|
|
{
|
|
case EnumRoleType.Admin: return "Admin";
|
|
case EnumRoleType.Self_Service: return "Self Service";
|
|
case EnumRoleType.Mobile: return "Mobile";
|
|
default: return roleType.Value.ToString();
|
|
}
|
|
}
|
|
|
|
// Z_USERS.usertype is the Users.UserType number as text.
|
|
private static string UserTypeText(string userType)
|
|
{
|
|
int value;
|
|
if (string.IsNullOrWhiteSpace(userType) || !int.TryParse(userType.Trim(), out value))
|
|
return userType;
|
|
switch ((EnumUserType)value)
|
|
{
|
|
case EnumUserType.SuperUser: return "Super User";
|
|
case EnumUserType.User: return "User";
|
|
case EnumUserType.Employee: return "Employee";
|
|
default: return userType;
|
|
}
|
|
}
|
|
|
|
#region Service implementation
|
|
|
|
public List<SystemAuditHistory> Get(EnumSystemAuditHistory type, DateTime dtFrom, DateTime dtTo)
|
|
{
|
|
List<SystemAuditHistory> items = new List<SystemAuditHistory>();
|
|
TransactionContext tc = null;
|
|
try
|
|
{
|
|
tc = TransactionContext.Begin();
|
|
IDataReader reader;
|
|
switch (type)
|
|
{
|
|
case EnumSystemAuditHistory.Role:
|
|
reader = SystemAuditHistoryDA.GetRole(tc, dtFrom, dtTo);
|
|
break;
|
|
case EnumSystemAuditHistory.RolePermission:
|
|
reader = SystemAuditHistoryDA.GetRolePermission(tc, dtFrom, dtTo);
|
|
break;
|
|
case EnumSystemAuditHistory.User:
|
|
reader = SystemAuditHistoryDA.GetUser(tc, dtFrom, dtTo);
|
|
break;
|
|
case EnumSystemAuditHistory.UserRole:
|
|
reader = SystemAuditHistoryDA.GetUserRole(tc, dtFrom, dtTo);
|
|
break;
|
|
case EnumSystemAuditHistory.UserAccessType:
|
|
reader = SystemAuditHistoryDA.GetUserAccessType(tc, dtFrom, dtTo);
|
|
break;
|
|
default:
|
|
throw new ArgumentException("Unknown audit history.");
|
|
}
|
|
DataReader dr = new DataReader(reader);
|
|
items = this.CreateObjects<SystemAuditHistory>(dr);
|
|
dr.Close();
|
|
tc.End();
|
|
}
|
|
catch (Exception e)
|
|
{
|
|
#region Handle Exception
|
|
|
|
if (tc != null)
|
|
tc.HandleError();
|
|
ExceptionLog.Write(e);
|
|
throw new ServiceException(e.Message, e);
|
|
|
|
#endregion
|
|
}
|
|
|
|
return items;
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|