private Role MapRole(IDataReader reader)
{
return(new Role
{
RoleId = AdoConverter.Read(reader, "RoleId", -1),
RoleName = AdoConverter.Read(reader, "RoleName", string.Empty)
});
}
private Permission MapPermission(IDataReader reader)
{
return(new Permission
{
PermissionId = AdoConverter.Read(reader, "PermissionId", -1),
ResourceName = AdoConverter.Read(reader, "PermissionResource", string.Empty),
Description = AdoConverter.Read(reader, "Description", string.Empty),
Operation = (Permission.OperationType)AdoConverter.Read(reader, "PermissionTypeId", 0)
});
}
private User MapUser(IDataReader reader)
{
return(new User
{
UserId = AdoConverter.Read <Int64>(reader, "UserId", -1),
DisplayName = AdoConverter.Read(reader, "DisplayName", string.Empty),
Culture = AdoConverter.Read(reader, "Culture", string.Empty),
Role = new Role
{
RoleName = AdoConverter.Read(reader, "RoleName", string.Empty),
RoleId = AdoConverter.Read(reader, "RoleId", -1)
}
});
}
public void InsertRole(Role role)
{
_context.CreateCommand(
false,
CommandType.Text,
"INSERT INTO [Roles] ([RoleName],[IsEnabled]) OUTPUT INSERTED.RoleId VALUES (@RoleName, 1);",
new List <SqlParameter>
{
new SqlParameter("@RoleName", role.RoleName)
}
);
var output = _context.ExecuteScalar();
role.RoleId = AdoConverter.ReadResult(output, -1);
}
public void InsertUser(User newUser)
{
_context.CreateCommand(
false,
CommandType.Text,
"INSERT INTO [USERS] ([Username], [Password], [DisplayName], [Culture], [RoleId], [IsEnabled]) OUTPUT INSERTED.UserId VALUES (@Username, @Password, @DisplayName, @Culture, @RoleId, 1);",
new List <SqlParameter>
{
new SqlParameter("@username", newUser.Username),
new SqlParameter("@password", newUser.Password),
new SqlParameter("@DisplayName", newUser.DisplayName),
new SqlParameter("@Culture", newUser.Culture),
new SqlParameter("@RoleId", newUser.Role.RoleId)
}
);
var output = _context.ExecuteScalar();
newUser.UserId = AdoConverter.ReadResult <Int64>(output, -1); //output.Value as int? ?? default(int);
}