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