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(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 Get(EnumSystemAuditHistory type, DateTime dtFrom, DateTime dtTo) { List items = new List(); 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(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 } }