private static Models.Role Mapping(DataRow dr) { object o = DbHandler.GetObjectFromDb(dr, "RoleId"); int? i = DbHandler.IsMssqlConnected ? (int?)o : (int?)(long?)o; return(i == null ? null : new Models.Role() { RoleId = i.GetValueOrDefault(), UniqueName = (string)DbHandler.GetObjectFromDb(dr, "UniqueName"), DisplayName = (string)DbHandler.GetObjectFromDb(dr, "DisplayName"), IsDisabled = (bool)DbHandler.GetObjectFromDb(dr, "IsDisabled"), CreatedDt = (DateTime?)DbHandler.GetObjectFromDb(dr, "CreatedDt") ?? DateTime.MinValue, CreatedBy = (int?)DbHandler.GetObjectFromDb(dr, "CreatedBy") ?? 0, UpdatedDt = (DateTime?)DbHandler.GetObjectFromDb(dr, "UpdatedDt") ?? DateTime.MinValue, UpdatedBy = (int?)DbHandler.GetObjectFromDb(dr, "UpdatedBy") ?? 0, Description = (string)DbHandler.GetObjectFromDb(dr, "Description"), /// For Details. CreatedByDisplayName = (string)DbHandler.GetObjectFromDb(dr, "CreatedByDisplayName"), UpdatedByDisplayName = (string)DbHandler.GetObjectFromDb(dr, "UpdatedByDisplayName"), /// For MapRolesUsers. IsSelected = Convert.ToBoolean(DbHandler.GetObjectFromDb(dr, "IsSelected")), /// For Assign users to a specific role. UserList = null }); }
private static Models.AppFunction Mapping(DataRow dr) { object o = DbHandler.GetObjectFromDb(dr, "AppFunctionId"); int? i = DbHandler.IsMssqlConnected ? (int?)o : (int?)(long?)o; return(i == null ? null : new Models.AppFunction() { AppFunctionId = i.GetValueOrDefault(), UniqueName = (string)DbHandler.GetObjectFromDb(dr, "UniqueName"), DisplayName = (string)DbHandler.GetObjectFromDb(dr, "DisplayName"), ControllerName = (string)DbHandler.GetObjectFromDb(dr, "ControllerName"), ActionName = (string)DbHandler.GetObjectFromDb(dr, "ActionName"), AppFuncLevelId = (int?)DbHandler.GetObjectFromDb(dr, "AppFuncLevelId") ?? 0, ParentId = (int?)DbHandler.GetObjectFromDb(dr, "ParentId") ?? 0, SequentialNum = (int?)DbHandler.GetObjectFromDb(dr, "SequentialNum") ?? 1001, IsDisabled = (bool?)DbHandler.GetObjectFromDb(dr, "IsDisabled") ?? false, IsNavItem = (bool?)DbHandler.GetObjectFromDb(dr, "IsNavItem") ?? false, CreatedDt = (DateTime?)DbHandler.GetObjectFromDb(dr, "CreatedDt") ?? DateTime.MinValue, CreatedBy = (int?)DbHandler.GetObjectFromDb(dr, "CreatedBy") ?? 0, UpdatedDt = (DateTime?)DbHandler.GetObjectFromDb(dr, "UpdatedDt") ?? DateTime.MinValue, UpdatedBy = (int?)DbHandler.GetObjectFromDb(dr, "UpdatedBy") ?? 0, Description = (string)DbHandler.GetObjectFromDb(dr, "Description"), /// For Details. CreatedByDisplayName = (string)DbHandler.GetObjectFromDb(dr, "CreatedByDisplayName"), UpdatedByDisplayName = (string)DbHandler.GetObjectFromDb(dr, "UpdatedByDisplayName"), /// For MapAppFunctionRole. IsSelected = Convert.ToBoolean(DbHandler.GetObjectFromDb(dr, "IsSelected")) }); }
private static Models.User Mapping(DataRow dr) { object o = DbHandler.GetObjectFromDb(dr, "UserId"); int? i = DbHandler.IsMssqlConnected ? (int?)o: (int?)(long?)o; return(i == null ? null : new Models.User() { UserId = i.GetValueOrDefault(), LoginName = (string)DbHandler.GetObjectFromDb(dr, "LoginName"), DisplayName = (string)DbHandler.GetObjectFromDb(dr, "DisplayName"), Hash = (string)DbHandler.GetObjectFromDb(dr, "Hash"), Password = (string)DbHandler.GetObjectFromDb(dr, "Password"), IsDisabled = (bool?)DbHandler.GetObjectFromDb(dr, "IsDisabled") ?? false, CreatedDt = (DateTime?)DbHandler.GetObjectFromDb(dr, "CreatedDt") ?? DateTime.MinValue, CreatedBy = (int?)DbHandler.GetObjectFromDb(dr, "CreatedBy") ?? 0, UpdatedDt = (DateTime?)DbHandler.GetObjectFromDb(dr, "UpdatedDt") ?? DateTime.MinValue, UpdatedBy = (int?)DbHandler.GetObjectFromDb(dr, "UpdatedBy") ?? 0, Description = (string)DbHandler.GetObjectFromDb(dr, "Description"), /// For Details. CreatedByDisplayName = (string)DbHandler.GetObjectFromDb(dr, "CreatedByDisplayName"), UpdatedByDisplayName = (string)DbHandler.GetObjectFromDb(dr, "UpdatedByDisplayName"), /// For UI editing. IsUpdateHash = false, RetypedPassword = "", /// For MapRolesUsers. IsSelected = Convert.ToBoolean(DbHandler.GetObjectFromDb(dr, "IsSelected")), /// For Assign roles to a specific user. RoleList = null }); }
private static Models.AppFuncLevel Mapping(DataRow dr) { object o = DbHandler.GetObjectFromDb(dr, "AppFuncLevelId"); int? i = DbHandler.IsMssqlConnected ? (int?)o : (int?)(long?)o; return(i == null ? null : new Models.AppFuncLevel() { AppFuncLevelId = i.GetValueOrDefault(), UniqueName = (string)DbHandler.GetObjectFromDb(dr, "UniqueName"), DisplayName = (string)DbHandler.GetObjectFromDb(dr, "DisplayName"), Description = (string)DbHandler.GetObjectFromDb(dr, "Description") }); }
private static Student Mapping(DataRow dr) { object o = DbHandler.GetObjectFromDb(dr, "StudentId"); int? i = DbHandler.IsMssqlConnected ? (int?)o : (int?)(long?)o; if (i == null) { return(null); } return(new Student() { StudentId = i.GetValueOrDefault(), StudentName = (string)DbHandler.GetObjectFromDb(dr, "StudentName"), Age = (int?)DbHandler.GetObjectFromDb(dr, "Age") ?? -1, Email = (string)DbHandler.GetObjectFromDb(dr, "Email") }); }